시작하기무료로 시작하기

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 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.

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작