The auto repair industry is one that generates 63 billion dollars in sales every year! On top of this, not one company controls more than 10% of the market share, allowing for new auto repair shops to enter the scene without having to compete against giant corporations that control the market.

If you are entering the auto repair industry with a shop of your own, you will need to prepare financial projections fo your business to share with lenders and potential investors in order to fund your startup. We can help with that!

ProjectionHub is a web application that allows you to create accurate and customizable financial projections and pro forma financial statements. This blog post will walk you through the process of using our web tool to generate financial projections for your own auto repair shop.

If you would rather have us prepare projections for you, sign up here for a free 15-minute consultation with our CPA, Grace Cisna, or submit an interest form.

1. Sign up for ProjectionHub

1. Feel free to learn more about ProjectionHub in general before signing up.
2. You can sign up for a free trial by selecting the “Auto Repair” template here.
3. If you have any questions about the model as you go, please email support@projectionhub.com

2. Add your business info

Once you sign up and confirm your account you will be asked to complete some general business info as seen below:

Adding the Auto Repair Business Model

Once you save the general business info, you will be able to add a business model.  If you don’t already see a “Auto Repair” Business Model added on this page, you can click the add Business Model button as seen below to add your first auto repair unit.

3. Add your Revenue

Next you can click the orange button to Add Revenue to get started with your sales projections.

You will now have 2 options as you see in the image below:

1.  You can click “Add Revenue” which will give you the ability to add projected revenue numbers for each month for your shop.
2.  Or you can click “Add Google Sheet Revenue”.  We have created a special Google Spreadsheet template specifically for auto repair companies that will give you more control in terms of adding assumptions for your sales projections.
3. If you decide to utilize our Google Sheet template please see this guide on how to enable the Google Sheet Integration.  You can see a screenshot of a portion of the Google Sheet below:

4. Add your expense projections

Once you complete your revenue projections you can move on to your expenses.  There are 2 primary types of expenses:

1.  Startup Expenses
2.  Ongoing Operating Expenses

Some of the items listed as startup expenses should be entered as expenses on month 1 and some are actually cash spent on assets like:

• Leasehold improvements
• Equipment
• Buildings

If you have any of these types of expenses you will want to add them later as an “Asset” instead of an “Expense” on this page.

Operating Expenses

On the Expenses page in ProjectionHub you will be able to add/update your operating expenses.  You will notice that the Expense page will come with a number of standard expense line items along with a default monthly expense for most of the line items.  You can change any of these default expenses to reflect your specific situation.

Some expenses may be a % of your total sales, instead of a fixed monthly amount.

So as you see in the image above you can click the check boxes next to those expense categories and then in the drop down box you can select “Apply Industry Ratios” and then click “Apply”.

5. Add your assets

Next you can move on to the assets section.  You will notice that the Assets page comes pre-loaded with the default assets that you might have as an auto repair company owner.

To add an asset, hover over the row, see the 3 dots on the left of the asset name, hover over, and click edit.

Next you will be able to add your Machinery And Equipment as an example. You can enter in the details of your assets as seen below:

6. Add your liabilities

Next you can move to the Liabilities page and add a loan.  If you are going to borrow to help fund your startup costs, you can “Add a Liability” as seen below:

Then, you can go ahead and insert the details of the loan or other liability that you have acquired.

7. Add investors

Next you can add any personal investment you will be making as well as investment from outside investors.

Then, you can enter your investor’s information and the amount and terms of the investment:

8. Review your financial projection reports

Once you enter in all of your assumptions you will be able to review a number of reports.  Here is a sampling of some of the reports, tables below:

On the Dashboard page you will be able to download your Income Statement, Balance Sheet and Cash Flow projections to share with your lender or investor.

Adding Multiple Auto Repair Units

Finally, let’s assume you want to add another auto repair shop in the future.  All you need to do is go back to the “Business Model” page and add another “Auto Repair” business model.  You can then label it Auto Repair–unit 2 and you can repeat the process.  You can add as many units as you would like over time.

Again, you can get started by creating a ProjectionHub free trial account today.

As you complete your projections please don’t hesitate to reach out to us with questions at support@projectionhub.com

Good luck!

The tech repair industry is a 19 billion dollar industry with sales being driven by the increased demands for high-priced, technologically complex products.

If you are entering this market with a tech repair business of your own, you will need to have accurate financial projections created to show to potential investors and/or lenders. That’s where we can help!

