# Income Statement Model Build a five-year income statement without stitching formulas together by hand. Three revenue streams - product sales from units and price, a services contract book, and support and maintenance attaching to the installed base - feed a cost of sales that breaks into materials, direct service labour, support delivery and freight, each geared to the stream it serves. A headcount schedule with a benefits load drives salaries and benefits, an amortising term loan sizes interest off the opening balance so the charge falls as the loan pays down, and the statement walks to EBITDA, EBIT, profit before tax and net income with gross, EBITDA, operating and net margins and two arithmetic checks that must read zero. - Canonical: https://finamodel.com/templates/income-statement - Excel download: https://finamodel.com/templates/income-statement.xlsx - Category: Corporate Finance - Model type: Operating model - Difficulty: Beginner - Audiences: CFOs & FP&A, Founders & operators, Founders and operators, FP&A and finance teams, Accountants and bookkeepers, Analysts and students - Tags: income-statement, profit-and-loss, forecasting, financial-statements, budgeting ## Overview This model gives you a complete five-year income statement for a product-and-services business, built so every number traces back to a driver you can change. Revenue is split into product sales, a services contract book and a support and maintenance line, each with its own growth mechanics, and the cost of delivering them is broken into components tied to the stream each one serves. Use it as an annual budget, a five-year forecast, or a way to see how a profit and loss statement is actually put together. Test pricing, revenue mix, hiring pace and the cost of debt to see how each one moves gross margin, EBITDA and net income. ## What's included - Revenue drivers: Year-1 units and unit price, volume and price growth, Year-1 service contracts and annual contract fee, contract growth, support attach rate - Cost of sales: materials and components, direct service labour, support delivery cost, freight and fulfilment, each geared to the stream it serves - Operating expenses: Year-1 headcount and annual additions, average salary, benefits load, wage growth, sales and marketing, rent and facilities with lease inflation, technology and admin - Below the operating line: depreciation and amortisation, opening debt, scheduled repayment, interest rate, tax rate - Revenue sheet: units and price, contracts and fee, revenue by stream, total revenue and year-on-year growth - Operating_Costs sheet: cost of sales by component with a total, headcount and fully loaded cost per FTE, the four operating expense lines with a total - Income_Statement sheet: revenue to net income with an amortising debt and interest schedule, four margin lines and two arithmetic checks - Dashboard with revenue, revenue CAGR, gross profit, EBITDA, net income, margins, revenue per FTE, revenue mix and a Revenue to Net Income bridge ## How the Income Statement Template Calculates Revenue, Costs and Profit This income statement template projects a five-year profit and loss for a product-and-services business, where every figure traces back to a driver you can change. It covers three revenue streams, a component-level cost of sales, headcount-driven operating expenses, a term-loan interest schedule and a full earnings walk to net income. The public download is a values-only preview. ### Revenue Driven by Volume, Price and Attach Rates The model builds revenue from three distinct streams rather than a single growth line. Product sales combine units and unit price, with volume and price each escalating on separate assumptions, so demand growth can be examined independently of pricing power. - The services book compounds on its own contract growth rate, while the annual contract fee tracks the same price escalator used by the product line, keeping pricing consistent across the business. Support and maintenance is not forecast independently; it attaches to product revenue at a fixed rate, mirroring how a maintenance base is sold against the installed product. - The three streams sum to total revenue, with a year-on-year growth row showing the combined movement. ### Cost of Sales and Why Blended Margin Is an Output Cost of sales is assembled from four components, and three of them are geared to the specific stream each one serves. Materials and components follow product revenue, direct service labour follows services revenue, and support delivery cost follows support revenue. - Only freight and fulfilment runs on total revenue. Because direct costs are tied to their own streams rather than to a single blended percentage, gross margin emerges as a consequence of revenue mix. - If the mix shifts toward a stream carrying a heavier direct-cost load, the blended margin compresses without any assumption being edited. This design makes the statement sensitive to mix, which is the intended mechanism. ### Headcount, Benefits Load and Operating Leverage Operating expenses are anchored by a headcount schedule built in three steps. Headcount rolls forward from an opening FTE count plus a fixed annual intake, average salary escalates at wage growth, and a benefits load grosses salary into a fully loaded cost per FTE. - Salaries and benefits is then headcount multiplied by that fully loaded cost. Other operating lines are geared to revenue or to their own escalation, with rent and facilities rising on lease inflation. - Because headcount growth can be set independently of revenue growth, the model exposes operating leverage: when headcount grows more slowly than revenue, EBITDA margin widens, and changing the intake assumption reverses that effect. ### The Earnings Walk, Interest, Tax and Practical Use Below gross profit, the statement walks through total operating expenses to EBITDA, then deducts depreciation and amortisation to reach EBIT, subtracts interest, applies tax and arrives at net income, with a four-line margin block alongside. Interest is charged on the opening loan balance within an amortising schedule, so the charge falls as the loan is repaid rather than sitting static. - Tax is floored at zero, so a loss year carries no tax credit rather than an implausible negative charge. Two check rows must resolve to zero in every period. - The template suits annual budgeting and five-year forecasting, and lets you test pricing, revenue mix, hiring pace and the cost of debt. ## Three revenue streams, not one growth rate Product sales are built from a true volume and price pair that grow on separate assumptions, services from a contract book, and support and maintenance from an attach rate on the installed product base. Total revenue is a genuine sum of the three, so an analyst can separate unit demand from pricing power and see exactly which stream is carrying the forecast. ## Gross margin is an output of mix Each cost of sales component is geared to the revenue stream it actually serves - materials to product, direct labour to services, delivery cost to support - rather than to total revenue. Shift the mix toward the heavier-cost services line and the blended gross margin compresses without a single assumption changing, which is how a real cost structure behaves. ## Interest on a declining balance A three-line amortising term-loan schedule sits inside the statement, with the repayment guarded so the loan cannot be over-repaid, and interest charged on the opening balance each year. The charge falls as the loan pays down and net margin widens faster than EBITDA margin - the single most common error in a hand-built P&L, where interest is entered once and copied across. ## Designed for one-edit responsiveness Every input - the unit volume and price escalators, the contract book, the support attach rate, each cost of sales component, the headcount plan and benefits load, the lease escalator, the loan terms and the tax rate - is a named-range cell. Edit one and the revenue build, cost build, statement, margins and dashboard all recompute. No formula rewrites are needed to test a pricing, hiring or financing scenario. ## Workbook structure ### Cover Workbook overview, sheet legend, units, and tab-colour key. - Title and scope framing - Sheet-by-sheet purpose summary - Units and tab-colour legend ### Assumptions Every driver in one sheet: revenue, cost of sales, opex, below the line. - Year-1 units and unit price, volume and price growth - Year-1 service contracts, annual contract fee, contract growth, support attach rate - Materials, direct service labour, support delivery cost, freight and fulfilment - Headcount and additions, average salary, benefits load, wage growth - Sales and marketing, rent and facilities with lease inflation, technology and admin - Depreciation and amortisation, opening debt, scheduled repayment, interest rate, tax rate ### Revenue Volume, price, and revenue by stream. - Units sold and unit price, each on its own escalator - Service contracts and annual contract fee - Product sales equal units times unit price - Services equal contracts times annual fee - Support and maintenance equals product sales times the attach rate - Total revenue and year-on-year growth ### Operating_Costs Cost of sales, headcount, and the operating expense stack. - Materials on product revenue, direct labour on services, delivery cost on support - Freight and fulfilment on total revenue - Total cost of sales - Headcount rolls forward from an opening count plus annual additions - Average salary escalates at wage growth; the benefits load gives cost per FTE - Salaries and benefits, sales and marketing, rent and facilities, technology and admin, and the total ### Income_Statement Revenue to net income with margins and checks. - Revenue, cost of sales, gross profit - The four operating expense lines and their subtotal - Amortising debt schedule: opening, repayment, closing, interest on the opening balance - EBITDA, depreciation and amortisation, EBIT - Interest expense, profit before tax, income tax, net income - Gross, EBITDA, operating and net margins - Two arithmetic checks that resolve to zero in every column ### Dashboard Headline metrics, trend charts, and an earnings bridge. - KPI cards for revenue, revenue CAGR, gross profit, EBITDA, net income and margins - Revenue per FTE - Five-year income statement summary table - Trend charts for revenue, gross profit, EBITDA, net income and EBITDA margin - Revenue mix by stream - Revenue to Net Income waterfall bridge ## Features - **Three revenue streams, not one growth rate:** Product sales are built from a true volume and price pair that grow on separate assumptions, services from a contract book, and support and maintenance from an attach rate on the installed product base. Total revenue is a genuine sum of the three, so an analyst can separate unit demand from pricing power and see exactly which stream is carrying the forecast. - **Gross margin is an output of mix:** Each cost of sales component is geared to the revenue stream it actually serves - materials to product, direct labour to services, delivery cost to support - rather than to total revenue. Shift the mix toward the heavier-cost services line and the blended gross margin compresses without a single assumption changing, which is how a real cost structure behaves. - **Interest on a declining balance:** A three-line amortising term-loan schedule sits inside the statement, with the repayment guarded so the loan cannot be over-repaid, and interest charged on the opening balance each year. The charge falls as the loan pays down and net margin widens faster than EBITDA margin - the single most common error in a hand-built P&L, where interest is entered once and copied across. ## Use cases - **Annual budget and forecast:** Point the revenue drivers, cost ratios and headcount plan at your own numbers and read the resulting gross profit, EBITDA and net income by year. Every line traces back to a named-range assumption, so a budget revision is an input change rather than a formula rewrite. - **Operating leverage test:** Flex annual headcount additions against revenue growth and watch the EBITDA margin widen or compress. Because salaries and benefits are built from FTEs times a fully loaded cost per head, the hiring plan is a visible driver rather than a percentage buried in an opex line. - **Pricing and mix analysis:** Change the unit price escalator, the support attach rate or the services growth rate and read the impact on blended gross margin and net income. The cost components re-gear automatically because each one is tied to the stream it serves. ## Frequently asked questions ### What is an income statement model? An income statement model, also called a profit and loss or P&L model, forecasts revenue, the cost of delivering it, operating expenses and the charges below the operating line to arrive at net income. This template does it over five years for a generic product-and-services company, with three revenue streams, component-level cost of sales, a headcount-driven expense stack, an amortising loan and a full margin block. ### What is the difference between an income statement and a cash flow statement? An income statement records revenue when it is earned and costs when they are incurred, so it measures profitability over a period. A cash flow statement records money actually moving, so it measures liquidity. A profitable company can still run out of cash, which is why the two statements answer different questions and why non-cash charges like depreciation appear on one and are added back on the other. ### How is gross profit calculated here? Gross profit is revenue less cost of sales, where cost of sales is the sum of four components - materials and components, direct service labour, support delivery cost, and freight and fulfilment. Each component is geared to the revenue stream it serves rather than to total revenue, so blended gross margin falls out of the revenue mix instead of being assumed. ### Why does the interest charge fall each year? Interest is charged on the opening balance of an amortising term loan, and the loan repays a fixed amount each year, so the balance and therefore the charge both decline across the horizon. Modelling interest on a static average is the usual shortcut and it overstates the charge in later years, which is why the schedule is built out explicitly. ## Related templates - [Balance Sheet Model](https://finamodel.com/templates/balance-sheet) - [3 Statement Model](https://finamodel.com/templates/3-statement-model) - [Cashflow Model](https://finamodel.com/templates/cashflow-model)