URGENT PLEASE

Michelle_Michy
docx.docx

Analysis of ABC Company 1

ACC 206 Final Paper Analysis of ABC Company You’ve just been hired onto ABC Company as the corporate controller. ABC Company is a manufacturing firm that specializes in making cedar roofing and siding shingles. The company currently has annual sales of around $1.2 million, a 25% increase from the previous year. The company has an aggressive growth target of reaching $3 million annual sales within the next 3 years. The CEO has been trying to find additional products that can leverage the current ABC employee skillset as well as the manufacturing facilities.  As the controller of ABC Company, the CEO has come to you with a new opportunity that he’s been working on. The CEO would like to use the some of the shingle scrap materials to build cedar dollhouses. While this new product line would add additional raw materials and be more time-intensive to manufacture than the cedar shingles, this new product line will be able to leverage ABC’s existing manufacturing facilities as well as the current staff. Although this product line will require added expenses, it will provide additional revenue and gross profit to help reach the growth targets. The CEO is relying on you to help decide how this project can be afforded Provide details about the estimated product costs, what is needed to break even on the project, and what level of return this product is expected to provide. In order to help out the CEO, you need to prepare a six- to eight-page report that will contain the following information (including exhibits, but excluding your references and title page). Refer to the accompanying Excel spreadsheet (available through your online course) for some specific cost and profit information to complete the calculations.

Analysis of ABC Company

Course Name:

Course Code:

Student Registration Number:

Supervisor’s Name:

Introduction

ABC Company is a manufacturing company that concentrates in building cedar roofing and siding shingles. The current annual sales of the company are around $1.2 million, a 25% rise from the last year. The company has a violent growth target of achieving $3 million annual sales in next 3 years. The Chief Executive Officer of the company is keen to search additional goods that can influence the present employee skillset of ABC as well as the production facilities. The Chief Executive Officer is working on a new opportunity. The Chief Executive Officer is planning to use some of the shingle scrap materials to construct cedar dollhouses. This new product line would increase additional raw materials and will take lesser time to produce in comparison to cedar shingles. Although this product line will need extra expenses, it will generate extra revenue and gross profit and will assist in achieving the growth targets.

Risk Profile

Risk can be called as the ambiguity involved in a given thing or event. Risk is observed in every part of life. Two types of the risks are faced by business enterprise as well namely, Systematic Risk and Unsystematic Risk. The Systematic Risk is in-built to the whole market known as un-diversifiable risk or market risk. It cannot be diminished by using diversification instruments and influences all the business enterprises. Unsystematic Risk can be called as the risk related to a given business and it can be certainly diminished. Another name for unsystematic risk is diversifiable risk. Therefore, it can be said that identification of the risk involved is very necessary and diminish it by implementing variety of instruments. Examples of systematic risk are economic conditions, governmental law, policies, natural calamities etc. Examples of unsystematic risk are strike, governmental regulation for a particular type of manufacturer, poor relation with suppliers etc.

Systematic Risk can be controlled by the management of this company as well; instead they should pay some attention in managing the unsystematic risk. The possible unsystematic risk faced by the company includes expected price of product, manufacturing of new goods, whether there will be enough demand for new goods, choosing of supplier for extra requirement of raw material, whether current facilities will be able to manage the new production, method of financing i.e. debt or equity.

ABC COMPANY

Cash Flow Statement

For the year ended 31st Dec, 19x2

Cash from Operating Activities:

Cash Received from customers (Note - 1) $1,260,000

Cash Paid to Suppliers and Employees (Note - 2) $1,080,000

Cash Generated From Operations $180,000

Less: Income Tax Paid -

Cash Flow before Extra-ordinary Items $180,000

Cash Flow from Investing Activities:

Purchases of Equipment $(100,000)

Cash Flow from Financing Activities:

Dividend Declared $(100,000)

Net Increase/Decrease in Cash and Cash Equivalents: $(20,000)

Cash and Cash Equivalents As at beginning of the year $70,000

Cash and Cash Equivalents As at End of the year $50,000

Note - 1: Calculation of cash received

Total sales $1200000

Less: Opening Balance of Debtors $180000