ProjectionHub has developed a financial modeling template specifically designed for tech repair companies like your’s! This blog post will show you how to utilize our web application to generate your customizable and easy-to-read financial reports and projections.

1. Sign up for ProjectionHub

1. Feel free to learn more about ProjectionHub in general before signing up.
2. You can sign up for a free trial by selecting the “Phone, Tablet, Computer Repair” template here.
3. If you have any questions about the model as you go, please email support@projectionhub.com

2. Add your business info

Once you sign up and confirm your account you will be asked to complete some general business info as seen below:

Adding the Tech Repair Business Model

Once you save the general business info, you will be able to add a business model.  If you don’t already see a “Phone, Tablet, Computer Repair” Business Model added on this page, you can click the add Business Model button as seen below to add your first tech repair unit.

3. Add your Revenue

Next you can click the orange button to Add Revenue to get started with your sales projections.

You will now have 2 options as you see in the image below:

1.  You can click “Add Revenue” which will give you the ability to add projected revenue numbers for each month for your store.
2.  Or you can click “Add Google Sheet Revenue”.  We have created a special Google Spreadsheet template specifically for tech repair companies that will give you more control in terms of adding assumptions for your sales projections.
3. If you decide to utilize our Google Sheet template please see this guide on how to enable the Google Sheet Integration.  You can see a screenshot of a portion of the Google Sheet below:

4. Add your expense projections

Once you complete your revenue projections you can move on to your expenses.  There are 2 primary types of expenses:

1.  Startup Expenses
2.  Ongoing Operating Expenses

Some of the items listed as startup expenses should be entered as expenses on month 1 and some are actually cash spent on assets like:

• Leasehold improvements
• Equipment
• Buildings

If you have any of these types of expenses you will want to add them later as an “Asset” instead of an “Expense” on this page.

Operating Expenses

On the Expenses page in ProjectionHub you will be able to add/update your operating expenses.  You will notice that the Expense page will come with a number of standard expense line items along with a default monthly expense for most of the line items.  Obviously you can change any of these default expenses to reflect your specific situation.

Some expenses may be a % of your total sales, instead of a fixed monthly amount.

So as you see in the image above you can click the check boxes next to those expense categories and then in the drop down box you can select “Apply Industry Ratios” and then click “Apply”.

5. Add your assets

Next you can move on to the assets section.  You will notice that the Assets page comes pre-loaded with the default assets that you might have as a tech repair company owner.

To add an asset, hover over the row, see the 3 dots on the left of the asset name, hover over, and click edit.

Next you will be able to add your Machinery And Equipment as an example. You can enter in the details of your assets as seen below:

6. Add your liabilities

Next you can move to the Liabilities page and add a loan.  If you are going to borrow to help fund your startup costs, you can “Add a Liability” as seen below:

Then, you can go ahead and insert the details of the loan or other liability that you have acquired.

7. Add investors

Next you can add any personal investment you will be making as well as investment from outside investors.

Then, you can enter your investor’s information and the amount and terms of the investment:

8. Review your financial projection reports

Once you enter in all of your assumptions you will be able to review a number of reports.  Here is a sampling of some of the reports, tables below:

On the Dashboard page you will be able to download your Income Statement, Balance Sheet and Cash Flow projections to share with your lender or investor.

Adding Multiple Tech Repair Units

Finally, let’s assume you want to add another tech repair store in the future.  All you need to do is go back to the “Business Model” page and add another “Phone, Tablet, Computer Repair” business model.  You can then label it Phone, Tablet, Computer Repair–unit 2 and you can repeat the process.  You can add as many units as you would like over time.

Again, you can get started by creating a ProjectionHub free trial account today.

As you complete your projections please don’t hesitate to reach out to us with questions at support@projectionhub.com

Good luck!

At 5 % annually, the home health care service industry is the fastest-growing industry in the United States, according to AMNHealthCare. Now is a great time to launch an In-Home Health Care Service company as the industry’s growth is being spurred by reports of “greater patient satisfaction, greater patient compliance with treatment, and more proactive care”.

We at ProjectionHub.Com have created a financial modeling template specifically for In-Home Health Care Service companies backed by a Google Sheet revenue model that will make your financial projections more customizable and accurate.

This post will show you how to use our web application as a tool to generating your very own financial projections. If you would rather have us prepare projections for you, sign up here for a free 15-minute consultation with our CPA, Grace Cisna, or submit an interest form.

Signup Instructions

