Carribean Internet Cafe

1. Using the historical data as a guide, construct a pro forma (forecasted) profit and loss statement

Compute the projected profit for the order quantities suggested by the management team under three scenarios: worst case in which sales = 10,000 units, most likely case in which sales = 20,000 units, and best case in which sales = 30,000 units.

The relatively well posed project with promises of great future pay offs must be examined closely nevertheless to determine its true profitability. As such, the Super Project’s NPV must be calculated, however before we proceed we must acknowledge the relevant cash flows. The project incurred an expense of testing the market. This expense, however, must not be included in our cash flow analysis because it can be considered a sunk cost. This expense is required for ‘taking a temperature’ of the market and will not be recovered. Other sources of cash flow include:

2. Net Present Value – Secondly, Peter needs to investigate the Net Present Value (NPV) of each project scenario, i.e. job type, gross margin, and # new diamonds drills purchased. The NPV will measure the variance of the present value of cash outflow (drilling equipment investment) versus the future value of cash inflows (future profits), at the benchmark hurdle rate of 20%. A positive NPV associated with the investment means that the investment should be undertaken as it exceeds the minimum rate of return. A higher NPV determines which project scenario will have the highest return on cash flow, hence determining the most profitable investment in terms of present money value.

Decision Making Area 3:Investment Decisions * Table of Articles * Summary of Articles * Observations * Conclusion

3. Estimate the project’s NPV. Would you recommend that Tucker Hansson proceed with the investment?

Evaluating the risks, calculating the probability of success, and factoring in the projected profit from sales will provide a clearer NPV to be compared with other projects in the

Problem 1: Jonathon Barrs is a manager for Easy Manufacturing, LLC. He wishes to evaluate three possible investments. These investments are for the purchase of new machine tools from Germany, Japan, and a local US manufacturer. The firm earns 10% on its investments and they have a risk index of 5%. The chart below lays out the expected return and expected risks of the three projects.

General Foods is a large corporation organized by product lines. They are evaluating Super Project, the manufacture of a new powdered dessert. Crosby Sanberg, a financial analysis manager, must determine the value in accepting the proposal, along with J.C. Kresslin, the Corporate Controller. The Super Project will increase profit with a payback period of less than ten years. The proposed capital investment for the project is $200,000 ($80,000 for building modifications and $120,000 for machinery and equipment) and production would take place

Our approach to valuing the processing plant can easily be decomposed into three distinct steps first, find the value of the foreseeable free cash flows. Next, calculate the terminal value of the project. Finally, take the present value of those flows. The next few paragraphs walk through each of these steps in order of progression.

Thus, by year three the company will be making a profit off the investment as year three is 86.73 million profit by 55.35 cost giving the company a 31.38 million dollar surplus. Generally, a period of payback of three year or less is acceptable (Reference Entry) causing this project to be viable based off the payback analysis. Although, these calculations are flawed. The reason for this is because the time value of money is not taken into effect when calculating payback periods which is where IRR can further assist in a more realistic financial picture (Reference Entry).

Financial risks include the short payback period. A 3-year payback period would not allow Hansson the opportunity to breakeven. With a negative NPV in the first 3 years Hansson’s decision to invest in the project would be based on his ability to negotiate a longer contract time. The Net Present Value (NPV) would have to be examined in tandem with the other non-financial variables.

The profitability figures as derived from the data given in the case are as follows:

If we look at the financial summary of M.L.I we can calculate how much Winkler can bid for this company. We can calculate Net Present Value, Indicial Rate of Return and Payback period for this project. If we take last year and estimated after tax Income as a projection and investment of $2 million we can calculate:

Scenario 1 which resembles the steady state has a nominal cash flow of 2.5 million. The NPV of scenario 1 is 118,245.21 with an IRR of 8.59%. In scenario 2 the expected cash flow is (2,500,000*1.3) with an NPV of 2,202,737.72 and IRR 16.44%. Scenario 3 has an expected cash flow of (2,500,000*0.85) with an NPV of -960,507.80 and IRR of 4.25%. Taking the three scenarios into account, an expected value of NPV that incorporates the probabilities of each scenario needs to be considered.