Problem #1 – You need to accumulate $86,980 for your son’s education.

Problem #1 –

You need to accumulate $86,980 for your son’s education. You have decided to place equal year-end deposits in a savings account for the next 12 years. The savings account pays 5.85 percent per year, compounded annually. How much will each annual payment be?

Don't use plagiarized sources. Get Your Custom Essay on
Problem #1 – You need to accumulate $86,980 for your son’s education.
Just from $13/Page
Order Essay

I’m using the following formula but my answe is coming back wrong

=PMT(5.85% /12,12,0,86980,) = 7,056.04 however the correct answer should be 5,201.24 not sure what I’m missing

Problem #2 –

You plan to buy the house of your dreams in 5 years. You have estimated that the price of the house will be $117,573 at that time. You are able to make equal deposits every month at the end of the month into a savings account at an annual rate of 6.08 percent, compounded monthly. How much money should you place in this savings account every month in order to accumulate the required amount to buy the house of your dreams? 

I’m using the following formula but my answet is coming back wrong

= PMT(6.08%/5,12*5,0,117573)

I submitted 1,342.25 but the correct answer is 1681.69

Order your essay today and save 20% with the discount code: GREEN

Order a unique copy of this paper

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
Top Academic Writers Ready to Help
with Your Research Proposal
Live Chat+1(978) 822-0999EmailWhatsApp

Order your essay today and save 20% with the discount code GREEN