1. Feel free to learn more about ProjectionHub in general before signing up.
2. You can sign up for a free trial by selecting the “In-Home Health Care” template here.
3. If you have any questions about the model as you go, please email support@projectionhub.com

General Business Info

Once you sign up and confirm your account you will be asked to complete some general business info as seen below:

Adding the In-Home Care Business Model

Once you save the general business info, you will be able to add a business model.  If you don’t already see an In-Home Health Care Business Model added on this page, you can click the add a Business Model button as seen below to add your first In-Home Care unit.

Revenue

Next you can click the orange button to Add Revenue to get started with your sales projections.

You will now have 2 options as you see in the image below:

1.  You can click “Add Revenue” which will give you the ability to add projected revenue numbers for each month for your service.
2.  Or you can click “Add Google Sheet Revenue”.  We have created a special Google Spreadsheet template specifically for In-Home Health Care Services that will give you more control in terms of adding assumptions for your average price and number of patients each month.
3. If you decide to utilize our Google Sheet template please see this guide on how to enable the Google Sheet Integration.  You can see a screenshot of the Google Sheet below:

Expenses

Once you complete your revenue projections you can move on to your expenses.  There are 2 primary types of expenses:

1.  Startup Expenses
2.  Ongoing Operating Expenses

Some of the items listed as startup expenses should be entered as expenses on month 1 and some are actually cash spent on assets like equipment.

If you have any of these types of expenses you will want to add them later as an “Asset” instead of an “Expense” on this page.

Operating Expenses

On the Expenses page in ProjectionHub you will be able to add/update your operating expenses.  You will notice that the Expense page will come with a number of standard expense line items along with a default monthly expense for most of the line items.  You can change any of these default expenses to reflect your specific situation.

Some expenses will be a % of your total sales, instead of a fixed monthly amount.

So as you see in the image above you can click the check boxes next to those expense categories and then in the drop down box  you can select “Apply Industry Ratios” and then click “Apply”.

Assets

Next you can move on to the assets section.  You will notice that the Assets page comes pre-loaded with the default assets that you might have as an In-Home Health Service company owner.

To add an asset, hover over the row, see the 3 dots on the left of the asset name, hover over, and click edit.

You can then enter in the details of your assets as seen below:

Loans

Next you can move to the Liabilities page and add a loan.  If you are going to borrow to help fund your startup costs, you can “Add a Liability” as seen below:

You can then enter the details and terms of the loan:

Investors

Next you can add any personal investment you will be making as well as investment from outside investors.  Simply go to the investors tab and click “add investor” and choose from our list of potential investor types:

Then, you can enter your investor’s information and the amount and terms of the investment:

Reports

Once you enter in all of your assumptions you will be able to review a number of reports.  Here is a sampling of some of the reports, tables below:

On the Dashboard page you will be able to download your projection Income Statement, Balance Sheet and Cash Flow projections to share with your lender or investor.

Adding Multiple In-Home Care Units

Finally, let’s assume you want to start another In-Home Care service in the future.  All you need to do is go back to the “Business Model” page and add another “In-Home Health Care” business model.  You can then label it In_Home Health Care Unit 2 and you can repeat the process.  You can add as many units as you would like over time.

Again, you can get started by creating a ProjectionHub free trial account today.

As you complete your projections please don’t hesitate to reach out to us with questions at support@projectionhub.com

Good luck!

As you can see, the beer market has been growing over the past year, and craft beer is a large part of that growth, with craft beer sales growing at an annual rate of 8%! With these numbers, it is clear to see why you would invest in starting your very own brewery.

In order to do this, you will need to create financial projections unique to your business for lenders or investors to view before they decide to take a stake in the company.

ProjectionHub has a Brewery financial plan template specifically for breweries that integrates a Google Sheet revenue model for more customizable and accurate financial projections.

This post will show you step-by-step how to utilize this tool to create your custom financial projections.

Signup Instructions

1. Feel free to learn more about ProjectionHub in general before signing up.
2. You can sign up for a free trial by selecting the “Brewery” template here.
3. If you have any questions about the model as you go, please email support@projectionhub.com

General Business Info

Once you sign up and confirm your account you will be asked to complete some general business info as seen below:

Adding the Brewery Business Model

Once you save the general business info, you will be able to add a business model.  If you don’t already see a Brewery Business Model added on this page, you can click the add Business Model button as seen below to add your first Brewery unit.

Revenue

Next you can click the orange button to Add Revenue to get started with your sales projections.

You will now have 2 options as you see in the image below:

