Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Walmart is evaluating a $1,200,000 capital investment. The financial details include an initial investment of $1,200,000 and an annual depreciation rate of 10%, resulting in

Walmart is evaluating a $1,200,000 capital investment. The financial details include an initial investment of $1,200,000 and an annual depreciation rate of 10%, resulting in yearly depreciation of $120,000. The book values at the end of each year decrease progressively from $1,080,000 to $0 over ten years. The projected cash flows are $200,000, $220,000, $240,000, $260,000, $280,000, $300,000, $320,000, $340,000, $360,000, and $380,000. The corresponding profits are $80,000, $100,000, $120,000, $140,000, $160,000, $180,000, $200,000, $220,000, $240,000, and $260,000, leading to ARR percentages ranging from 6.67% to 21.67%. The average profits are $172,000, the average investment is $600,000, and the average ARR is 28.67%. The payback period is calculated to be 5.2 years, and the NPV at an 8% discount rate is $130,000.

Requirements:

  1. Compute the ARR, payback period, and NPV.
  2. Analyze the investment's profitability.
Make a recommendation on whether Walmart should proceed with the investment.

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_2

Step: 3

blur-text-image_3

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

Financial Reporting Financial Statement Analysis And Valuation A Strategic Perspective

Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

9th Edition

1337614689, 1337614688, 9781337668262, 978-1337614689

More Books

Students also viewed these Accounting questions