Instead of inputting the answers, CAN I PLEASE GET THE FUNCTION FORMULA. Thank you.

File Home Insert Page Layout Formulas Data ReviewView Help Tell me what you want to do AutoSum cut Copy Format Painter Calibri Number Fill Conditional Format as Cell Insert Delete Format Formatting , Table- Styles- , Paste I U Clear- Clipboard Cells C11 Output Area Input Area IPMT PPMT What amount of 2 Loan 3 APR 4 Years 5 Pmts per Year 6 Payment princia wilipy atPeriodic Rate 2.74% the 3-year mark? No. of Pmts What amount of interest will I pay at the 2-year mark? 12 Output Area is Necessary for CUMIpmt and CUMPrinc Functions Payment Beginning M Number Balance Payment Cumulative Cumulative Interest Paid Principal Repayment Balance Principal Interest 10 1 S 30,000 $ Instructions 12 1) Calculate the monthly payment in cell B6 based on the items above it 4 14 15 16 17 18 19 2) Now you can fill in all the yellow boxes and complete the amortization table below Be sure to use appropriate absolute/mixed cell referencing 10 21 12 13 14 15 16 17 23 24 25 26 Amortization