Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help setting thos up in an Excel format, please. y is contemplating 11-25 Integrative-Determining relevant cash flows Lombard Company is contemp the purchase

I need help setting thos up in an Excel format, please.
image text in transcribed
image text in transcribed
y is contemplating 11-25 Integrative-Determining relevant cash flows Lombard Company is contemp the purchase of a new high-speed widget grinder to replace the existing grinde, existing grinder was purchased 2 years ago at an installed cost of $60,000: it being depreciated under MACRS using a 5-year recovery period. The existing grinder is expected to have a usable life of 5 more years. The new grinder costs $105.000 and requires $5,000 in installation costs; it has a 5-year usable life and would be depreciated under MACRS using a 5-year recovery period. Lombard can currently sell the existing grinder for $70,000 without incurring any removal or cleanup costs. To support the increased business resulting from purchase of the new grinder, accounts receivable would increase by $40,000, inventories by $30,000, and accounts payable by $58,000. At the end of 5 years, the existing grinder would have a market value of zero; the new grinder would be sold to net $29,000 after removal CHAPTER 11 Capital Budgeting Cash Flows and cleanup costs and before taxes. The firm is subject a 40% tax rate mated cars before deprecia t erest and over the 5 years for botn the new and the existing prinder are shown in the following table Table page 117 contains the applicable MACRS depreciation percentages.) Ears before Year New grinder 543,000 Existing rider $26.000 24,000 22.000 20,000 18.000 43,000 43.000 1. Calculate the initial investment associated with the replacement of the existing grinder by the new one. b. Determine the incremental operating cash inflows associated with the proposed grinder replacement. (Note: Be sure to consider the depreciation in year 6.) c. Determine the terminal cash flow expected at the end of year 5 from the pro- posed grinder replacement. d. Depict on a time line the relevant cash flows associated with the proposed grinder replacement decision

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Managerial Finance

Authors: Chad J. Zutter, Scott Smart

16th Edition

0136945880, 978-0136945888

More Books

Students also viewed these Finance questions