Not sure what formula to use.

Secure https://sim5 pegasus pea so cmg.com/SM5Services SIM5Frame.aspx?resli k1D-4000001505471 7898 esultID=&nonce-ee0b3095-80 9-4c35-9f68-69c07e00e0618 aunch odezqe8mtdEeV5pKO g eEUGcw1UXS2NM 02h3JobFairAttendance- Microsoft Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW IEW SIMS AT 1.00 Point: XL Step 2.3.2 Use the PMT Function Conditional Formatting- e-nsert . Fommat as Table Cell Styles ing" Delete" Calibri ' . - General % , .284% Format, e. Sort &Find & Filter- Select- Filter Clipboard Aignment View All Q Reset C E12 On the Loan worksheet, o in cell C9, enter a PMT function to calculate the monthly payment for the Altamonte Springs 2015 facilities loan. Ensure that the function returns a positive value and set the references to cells B5 and B6 as absolute references. Copy the formula to the range C10:C15 1 Orlando Area Job Fair 2 2015 Facilities Loans by Location Loan Details Interest Rate: 6 Number of Payments: 4.5% 12 Location Facilities Cost Monthl $ 16,450.95 $64,987.38 $ 36,201.59 $21,300.25 ent 9Altamonte Springs$ 0 Central Orlando 1 Caselberry 2 Kissimmee 3 Lake Mary 4 Mount Dora 5 St. Cloud 39,814.27 $ 28,656.39 $42,562.51 11 of 16 Attempts Remaining Save Submit Attendance Loan Keyboarc +100% 6:18 PM 7/3/2017 Accessibility