Please post formulas

1.00 Point: XL Step 2.1.3: Use a 2 ShareMixed Cell Reference in a Formula Enter a formula in cell HB to calculate the # of Pmt Periods for the first loan by multiplying the Years by the Pmts Per Year using a mixed cell refe containing the Pmts Per Year: G8"B$5. Copy the formula in cell H8 down the # of Pmt Periods column to the range H9 H12 rence for the cell Data Format as Cell Insert Delete Format c FormattingTable Styles Font nd Mortgage Company Townsend Mortgage Company Input Area 4 Today's Date: 5 Pmts Per Year: 12 Date Payoff Period Years Periods Financed Financed Year #ofPmt % House Down Amount Mortgage Rate Per Cost Payment Financed Rate 400,000 $ 80,000 320,000 350,000 $ 60,000 290,000 Loan # 5/1/2011 11/3/2011 4/10/2012 10/14/2012 2/4/2013 8 452786 9 453000 10 453025175,500 30,000 145,500 0.3 0.296% 25 0. 3.550% 11 452600 265,950 58,000 $ 207,950 12 452638 329,750 65,000 13 Summary Statistics House Down Amount Cost Payment Financed Statistics 6 Total 8 Mediarn Highest # of Mortgages