Forecast Cash Flows
You now have updated forecast data, so you should update the cash flow model. This information would allow Grape Debate to plan for the future and identify potentials cash flow problems and ways to improve their financial outcomes.
The formulas have mostly been provided but you should fill in the missing forecast for operations, and the missing forecast factors for inventories and equipment.
이 연습은 강의의 일부입니다
Google Sheets로 하는 Financial Modeling
연습 안내
- In cells
E5:E12, use the formula= Year 2018 reference * (1 + Forecast Factor)for each row. - In cells
F8andF16, add the formula to reference the Balance Sheet Common Size for Inventories and Equipment. - For
F8andF16, click on the Balance sheet and the matching row in theFcolumn.
