please someone do it within next two hours i will be really helpful

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 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 Amandeer the following table illustrating the comparison of the lease vs. finance options for the vehicle he liked. Copy the table into your notes and fill in each cell. Some cells will require a calculation using your Ball plus calculator; some will be copied directly from your data set. Don't forget to show your work where possible. Leasing the car Financing the car Down Payment Interest Rate compounded annually List Price Additional purchase costs 13% HST De total hasta listi Net Price Term in months [BGN) HST [END] Monthly payments Residual (FV) payment to own ad HST 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. b. Draw a detailed timeline for the lease option. Be sure to in (with HST) at the end of the last payment interval, the net price, and the after-tax payments at equal payment intervals. 1 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. Completion and Grading Submit your personal data set as well as your completed assignment to the Moodle dropbox by the due date indicated in the Moodle assignment link. See the Grading Criterion in the Moodle assignment link for the full rubric on how you will be graded Leasing the car Down payment {A} $2,000.00 Interest (compounded annually) {B} 4.50% List Price {C} $26,800.00 Additional purchase costs {D} $1,508.00 Term in months {F} 72 {G} $300.00 Monthly payments (without HST) (beginning-of-month payments) Residual (FV) payment to own {H} $13,100.00 Down payment Interest (compounded annually) List Price Additional purchase costs Term in months Financing the car {A} {B} {C} {E} {F} $2,000.00 4.50% $26,800.00 $1,734.00 72 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 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 Amandeer the following table illustrating the comparison of the lease vs. finance options for the vehicle he liked. Copy the table into your notes and fill in each cell. Some cells will require a calculation using your Ball plus calculator; some will be copied directly from your data set. Don't forget to show your work where possible. Leasing the car Financing the car Down Payment Interest Rate compounded annually List Price Additional purchase costs 13% HST De total hasta listi Net Price Term in months [BGN) HST [END] Monthly payments Residual (FV) payment to own ad HST 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. b. Draw a detailed timeline for the lease option. Be sure to in (with HST) at the end of the last payment interval, the net price, and the after-tax payments at equal payment intervals. 1 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. Completion and Grading Submit your personal data set as well as your completed assignment to the Moodle dropbox by the due date indicated in the Moodle assignment link. See the Grading Criterion in the Moodle assignment link for the full rubric on how you will be graded Leasing the car Down payment {A} $2,000.00 Interest (compounded annually) {B} 4.50% List Price {C} $26,800.00 Additional purchase costs {D} $1,508.00 Term in months {F} 72 {G} $300.00 Monthly payments (without HST) (beginning-of-month payments) Residual (FV) payment to own {H} $13,100.00 Down payment Interest (compounded annually) List Price Additional purchase costs Term in months Financing the car {A} {B} {C} {E} {F} $2,000.00 4.50% $26,800.00 $1,734.00 72