In cell B27, calculate the number of years it would take to pay off the amount borrowed in loan option 3, using the total payment periods calculated in cell B26. Format as a number with 2 decimal places.

JLU 6. Interest Rate 7 Term of Loan (years) 8 Payments per Year 9 Monthly Payment (end of period) 10 Monthly Payment (beginning of period) $2,553.69 $2,538.46 12 Loan Analysis - Option 2 $218,000.00 $2,200.00 14 Loan Amount 15 Monthly Payment 16 Term of Loan (years) 17 Payments per Year 18 Interest Rate (end of period) 19 Interest Rate (beginning of period) 0.33% 0.33% 20 21 Loan Analysis - Option 3 $218,000.00 7.20% $2,200.00 150.91 23 Loan Amount 24 Interest Rate 25 Monthly Payment (end of period) 26 Total Number of Payments (end of period) 27 Term of loan in years 28 29 Loan Analysis - Option 4 30 $218,000.00 7.2% 31 Loan Amount 32 Interest Rate 33 Term of Loan (years) 34 Payments per Year 35 Quarterly Payments $7,692.29 Quarter Principal Payments Interest Pa Loan Analysis NPV Depreciation DescriptiveStatistics Ready 1 Type here to search O