You are in charge of a young and growing company.You have identified the various factors (sources of revenue and expenses) that influence the company business as shown below.

All the figures are in thousands of Kenya Shillings except the percentages.

ANNUAL INCOME AND EXPENSES PROJECTION

Revenue

Sales

Starts at 10,000 and grows by 8%

Expenses

Raw materials

15% of sales

Transport

7% of sales

Electricity

2.1% of sales + 10

Rent

Starts at 120 then grows by 2%

Salaries

Starts at 1,000 then grows by 10%

Commissions (Sales)

1.8% of sales

Loan repayment

170

Advertising and promotion

2.5% of sales

Depreciation

Fixed at 20

Miscellaneous

Starts at 10 and grows by a fixed amount of 10

Total (Expenses)

Profit

1.Use the information provided in the table above to produce a financial projection model for the company for the next six years.

2.Make a line graph of sales, total expenses and profit for the six-year period.

3.Find the average expenses, sales and profit for the six-year period.

Print the worksheet and the graph