Accounting Project Final -- AWARDED
Lew Core
module4cashbudgettemplate.xlsxcash forecast
| 0 | 1 | 2 | 3 | 4 | 5 | |||
| 20xx | 20xx | 20xx | 20xx | 20xx | 20xx | |||
| Investment Outlays at Time Zero: | ||||||||
| Equipment or other investment | (10,000) | |||||||
| Operating Cash Flows over the Project's Life: | ||||||||
| Sales revenue | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | |||
| Cost of Sales | 1 | 1 | 1 | 1 | 1 | |||
| Gross Profit | 2,999 | 2,999 | 2,999 | 2,999 | 2,999 | |||
| Adverstiing | 1 | 1 | 1 | 1 | 1 | |||
| Depreciation (equipment) | 1 | 1 | 1 | 1 | 1 | |||
| Dues and subscriptions | 1 | 1 | 1 | 1 | 1 | |||
| Insurance | 1 | 1 | 1 | 1 | 1 | |||
| Salaries | 1 | 1 | 1 | 1 | 1 | |||
| Payroll Taxes | 1 | 1 | 1 | 1 | 1 | |||
| Other Taxes | 1 | 1 | 1 | 1 | 1 | |||
| Other expenses | 1 | 1 | 1 | 1 | 1 | |||
| Total expenses | 8 | 8 | 8 | 8 | 8 | |||
| Oper. income before taxes (EBIT) | 2,991 | 2,991 | 2,991 | 2,991 | 2,991 | |||
| Taxes on operating income | 90 | 90 | 90 | 90 | 90 | Note: Change the tax rate in these cells to what is required | ||
| Net Operating Profit After Taxes (NOPAT) | 2,901 | 2,901 | 2,901 | 2,901 | 2,901 | |||
| Add back depreciation | 1 | 1 | 1 | 1 | 1 | |||
| Operating cash flow | $2,902 | $2,902 | $2,902 | $2,902 | $2,902 | |||
| Terminal Year Cash Flows: | ||||||||
| After-tax salvage value of equipment that you sell | 1 | |||||||
| Total termination cash flows | $1 | |||||||
| Net Cash Flow (Time line of cash flows) | ($10,000) | $2,902 | $2,902 | $2,902 | $2,902 | $2,903 | ||
| Net Present Value | Create a formula using the NPV function as specified Doug Letsch: Doug Letsch: Hit the ? Or help key in the upper right corner of Excel to see how to use NPV function =NPV() | click the help file (? On top right of screen) and search for NPV | ||||||
| IRR | Create a formula using the IRR function as specified Doug Letsch: Doug Letsch: Hit the ? Or help key in the upper right corner of Excel to see how to use IRR function =IRR() | Click the help file and search for IRR |
