Q2.
It is your 6th birthday today. You have a trust fund with $50,000
that is...
Q2.
It is your 6th birthday today. You have a trust fund with $50,000
that is earning 8% per year. You expect to withdraw $30,000 per
year for 7 years starting on your 22nd birthday for graduate
school. How much money will be left in the trust fund after your
last withdrawal (rounded to the nearest $10)?
Solutions
Expert Solution
Value at the end of 21st birthday = 50,000(1.08)¹⁵ =
$158,608.46
Calculating Future Value after withdrawal,
Using TVM Calculation,
FV = [PV = 158,608.46, PMT = -30,000, N = 7, I = 0.08]
what is the present value of your trust fund if you have projected
that it will provide you with $50,000 9 years from today and it
earns 7% compounded annually?
Today is your 25th birthday, and you want to save $2.4 Million
by your birthday at age 70. If you expect to earn 7% APR compounded
monthly in your retirement account, what constant payment at the
end of each month must you deposit into the account through your
70th birthday in order to reach your retirement savings goal on
your 70th birthday? (Answer to the nearest penny.)
Today is your 25th birthday, and you have calculated that you
need to accumulate $2.1 Million by your 70th birthday in order to
retire in a manner in which you are accustomed to living. If your
retirement account earns 7.1% per year simple interest, how much
must you deposit on each of your birthdays (from 26 to 70) in order
to reach your target retirement savings on your 70th birthday?
(Answer to the nearest dollar.)
You are celebrating your 22nd birthday today. You
have decided to start investing toward your retirement beginning
one month from today. For the first twenty years, you will invest
$500 every month. During the next ten years, you will increase your
contributions to $900 per month. For the remainder of your working
life until you retire at age 67, you plan to invest $1,500 every
month. If your investments earn a rate of return of 8.4 percent
throughout your working...
Could you show your work in Excel Please. Today is your 25th
birthday. You have decided that it is necessary to plan your own
retirement since you are not confident that government benefits
will be available when you retire. You will make annual payments
into an account earning 5% APY starting on your next birthday
(26th) a year from now. Your last payment will occur on your 70th
birthday. You have decided that you need to plan for payments of...
You are celebrating your 22nd birthday today. You
have decided to start investing toward your retirement beginning
one month from today. For the first twenty years, you will invest
$500 every month. During the next ten years, you will increase your
contributions to $900 per month. For the remainder of your working
life until you retire at age 67, you plan to invest $1,500 every
month. If your investments earn a rate of return of 8.4 percent
throughout your working...
Today is your 22nd birthday. You plan to retire on your 60th
birthday, immediately after making your last savings deposit, and
begin collecting your retirement payments on your 61st birthday.
You decide that your retirement payment will be $80,000 at age 61,
growing at 1.5% per year afterwards, and you expect to collect a
total of 35 payments. Starting on your 23rd birthday, and on every
birthday before you retire, you will make a deposit into your
retirement savings account....
You have received a trust fund currently worth $900,000.
However, you cannot access to the fund until you turn 60 years old,
which is in 20 years. At that time you will be able to withdraw
$10,000 per month. If the trust fund is invested at a 7 percent
rate, compounded monthly, how many months will the money last once
you start making the monthly withdrawals? **Answer and show work in
Excel
Today is your 30th birthday and you plan to retire in 30 years
when you are 60. You expect to need $75,000 a year in retirement
(the first $75,000 will be paid on your 61st birthday) and expect
to live to be 95. If you assume you can earn a nominal rate of 5.5%
on your investments calculate the amount you will need to save each
year until you retire if you start saving next year on your 31st
birthday....
You and your cousin Kristin were born on the same day. Today is
your 25th birthday. Five years ago (when you turned 20) your aunt
started depositing $2,500 into Kristin's account. She did this
every year and she just made a sixth deposit. Your aunt will make
forty more $2,500 payments until a 46th and final payment is made
on Kristin's sixty fifth birthday. Your aunt has had a change of
heart and now wants to make an equivalent provision...