Note, for all numeric answers, show final dollar answers to two decimal places; e.g., round to the cent for dollar answers. Do not round intermediate calculations – use Excel, unrounded, for all calculations.
⦁ Tacky Textiles buys some inventory from Calvin Klein in 2019 for $495,000 on credit terms and will pay for the inventory in 2020. In 2020 Tacky Textiles sells $231,000 of the inventory to The Bay for $490,000. The Bay will pay Tacky Textiles in 2021. (You do not need to show all financial statements.)
⦁ Indicate the cash flows caused by the above transactions. (Be specific in terms of years too – show numbers for each of the three years and indicate whether the cash flow for the year is positive, negative, or zero.)
⦁ Assume without these transactions, inventory accounts each year would be zero. Indicate the balances in inventory accounts caused by the above transactions. (Be specific in terms of each year too – show numbers for each of the three years even if zero.)
⦁ Indicate the effects on profitability (ignore taxes) caused by the above transactions. Assume that without these transactions, profit each year would be zero. (Be specific in terms of years too – show numbers for each of the three years – even if zero.)
⦁ Do the cash flow numbers give the same indication of performance for Tacky Textiles as the profitability numbers? Consider if you had to calculate the with only the data given so far. Explain briefly.
⦁ To start up a business you, as its founders, must invest as follows:
Year 0 1 2 3 4
Investment $4,000,000 $2,000,000 $1,000,000 $500,000 $250,000
Following the times when you are investing, the business is projected to make positive cash flows. For year 5, the cash inflow is expected to be $150,000 and this is expected to double each year ending with the cash flow that occurs at year 10. In year 11 and into the future, the cash flows are expected to grow at a rate of 3% per year (and continuing in perpetuity).
⦁ If the risk of the business implies an appropriate discount rate of 16% per year, what is the economic profit generated by this business venture (i.e., what is the NPV of starting this business)?
⦁ What is the present value of the investment in the business (just the investing cash flows – the cash flows from year 0 to year 4)? Show how this can be calculated with the PV growing annuity equation using the year 0 cash flow as the first cash flow of the growing annuity (show the equation with the numbers in it – use Word’s equation editor in a professional manner with the appropriate numbers in it so that it captures, within the growing annuity, all five of the cash flows from years 0 to 4 inclusive).
⦁ Suppose the owners of the business do a public offering of the business on the stock market at the end of year 4 (just after the last investment cash flow) and the market has the same expectations of future cash flows (as stated above for years 5 onward).
⦁ What will be the market price of the business when it goes public (at year 4)?
⦁ What would be the present value of this amount 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 b. Compare this result to your answer in part a.
⦁ What is the IRR of this business? Hint, you may want to set up the first 10 years of cash flows on a spreadsheet and then bring in the growing perpetuity formula to handle the cash flows from year 11 onward. Make sure all discounting references one rate cell. 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 setup of Solver and the result following running Solver.)