Question
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started