i am looking for the following functions for the excel sheet that'll help solve it.

interest rate-

monthly payment function-

closing cost function-

mortgage insurance function-

average minthly payment function-

highest monthly payment function-

lowest monthly payment function-

number of loans function-

numbers of mortgages requiring function-

Im not looking for the answers to all of it, just the functions thatll help solve it.

thank you!

Segnet Mont FORMULAS DATA REVIEW VIEW -A A FILE HOME INSERT PAGE LAYOUT * Cut Times New Roma - 16 La Copy - Paste Format Painter Clipboard Font Ef Wrap Text a-A- === Merge & Center Alignment F H21 X for B E F G 4 Prepared on: 9/11/2020 Acct. # Loan Amount Term (years) Interest Rate Monthly Payment Closing Cost Mortgage Insurane 5 6 Customer 7 Name 8 9 OLEARY 10 CURTIN 11 JUDD 12 NAPIER 13 STARR 4 DELMONTE 5. FARZAD WOODS DEMON KEMP HANSON O NAGLE 5647 8945 5623 9089 8877 6607 4509 $ $ $ $ $ $ $ $ $ $ $ S 125,000 150,000 75,000 130,000 225,000 165,000 200,000 100,000 80,000 58,000 95,000 350,000 30 20 15 15 20 15 20 25 30 30 15 20 9023 1093 7410 1313 1992 Average Monthly Payment: Highest Monthly Payment: Lowest Monthly Payment: Number of Loans Number of mortgages requiring mortgage insurance: Mortgage Report Int. Rate Sheet3 ADY o Type here to search 0 U FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW X Cut e Copy Times New Roma - 14 -A Paste EP Wrap Text Format Painter BLUE A Clipboard Merge & C Font Alignment table1 : X fro B D E F G 1 2 3 4 5 6 Interest Rate and Closing cost Table Amount Int. Rate Closing Cost 0 6% 500 50000 5% 750 100000 4.50% 1000 150000 4% 1250 200000 3.50% 1500 250000 3% 2000 7 B 9 9 10 11 12 13 14 15 16 17 18 19 20 Mortgage Report Int. Rate Sheet READY Type here to search