開始使用免費開始

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 進行財務建模

檢視課程

練習說明

  • In cells E5:E12, use the formula = Year 2018 reference * (1 + Forecast Factor) for each row.
  • In cells F8 and F16, add the formula to reference the Balance Sheet Common Size for Inventories and Equipment.
  • For F8 and F16, click on the Balance sheet and the matching row in the F column.

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習