Session 6: 

Financial Pro Forma Statements

Timestamps

1:38 – Statement inputs tab; owner’s equity cushion, % of revenue realized, COGS, and other inputs.

2:00 – Owner’s equity cushion

2:58 – Percentage of revenue realized

5:38 – Taxes

6:08 – The Balances tab: Assets = Liabilities + Owner’s Equity

8:19 – Financial Pro Forma Statements

9:29 – Balance Sheet

11:35 – Income Statement

14:42 – Cash flow statement

15:13 – Financial ratios: how to plan for profitability

Financial Worksheet – Statements Input

Financial Worksheet – Balances Tab

Financial Worksheet – All Statements Tab

Adjusting Your Assumptions for Increased Profitability

Action Items:

  • View tutorial videos
  • Understand how the Financial Planning worksheet is using your farm planning information to create your Pro Forma statements.
  • Adjust your farm planning to reach a profitable scenario.