On the Loan worksheet, in cell C9, enter a PMT function to calculate the monthly payment for the Altamonte Springs 2018 facilities loan. Ensure that the function returns a positive value and set the references to cells B5 and B6 as absolute references.

B h'd' e02h3JobFairAttendance- Excel File Home Insert Page Layout Formulas Data Review View 9 Tell me what you want to do... fx 2 I. IE I. I. I. I. E E [9 GE Dene Name v 3:: Trace Preoedents E Show Formulas E 71 7 an 4 - 66 )3 Use In Formula mg Trace Dependents 0 Error Checking v insert AutoSum Recently Financial Logical Tert Date 81 Lookup 8L Math 51 More Name . Watch Calculatic Inction ' Used ' v v ' Time ' Reference ' Trig ' Functions ' Manager g Create from Selection 1; Remove Arrows ' Evaluate Formula Window Options Function Library Dened Names Formula Auditing 'MT V 7* fr =PMT() A B i C i D E F i G i H 1 J K L M N i c Orlando Area Job Fair 2018 Facilities Loans by Location W\" mus Function Arguments ? X Interest Rate: 4.5% PMT Nunber of Payments: 12 Ram I = number Nper I = number Pv - = number location Facilities Cost Month Pa nt Fv - = number Altamonte Springs 5 16,450.95 =PMT() _ be ) gem. 0,13,,\" 5 54,987.38 W - \"m r Caselberry 5 36,201.59 = 1 "55immee 5 21: 3m-25 Calculates the payment for a loan based on constant payments and a constant interest rate. ; lake Mary 5 39'814'27 Rate is the interest rate per period for the loan. For example, use 696/4 for quarterly 1 Mount Dora 5 28,656.39 payments at 6% APR- ; St. Cloud 5 42,562.51 3 l Formula result = ; Help on this function - Cancel )