THE ABC CORPORATION BUDGET - JANUARY 2012 - DECEMBER 2014
Jan 2012 $ Feb 2012 $ Mar 2012 April 2012 May 2012 Jun 2012 $ $ $ $
Income Credit Sales 10,000 15,000 20,000 25,000 30,000 35,000 Cash Sales 12,500 15,000 17,500 20,000 22,500 25,000 T. Income 22,500 30,000 37,500 45,000 52,500 60,000 Expenditure Purchases 5,000 7,500 10,000 12,500 15,000 17,500 Wages 9,000 9,000 9,000 9,000 9,000 9,000 Depreciation 700 700 700 700 700 700 Other Overheads 16,200 16,000 17,000 18,000 19,000 20,000 T. Expenditure 30,900 33,200 36,700 40,200 43,700 47,200 Profit/(Losss) (8,400) (3,200) 800 4,800 8,800 12,800 Profit/(Losss) B/F 0 (8,400) (11,600) (10,800) (6,000) 2,800 Profit/(Losss) C/F $ (8,400) (11,600) (10,800) (6,000) 2,800 15,600 Notes 1 Purchases assumed to be 75% on Credit, 25% cash. 2 Owner/Manager $4,000 (50% forgone), plus 2 assistants at $2,500 each per month. Tax at 20%, superannuation at 5%. 3 Assumed to be 50% on Credit, 50% cash. Includes $1,200 for nsurance covering the first 6 months. Paid Jan. 4 After 1st month formula is =B15, =C15 etc. 5 Turnng profitable in May, bodes well for the future.
1 2 3
4 5
THE ABC CORPORATION CASH FLOW FORECAST - JANUARY 2012 - DECEMBER 2014
Jan 2012 $ Income Credit Sales Cash Sales T. Income 500 12,500 13,000 Feb 2012 $ 5,750 15,000 20,750 Mar 2012 April 2012 May 2012 Jun 2012 $ $ $ $ 11,500 17,500 29,000 16,250 20,000 36,250 28,000 22,500 50,500 35,000 6 25,000 60,000
Operating Expenditure Purchases 1,250 5,625 8,125 10,625 13,125 15,625 Wages 5,250 5,250 5,250 5,250 5,250 5,250 Overheads 9,100 15,900 16,300 17,300 18,300 19,300 T. Op. Expenditure 15,600 26,775 29,675 33,175 36,675 40,175 Fixed Assets Shop Fittings 10,000 0 0 0 0 0 Delivery Van 25,000 0 0 0 0 0 Tot. Fixed Assets 35,000 0 0 0 0 0 Taxes Etc Tax deducted 0 1,400 1,400 1,400 1,400 1,400 Superannuation 0 350 350 350 350 350 Tot. Taxes Etc 0 1,750 1,750 1,750 1,750 1,750 Tot. Expenditure 50,600 28,525 31,425 34,925 38,425 41,925 Surplus/(Deficit) (37,600) (7,775) (2,425) 1,325 12,075 18,075 Balance B/F 10,000 (27,600) (35,375) (37,800) (36,475) (24,400) Balance C/F $ (27,600) (35,375) (37,800) (36,475) (24,400) (6,325) Notes 6 June 2012 formula, based on the Budget spreadsheet is: =ROUND(($C6*0.05)+($D6*0.5)+($E6*0.3)+($F6*0.5)+($G6*0.05),0) 7 Purchases assumed to be 75% on Credit, 25% cash. 8 Owner/Manager $4,000 (50% forgone), plus 2 assistants at $2,500 each per month. Tax at 20%, superannuation at 5%. 9 Overheads assumed to be 50% on Credit, 50% cash. Includes $1,200 for Insurance covering the first 6 months. Paid Jan. 10 After 1st month formula is =B49, =C49 etc. 11 The Owner/Manager will have to borrow an extra $37,800 to survive, but the reducing balance from March bodes well for the future.
7 8 9
10 11
doc_484433124.xls
Jan 2012 $ Feb 2012 $ Mar 2012 April 2012 May 2012 Jun 2012 $ $ $ $
Income Credit Sales 10,000 15,000 20,000 25,000 30,000 35,000 Cash Sales 12,500 15,000 17,500 20,000 22,500 25,000 T. Income 22,500 30,000 37,500 45,000 52,500 60,000 Expenditure Purchases 5,000 7,500 10,000 12,500 15,000 17,500 Wages 9,000 9,000 9,000 9,000 9,000 9,000 Depreciation 700 700 700 700 700 700 Other Overheads 16,200 16,000 17,000 18,000 19,000 20,000 T. Expenditure 30,900 33,200 36,700 40,200 43,700 47,200 Profit/(Losss) (8,400) (3,200) 800 4,800 8,800 12,800 Profit/(Losss) B/F 0 (8,400) (11,600) (10,800) (6,000) 2,800 Profit/(Losss) C/F $ (8,400) (11,600) (10,800) (6,000) 2,800 15,600 Notes 1 Purchases assumed to be 75% on Credit, 25% cash. 2 Owner/Manager $4,000 (50% forgone), plus 2 assistants at $2,500 each per month. Tax at 20%, superannuation at 5%. 3 Assumed to be 50% on Credit, 50% cash. Includes $1,200 for nsurance covering the first 6 months. Paid Jan. 4 After 1st month formula is =B15, =C15 etc. 5 Turnng profitable in May, bodes well for the future.
1 2 3
4 5
THE ABC CORPORATION CASH FLOW FORECAST - JANUARY 2012 - DECEMBER 2014
Jan 2012 $ Income Credit Sales Cash Sales T. Income 500 12,500 13,000 Feb 2012 $ 5,750 15,000 20,750 Mar 2012 April 2012 May 2012 Jun 2012 $ $ $ $ 11,500 17,500 29,000 16,250 20,000 36,250 28,000 22,500 50,500 35,000 6 25,000 60,000
Operating Expenditure Purchases 1,250 5,625 8,125 10,625 13,125 15,625 Wages 5,250 5,250 5,250 5,250 5,250 5,250 Overheads 9,100 15,900 16,300 17,300 18,300 19,300 T. Op. Expenditure 15,600 26,775 29,675 33,175 36,675 40,175 Fixed Assets Shop Fittings 10,000 0 0 0 0 0 Delivery Van 25,000 0 0 0 0 0 Tot. Fixed Assets 35,000 0 0 0 0 0 Taxes Etc Tax deducted 0 1,400 1,400 1,400 1,400 1,400 Superannuation 0 350 350 350 350 350 Tot. Taxes Etc 0 1,750 1,750 1,750 1,750 1,750 Tot. Expenditure 50,600 28,525 31,425 34,925 38,425 41,925 Surplus/(Deficit) (37,600) (7,775) (2,425) 1,325 12,075 18,075 Balance B/F 10,000 (27,600) (35,375) (37,800) (36,475) (24,400) Balance C/F $ (27,600) (35,375) (37,800) (36,475) (24,400) (6,325) Notes 6 June 2012 formula, based on the Budget spreadsheet is: =ROUND(($C6*0.05)+($D6*0.5)+($E6*0.3)+($F6*0.5)+($G6*0.05),0) 7 Purchases assumed to be 75% on Credit, 25% cash. 8 Owner/Manager $4,000 (50% forgone), plus 2 assistants at $2,500 each per month. Tax at 20%, superannuation at 5%. 9 Overheads assumed to be 50% on Credit, 50% cash. Includes $1,200 for Insurance covering the first 6 months. Paid Jan. 10 After 1st month formula is =B49, =C49 etc. 11 The Owner/Manager will have to borrow an extra $37,800 to survive, but the reducing balance from March bodes well for the future.
7 8 9
10 11
doc_484433124.xls