Foster Company wants to buy a special automated machine to replace an existing manual system....

80.2K

Verified Solution

Question

Accounting

imageimage

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!
Become a Member

Other questions asked by students