Mini-Case Amandeep, a graduate of Cambrian College's Business Program, found a job as an online marketing specialist for Tangerine Bank. Within a year, he had saved {A} and decided to buy a new car but was not quite sure if he should lease it or buy it through financing from the bank. Assume a rate of interest of [B} compounded annually for both options. Lease payments are subject to HST (Harmonized Sales Tax). Taxes should not be added to the list price or net price of the vehicle for the lease option, only to the payment Additional purchase costs include freight & PDI, Air Conditioner Tax, Tire Tax, and registration fees. a. A salesperson at the car dealership gave Amandeep the following table illustrating the comparison of the lease vs. finance options for the vehicle he liked. Copy the table below into your notes and fill in each cell using the Excel data set. Some cells will require a calculation using your Ball plus calculator; some will be copied directly from your Excel data set. Don't forget to show your work where possible. b. Draw a detailed timeline for the lease option. Be sure to include the residual value (with HST) at the end of the last payment interval, the net price, and the after-tax payments at equal payment intervals. c. Which option would be most economical for Amandeep? Show all calculations and provided a detailed explanation with your answer. Hint: Compare NPVs d. What should the residual payment be (including taxes) in order to make both options equal? e. Which option would be most economical if the residual value was $20,000 (including HST) for the lease option? Provide justification for your answer. Leasing the car Down payment $2,000.00 {A} {B} Interest (compounded annually 5.009% List Price $27,100.00 $1,548.00 Additional purchase costs {C} [D} {F} {G} Term in months TVIONITy payments WILDL UGTI S270.00 (beginning-of- month payments) $13,100.00 Residual (FV) payment to own {H] 10 11 Financing the car 12 Down payment $2,000.00 13 Interest (compounded annually {B} 5.0096 14 List Price {C} $27,100.00 $1.780.00 15 Additional purchase costs 16 Term in months [E] {F} 72