Annual Budget Forecast Template

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 2

Revenue JANUARY FEBRUARY MARCH Q1 APRIL MAY JUNE Q2 S1 JULY AUGUST SEPTEMBER Q3 OCTOBER NOVEMBER DECEMBER Q4 S2 Year

1 2 3 4 5 6 7 8 9 10 11 12

Product 1 - -
Product 2 - -
Product 3 - -
Product 4 - -
Product 5 - -
Product 6 - -
Total Revenue - - - - - - - - - - - - - - - - - - -

EXPENSES
Expenses Operating
Accounting and Legal Fees - -
Advertising and promotion - -
Business Travel and Accommodation - -
Depreciation - -
Electricty Utilities … - -
Water Utilities - -
Gasoline/Fuel - -
Insurance - -
Interest and Bank Charges - -
Printing,postage,stationery,packaging - -
Registrations ,licenses and permits - -
Repairs,Maintenance and cleaning - -
Office Supplies - -
Furniture,equipment
Taxes - -
Telephone - -
Salaries and Wages - -
Other - -
Total Operating Expenditure - - - - - - - - - - - - - - - - - - -

- -
- -
- -
- -
- -
- -
- -
Operating Exp JANUARY FEBRUARY MARCH Q1 APRIL MAY JUNE Q2 S1 JULY AUGUST SEPTEMBER Q3 OCTOBER NOVEMBER DECEMBER Q4 S2 Year
1 2 3 4 5 6 7 8 9 10 11 12
Expenses Operating
Salaries - -
Supplies - -
Equipment - -
Lease Permits - -
Advertising - -
Other - -
Total Revunue - - - - - - - - - - - - - - - - - - -

Expenses Operating
Salaries and Wages - -
Office Supplies - -
Equipment - -
Lease Permits - -
Advertising - -
Property Taxes - -
Other - -
Total Operating Expense - - - - - - - - - - - - - - - - - - -
Salaries 20,000.00 20,000.00 20,000.00 60,000.00 22,000.00 22,000.00 27,000.00 71,000.00 131,000.00 22,000.00 22,000.00 22,000.00 66,000.00 22,000.00 22,000.00 22,000.00 66,000.00 132,000.00 263,000.00
Supplies 5,000.00 5,000.00 5,000.00 15,000.00 5,000.00 5,000.00 5,000.00 15,000.00 30,000.00 5,000.00 5,000.00 5,000.00 15,000.00 5,000.00 5,000.00 5,000.00 15,000.00 30,000.00 60,000.00
Equipment 9,500.00 9,500.00 9,500.00 28,500.00 11,000.00 11,000.00 11,000.00 33,000.00 61,500.00 11,000.00 11,000.00 11,000.00 33,000.00 11,000.00 11,000.00 11,000.00 33,000.00 66,000.00 127,500.00
Lease Pmts 17,000.00 17,000.00 17,000.00 51,000.00 17,000.00 17,000.00 17,000.00 51,000.00 102,000.00 17,000.00 17,000.00 17,000.00 51,000.00 17,000.00 17,000.00 17,000.00 51,000.00 102,000.00 204,000.00
Advertising 3,000.00 3,000.00 3,000.00 9,000.00 3,000.00 3,500.00 3,500.00 10,000.00 19,000.00 3,500.00 3,500.00 3,500.00 10,500.00 3,500.00 3,500.00 3,500.00 10,500.00 21,000.00 40,000.00
Other 1,500.00 1,500.00 1,500.00 4,500.00 2,000.00 2,400.00 2,200.00 6,600.00 11,100.00 2,200.00 2,675.00 2,800.00 7,675.00 3,200.00 3,600.00 4,100.00 10,900.00 18,575.00 29,675.00
Total Operating Expenditure

28,500.00 28,750.00 28,750.00 86,000.00 29,250.00 29,650.00 30,100.00 89,000.00 175,000.00 29,450.00 29,925.00 30,050.00 89,425.00 30,450.00 30,850.00 31,350.00 92,650.00 182,075.00 357,075.00
Salaries 7,700.00 7,700.00 7,700.00 23,100.00 7,700.00 7,700.00 8,350.00 23,750.00 46,850.00 7,700.00 7,700.00 7,700.00 23,100.00 7,700.00 7,700.00 7,700.00 23,100.00 46,200.00 93,050.00
Supplies 2,100.00 2,350.00 2,350.00 6,800.00 2,350.00 2,350.00 2,350.00 7,050.00 13,850.00 2,350.00 2,350.00 2,350.00 7,050.00 2,350.00 2,350.00 2,350.00 7,050.00 14,100.00 27,950.00
Equipment 6,500.00 6,500.00 6,500.00 19,500.00 6,500.00 6,500.00 6,500.00 19,500.00 39,000.00 6,500.00 6,500.00 6,500.00 19,500.00 6,500.00 6,500.00 6,500.00 19,500.00 39,000.00 78,000.00
Lease Pmts 8,500.00 8,500.00 8,500.00 25,500.00 8,500.00 8,500.00 8,500.00 25,500.00 51,000.00 8,500.00 8,500.00 8,500.00 25,500.00 8,500.00 8,500.00 8,500.00 25,500.00 51,000.00 102,000.00
Advertising 2,200.00 2,200.00 2,200.00 6,600.00 2,200.00 2,200.00 2,200.00 6,600.00 13,200.00 2,200.00 2,200.00 2,200.00 6,600.00 2,200.00 2,200.00 2,200.00 6,600.00 13,200.00 26,400.00
Other 1,500.00 1,500.00 1,500.00 4,500.00 2,000.00 2,400.00 2,200.00 6,600.00 11,100.00 2,200.00 2,675.00 2,800.00 7,675.00 3,200.00 3,600.00 4,100.00 10,900.00 18,575.00 29,675.00

74,450.00 74,450.00 74,450.00 223,350.00 76,500.00 76,900.00 80,700.00 234,100.00 457,450.00 77,625.00 80,200.00 80,325.00 238,150.00 80,800.00 81,200.00 81,700.00 243,700.00 481,850.00 939,300.00

158,950.00 159,200.00 159,200.00 477,350.00 165,750.00 167,450.00 176,500.00 509,700.00 987,050.00 167,775.00 171,300.00 171,675.00 510,750.00 172,950.00 174,150.00 175,650.00 522,750.00 1,033,500.00 2,020,550.00

You might also like