Your company may buy a used pick-up for $15,000. During the truck's five year useful life, it is estimated the firm will save $5,000 per year after all of the costs of owning and operating the truck have been paid. The truck's salvage value is estimated to be $3,000. Assume straight line depreciation and a tax rate of 35%. Assume r of 10%.

Create a model that will calculate before-tax and after-tax cash flows.

Perform the same analysis on another tab of your spreadsheet using a tax rate of 39%.

Submit your file as your response to this question. Be sure to include all required elements and to submit your file with tabs for both 35 and 39 percent tax rates.