Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cohomological Aspects In Complex Non-Kähler Geometry

Authors: Daniele Angella

1st Edition

3319024418, 9783319024417

More Books

Students also viewed these Mathematics questions

Question

What are dividends? What types of dividends might a company pay?

Answered: 1 week ago