Unit 4 Individual AssignmentYou must upload an Excel spreadsheet for your assignment, with formulas showing all
calculations. If you wish, you may submit, in addition, a Word document or PDF with
accompanying text.
For this unit, the assignment focuses on working with the formulas that are used to
measure risk and return.
PROBLEM #1
Twin sisters, Joanna and Liz, received today $44,000 each from their parents for their
24th birthday. They will use this money to start their retirement plans.
They both hope to retire with $1.5 million dollars. Each plans to make a $1,000 monthly
contribution to her retirement fund, beginning one month from today.
Joanna opened an account with the Conservative Bond Fund, a mutual fund that invests
in high-quality bonds whose investors have earned 4.7% per year in the past.
Liz invested in the Aggressive Growth Fund, which invests in small, bio-tech stocks and
whose investors have earned an average of 7.9% per year in the fund’s short history.
a) If the two women’s funds earn the same returns in the future as in the past, how old
will each be when she reaches her retirement goal? Round your answer to the nearest
whole year.
b) How much would Liz’s retirement fund grow to, if she invests for the exact same time
as Joanna needs to reach her initial goal?
c) How large would Joanna’s monthly contributions have to be for her to reach her
retirement goal at the exact same time as Liz needs to reach her initial goal?
d) Is it rational or irrational for Joanna to invest in the bond fund rather than in stocks?
PROBLEM #2
Simon recently received a credit card with an 18% nominal annual interest rate. With the
card, he purchased a new Apple iPhone 14 for $900. The minimum payment on the card
is $35 per month.
a) If Simon makes only the minimum monthly payment and makes no other charges, how
many months will it be before he pays off half the balance on the card? Round your
answer to the nearest whole month.
b) If Simon adds just $5 more to his minimum monthly payment, how much less would
he owe at that time? Round your answer to the nearest whole month.
c) Simon’s wants to finish paying off in just two years. He found an internet offer from a
company willing to pay off his credit card balance, if he pays them $40 per month for 24
months. Is this a good deal for Simon? Why?
PROBLEM #3
Assume that the real risk-free rate is 1.5%, and that the credit risk, liquidity risk and
maturity risk premiums are all zero. A 1-year U.S. Treasury bill yield is 4.66% and a 2year Treasury note yields 4.31%.
a).What is the 1-year interest rate that is expected for Year 2? Do not round intermediate
calculations. Round your final answer to two decimal places.
b) Inflation is currently 4%. Based on the above Treasury yields, what does the market
expect inflation to be next year?
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Achiever Papers is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.
Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Dissertation Writing Service Works
First, you will need to complete an order form. It's not difficult but, if anything is unclear, you may always chat with us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order form
Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignment
As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download