60.1K

Verified Solution

Link Copied!

For parts 1-5. You have the option to lease or purchase an asset which will have a 3-year life. You can purchase the asset for $17,500, or you can lease it for 3 years with the first payment of $6500 due today(the cash flow will be 3 equal payments at the beginning of periods 1,2, and 3). You can borrow from the bank at 18%. Create a spreadsheet model in Excel to compare each option. Could you please show me the formulas in excel!

1.) What is the NPV of the costs of the lease? A.) 16594 B.) -17060.57 C.) 18542 D.) 16677

2.) Use an if()function to determine your lease vs purchase decision based on NPV of the lease-minus-purchase decision. Select its output here: A.) Purchase B.) Lease

3.) Create an additional column that contains the Lease Minus Purchase cash flows, and calculate the IRR of the differential cash flows. A.) .061 B.) -.14875 C.).119 D.).18

4.) You discover that the asset will have a salvage value at the end of year 3 of $1000. What is the new NPV of the costs of the purchase? A.) .16677 B.) 17476 C.) 16653 D.) -16677

5.) Determine the purchase price at which you would be indifferent between the lease or the purchase decision (given the new salvage value). Using your completed model, substitute the following numbers to approximate the correct answer. A.) 17524 B.)17476 C.) 23177 D.) 17675

Answer & Explanation Solved by verified expert

See Answer