1.  You can click “Add Revenue” which will give you the ability to add projected revenue numbers for each month for your brewery.
2.  Or you can click “Add Google Sheet Revenue”.  We have created a special Google Spreadsheet template specifically for Breweries that will give you more control in terms of adding assumptions for your average ticket price and number of customer orders each month.
3. If you decide to utilize our Google Sheet template please see this guide on how to enable the Google Sheet Integration.  You can see a screenshot of the Google Sheet below:

Expenses

Once you complete your revenue projections you can move on to your expenses.  There are 2 primary types of expenses:

1.  Startup Expenses
2.  Ongoing Operating Expenses

If you are creating a set of projections for a startup brewery this list of startup expenses and ranges comes from ProBrewer.com.

• Licensing and Permits
• Construction Costs
• Furniture and Fixtures
• Insurance
• Brewery Incubators

Some of the items listed as startup expenses should be entered as expenses on month 1 and some are actually cash spent on assets like:

• Leasehold improvements
• Equipment
• Buildings

If you have any of these types of expenses you will want to add them later as an “Asset” instead of an “Expense” on this page.

Operating Expenses

On the Expenses page in ProjectionHub you will be able to add/update your operating expenses.  You will notice that the Expense page will come with a number of standard expense line items along with a default monthly expense for most of the line items.  Obviously you can change any of these default expenses to reflect your specific situation.

Some expenses will be a % of your total sales, instead of a fixed monthly amount.

So as you see in the image above you can click the check boxes next to those expense categories and then in the drop down box you can select “Apply Industry Ratios” and then click “Apply”.

Assets

Next you can move on to the assets section.  You will notice that the Assets page comes pre-loaded with the default assets that you might have as a Brewery owner.

To add an asset, hover over the row, see the 3 dots on the left of the asset name, hover over, and click edit.

You can enter in the details of your assets as seen below:

Loans

Next you can move to the Liabilities page and add a loan.  If you are going to borrow to help fund your startup costs, you can “Add a Liability” as seen below:

Investors

Next you can add any personal investment you will be making as well as investment from outside investors.

Reports

Once you enter in all of your assumptions you will be able to review a number of reports.  Here is a sampling of some of the reports, tables below:

On the Dashboard page you will be able to download your projection Income Statement, Balance Sheet and Cash Flow projections to share with your lender or investor.

Adding Multiple Brewery Units

Finally, let’s assume you want to add another brewery in the future.  All you need to do is go back to the “Business Model” page and add another “Brewery” business model.  You can then label it Brewery Unit 2 and you can repeat the process.  You can add as many units as you would like over time.

Again, you can get started by creating a ProjectionHub free trial account today.

As you complete your projections please don’t hesitate to reach out to us with questions at support@projectionhub.com

Good luck!

The incredible growth in smart phone users in the last few years has led to a boom in the mobile app market. The Apple App Store alone has almost 2 million apps while Google owns around 2.2 million of their own. With this market growing, now is a great time to create and sell a mobile app of your own!

To do this, you will need the ability to create financial projections for your app in order for investors and lenders to buy into the idea. We can help with that! ProjectionHub has a financial projection template made specifically for selling a mobile app backed up by a Google Sheet revenue model for more customizable and accurate projections.

This post will take you step-by-step through the process of using the ProjectionHub.Com web application.

You may also be interested in our Mobile App Financial Projection Template here.

Signup Instructions

1. Feel free to learn more about ProjectionHub in general before signing up.
2. You can sign up for a free trial by selecting the “Mobile App” template here.
3. If you have any questions about the model as you go, please email support@projectionhub.com

General Business Info

Once you sign up and confirm your account you will be asked to complete some general business info as seen below:

Adding the Mobile App Business Model

Once you save the general business info, you will be able to add a business model.  If you don’t already see a Mobile App Business Model added on this page, you can click the add Business Model button as seen below to add your first Mobile App unit.

Mobile App Revenue

Next you can click the orange button to Add Revenue to get started with your sales projections.

You will now have 2 options as you see in the image below:

1.  You can click “Add Revenue” which will give you the ability to add projected revenue numbers for each month for your app.
2.  Or you can click “Add Google Sheet Revenue”.  We have created a special Google Spreadsheet template specifically for Mobile Apps that will give you more control in terms of adding assumptions for your average ticket price and number of customer orders each month.
3. If you decide to utilize our Google Sheet template please see this guide on how to enable the Google Sheet Integration.  You can see a screenshot of the Google Sheet below:

Expenses

Once you complete your revenue projections you can move on to your expenses.  There are 2 primary types of expenses:

1.  Startup Expenses
2.  Ongoing Operating Expenses

If you are creating a set of projections for a startup Mobile App, this list of startup expenses and ranges comes from MobileAppCost.Com

• Legal
• HR
• Marketing
• Equipment and Software

Some of the items listed as startup expenses should be entered as expenses on month 1 and some are actually cash spent on assets like Equipment

If you have any of these types of expenses you will want to add them later as an “Asset” instead of an “Expense” on this page.

Operating Expenses

On the Expenses page in ProjectionHub you will be able to add/update your operating expenses.  You will notice that the Expense page will come with a number of standard expense line items along with a default monthly expense for most of the line items.  You can change any of these default expenses to reflect your specific situation.

Some expenses will be a % of your total sales, instead of a fixed monthly amount.

So as you see in the image above you can click the check boxes next to those expense categories and then in the drop down box  you can select “Apply Industry Ratios” and then click “Apply”.

Assets

Next you can move on to the assets section.  You will notice that the Assets page comes pre-loaded with the default assets that you might have as a Mobile App owner.

To add an asset, hover over the row, see the 3 dots on the left of the asset name, hover over, and click edit.

You can enter in the details of your assets as seen below:

Loans

Next you can move to the Liabilities page and add a loan.  If you are going to borrow to help fund your startup costs, you can “Add a Liability” as seen below:

Investors

Next you can add any personal investment you will be making as well as investment from outside investors.

Reports

Once you enter in all of your assumptions you will be able to review a number of reports.  Here is a sampling of some of the reports, tables below:

On the Dashboard page you will be able to download your projection Income Statement, Balance Sheet and Cash Flow projections to share with your lender or investor.

Adding Multiple Mobile App Units

Finally, let’s assume you want to create another Mobile App in the future.  All you need to do is go back to the “Business Model” page and add another “Mobile App” business model.  You can then label it Mobile App Unit 2 and you can repeat the process.  You can add as many units as you would like over time.

Again, you can get started by creating a ProjectionHub free trial account today.

As you complete your projections please don’t hesitate to reach out to us with questions at support@projectionhub.com

Good luck!

Photo by PhotoMIX Company from Pexels

With advancements being made in technology and a greater emphasis being put on convenience, e-commerce is a growing industry with new competitors entering the market on a regular basis. If you choose to take advantage of this growing market and open an e-commerce business, you will need financial projections unique to your business for potential investors and lenders.

ProjectionHub can help you with those projections. Using our web application at ProjectionHub.Com, you can easily create customizable and accurate financial projections to share with the potential stakeholders of your company.

The purpose of this blog is to walk you through the process of using our website to create accurate projections.

Signup Instructions

1. Feel free to learn more about ProjectionHub in general before signing up.
2. You can sign up for a free trial by selecting the “E-commerce” template here.
3. If you have any questions about the model as you go, please email support@projectionhub.com
   

General Business Info

Once you sign up and confirm your account you will be asked to complete some general business info as seen below:

Adding the E-commerce Business Model

Once you save the general business info, you will be able to add a business model.  If you don’t already see an E-commerce Business Model added on this page, you can click the add Business Model button as seen below to add your first E-commerce unit.

Revenue

Next you can click the orange button to Add Revenue to get started with your sales projections.

You will now have 2 options as you see in the image below:

1.  You can click “Add Revenue” which will give you the ability to add projected revenue numbers for each month for your business.
2.  Or you can click “Add Google Sheet Revenue”.  We have created a special Google Spreadsheet template specifically for an E-commerce business that will give you more control in terms of adding assumptions for your average ticket price and number of customer orders each month.
3. If you decide to utilize our Google Sheet template please see this guide on how to enable the Google Sheet Integration.  You can see a screenshot of the Google Sheet below:

Expenses

Once you complete your revenue projections you can move on to your expenses.  There are 2 primary types of expenses:

1.  Startup Expenses
2.  Ongoing Operating Expenses

Some of the items listed as startup expenses should be entered as expenses on month 1 and some are actually cash spent on assets like:

• Leasehold improvements
• Equipment
• Buildings

If you have any of these types of expenses you will want to add them later as an “Asset” instead of an “Expense” on this page.

Operating Expenses

On the Expenses page in ProjectionHub you will be able to add/update your operating expenses.  You will notice that the Expense page will come with a number of standard expense line items along with a default monthly expense for most of the line items.  Obviously you can change any of these default expenses to reflect your specific situation.

