To start up a business you, as its founders, must invest as follows Year 0 1 2 3 4 5 Investment $5,000,000 $0 $2,400,000 $2,400,000 $2,400,000 $2,400,000 Following the times when you are investing, the business is projected to make positive cash flows Six years from now, the cash inflow is expected to be $3,750,000 and the cash flows are expected to grow at a rate of 3 1 per year (and continue in perpetuity) The risk of the business implies an appropriate discount rate of 16 per year for all cash flows What is the present value of the investment in the business (just the investing cash flows the cash flows from year 0 to year 5) Show how this can be calculated, in equation form with numbers included , where part of the equation is the PV of an annuity equation with n 4 cash flows of $2,400,000 plus, separately, the $5,000,000 cash flow You must show the full equation (use Word's equation editor) with numbers in it and with n 4 cash flows for the annuity equation portion Use Word's equation editor in a professional manner with the appropriate numbers in it Be careful on the sign ( or ) of your result You should display the PV of these cash flows as though this amount will be added into the overall NPV equation What is the economic profit generated by this business venture (i e , what is the NPV of starting this business) Suppose the owners of the business go for a public offering of the business on the stock market at the end of year 5 (just after the last investment cash flow) and the market has the same expectations of future cash flows (as stated above for years 6 onward) What will be the market price of the business when it goes public (at year 5 just after the last investment cash flow) What would be the present value of this amount (calculated in c i) discounted back to year 0 What does this imply about the economic profit expected to be received by the people who buy the stock in the public offering What does this imply about the economic profit expected to be received by the original founders of the business In answering this, use the result from parts c i, c ii, and a Include these numbers and show how you are using them when giving your answer Compare this result to your answer in part b What is the IRR of this business Hint, you may want to set up the years 0 to 5 cash flows on a spreadsheet and then bring in the growing perpetuity formula to handle the cash flows from year 6 onward Make sure all discounting calculations reference one rate cell Do not hard code the discount rate anywhere else in the spreadsheet Then you can use Solver to determine the IRR by solving for NPV 0 by changing the number in the rate cell (Please use a clear high resolution screen capture printout to show the results first with a rate of 12 (note, the rate should be formatted so that 6 digits appear after the decimal point 12 000000 ), then show the setup of Solver (with the solver box open referencing the relevant cells) and then show result following running Solver (including 6 digits after the decimal point for the rate) What is the IRR (show 6 digits after the decimal place e g , 12 123456 ) (Make sure that after solving for IRR, the NPV is 0 to at least 12 decimal places )

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on May 19, 2024

To start up a business you, as its founders, must invest as follows: Year 0 1 2 3 4 5 Investment $5,000,000 $0 $2,400,000 $2,400,000

To start up a business you, as its founders, must invest as follows:

Year	0	1	2	3	4	5
Investment	$5,000,000	$0	$2,400,000	$2,400,000	$2,400,000	$2,400,000

Following the times when you are investing, the business is projected to make positive cash flows. Six years from now, the cash inflow is expected to be $3,750,000 and the cash flows are expected to grow at a rate of 3.1% per year (and continue in perpetuity). The risk of the business implies an appropriate discount rate of 16% per year for all cash flows.

What is the present value of the investment in the business (just the investing cash flows - the cash flows from year 0 to year 5)? Show how this can be calculated, in equation form with numbers included, where part of the equation is the PV of an annuity equation with n=4 cash flows of $2,400,000 plus, separately, the $5,000,000 cash flow. You must show the full equation (use Word's equation editor) with numbers in it and with n=4 cash flows for the annuity equation portion. Use Word's equation editor in a professional manner with the appropriate numbers in it.Be careful on the sign (+ or -) of your result. You should display the PV of these cash flows as though this amount will be added into the overall NPV equation.
What is the economic profit generated by this business venture (i.e., what is the NPV of starting this business)?
Suppose the owners of the business go for a public offering of the business on the stock market at the end of year 5 (just after the last investment cash flow) and the market has the same expectations of future cash flows (as stated above for years 6 onward).
1. What will be the market price of the business when it goes public (at year 5 just after the last investment cash flow)?
2. What would be the present value of this amount (calculated in c.i) discounted back to year 0?
3. What does this imply about the economic profit expected to be received by the people who buy the stock in the public offering?
4. What does this imply about the economic profit expected to be received by the original founders of the business? In answering this, use the result from parts c.i, c.ii, and a. Include these numbers and show how you are using them when giving your answer. Compare this result to your answer in part b.
5. What is the IRR of this business? Hint, you may want to set up the years 0 to 5 cash flows on a spreadsheet and then bring in the growing perpetuity formula to handle the cash flows from year 6 onward. Make sure all discounting calculations reference one rate cell. Do not hard-code the discount rate anywhere else in the spreadsheet. Then you can use Solver to determine the IRR by solving for NPV = 0 by changing the number in the rate cell. (Please use a clear high-resolution screen capture printout to show the results first with a rate of 12% (note, the rate should be formatted so that 6 digits appear after the decimal point: 12.000000%), then show the setup of Solver (with the solver box open-referencing the relevant cells) and then show result following running Solver (including 6 digits after the decimal point for the rate). What is the IRR (show 6 digits after the decimal place; e.g., 12.123456%)? (Make sure that after solving for IRR, the NPV is 0 to at least 12 decimal places.)