Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Basic Finance Expert

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?

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

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M92661951
  • Price:- $10

Priced at Now at $10, Verified Solution

Have any Question?


Related Questions in Basic Finance

From 1991 to 2000 the us economy had an annual inflation

From 1991 to? 2000, the U.S. economy had an annual inflation rate of around 3.50?%. The historical annual nominal? risk-free rate for this same period was around 5.73?%. Using the approximate nominal interest rate equati ...

Tank ltd is considering undertaking the purchase of a new

Tank Ltd is considering undertaking the purchase of a new piece of equipment that is expected to increase revenue by $12,000 each year for six years. The equipment will increase costs $4,000 each year for six years. It c ...

Question - how is cash flow different than net income what

Question - How is cash flow different than net income? What are some items included in the cash flow statement that are not included in the profit and loss statement? Write a 3-6 paragraph response to the above question( ...

Grant technologies needs 300000 to pay its supplier grants

Grant Technologies needs $300,000 to pay its supplier. Grant's bank is offering a 210-day simple interest loan with a quoted interest rate of 11 percent and a 20 percent compensating balance requirement. Assuming there a ...

Groceries inc is specialized in the distribution of

Groceries, Inc. is specialized in the distribution of groceries. NS Groceries is considering expanding into a new line of business by adding coffee shops (the coffee venture) to its existing groceries retail locations. C ...

Please show formula and detailed explanationyou have just

Please show formula and detailed explanation. You have just purchased an investment that generates the following cash flows for the next four years. You are able to reinvest these cash flows at 11.1 percent, compounded a ...

A you are awarded a 10 pay raise inflation for the upcoming

a) You are awarded a 10% pay raise. Inflation for the upcoming year is 3.9%. What is your real pay raise? Answer in percent and round to two decimal places. b) According to the yield curve, the one-year rate is 4% and th ...

What are the implications of increased index investing for

What are the implications of increased index investing for market efficiency?

Mrs salmon agrees to repay a loan by paying 500 at the end

Mrs. Salmon agrees to repay a loan by paying $500 at the end of each month for 5 years. The first payment is due at the end of the 6th month from today and the remaining payments will continue for another 59 months. If t ...

Question - bridgestone a japanese-based company receives

Question - Bridgestone, a Japanese-based company, receives recurring income in USD of about USD 5 billion per year. The current exchange rate is ¥120/USD. The annualized exchange rate volatility is 10%. The interest rate ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As