1. Two lease options with varying lengths but equal rate on the same project 2. Which lease option has the lowest cost? By how much? 3. If the two options were to be equal, what would be the interest rate? Scenarios: Rate Option 1 .00%$5,148.40 4.00% $5,040 86 5.00% $493771 6.00% $4838.73 7.00% $4,743.70 800% s4,652.42 9.00% $4,564 69 NPUT: Option 2 Option 2 $5,441.10 $5,167.94 $4914.73 $4,679.75 s4,46 1.48 $4,258 51 $4,069 60 Option 1 4.84030% Interest Rate Years Annual Lease Payment End-of period Payment Total Payment OUTPUT Net Present Value (PV) Difference 4.84% $1,000.00 $500 00 $5,500.00 $425.00 $3,000.00 $6,400.00 $4,953.90 $4,953.90 S0.00