90.2K

Verified Solution

Link Copied!

Purchase vs Lease problem:

"For Problems 11-15: You have the option to lease or purchase an asset which will have a 3 year life. You can purchase the asset for $17500, or you can lease it for three years with the first payment of $6500 due today (the cash flow stream will be three equal payments at the beginning of periods 1, 2, and 3). You can borrow from the bank at 18%. On the tab labeled Part 3, Create a spreadsheet model to compare your lease vs. purchase decision. The model should follow best practices (separate your variables from the model or tables you're building), and it should map out the cash flows for each period under each scenario. Problem 11: What is the NPV of the costs of the lease? (Round to the nearest doliar.)" a. 10594 b. -17060.571 c. 18542 d. 16677 Problem 14: 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 QUESTION 15 "Problem 15: Determine the purchase price at which you would be indifferent between the lease or the purchase decision (given the new salvage value). Note that again you know, in your heart, that Solver would be a great way to approach this problem, but alas, you are constrained. Using your completed model, substitute the following numbers in to approximate what Solver is doing. Round to the neareat dollar. " a. 17524 b. 17476 c. 23177 "Problem 12: Use an ifo function to determine your lease vs purchase decision based on the NPrbf the lease-minus-purchase decision. Select its output here (note, you must also have a properly functioning IF function producing this output in your submitted spreadsheet to receive full credit). " a. Purchase b. What even is an IF function man c. OldBeans d.Lease QUESTION 13 "Problem 13; Create an additional column that contains the "Lease Minus Purchase" cash flows, and calculate the IRR of the differential cash flows. (Round to the nearest 2 decimal places, ex:x,%) a. 0.001 b. 0,14875 c. 0.119 d. 0.18

Answer & Explanation Solved by verified expert

See Answer