开始使用免费开始使用

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.

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习