Some expenses will be a % of your total sales, instead of a fixed monthly amount.

So as you see in the image above you can click the check boxes next to those expense categories and then in the drop down box you can select “Apply Industry Ratios” and then click “Apply”

Assets

Next you can move on to the assets section.  You will notice that the Assets page comes pre-loaded with the default assets that you might have as an E-commerce business owner.

To add an asset, hover over the row, see the 3 dots on the left of the asset name, hover over, and click edit.

You can enter in the details of your assets as seen below:

Loans

Next you can move to the Liabilities page and add a loan.  If you are going to borrow to help fund your startup costs, you can “Add a Liability” as seen below:

Investors

Next you can add any personal investment you will be making as well as investment from outside investors.

Reports

Once you enter in all of your assumptions you will be able to review a number of reports.  Here is a sampling of some of the reports, tables below:

On the Dashboard page you will be able to download your projection Income Statement, Balance Sheet and Cash Flow projections to share with your lender or investor.

Adding Multiple E-commerce Units

Finally, let’s assume you want to add another E-commerce business in the future.  All you need to do is go back to the “Business Model” page and add another “E-commerce” business model.  You can then label it E-commerce Unit 2 and you can repeat the process.  You can add as many units as you would like over time.

Again, you can get started by creating a ProjectionHub free trial account today.

As you complete your projections please don’t hesitate to reach out to us with questions at support@projectionhub.com

Good luck!

The restaurant industry is booming with industry sales of $799, employing 14.7 million individuals, and growing at an annual rate of 5.3%. People have to eat, and as eating out becomes more of a cultural norm, starting your very own restaurant begins presenting a vast amount of financial benefits.

First, in order to start/run your own restaurant, it will be necessary to create financial projections to show potential lenders or investors as well as for internal planning purposes.

That’s where we come in! ProjectionHub has been adding financial templates backed by Google Sheet revenue modeling for numerous business models onto our web application at ProjectionHub.com. This post will show you the process of utilizing this helpful tool to create customized and accurate financial projections!

Signup Instructions

1. Feel free to learn more about ProjectionHub in general before signing up.
2. You can sign up for a free trial by selecting the “Restaurant” template.
3. If you have any questions about the model as you go, please email support@projectionhub.com

General Business Info

Once you sign up and confirm your account you will be asked to complete some general business info as seen below:

Adding the Restaurant Business Model

Once you save the general business info, you will be able to add a business model.  If you don’t already see a Restaurant Business Model added on this page, you can click the add Business Model button as seen below to add your first Restaurant.

We have 6 different Restaurant business models for you to choose from, each with it’s own revenue model and customizable expenses:

1. Restaurant–General Model
2. Restaurant–Fast Food
3. Restaurant–Fast Casual
4. Restaurant–Casual Dining
5. Restaurant–Fine Dining
6. Restaurant–Bar

Revenue

Next you can click the orange button to Add Revenue to get started with your sales projections.

You will now have 2 options as you see in the image below:

1.  You can click “Add Revenue” which will give you the ability to add projected revenue numbers for each month for your restaurant.
2.  Or you can click “Add Google Sheet Revenue”.  We have created a special Google Spreadsheet template specifically for each Restaurant model that will give you more control in terms of adding assumptions for your average ticket price and number of customer orders each month.
3. If you decide to utilize our Google Sheet template please see this guide on how to enable the Google Sheet Integration.  You can see a screenshot of the Google Sheet below:

Expenses

Once you complete your revenue projections you can move on to your expenses.  There are 2 primary types of expenses:

1.  Startup Expenses
2.  Ongoing Operating Expenses

If you are creating a set of projections for a startup Jimmy John’s location, this list of startup expenses and ranges comes from Inc.com.

Some of the items listed as startup expenses should be entered as expenses on month 1 and some are actually cash spent on assets like:

• Leasehold improvements
• Equipment
• Buildings

If you have any of these types of expenses you will want to add them later as an “Asset” instead of an “Expense” on this page.

Operating Expenses

On the Expenses page in ProjectionHub you will be able to add/update your operating expenses.  You will notice that the Expense page will come with a number of standard expense line items along with a default monthly expense for most of the line items.  You can change any of these default expenses to reflect your specific situation.

Some expenses will be a % of your total sales, instead of a fixed monthly amount.

So as you see in the image above you can click the check boxes next to those expense categories and then in the drop down box you can select “Apply Industry Ratios” and then click “Apply”

