Question: Could you solve these questions by using excel formula? Thanks. Calculate the answers for the below questions in cells C3 to C10 using Excel TVM

Could you solve these questions by using excel formula? Thanks. Calculate theanswers for the below questions in cells C3 to C10 using ExcelCould you solve these questions by using excel formula? Thanks.

Calculate the answers for the below questions in cells C3 to C10 using Excel TVM functions. Jse AT LEAST ONE of Excel's TVM functions among =PV,=FV,=PMT,=RATE,=NPER,=IPMT,=PPMT,=CUMIPMT,=CUMPRINC to answer each question. New Scenario (Independent): Laura wants to have $935286 in her savings account in 15 years. The interest rate is 8% p.a. compounded monthly from today to the end of year 8 and 8.5% p.a. compounded monthly thereafter. Calculate how much Laura needs to deposit today. New Scenario (Independent): Leah makes a deposit into her savings account today. If Leah wants to double her money in 15 years. Calculate the interest rate p.a. compounded monthly she needs to earn. New Scenario (Independent): Robert takes out a loan today. The interest rate is 8.4% p.a. compounded quarterly. To fully repay the loan, Robert will make quarterly repayments of $9352 starting in 7 years. He needs to make 68 repayments in total. Calculate the orginal loan Robert borrows. New Scenario (Independent): Daniel takes out a $158984 mortgage loan today. The interest rate is 8.2% p.a. compounded monthly. To fully repay the loan, he needs to make 34 equal monthly repayments of $4676 starting in one month. Daniel will also make a final repayment at the end of month 35 . Calculate the amount of the final repayment

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!