Add: Closing Balance of Debtors $120000

$1260000

Note – 2: Calculation of cash Paid to Suppliers

Cost Of goods sold $800000

Less: Opening Stock $280000

Add: Closing Stock $350000

Total Purchase $870000

Add: Opening Balance of Creditors $210000

Less: Closing Balance of Creditors $250000

Total Cash Paid $830000

Add: Selling and Distribution Expenses $250000

$1080000

Sources & Uses of Funds

Sources:

1. Operating: Cash received from debtors

2. Investing: None

3. Financing: None

Uses:

1. Operating: Payment to suppliers

2. Investing: Purchase of equipment

3. Financing: Payment of dividend

Steps for improvement of cash flows

Implementation of following techniques will assist in improving the cash inflows from debtors:

1. Providing discount on early payments.

2. Regular reminders for payment.

3. Discount on immediate cash payments.

4. Automated system for accepting payment like credit card, debit card.

5. Implementation of debt factoring.

6. Evaluating credit worthiness of the client before granting debt.

Similarly, to improve the cash outflows, the company shall try to avail the benefits offered by the creditor or the lending institutions.

Financing Options

Any new investment or project or expansion of existing project can be made by two ways namely, by taking money from lenders or owners. These are known as debt financing and equity financing.

Advantages of Debt Financing:

1. Control over ownership

2. Interest paid is tax deductible

3. Flexibility

4. Less complicated in terms of paper work

Disadvantages of Debt Financing:

1. Principal borrowed is to be repaid and creates an obligation on borrower.

2. Excessive debt increases the riskiness and affects the reputation of the company.

Advantages of Equity Financing:

1. Money taken is not required to be repaid.

2. No obligation of regular interest payments.

Disadvantages of Debt Financing:

1. Ownership is lost.

2. Requires complex paper work at the time of issuance.

Statement Showing Product Cost for the Expansion Product

Particulars

Calculation

Amount

Units produced and expected to be sold

5000 units

Machine Hours

5000 Hours

Direct Material

5.60 x 5000

28,000

Direct Labor

4.00 x 5000

20,000

Factory Overhead

Variable

1.00 x 5000

5,000

Fixed

-

Selling Expenses

Variable

0.20 x 5000

1,000

Fixed

-

Total Cost

54,000

Statement Showing Total Cost of Existing Product, Expansion Product and overall cost of Products

Particulars

Existing

Expansion

Total

Units produced and expected to be sold

80,000 units

5,000 units

85,000 units

Machine Hours

40,000 units

5,000 Hours

45,000 Hours

Direct Material

104,000

28,000

Direct Labor

224000

20,000

Variable Factory Overhead

40000

5,000

Variable Selling Expenses

16000

1,000

Fixed Factory Overhead

198000

198000

Fixed Selling Expenses

191250

191250

Total Cost

773250

54000

54,000

Cost per unit

9.67

10.80

9.73

The cost of existing product has increased due to the expansion by $0.06 per unit.

Calculation of Selling Price for the new Expansion Product

Particulars

Calculation

Amount

Total Cost

54000

Profit Margin on sales

40% on sales

54000 x 40

60

36000

Total Sales

90000

Selling Price

90,000 / 5,000

18 per unit

Sales Mix:

Existing: 80,000 units

Expansion: 5,000 units

Statement Showing Contribution margin and Break Even Points

Particulars

Existing

Expansion

Sales

1,160,000

90000

Variable Cost

384,000

54000

Contribution

776000

36000

P/V Ratio

66.70%

40%

Total Sales

1250000

Total Contribution

812000

Total P/V Ratio

64.96%

Fixed Cost

389250

Total Profit

422750

Break Even Sales = Fixed Cost

P/V Ratio

= 389250

64.96%

= 599,215

Sales Mix Ratio 80:5 or 16: 1

Break Even Sale : Existing = 563,967

Expansion = 35,248

a)

Year

Cash Flows

PVF @ 12%

Product

0

Outflow

$ 42000

1

(42,000)

1

Inflows

$15000

0.8929

13,394

2

$13000

0.7972

10,364

3

$10,000

