Iโve been fortunate to build over ๐ญ๐ฌ๐ฌ ๐ณ๐ถ๐ป๐ฎ๐ป๐ฐ๐ถ๐ฎ๐น ๐บ๐ผ๐ฑ๐ฒ๐น๐ in my careerโฆ
and each time, I learn something new.
But the general process is fairly consistent across each oneโฆ
and can be summarized in just 7 steps
Let me take you through each step...
and each time, I learn something new.
But the general process is fairly consistent across each oneโฆ
and can be summarized in just 7 steps
Let me take you through each step...
1. ๐๐ผ๐ป๐ป๐ฒ๐ฐ๐๐ถ๐ป๐ด ๐๐ผ๐๐ฟ ๐๐ฎ๐๐ฎ
Connecting your data is the starting point in your financial model
The foundation here is importing your existing P&L and Balance sheet from your Accounting Software
Connecting your data is the starting point in your financial model
The foundation here is importing your existing P&L and Balance sheet from your Accounting Software
2. ๐๐ถ๐ป๐ธ ๐๐ต๐ฒ ๐๐ถ๐ป๐ฎ๐ป๐ฐ๐ถ๐ฎ๐น ๐ฆ๐๐ฎ๐๐ฒ๐บ๐ฒ๐ป๐๐
Now that your financials are imported, itโs time to link them
The concept is pretty simpleโฆ
P&L connects to the Balance sheet via Net Income & Retained Earnings
Now that your financials are imported, itโs time to link them
The concept is pretty simpleโฆ
P&L connects to the Balance sheet via Net Income & Retained Earnings
3. ๐๐ผ๐ฟ๐ฒ๐ฐ๐ฎ๐๐ ๐ฅ๐ฒ๐๐ฒ๐ป๐๐ฒ
Here comes the biggest part in you forecastโฆyour revenue
Here, you would start by analyzing the activity from your existing customers, and customers who are warm in your pipeline
Here comes the biggest part in you forecastโฆyour revenue
Here, you would start by analyzing the activity from your existing customers, and customers who are warm in your pipeline
4. ๐๐ผ๐ฟ๐ฒ๐ฐ๐ฎ๐๐ ๐๐ฒ๐ฎ๐ฑ๐ฐ๐ผ๐๐ป๐
Now comes your biggest opex account
You would start by reviewing the existing headcount that you imported in step 1
Then add in projected hires
Things to consider:
* Hire date
* Salary
* Department
* Employee vs Consultant
Now comes your biggest opex account
You would start by reviewing the existing headcount that you imported in step 1
Then add in projected hires
Things to consider:
* Hire date
* Salary
* Department
* Employee vs Consultant
4. ๐๐ผ๐ฟ๐ฒ๐ฐ๐ฎ๐๐ ๐๐ฒ๐ฎ๐ฑ๐ฐ๐ผ๐๐ป๐
Now comes your biggest opex account
You would start by reviewing the existing headcount that you imported in step 1
Then add in projected hires
Things to consider:
* Hire date
* Salary
* Department
* Employee vs Consultant
Now comes your biggest opex account
You would start by reviewing the existing headcount that you imported in step 1
Then add in projected hires
Things to consider:
* Hire date
* Salary
* Department
* Employee vs Consultant
5. ๐๐ผ๐ฟ๐ฒ๐ฐ๐ฎ๐๐๐ถ๐ป๐ด ๐ข๐ฝ๐ฒ๐
Now that we have our headcount projections out of the way, itโs time to forecast out the rest of our Opex
Since weโre building all of this in excel, we have full control over how we want our forecast to look.
Now that we have our headcount projections out of the way, itโs time to forecast out the rest of our Opex
Since weโre building all of this in excel, we have full control over how we want our forecast to look.
6. ๐๐ผ๐ฟ๐ฒ๐ฐ๐ฎ๐๐ ๐๐ฎ๐น๐ฎ๐ป๐ฐ๐ฒ ๐ฆ๐ต๐ฒ๐ฒ๐
Now we get to the last section of our forecastโฆthe Balance Sheet
Here, we need to analyze the balance of key accounts, and plan how those balances will change in the future.
Now we get to the last section of our forecastโฆthe Balance Sheet
Here, we need to analyze the balance of key accounts, and plan how those balances will change in the future.
7. ๐ฃ๐ฟ๐ฒ๐๐ฒ๐ป๐ ๐๐ถ๐๐ต ๐ฃ๐ฟ๐ฒ๐๐๐ ๐๐ฒ๐๐ถ๐ด๐ป
Now we get to my favorite partโฆpresentation๐คฉ
Itโs here that we take all of our hard work, and present it in a manner that will woo the crowdโฆ
whether that be the CEO, management, investors, the board of directorsโฆanyone
Now we get to my favorite partโฆpresentation๐คฉ
Itโs here that we take all of our hard work, and present it in a manner that will woo the crowdโฆ
whether that be the CEO, management, investors, the board of directorsโฆanyone
Thatโs my proven system for building a Financial Modelโฆ
๐ฃ๐ฆ: ๐๐ฒ๐๐ฒ๐น ๐๐ฝ ๐๐ผ๐๐ฟ ๐ฐ๐ฎ๐ฟ๐ฒ๐ฒ๐ฟ ๐ฎ๐ป๐ฑ ๐ด๐ฒ๐ ๐๐ถ๐ป๐ฎ๐ป๐ฐ๐ฒ & ๐๐ฐ๐ฐ๐ผ๐๐ป๐๐ถ๐ป๐ด ๐๐ถ๐ฝ๐ ๐น๐ถ๐ธ๐ฒ ๐๐ต๐ถ๐ ๐ฑ๐ฒ๐น๐ถ๐๐ฒ๐ฟ๐ฒ๐ฑ ๐ฟ๐ถ๐ด๐ต๐ ๐๐ผ ๐๐ผ๐๐ฟ ๐ถ๐ป๐ฏ๐ผ๐ :
yourcfoguy.com
๐ฃ๐ฆ: ๐๐ฒ๐๐ฒ๐น ๐๐ฝ ๐๐ผ๐๐ฟ ๐ฐ๐ฎ๐ฟ๐ฒ๐ฒ๐ฟ ๐ฎ๐ป๐ฑ ๐ด๐ฒ๐ ๐๐ถ๐ป๐ฎ๐ป๐ฐ๐ฒ & ๐๐ฐ๐ฐ๐ผ๐๐ป๐๐ถ๐ป๐ด ๐๐ถ๐ฝ๐ ๐น๐ถ๐ธ๐ฒ ๐๐ต๐ถ๐ ๐ฑ๐ฒ๐น๐ถ๐๐ฒ๐ฟ๐ฒ๐ฑ ๐ฟ๐ถ๐ด๐ต๐ ๐๐ผ ๐๐ผ๐๐ฟ ๐ถ๐ป๐ฏ๐ผ๐ :
yourcfoguy.com
5. ๐๐ผ๐ฟ๐ฒ๐ฐ๐ฎ๐๐๐ถ๐ป๐ด ๐ข๐ฝ๐ฒ๐
Now that we have our headcount projections out of the way, itโs time to forecast out the rest of our Opex
Since weโre building all of this in excel, we have full control over how we want our forecast to look.
Now that we have our headcount projections out of the way, itโs time to forecast out the rest of our Opex
Since weโre building all of this in excel, we have full control over how we want our forecast to look.
6. ๐๐ผ๐ฟ๐ฒ๐ฐ๐ฎ๐๐ ๐๐ฎ๐น๐ฎ๐ป๐ฐ๐ฒ ๐ฆ๐ต๐ฒ๐ฒ๐
Now we get to the last section of our forecastโฆthe Balance Sheet
Here, we need to analyze the balance of key accounts, and plan how those balances will change in the future.
Now we get to the last section of our forecastโฆthe Balance Sheet
Here, we need to analyze the balance of key accounts, and plan how those balances will change in the future.
7. ๐ฃ๐ฟ๐ฒ๐๐ฒ๐ป๐ ๐๐ถ๐๐ต ๐ฃ๐ฟ๐ฒ๐๐๐ ๐๐ฒ๐๐ถ๐ด๐ป
Now we get to my favorite partโฆpresentation๐คฉ
Itโs here that we take all of our hard work, and present it in a manner that will woo the crowdโฆ
whether that be the CEO, management, investors, the board ofโฆ
Now we get to my favorite partโฆpresentation๐คฉ
Itโs here that we take all of our hard work, and present it in a manner that will woo the crowdโฆ
whether that be the CEO, management, investors, the board ofโฆ
Thatโs my proven system for building a Financial Modelโฆ
๐ฃ๐ฆ: ๐๐ฒ๐๐ฒ๐น ๐๐ฝ ๐๐ผ๐๐ฟ ๐ฐ๐ฎ๐ฟ๐ฒ๐ฒ๐ฟ ๐ฎ๐ป๐ฑ ๐ด๐ฒ๐ ๐๐ถ๐ป๐ฎ๐ป๐ฐ๐ฒ & ๐๐ฐ๐ฐ๐ผ๐๐ป๐๐ถ๐ป๐ด ๐๐ถ๐ฝ๐ ๐น๐ถ๐ธ๐ฒ ๐๐ต๐ถ๐ ๐ฑ๐ฒ๐น๐ถ๐๐ฒ๐ฟ๐ฒ๐ฑ ๐ฟ๐ถ๐ด๐ต๐ ๐๐ผ ๐๐ผ๐๐ฟ ๐ถ๐ป๐ฏ๐ผ๐ : yourcfoguy.com
๐ฃ๐ฆ: ๐๐ฒ๐๐ฒ๐น ๐๐ฝ ๐๐ผ๐๐ฟ ๐ฐ๐ฎ๐ฟ๐ฒ๐ฒ๐ฟ ๐ฎ๐ป๐ฑ ๐ด๐ฒ๐ ๐๐ถ๐ป๐ฎ๐ป๐ฐ๐ฒ & ๐๐ฐ๐ฐ๐ผ๐๐ป๐๐ถ๐ป๐ด ๐๐ถ๐ฝ๐ ๐น๐ถ๐ธ๐ฒ ๐๐ต๐ถ๐ ๐ฑ๐ฒ๐น๐ถ๐๐ฒ๐ฟ๐ฒ๐ฑ ๐ฟ๐ถ๐ด๐ต๐ ๐๐ผ ๐๐ผ๐๐ฟ ๐ถ๐ป๐ฏ๐ผ๐ : yourcfoguy.com
Loading suggestions...