How to Customize a ProjectionHub Financial Model Template

August 24, 2022

Adam Hoeksema

One of the most common requests at ProjectionHub is to add revenue line items or expenses to one of our existing financial model templates.  Just today we were asked to add special event catering to our food truck template, services to our manufacturing financial model, and multiple units to our medical office financial model.  We are happy to provide custom financial modeling services and charge customers for these changes for those that don’t want to mess with Excel, but for those of you willing to try a bit of spreadsheet customization, we wanted to share how you can customize a ProjectionHub financial model yourself. 

The three most common requests are:

  1. Can I add a revenue model to an existing spreadsheet? 
  2. Can I add more expense line items to a ProjectionHub financial model? 
  3. Can I add more salaried positions to a ProjectionHub template? 

I am going to share a video demonstration to show you how to do all three customizations on your own if you have the confidence and patience to work in Excel.  

Customizing Revenue Models - ProjectionHub

Almost all ProjectionHub financial projection templates come with at least 4 revenue line items, but many templates only have one or two line items utilized by default.  This means that it is relatively easy to add your own revenue line items to the template if you have additional revenue drivers in your business that need to be included.  Watch the video below to learn exactly how to add your own revenue model customizations. 

Adding Expenses to a ProjectionHub Template

ProjectionHub templates come with a set amount of operating expense line items, but there is an easy hack to essentially create an unlimited number of expense line items that would simply be consolidated in the financial statements.  In this video I will show you how to add additional operating expenses into any ProjectionHub template. 

Adding Salaried Positions to a ProjectionHub Template

ProjectionHub templates come with a set amount of salaried position line items, but there is an easy customization to create additional salaried position line items.  In this video I will show you how to add additional salary expenses into any ProjectionHub template. 

If you have more money than time or patience to fiddle around with Excel equations all day, that is why we are here, just reach out with your custom financial modeling needs and we will provide a quick quote to help you complete a set of projections that will satisfy your potential investors, lenders and internal stakeholders.

How to Change Currency Symbols on a ProjectionHub Template

About the Author

Adam is the Co-founder of ProjectionHub which helps entrepreneurs create financial projections for potential investors, lenders and internal business planning. Since 2012, over 50,000 entrepreneurs from around the world have used ProjectionHub to help create financial projections.

Other Stories to Check out

5 Key Tips to Make Your Startup Business Plan Shine for an SBA Loan

Learn 5 key tips to make your startup business plan stand out and secure an SBA loan, from demonstrating market potential to creating realistic financial projections.

How to Know if Your Financial Projections are Realistic

It is important for financial projections for a small business or startup to be realistic or else an investor or lender may not take them seriously. More importantly, the founder may make a financial mistake without a reliable plan.

How to Finance a Small Business Acquisition

In this article we are going to walk through how to finance a small business acquisition and answer some key questions related to financing options.

Have some questions?
Let us know and we'll be in touch.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.