Discussion post minimum 400 words

Review and reflect on the Alternative Treatment Discussion Board. Based on your review and reflection of new learnings in this course, write at least 400-600 words on the following:

  • What have you learned from others’ responses?
  • What were the most compelling points from the interaction with your fellow students?
  • How did participating in this discussion help in your understanding of the Discussion Board task?

Student 1 reply:

Krystal,

Thank you for sharing your recommendation with us. I completely agree with you that the 12-Step program might not be appealing to some because of the religious component of it. I also do not like it because it seems to be a one-size-fits all treatment. I really like your recommendation of treatment. I like that it not only has no spiritual component to it so more people will be able to benefit from it, but that it also has CBT as part of the therapy. CBT is, in my opinion, a very solid type of treatment. Another factor that you mentioned is that it is not peer supported so it helps the addict be more independent. Even though it is good to have some support, I also believe that 12-Step programs can become a crutch for the addict. It is better for the addict to learn how to deal with his or her addiction independently and with the suport of his or her closest relatives and friends. Yes, it does not hurt to have a support group; however, if the 12-Step is the only form of treatment, I don’t think it is good. 12-Step programs should be used as an accessory to other types of treatments, not as the main treatment.

What do you think of holistic approaches for this client? Do you think there is any specific type of holistic approach that would benefit them? In fact, do you believe in holistic approaches?

Looking forward to your answers.

Xio

Student reply 2:

Hello Krystal,

I enjoyed reading your very informative discussion board post. You explained the S.M.A.R.T. program very well. I too believe that due to the 12 step programs focusing on a religious (versus spiritual) aspect is one reason there is not a higher success rate. I have learned that when we are faced with adversity the people who don’t seek a higher power, or have and not felt the connection find this aspect of the program difficult at best. If the belief system is not there then it is not likely they can adhere to the steps in the program. Would you say you agree?

Student reply 3:

Hello Krystal. You post was very informative. I agree that the spirituality part of the 12-step program may be a huge turn off for some. If a person is not spiritual, it would be a waste of time for all involved. Even if a person is spiritual but are of another faith, it would not work for them. I like that SMART requires that the person take responsibility for their own recovery. The techniques prepare them to handle everything they may encounter while going through the process and afterwards as well. I chose this program for discussion. Keep up the good work.

Silvanus Harris

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

Finance for Business 6 page Report (CAPELLA)

Introduction

This portfolio work project is about one of the basic functions of the finance manager: allocating capital to areas that will increase shareholder value. There are many uses of cash managers can select from, but it is essential that the selected projects are ones that add the most value to the company. This means forecasting the projected cash flows of the projects and employing capital budgeting metrics to determine which project, given the forecast cash flows, gives the firm the best chance to maximize shareholder value.

As a business professional, you are expected to:

  • Use capital budgeting tools to compute future project cash flows and compare them to upfront costs.
  • Evaluate capital projects and make appropriate decision recommendations.
  • Prepare reports and present the evaluation in a way that finance and non-finance stakeholders can understand.

Scenario

You work as a finance manager for Drill Tech, Inc., a mid-sized manufacturing company located in Minnesota. Three capital project requests were identified as potential projects for the company to pursue in the upcoming fiscal year. In the meeting to discuss capital projects, the director of finance (and your boss), Jennifer Davidson, gives you a synopsis of the projects along with this question: Which one of these projects will provide the most shareholder value to the company?

She also tells you that other than what is noted in each project scenario, all other costs will remain constant, and you should remember to only evaluate the incremental changes to cash flows.

The proposed projects for you to review are as follows.

Project A: Major Equipment Purchase
  • A new major equipment purchase, which will cost $10 million; however, it is projected to reduce cost of sales by 5% per year for 8 years.
  • The equipment is projected to be sold for salvage value estimated to be $500,000 at the end of year 8.
  • Being a relatively safe investment, the required rate of return of the project is 8%.
  • The equipment will be depreciated at a MACRS 7-year schedule.
  • Annual sales for year 1 are projected at $20 million and should stay the same per year for 8 years.
  • Before this project, cost of sales has been 60%.
  • The marginal corporate tax rate is presumed to be 25%.
