ProjectionHub’s acquisition financial model allows you to enter in specific details about the business and details related to the acquisition such as:

• Acquisition price
• Cash balance as of acquisition date
• A/R, Inventory, and A/P balances as of acquisition date
• Existing fixed assets and fair market value as of acquisition date
• Projected future fixed asset purchases
• Loans prior to acquisition and whether the loan will be paid off in acquisition or not
• New loans for the acquisition or post acquisition
• Add a seller’s note including the ability to place on full standby to an SBA loan
• Ability to add in additional investment post acquisition
• Goodwill is automatically calculated

Then, the template will generate:

• 5 Year Income Statement Annual Summary
• 5 Year Income Statement Monthly Breakdown
• 5 year Cash Flow Statement Annual Summary
• 5 year Cash Flow Statement Monthly Breakdown
• 5 Year Projected Balance Sheet Annual Summary
• 5 Year Projected Balance Sheet Monthly Breakdown

The At-A-Glance tab serves up a comprehensive financial snapshot. Visualize your data with key financial ratios, startup cost estimations, and break-even points. Infographics, charts, and summaries will enhance your presentations, making them compelling for stakeholders, lenders, or investors.

Tables, charts, graphs and dashboards include:

• Profit and loss summary
• Use of expansion funds
• Key industry financial ratios ​​
• Cash flow from operations graph
• 5 years of monthly and annual profit and loss, cash flow and balance sheet forecasts

When projecting revenue for an existing business expansion, it makes sense to start with the historical financials.  Our template gives you the ability to create a base to project off of using your historical financials.  You can input up to 5 years of historical data including monthly detail for the current year.  From there you can select how you would like to project revenue for each revenue line item.  Your revenue forecasting options include:

• Annualize current year revenue
• An Average of previous years
• Manually set a base monthly revenue projection

Once you have a base monthly revenue calculated, you can increase or decrease each revenue line by a percentage or manually forecast revenue based upon your businesses planned expansion.

Similarly with expenses you will be able to establish a base level of expenses based on historical data or manual entry. From there you can increase or decrease expense line items by a percentage, or forecast expense line items as a percentage of revenue.

‍

In the general assumptions tab, you will input important details such as your existing fixed assets, current assets, and loans. Then you will also be able to add any fixed assets to be purchased as well as any future loans or additional investments following the acquisition. The template will then automatically build your financial statements including your balance sheet which will always balance.