Assets

Next you can move on to the assets section.  You will notice that the Assets page comes pre-loaded with the default assets that you might have as a Restaurant owner.

To add an asset, hover over the row, see the 3 dots on the left of the asset name, hover over, and click edit.

You can enter in the details of your assets as seen below:

Loans

Next you can move to the Liabilities page and add a loan.  If you are going to borrow to help fund your startup costs, you can “Add a Liability” as seen below:

Investors

Next you can add any personal investment you will be making as well as investment from outside investors.

Reports

Once you enter in all of your assumptions you will be able to review a number of reports.  Here is a sampling of some of the reports, tables below:

On the Dashboard page you will be able to download your projection Income Statement, Balance Sheet and Cash Flow projections to share with your lender or investor.

Adding Multiple Restaurant Units

Finally, let’s assume you want to add another restaurant in the future.  All you need to do is go back to the “Business Model” page and add another “Restaurant” business model.  You can then label it Restaurant Unit 2 and you can repeat the process.  You can add as many units as you would like over time.

Again, you can get started by creating a ProjectionHub free trial account today.

As you complete your projections please don’t hesitate to reach out to us with questions at support@projectionhub.com or view our other financial templates including our cafe expenses spreadsheet and our small donut shop income template.

Good luck!

Are you starting or running your own private dental practice? If so, odds are you didn’t graduate college with a business degree, and you may be struggling with the financials of owning your own company. ProjectionHub is here to help!

We have developed a web application integrating revenue model dental office spreadsheets. This blog post will walk you through how to use the ProjectionHub web application to generate your financial projections, whether that be for lenders, investors, or simply internal planning.

Signup Instructions

1. Feel free to learn more about ProjectionHub in general before signing up.
2. You can sign up for a free trial by selecting the “Dental Practice” template.
3. If you have any questions about the model as you go, please email support@projectionhub.com

General Business Info

Once you sign up and confirm your account you will be asked to complete some general business info as seen below:

Adding the Dental Practice Business Model

Once you save the general business info, you will be able to add a business model.  If you don’t already see a Dental Practice Business Model added on this page, you can click the add a Business Model button as seen below to add your first Dental Practice unit.

Dental Practice Revenue

Next you can click the orange button to Add Revenue to get started with your sales projections.

You will now have 2 options as you see in the image below

1. Add Revenue
2. Add Google Sheet Revenue

1.  You can click “Add Revenue” which will give you the ability to add projected revenue numbers for each month for your practice.
2.  Or you can click “Add Google Sheet Revenue”.  We have created a special Google Spreadsheet template specifically for Dental Practices that will give you more control in terms of adding assumptions for your average price and number of patients each month.
3. If you decide to utilize our Google Sheet template please see this guide on how to enable the Google Sheet Integration.  You can see a screenshot of the Google Sheet below:

Expenses

Once you complete your revenue projections you can move on to your expenses.  There are 2 primary types of expenses:

1.  Startup Expenses
2.  Ongoing Operating Expenses

Some of the items listed as startup expenses should be entered as expenses on month 1 and some are actually cash spent on assets like:

• Leasehold improvements
• Equipment
• Buildings

If you have any of these types of expenses you will want to add them later as an “Asset” instead of an “Expense” on this page.

Dental Practice Operating Expenses

On the Expenses page in ProjectionHub you will be able to add/update your operating expenses.  You will notice that the Expense page will come with a number of standard expense line items along with a default monthly expense for most of the line items.  Obviously you can change any of these default expenses to reflect your specific situation.

Some expenses will be a % of your total sales, instead of a fixed monthly amount.

So as you see in the image above you can click the check boxes next to those expense categories and then in the drop down box  you can select “Apply Industry Ratios” and then click “Apply”.

Dental Practice Assets

Next you can move on to the assets section.  You will notice that the Assets page comes pre-loaded with the default assets that you might have as a Dental Practice owner.

To add an asset, hover over the row, see the 3 dots on the left of the asset name, hover over, and click edit.

You can enter in the details of your assets as seen below:

Dental Practice Loans

Next you can move to the Liabilities page and add a loan.  If you are going to borrow to help fund your startup costs, you can “Add a Liability” as seen below:

Investors

Next you can add any personal investment you will be making as well as investment from outside investors.  Simply go to the investors tab and click “add investor” and choose from our list of potential investor types:

Reports

