Home > Thus,The following info is about Hola Kola Case Match the Supporting Excel Assignment
Thus,The following info is about Hola Kola Case Match the Supporting Excel Assignment
Thus,The following info is about Hola Kola Case Match the Supporting Excel Assignment. In evaluating a potential investment project, the first thing is to examine the investment environment of the company
Hola Kola Case: Match the Supporting Excel Assignment
Please read the Hola Kola Case reading, the project is based on the case reading and all the numbers throughout the article must match the supporting excel. The excel provided is an example only that must be follow by using the income statement, balance sheet and other quantitative number in the reading. This order require a support excel to show all calculation, and a write up paper (3+pgs) that explain the Hola Kola case sensitive analysis and results. Hola Kola Case:
The write up portion should start with an executive summary • Include numerical analysis (when inserting printouts of Excel worksheet) • Provide justifications for the assumptions made in your analysis. Firstly, Note: What do you think about the soda market in Mexico? What would be the potential risks and benefits of this investment to Hola-Kola? What are the key factors that could potentially affect the related cash flows and ultimately, the NPV. Secondly, What are the relevant cash flows? Note: Define working capital requirement as: Hola Kola Case:
3. Based on your projections of cash flows, compute a net present value (NPV) and internal rate of return (IRR). 4. What is the breakeven point in sales that makes NPV equal to zero? 5. Based on your evaluation of business conditions and cash flow analysis, discuss the key variables that you. Thus, think are critical to the value of the project. Using Data Table in Excel, conduct sensitivity analyses and examine the sensitivity of NPV to the key variables that you have identified. 6. Using the “Scenario Manager” tool in Excel, conduct a scenario analysis based on the following two conditions in addition to the base case.
Read more on Hola Kola Case: Match the Supporting Excel Assignment here
Click here to request for this assignment help
Place Order Now
