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.
4. Print the worksheet and the graph