SaaS Startup - 5 Year Financial Planning Model
Originally published: 15/10/2020 10:50
Last version published: 16/10/2020 07:09
Publication number: ELQ-28008-2
View all versions & Certificate

SaaS Startup - 5 Year Financial Planning Model

Fast evaluation of your startups plan

With one easy to use Inputs page and one funding requirements assessment page, the model will produce for you a set of 5 year accounts, revenue analyses, cost analyses, a key financial KPIs dashboard and an Investor Final stake value.

Outline of the process


Stage one:
is to populate the Inputs Worksheet with details of your products, their forecast sales profiles, product development and other operational Costs.

Stage two:
Is to go to the Funding Worksheet & refresh the graphs. Both will be the same, the key one to start with is the left one showing cash flows from your operations and any cash shortfalls that you have to cover.
Then input above in the appropriate sections how you plan to fund your company across the life of the plan.
Refresh the graphs and the right graph will show you how your funding has helped you reach you cash needs objectives or not.
Either review your funding assumptions or your operational plans until you have the result that you need.

The model will now generate a set of reports, accounts and dashboard for you and potential investors and / or lenders to review. These are:

a set of 5 Year Income Statements, Balance Sheets and Cash Flow Forecasts.

Cost analyses:
Setting out you expenses & payroll spend over the 5 years across the departments that you have activated.

Revenue metrics:
Made up of two elements:
• A five-year revenue summary
• A month by month analysis allowing you to drill down & analyse the revenue streams by product, subscription type & by Bookings, MRR, ARR or LTV’s.

Financial dashboard with representations of the key KPI’s for:
• General financial KPIs
• Profitability Ratios
• Liquidity Ratios
• Leverage Ratios

Investor returns summary sheet showing:
• How much, based on the Company’s final book value, each investors’ original stake is now worth
• A technical Discounted cash Flow analysis across the five years of the plan

This Best Practice includes
Excel workbook

Acquire business license for $29.00

Add to cart

Add to bookmarks


Further information

Be able to assess your plans and amend and refine to obtain the outcomes that you need

SaaS Startup Initial Assessment

Non Subscription based business


  • Be the first to review this Downloadable Best Practice

    Write a review


Any questions on SaaS Startup - 5 Year Financial Planning Model?

The user community and author are here to help. Go ahead!

0.0 / 5 (0 votes)

please wait...