Corporation Finance PV Problem-Car Lease You are considering buying a new car. The car costs $35,000. You can either lease it or purchase it with a three year loan. The lease arrangement requires that you pay $1 today and $450 per month for the next three years. You can also purchase the car with a three year loan at 8%. The loan would require monthly payments. Input the key facts into an excel spreadsheet. Then, use Excel to calculate the following information: a. What is the cash price of the car today? What is the PV of the loan arrangement? Is it equal to the cash price today? b. What is the PV of the lease arrangement? Why is it less than the cash price of buying the car? c. Note that the timeline must be modified when the customer purchases the car because he/she retains the value of the car at the end of the life of the loan. That benefit changes the "net" present value of the cost of buying the car. Suppose you believe you will sell the car for $23,000 at the end of the third year. What the new "net" present value of the car loan/purchase alternative? Is leasing still the less expensive alternative? d. What is the value of the car (in three years) that would make you indifferent between buying and leasing today? e. 23