Question: Use the amortization schedule shown below for a 4 year loan to calculate the total interest paid over the life of the loan. Do not

Use the amortization schedule shown below for a 4 year loan to calculate the total interest paid over the life of the loan. Do not include a dollar sign in your answer. Month 0 1 2 3 4. 5 6 Principal Paid $0.00 $377.25 $378.82 $380.40 $381.99 $383.58 $385.18 $386.78 $388.39 $390.01 $391.64 Interest Paid $0.00 $83.33 $81.76 $80.18 $78.60 $77.01 $75.41 $73.80 $72.19 $70.57 $68.95 Loan Balance $20,000.00 $19,622.75 $19,243.92 $18,863.52 $18,481.53 $18,097.95 $17,712.78 $17,325.99 $16,937.60 $16,547.59 $16,155.95 8 9 10

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!

What are the six primary roles that information systems play in organizations? How are information systems used in each context? What does digital transformation mean?

Use the amortization schedule shown below for a 3 year loan to calculate the total interest paid over the life of the loan. Do not include a dollar sign in your answer. Month 0 1 2 3 4 5 6 Principal...

ONLY NEED 8,9, AND 10. Thank you. 1. Answer questions 1 - 3 for a $250,000 home purchase using a conventional fixed rate mortgage from a private lender. Reminder: mortgage payments are monthly so use...

please answer the question below Assignment#1 Loan Amortization You are thinking of purchasing a house. The house costs $350,000. You have $50,000 in cash that you can use as a down payment on the...

You are thinking of purchasing a house that costs $185,000. You have $9,000 in cash that you can use as a down payment, but you need to borrow the rest of the purchase price. The bank is offering a...

PLEASE SHOW ALL YOUR WORK -DATES ARE NOT INCLUSIVE Loans Gayle has a HELOC with MCAP Financial Corporation at an interest rate of prime + 2.75%. Her current balance owing on November 1 is $13,250.00...

question & answer is provided. please show this answer/calculations in excel. thank you! You are thinking of purchasing a house that costs $175,000. You have $12,000 in cash that you can use as a...

Please Answer on Excel Assignment#1 Loan Amortization You are thinking of purchasing a house. The house costs $350,000. You have $50,000 in cash that you can use as a down payment on the house, but...

Question 1 -Interest & loan Sue will need $120,000 to refurbish her house at the corner of a main road into a cake shop in 5 years. She has a saving account which carn 3.47 % p.a. compounding...

Assignment#1 Loan Amortization You are thinking of purchasing a house. The house costs $350,000. You have $50,000 in cash that you can use as a down payment on the house, but you need to borrow rest...

What are the yield ratios for each step in the recruitment and selection process? What are the implications of these ratios for future hiring?

Please answer these true/false questions. 1. Endo-glucanase is an exocellulases 2. A selection pressures on weeds in a freshly tilled agricultural field are called r-selection. 3. Mitochondrial RNA...

Question 4 2 0 pts What is the difference in returns between the tenth smallest portfolio of stocks and the tenth largest portfolio, from 1 9 2 6 - 2 0 2 2 , suggesting a small - firm effect? 6 . 7 %...

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".