Budget

Budgeting template excel and brief analysis.

Sheet

1

S

A

MPLE INC.

B

udgeted Income Statement
For the Years Ended December

3

1, xxx

2

Budget Actual xxx2 xxx1

Net sales

10,

4

5

6

,000

Cost of goods sold

4,1

8

2,400

Gross profit

6,2

7

3,600

Research and Development Expenses

378,

9

65

General and Administrative Expenses 875,632 Marketing Expenses 155,678 Total operating expenses 1,410,275 Income from operations 4,863,325 Income tax expense 1,361,731 Net income 3,501,594 Expectations: Sales are expected to increase 4.5% next year Cost of good sold will continue to remain at the same level as last year Research and Development Expenses are expected to increase by 20% General and Administrative Expenses are expected to decrease by 12% Marketing Expenses are expected to increase at the same rate as sales Income taxes are expected to remain at the same rate as last year Analysis:

Sheet2

Sheet3

1
2
3
4
5
6
7
8
9
A
B

SAMPLE INC.

Budgeted Income Statement

For the Years Ended December 31, xxx2

Net sales
Cost of goods sold