Question no 1:

Prepare the following statements:

Sheet 1

Sales
	Year 1	Year 2	Year 3	Year 4	Year 5
Units sold
Sales Price
Sales

Sheet 2

Budgeted Income Statement
	Year 1	Year 2	Year 3	Year 4	Year 5
Sales
Cost of Sales
Gross Profit
Selling and Admin Profits
Expenses 1
Expenses 2
Expenses 3
Expenses 4
Expenses 5
Expenses 6
Total Selling and Admin
Net Profit

Sheet 3

Sales
	Year 1	Year 2	Year 3	Year 4	Year 5
Units Sold
Sales Price
Sales

Sheet 4

Budgeted Income Statement
	Year 1	Year 2	Year 3	Year 4	Year 5
Sales
Cost of Sales
Gross Profit
Selling and Admin Profits
Expenses 1
Expenses 2
Expenses 3
Expenses 4
Expenses 5
Expenses 6
Total Selling and Admin
Net Profit

3. All figures should be rounded off to three decimal places.

4. Ensure the use of proper formulas and formatting.