Financial Projection Overview

Step 1: Get your copy.

1. Grab your copy here 👉

2. Click "File" then "Make a Copy"

3. Store in your Google Drive

Step 2: Watch training video.

Step 3: Review and Set Up System

Financial Projection Set Up:

Download copy of Finance Projection System
Adjust Income fields (B5:B12), Cost of Goods fields (B17:B22), and Expense fields (B28:B39)
Hide any columns for past months if you're not using them

System Set Up:

Prior to the start of each month, sit down and spend 30 minutes filling out "Estimates" for the next month. Use these projections to then plan the work/project required to met these goals. Add this in your calendar as a recurring task.
Within 1 week of the start of the month, fill out "Actuals" for the previous month.
Take 30 minutes to review "Estimates" vs "Actuals" for the previous month. Add this in your calendar as a recurring task. Let the numbers tell a story. Which assumptions were correct, and which were incorrect. Do you need to make any immediate adjustments to this month's goals?
If you have 2+ months of data for "Estimates" and "Actuals" look for any trends that appear (good or bad). Again, how can you act upon these trends to capitalize on opportunities or fix mistakes.