I need help with questions 4 to 7 and please show how to work on the Excel Table. 4.5.6.7.Miranda wants to calculate the monthly payment for a loan to purchase the BeecherStreet house at the most favorable interest rate she found online. Calculate the paymentas follows:a.b.C.d.e.In cell D5, start to enter a formula using the PMT function.For the rate argument, divide the Rate (cell D3) by 12 to use the monthly interestrate.For the nper argument, use the Term_in_Months (cell D4) to specify the numberof periods.In cell D6, enter a formula without using a function that multiples theMonthly Payment (cell D5) by the Term_in_Months (cell D4), and then subtractsthe Loan_Amt (cell B7) from the result to determine the total interest on the mortgage.For the pv argument, use the Loan_Amt (cell B7) to include the present value.Insert a negative sign (-) after the equal sign in the formula to display the resultas a positive amount.In cell D7, enter a formula without using a function that adds the Price (cell B5) to theTotal Interest (cell D6) to determine the total cost of the house.a.Miranda wants to compare monthly payments for interest rates that vary from 4.00 to4.96 percent and for terms of 180, 240, and 360 months. She has already set up thestructure for a data table in the range A11:D24.Create a two-variable data table as follows to provide the comparison that Mirandarequests:InA11, enter a formula without using a function that references theMonthly Payment amount (cell D5) because Miranda wants to compare themonthly payments.b.Based on the range A11:D24, create a two-variable data table that uses the termin months (cell D4) as the row input cell and the rate (cell D3) as the columninput cell. 2346ABNew House Mortgage CalculatorDatePropertyPriceDown PaymentLoan Amount8910Rate11 P*(1/N))/(1-(1/N))^-T)124.00%134.08%144.16%154.24%4.32%4.40%4.48%4.56%4.64%4.72%4.80%4.88%4.96%1617181920212223244>Beecher Street$10/1/2021 RateŞ$350,00035,000315,000C180$2,330.02$2,342.67$2,355.35$2,368.08$2,380.85$2,393.66$2,406.51$2,419.40$2,432.33$2,445.30$2,458.31$2,471.35$2,484.44Term in MonthsVarying Interest Rates and TermsNumber of Months240Monthly PaymenTotal InterestTotal Cost$1,908.84$1,922.14$1,935.50$1,948.91$1,962.37$1,975.88$1,989.45$2,003.06$2,016.73$2,030.45$2,044.22$2,058.04$2,071.91Documentation Sheet1 Mortgage Calculator$$D4.32%360$1,562.55247,516.76597,517360$1,503.86$1,518.42$1,533.06$1,547.77$1,562.55$1,577.40$1,592.32$1,607.31$1,622.37$1,637.50$1,652.70$1,667.96$1,683.30Listings Car LoanEScenariosLoan AmountAnnual Interest RateMonthly Interest RateLoan Period in YearsLoan Period in MonthsStart DateMonthly PaymentFuture Value$GCurrent Rent$Monthly House Payment $Bank 1315,000 $4.40%0.37%303601/5/2022$1,5001,563HBank 24.56%0.38%303601/5/2022($1,176,334.51) $1,151,573.10$(1,500) $Bank 3337,5004.56%0.38%202401/5/2022(1,500)

A loan is referred to as an annuity because it consists of s series of future periodic payments and the formula to calculate loan payments is given as under: P = rPV1-1+r-nwhere, P = Payment PV = Present valuer = rate per periodn = number of periodsExcel table for solutions to Questions 4 to 7: Formula table: