use given materials and assumptions to forecast a ten year cash flow better finish the work in an excel worksheet

by

Using the income statement from the previous exercise, forecast a ten year cash flow using the following assumptions:

  • Capital Expenditures of $50,000 per year.
  • Leasehold Improvements of $10,000 per year.
  • DSO of 75 Days.
  • Inventory Turnover of 12 times.
  • Accounts Payable of 30 days.
  • Depreciation is constant.
  • The combined Federal and State Tax Rate is 40%.
  • There are no additional financing expenses associated with the transaction.

After you have completed your cash flow forecast, calculate a Net Present Value assuming a discount rate of 15%.

Remember that once you’ve calculated the Total Working Capital for Year 0, all future Working Capital needs will be incremental. Almost all of the variables will be provided to you here.

The income statement is given in the excel worksheet. Use it and the assumptions given above to do a ten-year cash flow forecast. Use excel to finish all the work, make it just like the income statement that is already given.