Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Microsoft is considering a $4,000,000 investment in new data centers. The project will depreciate at a rate of 20% annually, leaving book values of $3,200,000,

Microsoft is considering a $4,000,000 investment in new data centers. The project will depreciate at a rate of 20% annually, leaving book values of $3,200,000, $2,400,000, $1,600,000, $800,000, and $0 at the end of each year. Expected annual cash flows are $1,200,000, $1,400,000, $1,200,000, $1,000,000, and $800,000. The profits are projected at $400,000, $600,000, $400,000, $200,000, and $0, resulting in ARR percentages of 10%, 20%, 10%, 5%, and 0%. The average profit is $320,000, with an average investment of $2,000,000, yielding an average ARR of 16%. The cumulative cash flows indicate a payback period of 3.8 years. The NPV, discounted at 10%, is calculated to be $240,000.

Requirements:

  1. Determine the ARR, payback period, and NPV for the investment.
  2. Discuss the project's potential financial benefits and drawbacks.
  3. Provide a final recommendation on the investment 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

Contemporary Financial Management

Authors: James R Mcguigan, R Charles Moyer, William J Kretlow

10th Edition

978-0324289114, 0324289111

More Books

Students also viewed these Accounting questions

Question

Describe the specific accounts used by a merchandising firm.

Answered: 1 week ago