Project B: Expansion into Europe
  • Expansion into Western Europe has a forecast to increase sales/revenues and cost of sales by 10% per year for 5 years.
  • Annual sales for the previous year were $20 million.
  • Start-up costs are projected to be $7 million and an upfront needed investment in net working capital of $1 million. The working capital amount will be recouped at the end of year 5.
  • Because of the higher European tax rate, the marginal corporate tax rate is presumed to be 30%.
  • Being a risky investment, the required rate of return of the project is 12%.
Project C: Marketing/Advertising Campaign
  • A major new marketing/advertising campaign, which will cost $2 million per year and last 6 years.
  • It is forecast that the campaign will increase sales/revenues and costs of sales by 15% per year.
  • Annual sales for the previous year were $20 million.
  • The marginal corporate tax rate is presumed to be 25%.
  • Being a moderate risk investment, the required rate of return of the project is 10%.
Your Role

You are a finance manager at Drill Tech, Inc., who plays a major role in reviewing capital project requests.

Requirements

Jennifer reiterates that your report is critical for the company to select the project that will bring the most value to shareholders. Your calculations and report should address these items for her and other stakeholders:

  • Apply computations of capital budgeting methods to determine the quality of the proposed investments.
    • Use budgeting tools to compute future project cash flows and compare them to upfront costs. Remember to only evaluate the incremental changes to cash flows.
    • Demonstrate knowledge of a variety of capital budgeting tools including net present value (NPV), internal rate of return (IRR), payback period, and profitability index (PI). The analysis of the capital projects will need to be correctly computed and the resulting decisions rational.
  • Evaluate the capital projects using data analysis and applicable metrics that align to the business goal of maximizing shareholder value.
    • Evaluate capital projects and make appropriate decision recommendations. Accurately compare the indicated projects with correct computations of capital budgeting tools and then make rational decisions based on the findings.
  • Select the best capital project, based on data analysis and evaluation, that will add the most value for the company.
  • Prepare an appropriate evaluation report for requestors, using sound research and data to defend your decision.
    • Justify your decision with a clear analysis showing the findings of the analysis and which project has the best chance to increase shareholder value.
    • Use your calculations and data to provide a clear picture of why your recommendation is the right one. This goes beyond just regurgitating the data. Think about how the data can tell the story that will be meaningful to the readers.

Deliverable Format

For this assessment, create two deliverables:

  1. An Excel spreadsheet showing the required cash flow forecasts and capital budgeting tool calculations for each project. Use the same spreadsheet but create separate tabs for each project.
  2. A report providing an analysis of the computations, the project selection decision, and justification for the decision, as well as its impact on the value of the firm. The project selection decision must have an analytical rationale to support it.
Report requirements:
  • Ensure written communication is free of errors that detract from the overall message and quality.
  • Use at least three scholarly resources.
  • Your report should be between 6 and 8 pages.
  • Use 12 point, Times New Roman.
Related company standards:
  • Your report is a professional document and should follow the corresponding MBA Academic and Professional Document Guidelines (found in the MBA Program Resources), including single-spaced paragraphs.
  • Use APA-formatted references.

Evaluation

By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies through corresponding scoring guide criteria:

  • Competency 1: Apply the theories, models, and practices of finance to the financial management of an organization.
    • Apply computations of capital budgeting methods to determine the quality of the proposed investments.
  • Competency 2: Analyze financing strategies to maximize stakeholder value.
    • Evaluate the capital projects using data analysis and applicable metrics that aligns to the business goals.
  • Competency 3: Apply financial analyses to business planning and decision making.
    • Select the best capital project, based on data analysis and evaluation, that will add the most value for the company.
  • Competency 5: Communicate financial information with multiple stakeholders.
    • Prepare an appropriate evaluation report for requestors, using sound research and data to defend the decision.

