Plan versus Actual Variance Report—Financial Services
Data cell key
Data input cells Formula cells: Totals are calculated and filled in automatically.
Line item
INCOME STATEMENT Interest income Plan Actual Variance $ (Actual - Plan) Variance % Interest expense Plan Actual Variance $ (Plan – Actual) Variance % Bad debt/credit losses Plan Actual Variance $ (Plan – Actual) Variance % Noninterest income Plan Actual Variance $ (Actual – Plan) Variance % Noninterest expense Plan Actual Variance $ (Plan – Actual) Variance % Net income Plan Actual Variance $ (Actual –- Plan) Variance %
January
February
March
Q1
April
May
June
Q2
July
August
September
Q3
October
November
December
Q4
Annual
Variance analysis notes
$65,000 $60,000 ($5,000) -7.69% $50,000 $45,000 $5,000 10.00% $8,000 $10,000 ($2,000) -25.00% $35,000 $40,000 $5,000 14.29% $10,000 $9,000 $1,000 10.00% $15,000 $16,500 $1,500 10.00%
$75,000 $70,000 ($5,000) -6.67% $55,000 $55,000 $0 0.00% $3,000 $4,000 ($1,000) -33.33% $40,000 $41,000 $1,000 2.50% $10,000 $10,000 $0 0.00% $15,000 $18,000 $3,000 20.00%
$85,000 $88,000 $3,000 3.53% $65,000 $63,000 $2,000 3.08% $4,000 $3,000 $1,000 25.00% $40,000 $42,000 $2,000 5.00% $11,000 $12,000 ($1,000) -9.09% $15,000 $15,000 $0 0.00%
$225,000 $218,000 ($7,000) -3.11% $170,000 $163,000 $7,000 4.12% $15,000 $17,000 ($2,000) -13.33% $115,000 $123,000 $8,000 6.96% $31,000 $31,000 $0 0.00% $45,000 $49,500 $4,500 10.00%
$75,000 $95,000 $20,000 26.67% $55,000 $45,000 $10,000 18.18% $6,000 $5,000 $1,000 16.67% $40,000 $42,000 $2,000 5.00% $11,000 $15,000 ($4,000) -36.36% $15,000 $13,500 ($1,500) -10.00%
$80,000 $65,000 ($15,000) -18.75% $60,000 $55,000 $5,000 8.33% $7,000 $6,500 $500 7.14% $40,000 $43,000 $3,000 7.50% $12,000 $13,000 ($1,000) -8.33% $15,000 $17,000 $2,000 13.33%
$90,000 $88,000 ($2,000) -2.22% $70,000 $63,000 $7,000 10.00% $8,000 $7,500 $500 6.25% $45,000 $45,000 $0 0.00% $15,000 $14,000 $1,000 6.67% $15,000 $16,000 $1,000 6.67%
$245,000 $248,000 $3,000 1.22% $185,000 $163,000 $22,000 11.89% $21,000 $19,000 $2,000 9.52% $125,000 $130,000 $5,000 4.00% $38,000 $42,000 ($4,000) -10.53% $45,000 $46,500 $1,500 3.33%
$90,000 $95,000 $5,000 5.56% $50,000 $45,000 $5,000 10.00% $7,500 $8,000 ($500) -6.67% $45,000 $45,000 $0 0.00% $14,000 $13,500 $500 3.57% $15,000 $12,000 ($3,000) -20.00%
$100,000 $110,000 $10,000 10.00% $55,000 $55,000 $0 0.00% $8,500 $8,000 $500 5.88% $45,000 $47,000 $2,000 4.44% $15,000 $14,500 $500 3.33% $15,000 $16,000 $1,000 6.67%
$105,000 $100,000 ($5,000) -4.76% $65,000 $63,000 $2,000 3.08% $9,000 $8,500 $500 5.56% $50,000 $49,000 ($1,000) -2.00% $16,000 $15,500 $500 3.13% $15,000 $18,000 $3,000 20.00%
$295,000 $305,000 $10,000 3.39% $170,000 $163,000 $7,000 4.12% $25,000 $24,500 $500 2.00% $140,000 $141,000 $1,000 0.71% $45,000 $43,500 $1,500 3.33% $45,000 $46,000 $1,000 2.22%
$120,000 $115,000 ($5,000) -4.17% $50,000 $45,000 $5,000 10.00% $8,000 $9,000 ($1,000) -12.50% $50,000 $50,000 $0 0.00% $15,000 $14,000 $1,000 6.67% $2,000 $21,000 $19,000 950.00%
$130,000 $120,000 ($10,000) -7.69% $55,000 $55,000 $0 0.00% $10,000 $9,000 $1,000 10.00% $55,000 $55,000 $0 0.00% $18,000 $22,000 ($4,000) -22.22% $20,000 $25,000 $5,000 25.00%
$145,000 $165,000 $20,000 13.79% $65,000 $63,000 $2,000 3.08% $6,500 $4,500 $2,000 30.77% $55,000 $57,000 $2,000 3.64% $15,000 $15,500 ($500) -3.33% $20,000 $24,000 $4,000 20.00%
$395,000 $400,000 $5,000 1.27% $170,000 $163,000 $7,000 4.12% $24,500 $22,500 $2,000 8.16% $160,000 $162,000 $2,000 1.25% $48,000 $51,500 ($3,500) -7.29% $42,000 $70,000 $28,000 66.67%
$1,160,000 $1,171,000 $11,000 0.95% $695,000 $652,000 $43,000 6.19% $85,500 $83,000 $2,500 2.92% $540,000 $556,000 $16,000 2.96% $162,000 $168,000 ($6,000) -3.70% $177,000 $212,000 $35,000 19.77%
Line item
BALANCE SHEET Cash and cash equivalents Plan Actual Variance $ (Actual –- Plan) Variance % Investment securities Plan Actual Variance $ (Actual –- Plan) Variance % Loans Plan Actual Variance $ (Actual – Plan) Variance % Accounts payable Plan Actual Variance $ (Actual – Plan) Variance % Deposits Plan Actual Variance $ (Actual – Plan) Variance %
January
February
March
Q1
April
May
June
Q2
July
August
September
Q3
October
November
December
Q4
Annual
Variance analysis notes
$45,000 $43,000 ($2,000) -4.44% $100,000 $95,000 ($5,000) -5.00% $325,000 $338,000 $13,000 4.00% $25,000 $26,000 $1,000 4.00% $125,000 $125,000 $0 0.00%
$45,000 $42,000 ($3,000) -6.67% $105,000 $100,000 ($5,000) -4.76% $330,000 $340,000 $10,000 3.03% $28,000 $30,000 $2,000 7.14% $48,000 $48,000 $0 0.00%
$40,000 $41,000 $1,000 2.50% $110,000 $105,000 ($5,000) -4.55% $335,000 $342,000 $7,000 2.09% $32,000 $34,000 $2,000 6.25% $50,000 $49,000 ($1,000) -2.00%
$43,333 $42,000 ($1,333) -3.08% $105,000 $100,000 ($5,000) -4.76% $330,000 $340,000 $10,000 3.03% $28,333 $30,000 $1,667 5.88% $74,333 $74,000 ($333) -0.45%
$40,000 $38,000 ($2,000) -5.00% $115,000 $105,000 ($10,000) -8.70% $325,000 $338,000 $13,000 4.00% $34,000 $35,000 $1,000 2.94% $55,000 $51,000 ($4,000) -7.27%
$42,000 $40,000 ($2,000) -4.76% $120,000 $112,000 ($8,000) -6.67% $330,000 $340,000 $10,000 3.03% $35,000 $35,500 $500 1.43% $55,000 $53,000 ($2,000) -3.64%
$45,000 $41,000 ($4,000) -8.89% $125,000 $118,000 ($7,000) -5.60% $335,000 $342,000 $7,000 2.09% $36,000 $36,500 $500 1.39% $54,000 $54,000 $0 0.00%
$42,333 $39,667 ($2,667) -6.30% $120,000 $111,667 ($8,333) -6.94% $330,000 $340,000 $10,000 3.03% $35,000 $35,667 $667 1.90% $54,667 $52,667 ($2,000) -3.66%
$48,000 $45,000 ($3,000) -6.25% $125,000 $122,000 ($3,000) -2.40% $325,000 $338,000 $13,000 4.00% $35,000 $35,000 $0 0.00% $53,000 $55,000 $2,000 3.77%
$52,000 $48,000 ($4,000) -7.69% $125,000 $125,000 $0 0.00% $330,000 $340,000 $10,000 3.03% $34,000 $34,000 $0 0.00% $52,000 $54,000 $2,000 3.85%
$55,000 $53,000 ($2,000) -3.64% $120,000 $121,000 $1,000 0.83% $335,000 $342,000 $7,000 2.09% $33,000 $32,500 ($500) -1.52% $51,000 $53,000 $2,000 3.92%
$51,667 $48,667 ($3,000) -5.81% $123,333 $122,667 ($667) -0.54% $330,000 $340,000 $10,000 3.03% $34,000 $33,833 ($167) -0.49% $52,000 $54,000 $2,000 3.85%
$60,000 $58,000 ($2,000) -3.33% $115,000 $116,000 $1,000 0.87% $325,000 $338,000 $13,000 4.00% $32,000 $31,000 ($1,000) -3.13% $50,000 $51,000 $1,000 2.00%
$65,000 $66,000 $1,000 1.54% $110,000 $108,000 ($2,000) -1.82% $330,000 $340,000 $10,000 3.03% $31,000 $30,000 ($1,000) -3.23% $50,000 $50,000 $0 0.00%
$70,000 $72,000 $2,000 2.86% $100,000 $102,000 $2,000 2.00% $335,000 $342,000 $7,000 2.09% $30,000 $29,500 ($500) -1.67% $50,000 $49,500 ($500) -1.00%
$65,000 $65,333 $333 0.51% $108,333 $108,667 $333 0.31% $330,000 $340,000 $10,000 3.03% $31,000 $30,167 ($833) -2.69% $50,000 $50,167 $167 0.33%
$70,000 $72,000 $2,000 2.86% $100,000 $102,000 $2,000 2.00% $335,000 $342,000 $7,000 2.09% $30,000 $29,500 ($500) -1.67% $50,000 $49,500 ($500) -1.00%