askediiFinancial projections for a loan or investor
Five-year projections for your kind of business, built the way lenders read them.
Each template starts from the numbers your industry actually runs on (covers and checks, enrollments and tuition, loaded miles and rate per mile) and produces the tables a loan officer asks for: annual P&L, monthly cash flow, sources and uses, DSCR and break-even.
Find your industryTemplates
Restaurant
Covers per day, average check, food and beverage cost %.
Example: $1,213,183 revenue in year 2, DSCR 3.60x
See inside →Food Truck
Service days per month, orders per day and average order, food cost %.
Example: $398,420 revenue in year 2, DSCR 4.97x
See inside →Coffee Shop
Transactions per day, average ticket, cost of goods %.
Example: $589,071 revenue in year 2, DSCR 3.31x
See inside →Daycare
Licensed capacity by age group, enrollment ramp, monthly tuition.
Example: $983,362 revenue in year 2, DSCR 4.01x
See inside →Trucking Company
Loaded miles per month, rate per mile, fuel.
Example: $676,578 revenue in year 2, DSCR 3.79x
See inside →Cleaning Business
Cleans per working day, price per clean, labor.
Example: $620,185 revenue in year 2, DSCR 35.19x
See inside →What is in every template
- Assumptions
- Every input on one sheet in blue: sales drivers, prices, payroll, rent and fixed costs, startup costs, loan terms. Each default has a note on typical values.
- Annual (5 years)
- Revenue, gross profit, EBITDA, net profit, closing cash and the lowest cash point each year, with margins, DSCR and revenue growth.
- Monthly (60 months)
- The full month-by-month P&L and cash flow, so you can see the cash low point while sales ramp up.
- Sources & Uses
- Where the money comes from (owner, loan) and where it goes, plus the owner's share of the project. The first table a loan officer asks for.
- Break-even
- The monthly revenue you need to cover payroll, fixed costs and the loan payment.
Why industry-specific
A generic template asks for "revenue". A lender asks how you got it. Each askedii template builds revenue from the drivers your industry is judged on, with defaults taken from published industry data and a note beside each one, so you start from a realistic business and change what is different about yours.
All inputs sit on one sheet in blue. Everything else is formulas you can read: no macros, no locked cells.