Question: Please complete this in Excel using MACRS depreciation rates, be sure to show any formulas you use. The final cash flows should be yr 0

 Please complete this in Excel using MACRS depreciation rates, be sure

Please complete this in Excel using MACRS depreciation rates, be sure to show any formulas you use. The final cash flows should be yr 0 = $115,000 yr1 = $112,344 yr 2= $122,572 yr 3 = $109,894 yr 4 = $101,827 yr 5 = $109,015. Do not repost Chegg Textbook solution as it is incomplete in explanation. Thank you so very much!!

Refer to the financial data in Problem. Suppose that 50% of the initial investment of $230,000 will be borrowed from a local bank at an interest rate of 11% over five years (to be paid off in five equal annual payments). Recompute the after-tax cash flow. Problem An automaker is considering installing a three-dimensional (3-D) computerized car-styling system at a cost of $230,000 (including hardware and software). With the 3-D computer modeling system, designers will have the ability to view their design from many angles and to fully account for the space required for the engine and passengers. The digital information used to create the computer model can be revised in consultation with engineers, and the data can be used to run milling machines that make physical models quickly and precisely. The automaker expects to decrease the turnaround time for designing a new automobile model (from configuration to final design) by 22%. The expected savings in dollars is $250,000 per year. The training and operating maintenance cost for the new system is expected to be $50,000 per year. The system has a five-year useful life and can be depreciated according to the five-year MACRS class. The system will have an estimated salvage value of $5,000. The automaker's marginal tax rate is 40%. Determine the annual cash flows for this investment. What is the return on investment for the project

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!