Faculty will use the scoring guide to review your deliverables in the role of your boss and stakeholders. Review the scoring guide prior to developing and submitting your assessment.

ePortfolio

This assessment shows potential employers and clients that you can analyze capital projects to determine whether and how they can provide value to shareholders. Include this in your personal ePortfolio.

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

Stress management presentation

I have attached the area of evaluation that will be based on. nothing much just make it with easy common words 5 minutes long . state the points on the powerpoint and then down on the notes write down what i’m supposed to say but please make it simple and straight to the point following all the instrections

The presentation needs to be 10 minutes in length and should visually explain your Stress Management Research Paper. Your presentation also needs to include a teaching demonstration of one of the stress management techniques that you selected in your paper (for 5 minutes or less). Be creative and use visuals in PowerPoint form. Visual aids will be needed to receive full credit for the final presentation. Please explain the components of what was written in your research paper in a clear, organized format. Please let me know ahead of time if you have special circumstances. Presentations and demonstrations must be given on the day assigned. Please submit your presentation online on Canvas on the day of your presentation.

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

International Crime Witness, Part 1

Use the Internet to research criminal proceedings in one (1) of the six (6) model countries from the textbook. Imagine you are traveling abroad in your chosen country when you witness a local national committing a violent assault. The criminal is arrested and charged by the police.

Upon returning to the United States, a professor in one of your criminal justice classes asks you to complete a written report on your experience.

Write a three to five (3-5) page paper in which you:

  1. Determine the pertinent demographic, social, political, and economic factors about your chosen country.
  2. Examine the manner in which your chosen country’s criminal code would likely view the crime you witnessed. Provide a rationale for the response.
  3. Choose two (2) individual rights that the United States grants criminal suspects, such as search and seizure, right to counsel, etc., and analyze the country’s perspective on each right. Provide support for the analysis.
  4. Investigate the manner in which the police in your chosen country would likely treat the defendant. Provide justification for the response.
  5. Classify the fundamental similarities and differences between the police culture in your chosen country compared to the United States.
  6. Use at least four (4) quality references. Note: Wikipedia and other Websites do not qualify as academic resources.

Your assignment must follow these formatting requirements:

  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

  • Compare and contrast American perspectives on criminal law with those of other countries.
  • Evaluate the nature of comparative policing and global law enforcement cooperation.
  • Analyze the role of procedural law in the four (4) major legal traditions.
  • Use technology and information resources to research comparative perspectives in criminal justice.
  • Write clearly and concisely about criminal justice topics using proper writing mechanics and APA style conventions.
 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

