Please show the formula used and explain the steps as well!

Thank you

Jx Term In Years Loan Calculator Mortgage Payment Calculator 3Down Payment 4 5Rate 6 7Manthly Payment 8 Total Interest Price Loan Amout Years S247,000.00 S45,000.00 S202,000.00 9.25% 15 3.375% 15 Date Item Price Down Pymt. Loan Amount 17-Mar-19 Rate House Term $369,000.00 Monthly Payment 75,000.00 Total Interest $0.00 $369,000.00 Total Cost (S202,000.00) S45,000.00 9Total Cast Future Value Present Value 10 11 Interest Rate 12 Months 13 Monthly Investment 14 Future Value 15 6 nstructions: 5.00% 240 S50 S1,904,956,208.48 Annual Rate Term In Years Monthly Pymt Present Value 675% S987 7Find the payment in C7 Please note: If the terms are in years, you multiply the term times 12 to convert the data to months. 18 orrect the function in C14 9 Find the pv in F14 20 Find the loan amount in F7 and the monthly payment in HB 21 23