Please post formula

ShareAbsolute MS Cell Reference in a Formula Enter a formula in cell F8 to calculate the Rate Per Period for the first loan by Vdividing the Mortgage Rate by the Pmts Per Year (12) using relative cell references: -E8/B5. Copy the formula to the range F9:F12. Look at cell F9, and then undo the action of copying the formula since it erroneously uses a relative cell reference. Edit the Rate Per Period formula in cell F8 by making cell B5 an absolute reference. Copy the formula to the range F9 F12 len r u . 1. I a. A, |! |Merge & Center $-56 , |Conditional Format as-Cell Formatting Table Styles Insert Delete Font Number A1 send Mortgage Company 1 Townsend Mortgage Company Input Area 4 Today's Date: 5 Pmts Per Year: 12 House Down Amount Mortgage Rate Per Date Payoff Period Years Periods Financed Financed Year #ofPmt % Loan # Cost Payment Financed Rate 8 452786 4,00,000 80,000 3,20,000 9 453000 3,50,000 60,000 2,90,000 0453025 1,75,500 $ 30,000 1,45,500 11 452600 2,65,950 58,000 2,07,950 12 452638$ 3,29,750 65,000 2,64 3.625% 3.550% 3.250% 01-05-2011 03-11-2011 10-04-2012 14-10-2012 04-02-2013 14 Summary Statistics House Down Amount Cost Payment Financed Statistics 16 Total 18 Median 20 Highest 21#of Mortgages ShareAbsolute MS Cell Reference in a Formula Enter a formula in cell F8 to calculate the Rate Per Period for the first loan by Vdividing the Mortgage Rate by the Pmts Per Year (12) using relative cell references: -E8/B5. Copy the formula to the range F9:F12. Look at cell F9, and then undo the action of copying the formula since it erroneously uses a relative cell reference. Edit the Rate Per Period formula in cell F8 by making cell B5 an absolute reference. Copy the formula to the range F9 F12 len r u . 1. I a. A, |! |Merge & Center $-56 , |Conditional Format as-Cell Formatting Table Styles Insert Delete Font Number A1 send Mortgage Company 1 Townsend Mortgage Company Input Area 4 Today's Date: 5 Pmts Per Year: 12 House Down Amount Mortgage Rate Per Date Payoff Period Years Periods Financed Financed Year #ofPmt % Loan # Cost Payment Financed Rate 8 452786 4,00,000 80,000 3,20,000 9 453000 3,50,000 60,000 2,90,000 0453025 1,75,500 $ 30,000 1,45,500 11 452600 2,65,950 58,000 2,07,950 12 452638$ 3,29,750 65,000 2,64 3.625% 3.550% 3.250% 01-05-2011 03-11-2011 10-04-2012 14-10-2012 04-02-2013 14 Summary Statistics House Down Amount Cost Payment Financed Statistics 16 Total 18 Median 20 Highest 21#of Mortgages