AA Homeloan- Excel Formulas Data Review View Tell me what you want to do File Home Insert Page Layout AutoSum -11- A A Wrap Text Currency Gill Sans MT Conditional Format as Cell Table Styles Merge & Center Delete Format Paste A. Insert 8IU Clear Formatting Alignment Number Styles Cells Clipboard Font Home Loan Options A1 M J K F G H C D A Home Loan Options 1 $276,000 2 Amount of Loan 3 Period (years) 4 Interest rate (per year) 5 Payment (per month) 15 4.75 % 6 10 11 12 Home Loan Payment Table Ready Ask me anything 1.00 Point XL Activity 4.01: Inserting the PMT Financial Function On the Home Loan worksheet, in cell B5, calculate the monthly payment for the loan using the PMT function. Use the rate in cell B4 divided by 12, the number of years in cll B3 multiplied by 12, and cell B2 as the present value. Modify the function to ensure that it returns a positive value. 1 of 12 Type here to search DELL WEN