Question

PLEASE SOLVE IN EXCEL SHOW ALL WORK! MUST USE FORMULAS!! Thank you!!

You are saving for retirement in 40 years. You deposit $20,000 in a bank account today that pays 3.5% interest, compounded semiannually. You leave those funds on deposit until you retire. You also contribute $5,000 a year to a pension plan for 20 years and then you stop making contributions to the fund. You leave your money in the pension fund until you retire. The pension plan grows at a rate of 4% a year. How much will you have when you retire?

Answer #1

Solution

Here 2 investment are being made

1. 20000 @ 3.5% semi-annual compounding for 40 years

2. 5000 per year @4% for 20 years, then the amount accrued through this annuity for again 20 years @4%

Now first let us calculate the future value of 20000 @ 3.5% semi-annual for 40 years

FV = Amount invested*(1+r/2)^2n

where r= 3.5% and n=40

FV= 20000*(1+.035/2)^80= 20000*(1.0175)^80

= 80127.84

Now

Coming to the second investment

First, let us find the future value of the annuity

Since it is not given in the question if it is an annuity due, we will take it as an ordinary annuity

FV of annuity= Amount*[((1+r)^n-1))/r)]

n=20 years

r=4%

FV = 5000*[((1.04^20)-1)/.04)

=5000*[(2.191123-1)/.04=

=148890.4

Now this amount is invested for 20 years @ 4%

FV = Amount invested*(1+r)^n

= 148890.4*(1.04)^20

=148890.4*2.191123

=326237.2

Therefore total money at retirement=326237.2+80127.84

=406365.02

Please show formulas in Excel or work - My formulas keep getting
an Error and I don't know what I am doing wrong.
You want to compare two separate retirement savings scenarios:
(A) and (B). In scenario (A) you start immediately, contribute
for a few years, but then stop contributing. However, you leave
the accumulated savings to compound until retirement. In
scenario(B) you start later (after the end of savings in
scenario A) and contribute all the way to retirement....

Excel retirement problem:
You just got your first job and plan to start saving for
retirement by investing with each monthly paycheck.
You plan to retire in 45 years.
In 50 years, you want to give your daughter a gift of
$1,000,000. You will receive an inheritance from a rich
great-uncle of $250,000 in 20 years.
You think you will want $150,000 every year when you retire,
starting the day you retire. You plan to...

Please use excel and show formulas used.
Alice wants to deposit $35,000 now and at the end of 6 years she
wants to deposit $45,000. The bank pays 10% interest compounded
semiannually. For the first 6 years, she wants to withdraw an
amount every year and for the following 4 years she wants to
withdraw exactly $1000 more. What is the maximum amount she can
withdraw in year 1?

Please show the work in
excel be sure to use appropriate formulas to solve
each exercise or problem.
A1 If you deposit $12,000 in a bank
account that pays 10% interest annually, how much will be in your
account after 7 years?
A2. What is the present
value of a security that will pay $10,000 in 20 years at an
interest rate of 8%?
A3.
Find the future value of the following ordinary
annuities:
$600 per year for...

PLEASE SHOW WORK AND NO EXCEL! THANK YOU
A deposit of $800,000 is made in February 25, 2011. By what date
the deposit will be worth $1.2M at 12% compounded annually? What
would be the answer if interest was compounded daily? (Use 1
year=360 days.) Why does this date come earlier?

A year from now, you plan to begin saving for your retirement by
making a deposit into a new savings account that has an expected
return of 7.5% compounded monthly. You plan to continue depositing
the same amount each year until you retire in 30 years. You expect
to make withdrawals in the amount of $200 from your savings account
every week for 45 years after you retire. Assume you were asked to
find the amount you will need to...

PLEASE WORK IN EXCEL SHEET
2.
You plan to retire in 30 years and you are investing $250 per
month in the BMO Large-Cap Growth mutual fund. The fund has an
average annual return of 13.45%. How much will you have at
retirement?
PLEASE WORK IN EXCEL SHEET

You are 23 years old and decide to start saving for your
retirement. You plan to save $ 6,500 at the end of each year (so
the first deposit will be one year from now), and will make the
last deposit when you retire at age 69. Suppose you earn 12% per
year on your retirement savings.
a. How much will you have saved for retirement?
b. How much will you have saved if you wait until age 40 to...

You are 30 years old and decide to start saving for your
retirement. You plan to save $ 5000 at the end of each year (so
the first deposit will be one year from now), and will make the
last deposit when you retire at age 65 Suppose you earn 11 % per
year on your retirement savings. a. How much will you have saved
for retirement?
b. How much will you have saved if you wait until age 39...

You are
2424
years
old and decide to start saving for your retirement. You plan to
save
$ 6 comma 500$6,500
at
the end of each year (so the first deposit will be
one year from now), and will make the last deposit
when you retire at age
6767.
Suppose
you earn
11 %11%
per
year on your retirement savings.
a.
How much will you have saved for
retirement?
b.
How much will you have saved if you wait until...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 6 minutes ago

asked 6 minutes ago

asked 13 minutes ago

asked 13 minutes ago

asked 19 minutes ago

asked 28 minutes ago

asked 40 minutes ago

asked 49 minutes ago

asked 51 minutes ago

asked 54 minutes ago

asked 57 minutes ago

asked 1 hour ago