Am. 313. A1 Mortgage Calculator234 Loan Amount5 Deposit6 Term (Years)7 Interest Rate891011 $12 $13 $14 $15 $16 $17 $18 $19 $Input Cells300,000325,000350,000375,000400,000425,000450,000475,000500,000300,000.0060,000.00155.00%15C20DResult CellsFinanced AmountMonthly PaymentTotal RepaidTotal Interest30E240,000.00$1,897.90$341,622.85$101,622.85LLSHanalysis shows.2. Suppose you know the annual interest rate will be 5 percent and you are going to put down 20% of the overallloan value. Create a table that shows for purchase prices from $300,000 through $500,000 (in $25,000increments), the difference in monthly payments between a 15-year, 20-year, and 30-year mortgage.

A mortgage is a specific kind of loan that is used to finance the acquisition of real estate, like a…

Suppose you know the annual interest rate will be 5 percent and you are going to put down 20% of the overall loan value. Create a table that shows for purchase prices from $300,000 through $500,000 (in $25,000 increments), the difference in monthly payments between a 15-year, 20-year, and 30-year mortgage.