write a contract about Employment Agreement

  1. You will draft an Employment Agreement based upon further instructions provided.
  2. You will compose a paper (not less than one page but no more than two pages) explaining how your Employment Agreement satisfies all of the elements of a valid, enforceable contract and the jurisdiction’s law governing covenants not to compete. Further instructions are provided below.
  3. You are an employer who has conducted interviews for an open position within your company. You are ready to extend an offer to one of the interviewees, but first, you need to compose an Employment Agreement. You are very concerned with the state of the economy at present and do not want to enter into any long-term contracts with any of your employees. On the other hand, you do not want to invest the time and money it takes to train a new employee, and then have that employee leave your company in a year and go to work for one of your competitors.
    1. The Employment Agreement must contain the following provisions:
      1. Name and address of the Employer (You must choose between Alabama or Florida as the applicable jurisdiction and location of the business)
      2. Name and address of the Employee
      3. Description of the company
      4. Description of the job (you determine what type of job the agreement will cover)
      5. Salary and other benefits
      6. Duration of the employment agreement
      7. Covenant not to compete
      8. Any other provisions you feel are necessary
      9. Signatures space and the date of the Agreement
      10. The format for the Employment Agreement should be straightforward and concise. Use language that is clear—in other words, do not use a lot of “legalese” that most people will not understand. It is prohibited for you to copy an existing employment agreement. You must write the agreement in your own words. The Agreement should be no more than two pages, typed, double-spaced in Times New Roman font.
      11. Use your creativity in creating an employer and the corresponding details of the employee identity, description of the company, salary and other benefits.Research Aspect: Based upon the jurisdiction (state) that you have chosen for the employer (Florida or Alabama), you will need to research the laws governing covenants not to complete within in that particular state to ensure that your covenant not to compete meets the legal requirements.
        1. Paper: You must write a paper explaining how your Employment Agreement satisfies each of the elements of a valid, enforceable contract. You must also explain how your covenant not to compete contained in the Employment Agreement satisfies the requirements of the particular state you have chosen for the location of the business. HOWEVER, if a covenant not to compete is not enforceable given your particular company and purpose of employment, then you must state the reasons for that and the applicable law prohibiting such a clause. You are REQUIRED to cite to at least two external resources which explain the laws governing covenants not to compete within the state that you chose. The Paper should not be less than one page or more than two pages, typed, double-spaced, using Times New Roman 12pt font. All margins must be one inch. Only include your first and last name in the paper. No other identifying information like the name of the course or my name needs to be included. There should be no more than one double-space between your name and the beginning of the paper. Use APA Style to cite your sources. This means you will need to include in-text citations and provide a references page. The references page does not count toward your page requirements for the assignment.

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

Topic 1: Emotions, Moods, Traits, and Values:

Although emotions and moods impact on-the-job performance, employees are often times chosen for their personality traits. Along with a person’s personality type, the organization’s culture is considered. The company recruiter tries to hire decision-makers he/she thinks will fit into the existing company culture. In this Discussion, you will consider all three aspects impacting employee hiring and employee effectiveness.

Label the three parts of your response as Part A, Part B, and Part C.

Topic 1: Emotions, Moods, Traits, and Values:

  • Part A: Based in the Reading, which emotions and moods have you experienced in your past or current job and how did it impact your performance?
  • How was Affective Events Theory or Trait Activation Theory (see Chapter 5) involved or not? Explain.
  • Part B: Characterize the personality of your past or current boss (do not use any names or organization names) using one of the major personality theories presented in your Reading.
  • Part C: According to your Reading, how do someone’s values relate to their culture and to organizational outcomes?

Just do response each posted down below only.

Posted 1

Good Afternoon,

Hey everyone I hope everyone is having a great week so far and is learning a lot of information!

Part A: In my current job as a stay at home mom I experience a lot of moods, and emotions. The moods that I have for the day all depends on how much sleep I get at night, but that can change if I get a good nap in. My mood is what helps me be motivated to clean for the day or to just play with the kids. Although I tend to get do things differently if my emotions change too. According to organizational behavior and I quote “emotions are intense discrete, and short-lived feeling experiences that are often caused by a specific event.” So when my youngest son comes up to me for a kiss its the best feeling and I feel like my mood has lifted and I am on top again. I feel like when I get loving attention for both my boys my mood changes and even if I didn’t sleep well I have the energy to get cleaning done and run around for a few hours playing tag. So, if my mood is just kind of blah or feels like your dragging then my performance is just terrible.

Part B: My current boss really would be my kids in a way haha. They are both so wonderful and great kids but even their personalities are so different. One of them is more along the lines of openness to experience, and the other is more along the lines of agreeableness.

Part C: Since I am the one the will be teaching my kids about values and others cultures I do try and take them out to different play dates and meets everyone. Kids are so moldable at this age and teaching them about other cultures just shows them how different everyone is. This will also help them when growing up to meet new people a bit easier if they understand how to interact with others.

Posted 2

