A=P r(1+r)ⁿ

(1+r)ⁿ-1

A $60,000 loan with an annual interest rate of 10% is scheduled to be paid over three years (36 months).

Step 1: What is the monthly interest rate (in percent up to 4 decimal places)?

Step 2: How much interest expense (in dollars and cents) will incur in the first month with the loan balance at $60,000?

Step 3: Use the formula from the lecture (below) to determine the monthly payment (in dollars and cents). Remember that to use a % in a calculation you need to move the decimal sign left two places.

Step 4: How much (in dollars and cents) of this first monthly payment went to principal?

Step 5: What is the remaining loan balance (in dollars and cents) after the first payment?

Step 6: Watch thisvideoand use an Excel spreadsheet to determine how much interest expense (in dollars and cents) was paid out over the entire loan.

Step 7: How much (in dollars and cents) was paid out total (principal and interest) over the entire loan?

Answer for blank # 1:0.833%Answer for blank # 2:$499.80Answer for blank # 3:$30.99Answer for blank # 4:$1,436.31Answer for blank # 5:$58,563.69Answer for blank # 6:$9,692.73Answer for blank # 7:$69,699.90

I did get them wrong and this was her response.

You need to go one more place in the % (to the ten-thousands), that will aid the rest of your answers.

I would try to figure it out on my own but I am not sure how the answers were calculated. Could you help me out?

Thank you!