fbpx

ProjectionHub

Custom Revenue Model

by Leave a Comment

Need a customized revenue model?

We’ve got you covered! ProjectionHub offers a revenue projection model customized specifically for your business. All we need is some information about your business model, and we will create 5 years of revenue projections that you can then import into the web application at ProjectionHub.Com to create accurate and customized financial projections.

Take a look at this short video to see what you will be receiving for a one-time fee of only $99!

What is ProjectionHub?

ProjectionHub is a web application that helps entrepreneurs create customizable and easy-to-read financial projections to share with potential investors, lenders, or simply for internal planning. We also offer additional consulting services if your business model is more complex or you would like more customized and detailed projections. See our services page to view all of our offerings!

Finally, if you are in need of any of our services, please fill out the form below to let us know what you need and how ProjectionHub can help make your business a success!

Fill out my online form.
There are tons of Wufoo features to help make your forms awesome.

SaaS Revenue Model

by Leave a Comment

We are ProjectionHub, a software that assists entrepreneurs in creating customizable and easy-to-read financial projections unique to their business models.

Google Sheet Integration

One of the ways in which we do this is by creating and integrating Google Sheet revenue models for each business model template. We structure a revenue model specific to a business type and allow you, the business owner, to customize it according to your company. Then, the user has the ability to import those revenue projections into the ProjectionHub web application in order to create accurate and custom financial projections unique to his/her business.

SaaS Business Model

If you would like to read more about SaaS business models and how to use ProjectionHub.Com to create financial projections for your SaaS company, see “Financial Projections for a SaaS Company”. This blog post is specifically designed to inform users on how to utilize our Google Sheet integration.

Saas Revenue Model

In the video below, we will walk you through how to edit and import the SaaS Google Sheet revenue model into the ProjectionHub web application to generate your customized financial projections. But first, I will simply provide you with a list of steps to integrate your Google Sheet revenue model:

  1. Add the Software as a Service business model
  2. Go to the “Revenue” tab and click “Add Google Sheet Revenue Model”
    1. You may have to connect your Google account then click this button a second time
  3. Click the green spreadsheet icon next to the “New Revenue” line item
  4. Edit any of the assumptions highlighted in blue on the Google Sheet to match your company’s assumptions
  5. Go back to ProjectionHub.Com, hover over the 3 dots to the left of the “New Revenue” line item, and select “Import Google Sheet Revenue”
  6. Add any expenses, assets, liabilities, and investors
  7. View your financial projections by clicking on the Dashboard icon to the left of your page

We hope this post and the following video proves to be helpful as you create your very own financial projections for your Software as a Service business!

Happy Projecting!

ProjectionHub Google Spreadsheet Integration

by Leave a Comment

We are excited to announce a major new feature for ProjectionHub – Google Spreadsheet Integration.

With this new integration, users will get the best of both worlds:

  1. The flexibility of a spreadsheet
  2. The ease of use of ProjectionHub to help ensure your financial projections are bank and investor ready

Why Use Google Sheets Integration with ProjectionHub

A spreadsheet is often the best way to develop an assumptions based, customized financial model for your specific business.  Over the years we have helped create 100’s of customized financial models for various startups and small businesses using a spreadsheet that may have 1,000’s of assumptions.  The problem is that you need to integrate those assumptions into an integrated financial model that will allow you to create projected income statements, cash flow statements and balance sheets that are banker and investor ready.

Our new Google Sheets Integration will allow you to do all of your customized assumptions for your business in a Google Sheet and then import your revenue projections directly into ProjectionHub.  ProjectionHub will then format your projected financial statements properly and allow you to download a finished set of projections so that you don’t have to worry about breaking your spreadsheet template.

How to Use Google Sheets Integration


So here is how to use Google Sheets within ProjectionHub.

1. Sign up for a ProjectionHub account and add your Business Info

2. Select a Business Model that best fits your company.

In this example I will add a Mobile App Business Model

3. Add Revenue

If your business model has a Google Sheet Template you will see a button that says “Add Google Sheet Revenue” which means this feature is enabled for your business model.  If we don’t have a template for your business model yet, please email support@projectionhub.com to let us know that you would like us to add a Google Sheet Template for your business model and we will add a template ASAP.

4.  Connect your Google Account

If you have not yet connected your Google Account, when you click “Add Google Sheet Revenue” you will be redirected to connect your Google Account.  Don’t worry, by connecting your Google Account you are only giving us the ability to add the Google Sheet Template to your Google Drive account so that you can work on customizing your projections in the Google Sheet.

Then you will get to select an existing Google Account that you would like to connect.

5.  Continue Adding Revenue

Next you will want to click “Continue Adding Revenue” to bring you back to the Revenue page.  Also, note that you can always come back to your Connected Accounts page to Revoke Google Account Access.

6.  Click “Add Google Sheet Revenue” Again

Now that you have connected your Google Account you can click “Add Google Sheet Revenue” again and it will add your Google Sheet Template.

7.  Take a Sip of Coffee – It May Take 10 Seconds to Add your Sheet

8.  Make sure Popup’s aren’t Blocked

You should now see a new row called “New Revenue” with a Google Sheet Icon next to it.  Click the Icon to open your Google Sheet template, and make sure that Popup’s aren’t blocked.  In Google Chrome there is a little box in the top right corner that you can click to unblock popup’s so that you can view your Google Sheet Template.

9.  Customize your Revenue Projections in the Google Sheet Template

You will see a template that we have created to help you develop your revenue projections.  Every cell that is highlighted in blue is an assumption that you can change.  So in this example you will see things like website visitors, conversion rates to app downloads, user cancellation rates, subscription revenue, ad revenue etc.

You can customize the “Data Sheet” tab in the template as much as you want for your specific model.

10.  Don’t Break the Integration!

You will need to be careful not to break the integration.  The Row titled “Total Revenue” on the “Data Sheet” tab flows into tabs Year 1, Year 2, Year 3, Year 4 and Year 5.  Ultimately this is what is imported into ProjectionHub, so you can customize anything you want in the sheet, BUT please make sure that your final revenue projections are in the Total Revenue row.

11.  Import your Google Sheet into ProjectionHub

Now back in ProjectionHub, hover over the left of your new Revenue Row and you will see 3 dots that will give you a menu option to “Import Google Sheet”  Once you click to Import ProjectionHub will pull your revenue numbers from your customized Google Sheet.

12.  Rename your Revenue Line Item

You can now rename your revenue line item to whatever you want, and then add an additional Google Sheet for an additional Revenue Line Item if you would like.

13.  Need help?

If you need some help, please reach out to support@projectionhub.com for technical questions, or if you would like us to help you develop your custom revenue model, we do offer consulting services which you can request a quote for here.