Project value analysis
Not what you're looking for?
Scenario
The board liked the analysis you did on valuation and agreed to proceed with the expansion plan. Your CFO, investment bankers, and consultants have all been working on the cost and benefits of various expansion options. They have agreed on an option that will see simultaneous expansion into five domestic markets (Chicago, Dallas, Miami, NY, and Charlotte), Germany and Brazil. The CFO has developed cost and benefits of the scenario in a spreadsheet and has asked you to review it.
Look at the spreadsheet and use present value analysis to discount the cash flows. Include the calculations for net income, operating cash flows, free cash flows and the present value cash flows and NPV in your spreadsheet. Does the project have a positive or negative NPV? What are the implications for CPI 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 do you think the CEO had to make. 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, would you support the above mentioned option for expansion? Why or why not.
Additional Objectives: Explain the significance and implications of various economic theories pertaining to profit, consumer choice, demand and supply, forecasting, and optimization. Apply risk methodologies to economic situations using a variety of approaches ranging from basic statistics to certain equivalency.
The CEO's spreadsheet
Year 2011 2012 2013 2014 2015 2016
Cost of Capital 6% 6% 7% 8% 8%
(US$ in millions)
Revenue $30.10 $34.20 $38.10 $40.40 $45.60
Selling, General, Admin ($16.10) ($17.20) ($18.90) ($19.50) ($21.40)
Depreciation ($4.10) ($4.40) ($4.80) ($4.90) ($5.30)
Interest Expense ($0.45) ($0.56) ($0.69) ($0.73) ($0.78)
Taxes ($1.10) ($1.30) ($1.70) ($1.90) ($2.00)
Increase in fixed assets ($1.30) ($2.40) ($0.90) $0.00 ($4.90)
Year 2017
Cost of Capital 7%
(US$ in millions)
Revenue $50.00
Selling, General, Admin ($24.30)
Depreciation ($5.70)
Interest Expense (0.81)
Taxes (42.10)
Increase in fixed assets ($2.10)
Initial Capital Expenditure ($18.00)
Students need to calculate the following
Net Income
Depreciation (provided) year 2012 ($4.10) year 2013 ($4.40)
year 2014($4.80) year 2015 ($4.90) year 2016 ($5.30) year 2017 ($5.70)
Operating Cash Flows (FV) year 2012 4.25; year 2013 6.34; year 2014 7.21; year 2015 8.47; year 2016 10.82; year 2017 11.39
Increase in fixed assets (provided) year 2012($1.30) year 2013($2.40) year 2014($0.90) year 2015 $0.00 year 2016 $(4.90)
year 2017 ($2.10)
Pvif factor year 2012 0.943; year 2013 0.89; year 2014 0.816; year 2015 0.735; year 2016 0.681; year 2017 0.666
Need PV Cash Flows
Value of future flows
Initial expenditure
NPV
Period 1 1% = 0.990; 2%= 0.980; 3%= 0.971; 4% = 0962; 5% = 0.952;
6% = 0.943; 7% = 0.935; 8% = 0.926; 9% = 0.917; 10% 0.909
Period 2 1% = 0.980; 2% = 0.961; 3% = 0.943; 4% = 0.925; 5% = 0.907;
6% = 0.890; 7%= 0.873; 8% = 0.857; 9%= 0.842; 10% = 0.826
Period 3 1% = 0.971; 2% = 0.942; 3% = 0.915; 4% = 0.889; 5% = 0.864;
6% = 0.840; 7% = 0.816; 8% = 0.794; 9% = 0.772;10%= 0.751
Period 4 1%= 0.961; 2%= 0.924; 3%= 0.888; 4%=0.855; 5%=0.823; 6%=0.792; 7%=0.763; 8%=0.735; 9%=0.708; 10% = 0.683
Period 5 1%=0.951; 2% = 0.906; 3%=0.863; 4%=0.822; 5%=0.784; 6%=0.747;
7%=0.713; 8%=0.681; 9%=0.650; 10%=0.621
Period 6 1%=0.942; 2%=0.888; 3%=0.837; 4%=0.790; 5%=0.746; 6%=0.705;
7%=0.666; 8%=0.630; 9%=0.596; 10% = 0.564
Period 7 1% =0.933; 2%=0.871; 3%=0.813; 4%=0.760; 5%=0.711; 6%=0.665;
7%=0.623; 8%=0.583; 9%=0.547; 10%=0.513
Period 8 1%=0.923; 2%=0.853; 3%=0.789; 4%=0.731; 5%=0.677; 6%=0.627;
7%=0.582; 8%=0.540; 9%=0.502; 10%=0.467
Period 9 1%=0.914; 2%=0.837; 3%=0.766; 4%=0.703; 5%=0.645; 6%= 0.592;
7%=0.544; 8%=0.500; 9%=0.460 10%=0.424
Period 10 1%=0.905; 2%=0.820; 3%=0.744; 4%=0.676; 5%=0.614; 6%=0.558;
7%=0.508; 8%=0.463; 9%=0.422; 10%= 0.386
Compute the correct Net Present Value. Articulate the economic and political risk. List options to overcome risk. Form appropriate questions on economic assumptions. Make the correct decision on whether or not to adopt the strategy. Provide the NPV, IRR, MIRR, and Payback Ratio. Please show work.
Purchase this Solution
Solution Summary
The projected value analysis is examined.
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
Economics, Basic Concepts, Demand-Supply-Equilibrium
The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.
Basics of Economics
Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.
Economic Issues and Concepts
This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.
Elementary Microeconomics
This quiz reviews the basic concept of supply and demand analysis.
Pricing Strategies
Discussion about various pricing techniques of profit-seeking firms.