Rolling Budget and Forecast
Model Key
Numbers in black represent budget numbers or actuals for the current or prior year. Numbers in blue represent forecast numbers for the current year. Italicized numbers in gray cells are calculations that generally should not be altered.
Line Item
PROFIT AND LOSS Revenue Budget Actual Budget variance (Actual – Budget) Prior year Prior year variance (Actual – Prior year) Cost of Goods Sold Budget Actual Budget variance (Budget – Actual) Prior year Prior year variance (Prior year – Actual) Sales and Marketing Costs Budget Actual Budget variance (Budget – Actual) Prior year Prior year variance (Prior year – Actual) Labor Expense Budget Actual Budget variance (Budget – Actual) Prior year Prior year variance (Prior year – Actual) General and Administrative Budget Actual Budget variance (Budget – Actual) Prior year Prior year variance (Prior year – Actual) Operating Income Budget Actual Budget variance (Actual – Budget) Prior year Prior year variance (Actual – Prior year) BALANCE SHEET Cash Budget Actual Budget variance (Actual – Budget) Prior year Prior year variance (Actual – Prior year) Inventory Budget Actual Budget variance (Actual – Budget) Prior year Prior year variance (Actual – Prior year) Accounts Receivable Budget Actual Budget variance (Actual – Budget) Prior year Prior year variance (Actual – Prior year) Net Fixed Assets Budget Actual Budget variance (Actual – Budget) Prior year Prior year variance (Actual – Prior year) Accounts Payable Budget
January
February
March
Q1
April
May
June
Q2
July
August
September
Q3
October
November
December
Q4
Annual
$65,000 $60,000 ($5,000) $55,000 $5,000 $50,000 $47,500 $2,500 $45,000 ($2,500) $8,000 $10,000 ($2,000) $7,000 ($3,000) $35,000 $40,000 ($5,000) $20,000 ($20,000) $10,000 $9,000 $1,000 $5,000 ($4,000) $5,000 ($5,000) ($10,000) ($5,000) $0
$75,000 $70,000 ($5,000) $60,000 $10,000 $55,000 $55,000 $0 $48,000 ($7,000) $3,000 $4,000 ($1,000) $6,000 $2,000 $40,000 $41,000 ($1,000) $25,000 ($16,000) $10,000 $10,000 $0 $6,000 ($4,000) $5,000 ($3,000) ($8,000) ($25,000) $22,000
$85,000 $88,000 $3,000 $70,000 $18,000 $65,000 $63,000 $2,000 $54,000 ($9,000) $4,000 $3,000 $1,000 $5,000 $2,000 $40,000 $42,000 ($2,000) $30,000 ($12,000) $11,000 $12,000 ($1,000) $7,000 ($5,000) $5,000 $2,000 ($3,000) ($27,000) $29,000
$225,000 $218,000 ($7,000) $185,000 $33,000 $170,000 $165,500 $4,500 $147,000 ($18,500) $15,000 $17,000 ($2,000) $18,000 $1,000 $115,000 $123,000 ($8,000) $75,000 ($48,000) $31,000 $31,000 $0 $18,000 ($13,000) $15,000 ($6,000) ($21,000) ($57,000) $51,000
$75,000 $95,000 $20,000 $75,000 $20,000 $55,000 $45,000 $10,000 $49,000 $4,000 $6,000 $5,000 $1,000 $5,000 $0 $40,000 $42,000 ($2,000) $30,000 ($12,000) $11,000 $15,000 ($4,000) $8,000 ($7,000) $10,000 $0 ($10,000) ($15,000) $15,000
$80,000 $65,000 ($15,000) $80,000 ($15,000) $60,000 $55,000 $5,000 $51,000 ($4,000) $7,000 $6,500 $500 $6,000 ($500) $40,000 $43,000 ($3,000) $31,000 ($12,000) $12,000 $13,000 ($1,000) $9,000 ($4,000) $10,000 $5,000 ($5,000) ($15,000) $20,000
$90,000 $88,000 ($2,000) $90,000 ($2,000) $70,000 $63,000 $7,000 $56,000 ($7,000) $8,000 $7,500 $500 $7,000 ($500) $45,000 $45,000 $0 $33,000 ($12,000) $15,000 $14,000 $1,000 $10,000 ($4,000) $10,000 $7,000 ($3,000) ($15,000) $22,000
$245,000 $248,000 $3,000 $245,000 $3,000 $185,000 $163,000 $22,000 $156,000 ($7,000) $21,000 $19,000 $2,000 $18,000 ($1,000) $125,000 $130,000 ($5,000) $94,000 ($36,000) $38,000 $42,000 ($4,000) $27,000 ($15,000) $30,000 $12,000 ($18,000) ($45,000) $57,000
$95,000 $95,000 $0 $90,000 $5,000 $70,000 $70,000 $0 $70,000 $0 $7,500 $7,500 $0 $7,000 ($500) $45,000 $45,000 $0 $34,000 ($11,000) $14,000 $14,000 $0 $10,000 ($4,000) $12,500 $12,500 $0 ($33,000) $45,500
$100,000 $100,000 $0 $95,000 $5,000 $75,000 $75,000 $0 $80,000 $5,000 $8,500 $8,500 $0 $8,000 ($500) $45,000 $45,000 $0 $35,000 ($10,000) $15,000 $15,000 $0 $12,000 ($3,000) $12,500 $12,500 $0 ($25,000) $37,500
$105,000 $105,000 $0 $100,000 $5,000 $80,000 $80,000 $0 $85,000 $5,000 $9,000 $9,000 $0 $8,000 ($1,000) $50,000 $50,000 $0 $36,000 ($14,000) $16,000 $16,000 $0 $13,000 ($3,000) $12,500 $12,500 $0 ($25,000) $37,500
$300,000 $300,000 $0 $285,000 $15,000 $225,000 $225,000 $0 $235,000 $10,000 $25,000 $25,000 $0 $23,000 ($2,000) $140,000 $140,000 $0 $105,000 ($35,000) $45,000 $45,000 $0 $35,000 ($10,000) $37,500 $37,500 $0 ($83,000) $120,500
$120,000 $120,000 $0 $110,000 $10,000 $90,000 $90,000 $0 $95,000 $5,000 $8,000 $8,000 $0 $8,000 $0 $50,000 $50,000 $0 $37,000 ($13,000) $15,000 $15,000 $0 $13,000 ($2,000) $15,000 $15,000 $0 ($30,000) $45,000
$130,000 $130,000 $0 $120,000 $10,000 $100,000 $100,000 $0 $105,000 $5,000 $10,000 $10,000 $0 $9,000 ($1,000) $55,000 $55,000 $0 $38,000 ($17,000) $18,000 $18,000 $0 $14,000 ($4,000) $15,000 $15,000 $0 ($20,000) $35,000
$145,000 $145,000 $0 $130,000 $15,000 $125,000 $125,000 $0 $115,000 ($10,000) $6,500 $6,500 $0 $7,000 $500 $55,000 $55,000 $0 $37,000 ($18,000) $15,000 $15,000 $0 $14,000 ($1,000) $15,000 $15,000 $0 ($20,000) $35,000
$395,000 $395,000 $0 $360,000 $35,000 $315,000 $315,000 $0 $315,000 $0 $24,500 $24,500 $0 $24,000 ($500) $160,000 $160,000 $0 $112,000 ($48,000) $48,000 $48,000 $0 $41,000 ($7,000) $45,000 $45,000 $0 ($70,000) $115,000
$1,165,000 $1,161,000 ($4,000) $1,075,000 $86,000 $895,000 $868,500 $26,500 $853,000 ($15,500) $85,500 $85,500 $0 $83,000 ($2,500) $540,000 $553,000 ($13,000) $386,000 ($167,000) $162,000 $166,000 ($4,000) $121,000 ($45,000) $127,500 $88,500 ($39,000) ($255,000) $343,500
$45,000 $43,000 ($2,000) $125,000 ($82,000) $100,000 $95,000 ($5,000) $80,000 $15,000 $45,000 $47,000 $2,000 $65,000 ($18,000) $250,000 $250,000 $0 $230,000 $20,000 $25,000
$45,000 $42,000 ($3,000) $110,000 ($68,000) $105,000 $100,000 ($5,000) $85,000 $15,000 $48,000 $48,000 $0 $63,000 ($15,000) $245,000 $245,000 $0 $230,000 $15,000 $28,000
$40,000 $41,000 $1,000 $95,000 ($54,000) $110,000 $105,000 ($5,000) $90,000 $15,000 $50,000 $49,000 ($1,000) $61,000 ($12,000) $240,000 $240,000 $0 $231,000 $9,000 $32,000
$40,000 $41,000 $1,000 $95,000 ($54,000) $110,000 $105,000 ($5,000) $90,000 $15,000 $50,000 $49,000 ($1,000) $61,000 ($12,000) $240,000 $240,000 $0 $231,000 $9,000 $32,000
$40,000 $38,000 ($2,000) $85,000 ($47,000) $115,000 $105,000 ($10,000) $90,000 $15,000 $55,000 $51,000 ($4,000) $60,000 ($9,000) $235,000 $235,000 $0 $234,000 $1,000 $34,000
$42,000 $40,000 ($2,000) $75,000 ($35,000) $120,000 $112,000 ($8,000) $100,000 $12,000 $55,000 $53,000 ($2,000) $58,000 ($5,000) $230,000 $230,000 $0 $235,000 ($5,000) $35,000
$45,000 $41,000 ($4,000) $65,000 ($24,000) $125,000 $118,000 ($7,000) $110,000 $8,000 $54,000 $54,000 $0 $55,000 ($1,000) $225,000 $225,000 $0 $235,000 ($10,000) $36,000
$45,000 $41,000 ($4,000) $65,000 ($24,000) $125,000 $118,000 ($7,000) $110,000 $8,000 $54,000 $54,000 $0 $55,000 ($1,000) $225,000 $225,000 $0 $235,000 ($10,000) $36,000
$48,000 $48,000 $0 $60,000 ($12,000) $125,000 $125,000 $0 $115,000 $10,000 $53,000 $53,000 $0 $48,000 $5,000 $300,000 $300,000 $0 $240,000 $60,000 $35,000
$52,000 $52,000 $0 $50,000 $2,000 $125,000 $125,000 $0 $105,000 $20,000 $52,000 $52,000 $0 $45,000 $7,000 $295,000 $295,000 $0 $240,000 $55,000 $34,000
$55,000 $55,000 $0 $40,000 $15,000 $120,000 $120,000 $0 $110,000 $10,000 $51,000 $51,000 $0 $45,000 $6,000 $290,000 $290,000 $0 $242,000 $48,000 $33,000
$55,000 $55,000 $0 $40,000 $15,000 $120,000 $120,000 $0 $110,000 $10,000 $51,000 $51,000 $0 $45,000 $6,000 $290,000 $290,000 $0 $242,000 $48,000 $33,000
$60,000 $60,000 $0 $35,000 $25,000 $115,000 $115,000 $0 $105,000 $10,000 $50,000 $50,000 $0 $47,000 $3,000 $285,000 $285,000 $0 $244,000 $41,000 $32,000
$65,000 $65,000 $0 $30,000 $35,000 $110,000 $110,000 $0 $95,000 $15,000 $50,000 $50,000 $0 $43,000 $7,000 $280,000 $280,000 $0 $245,000 $35,000 $31,000
$70,000 $70,000 $0 $25,000 $45,000 $100,000 $100,000 $0 $90,000 $10,000 $50,000 $50,000 $0 $42,000 $8,000 $275,000 $275,000 $0 $248,000 $27,000 $30,000
$70,000 $70,000 $0 $25,000 $45,000 $100,000 $100,000 $0 $90,000 $10,000 $50,000 $50,000 $0 $42,000 $8,000 $275,000 $275,000 $0 $248,000 $27,000 $30,000
$70,000 $70,000 $0 $25,000 $45,000 $100,000 $100,000 $0 $90,000 $10,000 $50,000 $50,000 $0 $42,000 $8,000 $275,000 $275,000 $0 $248,000 $27,000 $30,000
Rolling Budget and Forecast
Model Key
Numbers in black represent budget numbers or actuals for the current or prior year. Numbers in blue represent forecast numbers for the current year. Italicized numbers in gray cells are calculations that generally should not be altered.
Line Item
Actual Budget variance (Actual – Budget) Prior year Prior year variance (Actual – Prior year) Long-Term Debt Budget Actual Budget variance (Actual – Budget) Prior year Prior year variance (Actual – Prior year)
January
$26,000 $1,000 $18,000 $8,000 $125,000 $125,000 $0 $45,000 $80,000
February
$30,000 $2,000 $20,000 $10,000 $48,000 $48,000 $0 $45,000 $3,000
March
$34,000 $2,000 $24,000 $10,000 $50,000 $49,000 ($1,000) $45,000 $4,000
Q1
$34,000 $2,000 $24,000 $10,000 $50,000 $49,000 ($1,000) $45,000 $4,000
April
$35,000 $1,000 $25,000 $10,000 $55,000 $51,000 ($4,000) $65,000 ($14,000)
May
$35,500 $500 $26,000 $9,500 $55,000 $53,000 ($2,000) $65,000 ($12,000)
June
$36,500 $500 $26,000 $10,500 $54,000 $54,000 $0 $65,000 ($11,000)
Q2
$36,500 $500 $26,000 $10,500 $54,000 $54,000 $0 $65,000 ($11,000)
July
$35,000 $0 $27,000 $8,000 $53,000 $53,000 $0 $75,000 ($22,000)
August
$34,000 $0 $28,000 $6,000 $52,000 $52,000 $0 $75,000 ($23,000)
September
$33,000 $0 $27,000 $6,000 $51,000 $51,000 $0 $75,000 ($24,000)
Q3
$33,000 $0 $27,000 $6,000 $51,000 $51,000 $0 $75,000 ($24,000)
October
$32,000 $0 $28,000 $4,000 $50,000 $50,000 $0 $85,000 ($35,000)
November
$31,000 $0 $29,000 $2,000 $50,000 $50,000 $0 $85,000 ($35,000)
December
$30,000 $0 $28,000 $2,000 $50,000 $50,000 $0 $75,000 ($25,000)
Q4
$30,000 $0 $28,000 $2,000 $50,000 $50,000 $0 $75,000 ($25,000)
Annual
$30,000 $0 $28,000 $2,000 $50,000 $50,000 $0 $75,000 ($25,000)