Part A: In all my years I have been working I have seen all different types of emotions in the work place. As a manager I have seen customers be so happy and excited about their experience to customers that where so suspect that they wanted to call cooperate to make sure their issues where resolved. With employees who come to work happy, to them coming to work made or upset with home life or even with problems with work.
According to Robbins and Judge (2019), Affective Events Theory suggest that work place environment can affect employees attitudes , behaviors and emotions at work. This theory is involved in my experience because when ever the work environment was stressed for maybe a big visit everyone will be stress out and some days I would not even want to go to work.
Part B: With using the Big Five Traits of personality my last boss had openness and agreeableness. She was always open to new ideas and better ways to run the business. She was also very agreeable, she was very likes by everyone and was very laid back but was still able to run a business very effectively.
Part C: We get our values from them people who raise us and who we surround our selves around. It relates to the culture we practice as well how we see others cultural. We can learn so much from our coworker and about their cultural and values. In every organization they have people from all backgrounds and it helps us open up to new people and become well rounded employees.
Robbins, S. P., & Judge, T. A. (2019). Organizational Behavior. New York: Pearson

Posted 3

Part A:

Some of the emotions that I have experienced in my current role would be frustration, accomplished, boredom, and happiness. Starting Monday I will be moving into a Supervisor role which will help a lot. I have been a Sr. Technician for the last year after a layoff from a place where I was the Production Manager and had the ability to get things done. My biggest struggle as a technician at the new company was not being taken seriously and incompetent leadership. I also have several “friends” at work that are great to talk to and make the days more enjoyable.

According to the text, “A model suggesting that workplace events cause emotional reactions on the part of employees, which then influence workplace attitudes and behaviors” (Robbins & Judge, 2019). I would say that it has impacted me, I still got a lot done but when I saw management didn’t care, I stopped caring as much. The aftermarket repair station I worked in is going to suffer greatly when I move out to production, it annoys me that they don’t know that, and sadly makes me feel good that it’s going to hit them when it’s too late, they need to open their eyes.

Part B:

I would say my previous V.P. was a narcissist, not sure why that isn’t an option in the text but I guess it most closely translates to emotional stability. The reason I say that is the jerk had so much power being the owner’s little brother he never worried about anything or got stressed out, he knew he could manipulate the President into believing whatever he wanted, and would just pin it on someone else. I really hated that guy, I don’t feel hate as an emotion at my new company but I hate my previous boss, he is a really unethical and terrible person.

Part C:

Peoples values and how it relates to culture and the organizational outcome are critical. The previous company where I worked for the one jerk was predominantly Asian, as were the owners. Every year they would celebrate Lunar New Year and have give aways a company lunch, and all sorts of things. It was cool to learn about the culture, and find out things like I am the “year of the rat”, and how to say “happy new year” in a couple of different languages. I would say it is very important in an organization’s success to be mindful of peoples values.

Reference:

Robbins, S.P. & Judge, T.A. (2019). Organizational behavior (18th ed.) NY: Perason.

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

Nutrition powerpoint

Please write nutrition PowerPoint presentation I’ll send some stuff to add

Include what macros are

Toxins

Why you should eliminate dairy and gluten

Add self reflection quiz

Presentation handouts

Original

I’m not sure how many slides it will be but be informative and don’t add to many words on a page you can add photos etc thank you I’ll pay a fair price not sure price again

Going to say 10 pages but may be more but don’t want it to many pages

https://www.schoolnutritionandfitness.com/data/pdf/TeacherPowerPoints/Macronutrients.ppt

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

discuss an ethical dilemma that has confronted, or could confront, the organization when functioning on a global level

lobal Ethics on Leadership Decision-Making

As we have learned this week, global organizations are required to adapt to various cultures in today’s global marketplace. As such, organizational leaders should have a solid understanding of such differences and ethical issues when making decisions. Using a large multinational business organization in the Middle East, discuss an ethical dilemma that has confronted, or could confront, the organization when functioning on a global level. Assess the impact that the organization’s values have on ethical decision-making. If you were a leader in that organization, how would you react to the various challenges that your organization could face? In this written assignment, be sure that you discuss ethical issues from both a local and global perspective.

Deliverables:

