SWOT Analysis & NPV

Dec 10th, 2014
SKTFaker
Category:
Economics
Price: $45 USD

Question description


Over lunch, you and Lester meet to discuss your next assignment.

"The board of directors has been working on the cost and benefits of various expansion options," he says. "We have developed the numbers for one scenario in this spreadsheet, and we want you to review it," he says handing it to you.

"So you're looking for me to use present value analysis to discount the cash flows," you say. "Should I include the calculations for net income, operating cash flows, free cash flows, and the present value cash flows and net present value (NPV) in the spreadsheet?"

"Yes," he says. "We want to know if the project has a positive or negative NPV. Also, in 500 words or less, explain the implications for AutoEdge and its shareholders if there is a positive NPV or, conversely, if there is a negative NPV."

"This will be interesting," you say.

"Good," he says. "Oh, and one more thing. In addition to considering the NPV value, we want to know what kind of economic assumptions you think the board should consider. Articulate the economic and political risks with the strategy, and list options to overcome them. How will this decision affect the share price and the value of the company? In light of all this information, would you support the option for expansion abroad or relocate back to the United States? Include an explanation of your response, as well."

"I'll get right on it," you say.

Requirements

  1. Word Requirement: Completion of Excel Spreadsheet & 500 words 

    Use the information provided in the spreadsheet to Calculate:

  2. Net Income 

  3. Operating Cash Flows

  4. Free Cash Flows 

  5. Present Value Cash Flows 

  6. Net Present Value 

    Discussions: All discussions must demonstrate application of knowledge to real situations

  7. Based on the Outcome of your NPV Calculation, does the project have a positive or a negative NPV? 

  8. Explain the implications for AutoEdge and its shareholders if there is a positive NPV or a negative NPV 

  9. What kind of economic assumptions should the board consider? 

  10. What are the economic and political risks with the strategy? List options to overcome them.

  11. How will this decision affect the share price and the value of the company? 

  12. In the light of all this information, would you support the option for expansion abroad or relocate back to the United States? Include an explanation of your response.

Copy of ECON616_Revised Phase 4 IP_0616.xls 

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Carnegie Mellon University
PREMIUM TUTOR

Studypool has helped 1,244,100 students

7 Reviews


Summary
Quality
Communication
On Time
Value
kpcutie
Nov 30th, 2016
" Excellent job "
Hemapathy
Nov 17th, 2016
" all I can say is wow very fast work, great work thanks "
BlueOcean
Nov 3rd, 2016
" Awesome! Exactly what I wanted. "
kevin12622
Oct 25th, 2016
" Goes above and beyond expectations ! "
ashleyisgod
Oct 12th, 2016
" Top quality work from this guy! I'll be back! "
likeplum4
Oct 3rd, 2016
" Excellent work as usual "
Molly_Moon
Sep 19th, 2016
" AMAZING as always! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1819 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors