URGENT PLEASE
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