Your paper should be 4-6 pages long, double-spaced, and formatted according to Saudi Electronic University’s academic writing standards and APA style guidelines. Use at least three peer-reviewed scholarly sources and information from your module to support your decision.

It is strongly encouraged that you submit all assignments to the Turnitin Originality Check prior to submitting them to your instructor for grading. If you are unsure how to submit an assignment to the Originality Check tool, please review the Turnitin Originality Check Student Guide (linked below) for step-by-step instructions.

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

Political Economy Country Briefing Memo

The objective of this final assignment is to integrate concepts and prove that you can see policymaking in the development context through “political lenses” so integrate and incorporate in this memo as many as the concepts that you learned in this course as it fits the discussion.

The Ministry of [ your chosen policy area] in Pakistan has contacted you because you are well-known for your skills in applied political analysis. The Minister, a “reformist” who wishes to improve the conditions in [ the policy area you chose], has asked you to assess the government’s chances for a successful reform/policy.

Your job is to help them out make strategic decisions about how to achieve consensus and proceed to implementation:

First, identify a reform your country that you believe will help he reformers achieve their goal of improving conditions in this sector.

Then you will need to consider all the stakeholders, inside and outside government that will be affected, how they are expected to react, what alliances they could seek and what tools and resources they would most likely be using to push for or stop the reform depending on their interests. You are advising the government so you need to address the issues and obstacles they will face. How can they leverage the support?

Finish your memo with a clear political strategy recommendation to the Minister. Remember you want the policy to succeed but a responsible policy analyst you have to be realistic, your reputation is on the line.

This memo should build on the knowledge you have accumulated researching your country during the term. The proposed reform or policy can be real or hypothetical (something that has already been under consideration or something that has not been proposed ever but you think should). The analysis should be based on the real political environment, real actors and any data utilized should be real and its source properly cited.

It should be written following a policy memo format.

Beware of things that could be considered plagiarism, cite all sources properly.

Max 1000 words. Include a word count at the end (find it under review tab in Microsoft word).

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

Money and Banking & Present Discounted Value Questions

The Answers should be submitted as a single spreadsheet file (Excel, Google Sheets) with separate tabs for each question (Q1, Q2, Q3, Q4). Your spreadsheet should show how you calculated each value.

Question 1 (20 points)

To answer all parts of question 2, prepare a spreadsheet for each question, showing:

• Three columns for each question

• The first column should contain the years (2020, 2021, 2022, 2023…2038, 2039)

• The second column should contain cash payments (undiscounted) in each year

• The third column should contain present value (ie: discounted) of cash payments in each year

• At the bottom of the third column, provide the total present value of all cash payments

• A statement at the bottom of each table with the answer to the question (Example for 1A: “The present discounted value of this lottery prize is _____.”)

AWhat is the present value of a lottery prize paying $25,000 each year for 25 years (first payment in 2020, last in 2044), discounted at a rate of 5 percent?

BWith an interest rate of 3.3 percent, what is the present value of a security that pays $1,769 next year (2020) and $10,422 fifteen years from now (2034).

CWhat is the present value of a security that pays $500 in 2020 and $1,000 in 2021, $1,500 in 2022, $2,000 in 2023 and $2,500 in 2024with an interest rate of 7 percent?

DOn January 1, 2019 you purchased a bond with a face value of $3,000,000 that provides an annual coupon (paid on January 1) of 2.75 per cent and a yield to maturity of 4.0 per cent. The bond matures on January 1, 2039. Assuming you paid no more or less than the present value, how much did the bond cost you?

EOn January 1, 2019 you purchased a bond with a face value of $2,500,000 that provides an annual coupon (paid on January 1) of 7per cent and a yield to maturity of 1.5 per cent. The bond matures on January 1, 2024. Assuming you paid exactly the present value, how much did the bond cost you?

Question 2 (10 points)

You sell each of the bonds in (1D) and (1E) on January 2, 2020 (after you have received one coupon payment the day before). Each interest rate has fallen by 1 per cent, for what price did you sell each bond? What rate of return did you earn on each bond?

