no excel!!!

Congratulations, you recently inherited a farm, and decided to purchase a new road-safe tractor unit for $98,000 ! You plan on keeping the tractor unit for the next six years, at which time you will sell it for its salvage value of $8,000. Over these six years, you expect annual revenues-less-expenses due to the new tractor to be $20,000 per year. Assuming an effective tax rate of 25% and a MARR of 7%, a) [30pt] Calculate the annual depreciation and book value of the tractor, for each of the six years, using the following methods: i. SL (assume nonMACRS SL method) ii. DB (200%) iii. GDS b) [8pt] Using the GDS depreciation calculated in part a), convert your annual BTCFs to ATCFs. c) [4pt] Using the ATCFs calculated in part b), create a cash flow diagram of this scenario. d) [8pt] Using the ATCFs calculated in part b), calculate the PW of this purchase. Is this a good investment