Question

Suppose Microsoft has decided to introduce a new game playing consoles, the Z Box. Before they launch the Z Box, they conducted an analysis to see if the Z Box would be a desirable investment. The company estimated that it would sell 4.5 million Z Box’s per year at a price of $900 for the next six years. After the first year of sales, the quantity sold will increase by 2% per year for the remaining life of the project. The initial capital outlay is determined to be $1.9 billion and a $800 million outlay in net working capital (NWC) would also be required. Assume that there is a one-time investment in NWC and that this will be recovered at the end of the project. Assume that the equipment used will be depreciated using the MACRS 7 year schedule and that the equipment has a salvage value of zero. At the end of year 6, the equipment will be sold for its book value. Also, assume that that the tax rate is 21%.

Using information from Microsoft’s financial statements (you may want to use Morningstar.com or some other online site) estimate the operating cash flows from the project. Make any simplifying assumptions that are necessary to produce the estimate.

Answer 1

Operating Cash Flow= operating income + Depreciation - Tax Expenses +,- changes in working capital

Assumption:- Cost of Goods sold = 60% of sales

There is No Change in Working Capital

Amount of fixed assets - 1.9 billion

Particulars. Year 1. 2. 3. 4. 5. 6. 7

Revenue. 4050 4131 4213.62. 4297.89 4383.85 4471.53 4561

(-) COGS. 2430. 2478.6 2528.17 2578.73 2630.31 2682.92 2736.4

+ Dep. 271.4. 271.4 271.4 271.4 271.4 271.4 271.4

(-)Tax@21% 397.19 404 410.94 418.02 425.24 432.6 440.16

Operating. 1491.21 1519.8 1545.91 1572.54 1599.70 1627.41 1655.84

Cash flow