To answer question 3, prepare a spreadsheet for each of the bonds, showing:

• Three columns for each question

• The first column should contain the years (2021, 2022, 2023…2038, 2039) ßNote that for this question, the first year is 2021!

• The second column should contain cash payments (undiscounted) in each year

• The third column should contain present value (ie: discounted) of cash payments in each year

• At the bottom of the third column, provide the total present value of all cash payments

• Calculation of the rate of return when each bond is sold on January 2, 2020

• Four statements with the answers to the question (Price of bond 1D on January 2, 2020, rate of return on bond 1D, price of bond 1E, rate of return on bond 1E)

Question 3 (20 points – show tables for each)

What is the duration of:

Bond AA 20 year bond (2039) with a face value of $3,000,000, coupon rate of 5.5 per cent and yield to maturity of 3 per cent?

Bond BA 6 year bond (2025) with a face value of $5,000,000, coupon rate of 5 per cent and yield to maturity of 8 per cent?

Bond CA 10 year bond (2029) with a face value of $7,000,000, coupon rate of 2 per cent and yield to maturity of 10 per cent?

To answer question 3, prepare a spreadsheet for each bond, showing:

• Year (2020, 2021, 2022, 2023…2038, 2039)

• Cash payments in each year (coupon and/or face value)

• Present value of cash payments in each year (coupon and/or face value)

• Total Present value of all cash payments

• Share of total present value in each year (present value of that year’s cash payments divided by the total present value of all cash payments)

• Weighted maturity for each year (year times the share of total present value in each year)

What’s the duration of a portfolio holding all three bonds?

• Find the total present value of the entire portfolio of three bonds

• Find the share of the portfolio’s total present value represented by each bond’s individual present value

• Take the sum of:

(Bond A’s share of portfolio present value * Bond A’s duration)

+ (Bond B’s share of portfolio present value * Bond B’s duration)

+ (Bond C’s share of portfolio present value * Bond C’s duration)

Question 4 (50 points – 2 points each)

Copy and paste this table into a spreadsheet. Show your calculations. Assume all face values = $100

– To find the price use the table format from question 1

– To find the duration, use the table format from question 3

– To find the coupon for R, you’ll have to do some algebra. Here’s a formula (C is coupon, P is price, F is face value of $100 and n is the number of years to maturity)

– Finding the value of the interest rate requires some algebra too. You figure it out!

Fill in the blanks marked with letters (“A = ______, B = ______, etc.). Assume the year is 2019 and coupons are paid annually (so the next payment is Jan. 1, 2020).

Issuer

Redemption

Coupon

Price

Yield

Duration

Belgium

2021

1.50

A

-0.63

1.99

Belgium

2047

1.60

126.00

0.59

B

Canada

2022

0.50

C

1.57

2.98

France

2020

0.25

100.88

D

1.00

France

2025

0.50

106.17

-0.51

E

France

2048

2.00

F

0.57

23.44

Germany

2020

0.25

100.95

-0.69

G

Germany

2025

0.50

H

-0.72

5.93

Germany

2048

1.25

I

-0.02

25.29

Greece

2025

3.00

J

1.45

5.60

Italy

2021

0.35

100.98

-0.14

K

Italy

2028

4.75

L

0.73

7.76

Italy

2048

3.45

135.12

1.87

M

Japan

2022

0.10

N

-0.31

3.00

Japan

2023

0.60

103.71

-0.32

O

Japan

2028

1.90

P

-0.26

8.42

Japan

2047

0.80

113.70

0.29

Q

UK

2021

R

101.80

0.59

1.99

UK

2025

2.00

S

0.40

5.73

UK

2028

6.00

T

0.52

7.57

UK

2047

1.50

110.61

1.06

U

US

2020

1.75

99.82

V

1.00

US

2023

2.25

102.15

1.69

W

US

2028

5.25

X

1.76

7.61

US

2047

2.75

111.19

2.21

Y

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"