Once you enter in all of your assumptions you will be able to review a number of reports.  Here is a sampling of some of the reports, tables below:

On the Dashboard page you will be able to download your projection Income Statement, Balance Sheet and Cash Flow projections to share with your lender or investor.

Adding Multiple Dental Practice Units

Finally, let’s assume you want to add another Dental Practice in the future.  All you need to do is go back to the “Business Model” page and add another “Dental Practice” business model.  You can then label it Dental Practice Unit 2 and you can repeat the process.  You can add as many units as you would like over time.

Again, you can get started by creating a ProjectionHub free trial account today.

As you complete your projections please don’t hesitate to reach out to us with questions at support@projectionhub.com

Good luck!

Are you starting or running your own private medical practice? If so, odds are you didn’t graduate college with a business degree, and you may be struggling with the financials of owning your own company. ProjectionHub is here to help!

We have developed a web application integrating a Google Sheet revenue model specifically for medical practices. This blog post will walk you through how to use the ProjectionHub.com web application to generate your financial projections, whether that be for lenders, investors, or simply internal planning.

Signup Instructions

1. Feel free to learn more about ProjectionHub in general before signing up.
2. You can sign up for a free trial by selecting the “Medical Practice” template or view our in-home projection cost template.
3. If you have any questions about the model as you go, please email support@projectionhub.com

General Business Info

Once you sign up and confirm your account you will be asked to complete some general business info as seen below:

Adding the Medical Practice Business Model

Once you save the general business info, you will be able to add a business model.  If you don’t already see a Medical Practice Business Model added on this page, you can click the add a Business Model button as seen below to add your first Medical Practice unit.

Medical Practice Revenue

Next you can click the orange button to Add Revenue to get started with your sales projections.

You will now have 2 options as you see in the image below:

1.  You can click “Add Revenue” which will give you the ability to add projected revenue numbers for each month for your office.
2.  Or you can click “Add Google Sheet Revenue”.  We have created a special Google Spreadsheet template specifically for Medical Practices that will give you more control in terms of adding assumptions for your average price and number of patients each month.
3. If you decide to utilize our Google Sheet template please see this guide on how to enable the Google Sheet Integration.  You can see a screenshot of the Google Sheet below:

Expenses

Once you complete your revenue projections you can move on to your expenses.  There are 2 primary types of expenses:

1.  Startup Expenses
2.  Ongoing Operating Expenses

Some of the items listed as startup expenses should be entered as expenses on month 1 and some are actually cash spent on assets like:

• Leasehold improvements
• Equipment
• Buildings

If you have any of these types of expenses you will want to add them later as an “Asset” instead of an “Expense” on this page.

Medical Practice Operating Expenses

On the Expenses page in ProjectionHub you will be able to add/update your operating expenses.  You will notice that the Expense page will come with a number of standard expense line items along with a default monthly expense for most of the line items.  Obviously you can change any of these default expenses to reflect your specific situation.

Some expenses will be a % of your total sales, instead of a fixed monthly amount.

So as you see in the image above you can click the check boxes next to those expense categories and then in the drop down box  you can select “Apply Industry Ratios” and then click “Apply”.

Medical Practice Assets

Next you can move on to the assets section.  You will notice that the Assets page comes pre-loaded with the default assets that you might have as a Medical Practice owner.

To add an asset, hover over the row, see the 3 dots on the left of the asset name, hover over, and click edit.

You can enter in the details of your assets as seen below:

Medical Practice Loans

Next you can move to the Liabilities page and add a loan.  If you are going to borrow to help fund your startup costs, you can “Add a Liability” as seen below:

Investors

Next you can add any personal investment you will be making as well as investment from outside investors.  Simply go to the investors tab and click “add investor” and choose from our list of potential investor types:

Reports

Once you enter in all of your assumptions you will be able to review a number of reports.  Here is a sampling of some of the reports, tables below:

On the Dashboard page you will be able to download your projection Income Statement, Balance Sheet and Cash Flow projections to share with your lender or investor.

Adding Multiple Medical Practice Units

Finally, let’s assume you want to add another Medical Practice in the future.  All you need to do is go back to the “Business Model” page and add another “Medical Practice” business model.  You can then label it Medical Practice Unit 2 and you can repeat the process.  You can add as many units as you would like over time.

Again, you can get started by creating a ProjectionHub free trial account today.

As you complete your projections please don’t hesitate to reach out to us with questions at support@projectionhub.com

Good luck!

Top Photo by Tima Miroshnichenko from Pexels