Freelancer Financial Model (Excel + Google Sheets)
A 5 year financial model built for a freelancer or consultant, not a generic business template with the name changed.
Type your day rate, your retainers, your projects and your product sales on one tab. Everything else calculates.
WHAT YOU GET
• 15 tab financial model, Excel and Google Sheets
• Dashboard with 6 KPI tiles and 3 charts: capital required, revenue at maturity, margins, break even month, cash low point
• Revenue built from real freelance drivers: billable days, monthly retainers, fixed price projects, products and courses, each with growth and a capacity ceiling so it cannot pretend you have 40 billable days a month
• Hire timeline: virtual assistant, subcontractor, associate, each with a start month
• Freelance expense lines: software, coworking, marketing, accountant, insurance, training, travel, payment fees
• Linked P&L, cash flow and balance sheet, monthly for 60 months plus annual summaries
• Break even analysis, Base / Best / Worst scenarios, funding requirement and use of funds
• Benchmarks beside your own numbers: pay % of revenue, overheads %, EBITDA margin
• Checks tab that proves the model balances
• One page quick start guide
WHO IT IS FOR
Going freelance and want to know if the numbers work. Already freelance and want to know when you can hire. Pitching a bank, a partner or yourself.
HOW IT WORKS
1. Download and open in Excel, or import into Google Sheets
2. Go to Inputs. Blue cells on yellow are yours.
3. Read the Dashboard.
FORMAT
Excel .xlsx, opens in Excel 2016 or later and in Google Sheets. No macros. Instant download after purchase. A one click Google Sheets copy link is inside the download.
Preview images were created with AI assisted design tools. The spreadsheet itself is hand built and formula driven.
LICENCE
Personal and single business use. Not for resale or redistribution.
Also in the shop: Freelance OS (the Notion system) and the Freelance Rate Calculator.
Questions before you buy? Message me. I answer within a day.