Purchase Solution

NPV Calculations for Expanding Company.

Not what you're looking for?

Ask Custom Question

I need help calculating the attached spreadsheet, If I subtract the metrics in red from the metrics in black how will this calucate the required values for the PV and NPV? I know the PV is the present value factor, but how do I find the PV cash flows to calculate the NPV? A firm is going to expand into 5 domestic markets (Chicago, Dallas, Miami, New York, and Charlotte), Germany, and Brazil. The CFO has developed cost and benefits of the scenario in a spreadsheet. Accodrding to the spreadsheet a present value analysis is needed to discount the cash flows. How do I Include the calculations for net income, operating cash flows, free cash flows and the present value cash flows and NPV in the spreadsheet. Will the project have a positive or negative NPV? What are the implications for the firm and its shareholders if there is a positive NPV or a negative NPV. Is the dollar value of the NPV important in light of the expenditure? In making the final decision, what kind of economic assumptions should be made? Should this investment be Accepted or Rejected? Why? How will a positive NPV affect share price? Articulate the economic and political risk with the strategy and list options to overcome. How will this decision affect the share price and the value of the company? In light of all this information, is there support in the above-mentioned option for expansion? Why or why not. What strategies are there to Overcome the Economic and Political Risks? Thank you

Attachments
Purchase this Solution

Solution Summary

NPV calculations for expanding company is examined.

Solution Preview

Answer:
A firm is going to expand into 5 domestic markets (Chicago, Dallas, Miami, New York, and Charlotte), Germany, and Brazil. The CFO has developed cost and benefits of the scenario in a spreadsheet. Accodrding to the spreadsheet a present value analysis is needed to discount the cash flows. How do I Include the calculations for net income, operating cash flows, free cash flows and the present value cash flows and NPV in the spreadsheet. Will the project have a positive or negative NPV? What are the implications for the firm and its shareholders if there is a positive NPV or a negative NPV. Is the dollar value of the NPV important in light of the expenditure? ...

Solution provided by:
Education
  • MBA, Indian Institute of Finance
  • Bsc, Madras University
Recent Feedback
  • "I've posted a similar question for another course. It's post 657940, and it's a practice problem that I'd like to use for the final exam. Your help will be greatly appreciated. "
  • "thank you!"
  • "Thank you again Jayant. You are super fast. "
  • "Thank you Jayant. You are appreciated. "
  • "Again, thank you Jayant. You are wonderful. "
Purchase this Solution


Free BrainMass Quizzes
Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Introduction to Finance

This quiz test introductory finance topics.