Question: Please help to get answer for all following questions, please note that, Excel functions needs to be used as given in picture to answer them.

Please help to get answer for all following questions, please note that, Excel functions needs to be used as given in picture to answer them. Thanks !!

1. Mr. and Mrs. Good purchased a ski chalet for $328,715. They paid $17,043 down and agreed to make equal payments at the end of every three months for 10 years. Interest is 3.3% compounded quarterly.

Compute the equal quarterly payment.

Round your answer to 2 decimal places. Do not enter the dollar sign. Sample input: 124.34

2.

Sams Auto Repairs Inc. borrowed $7,508 to be repaid by monthly payments over 12 years. Interest on the loan is 4.01% compounded semi-annually. (*Hint: General Annuity)

Compute the equal monthly payment.

Round your answer to 2 decimal places. Do not enter the dollar sign. Sample input: 124.34

3.

Hansco borrowed $5,423 paying interest at 3.85% compounded annually. If the loan is repaid by payments of $352 made at the end of each year. Find the number of payments.

Round your answer to 8 decimal places. Sample input 6.43215678

Please help to get answer for all following questions, please note that,

C D G H Amount Payment 1 Number Interest Pald Principal Repald Outstanding Principal Balance Paid Payment Use PMT function here for payment Adjusted Interest Rate

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!