Please help with question 6 only! Thank you!

1) Your company will buy a heavy general-purpose truck. The purchase price is $90,000. Shipping and training will cost $10,000 to make the truck serviceable. Salvage=$0.

2) The Basis is 100k, Depreciable life on the truck is 7 years, and the Annual Depreciation Deduction is $20,000, Discount Rate = 12%

Question 5: Continuing with Question 1, if this truck is to be used for a project with a life of 4 years, and the annual profits estimated to be gained by the use of this truck is $35K, and its Market Value at the end of the project life is $50K, use Straight Line Depreciation to calculate its After Tax Cash Flows (ATCF). The effective tax rate is 40% and the ATRR is 12%. What is the NPV, IRR AND PI of this project based on this after tax analysis? Is this project feasible or not? Explain clearly.

Question 6: Continuing with Question 1 and using the additional info given in Question 5, use the MACRS method to perform after tax analysis. The effective tax rate is 40% and the ATRR is 12%. What is the NPV? What is the NPV, IRR AND PI of this project based on this after tax analysis? Is this project feasible or not? Explain clearly.

Take a screenshot of your well-organized, clean, 1-page work and upload it here. PLEASE UPLOAD ONLY THE SCREENSHOT. DO NOT UPLOAD AN EXCEL FILE (files other than a screenshot will NOT be graded)!

Hint: Use the following columns:

k; BTCF; MACRS rate; dk; NIBT=BTCF-dk; T=-t*NIBT; ATCF=BTCF+T; ATCF including the MV