0.7118

7,118

4

$10,000

0.6355

6,355

5

$6,000

0.5674

3,404

Net Present Value

(1,366)

Net Present Value of the proposed investment = $(1,366)

b) Depreciation = 42000/ 5 = $8,400

Year

1

2

3

4

5

Savings in Fixed Overhead

15000

13000

10000

10000

6000

Less: Depreciation

8400

8400

8400

8400

8400

Savings Before Tax

6600

4600

1600

1600

(2400)

Less: Tax

-

-

-

-

Savings After Tax

6600

4600

1600

1600

(2400)

Add: Depreciation

8400

8400

8400

8400

8400

Cash Flows

15000

13000

10000

10000

6000

The straight line method of depreciation will lead to increase in the fixed cost. There will be no effect on the cash flows because non-cash item like depreciation is not taken into account while calculating cash flows.

c) The equipment shall not be purchased because the net present value from equipment is negative.

Conclusion

The new project does not seem to be going well with the company as there is increase in the per unit cost of existing product, its manufacturing is quite time taking, demand for the product cannot be estimated with certainty. All these lead to doubt regarding the achievement of target profits and cash flows. The net present value of $1,366 is generated from the new equipment.

Preparation of detailed budget with fixed and variable cost is the responsibility of Controller and Management Accountant. He is liable for maintaining up to date cost records and ensuring effective cost controls. He is responsible for ensuring that production is carried out with the rules, regulation, laws laid down by the government. An effective production process required continuous monitoring, and any imperfections shall be modified.

The Chief Executive Officer shall work strategically by proper planning, evaluation of market conditions, analyzing the resources available, detailing the resources needed. The market for the product shall be stimulated by implementing promotional instruments. Extensive marketing will lead to increase in the demand for the goods. Healthy relationships with stakeholders like customers, suppliers, lending institutions, regulatory authorities shall be maintained. In production process, the cost can be decreased by reducing the waste, increasing the efficiency and adequate training and motivation of employees.

References

Carl S. Warren, (2009), Survey of Accounting, Fifth Edition

Jan R. Williams, Susan F. Haka, Mark S. Bettner, (2005), Financial and Managerial Accounting: The Basis for Business Decisions, 13e

Ronald W. Hilton, Michael W. Maher, Frank H. Selto, (2006), Cost Management: Strategies for Business Decisions, 3e

Richard A. Brealey, Stewart C. Myers, Alan J. Marcus, (2003), Fundamentals of Corporate Finance, 4e

Stephen A. Ross, Randolph W. Westerfield, Bradford D. Jordan, (2008), Fundamentals of Corporate Finance: Standard Edition, Eighth Edition

Analysis of ABC Company

1

A

C

C

2

0

6

F

i

n

a

l

P

a

p

e

r

Analysis of ABC Company

You’ve just been hired onto ABC Company as the

corporate controller. ABC Company is a manufacturing firm that specializes in making cedar roofing and siding

shingles. The company currently has annual sales of around $1.2 million, a 25% increase from the pr

evious year. The

company has an aggressive growth target of reaching $3 million annual sales within the next 3 years. The CEO has

been trying to find additional products that can leverage the current ABC employee skillset as well as the

manufacturing facil

ities.

As the controller of ABC Company, the CEO has come to you with a new opportunity that he’s been working on. The

CEO would like to use the some of the shingle scrap materials to build cedar dollhouses. While this new product line

would add addition

al raw materials and be more time

-

intensive to manufacture than the cedar shingles, this new

product line will be able to leverage ABC’s existing manufacturing facilities as well as the current staff. Although this

product line will require added expenses,

it will provide additional revenue and gross profit to help reach the growth

targets. The CEO is relying on you to help decide how this project can be afforded Provide details about the

estimated product costs, what is needed to break even on the project,

and what level of return this product is

expected to provide

.

In order to help out the CEO, you need to prepare a six

-

to eight

-

page report that will contain the following information

(including exhibits, but excluding your references and title page). Re

fer to the accompanying Excel spreadsheet

(available through your online course) for some specific cost and profit information to complete the calculations

.

Analysis of ABC Company