Foster Company wants to buy a special automated machine to replace an existing manual system....
80.2K
Verified Solution
Link Copied!
Question
Accounting
Foster Company wants to buy a special automated machine to replace an existing manual system. The outlay required is $3,500,000. The new machine will last 5 years with no expected salvage value. The expected annual cash flows are as follows: 2. Set up a table similar to the one in the Excel example file to show the calculations for the NPV (how you format it is up to you). You MUST show the years, annual net cash flow, discount factor, present value, and final NPV. MUST use a formula in the cell for any ralsulatinns If nnints) 3. Now assume that inflation over the 5 year useful life of the machine is expected to be 5% each year. Explain how the company would account for inflation in their estimates? ( 2 points) 4. Calculate the new net cash flow values for each year (to include inflation consideration). Hint: Inflation does not affect the outlay in year 0. (3 points. MUST use a formula in the cell for your calculations) 6. Accounting for inflation is a necessity in any planning/budgeting decision. Compare the NPV you calculated in \#2 vs the NPV you calculated in \#5. Did accounting for inflation change the decision the company should make? How so? ( 2 points)
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!