Task 1
Business
Description of the commonwealth bank of Australia
The finances of the
commonwealth bank of Australia are analyzed to determine the financial
performance of the organization. The financial ratio analysis has been
performed to identify the profitability, liquidity, financial leverage, and
efficiency of the corporation. The ratios not only help in financial decision
making but also provide a quick overview of the whole organization’s financial
position (Chandra, 2011).
Financial
Statements of the commonwealth bank of Australia
The financial statements
of the organization are provided in the excel sheet.
Ratio
Calculations of the commonwealth bank of Australia
Profitability
Profitability
|
2015-06
|
2016-06
|
2017-06
|
2018-06
|
2019-06
|
TTM
|
Tax Rate %
|
27.97
|
28.06
|
28.63
|
30
|
28.83
|
28.74
|
Net Margin %
|
38.87
|
38.63
|
40.34
|
37.59
|
37.02
|
43.19
|
Asset Turnover (Average)
|
0.03
|
0.03
|
0.03
|
0.03
|
0.02
|
0.02
|
Return on Assets %
|
1.09
|
1.02
|
1.04
|
0.96
|
0.88
|
1.03
|
Financial Leverage (Average)
|
16.65
|
15.5
|
15.46
|
14.49
|
14.03
|
14.03
|
Return on Equity %
|
17.9
|
16.38
|
16.09
|
14.3
|
12.52
|
14.57
|
Return on Invested Capital %
|
|
|
|
|
|
|
Liquidity
Liquidity/Financial Health
|
2015-06
|
2016-06
|
2017-06
|
2018-06
|
2019-06
|
Latest Qtr
|
Current Ratio
|
0.38
|
0.22
|
0.34
|
0.19
|
0.24
|
|
Quick Ratio
|
-0.81
|
-0.68
|
-0.82
|
-0.71
|
-1.00
|
|
Financial Leverage
|
16.65
|
15.5
|
15.46
|
14.49
|
14.03
|
14.03
|
Debt/Equity
|
0.24
|
0.26
|
0.3
|
0.34
|
0.32
|
0.32
|
Efficiency
Key Ratios -> Efficiency
Ratios
|
|
|
|
|
|
|
Efficiency
|
2015-06
|
2016-06
|
2017-06
|
2018-06
|
2019-06
|
TTM
|
Fixed Assets Turnover
|
8.26
|
7.05
|
6.3
|
7.7
|
9.34
|
6.16
|
Asset Turnover
|
0.03
|
0.03
|
0.03
|
0.03
|
0.02
|
0.02
|
Financial
Leverage
Key Ratios -> Financial
Health
|
|
|
|
|
|
|
Balance Sheet Items (in %)
|
2015-06
|
2016-06
|
2017-06
|
2018-06
|
2019-06
|
Latest Qtr
|
Cash & Short-Term Investments
|
5.55
|
2.66
|
4.81
|
2.37
|
4.44
|
4.44
|
Accounts Receivable
|
1.32
|
1.24
|
1.03
|
0.95
|
|
|
Inventory
|
|
|
|
|
|
|
Other Current Assets
|
-6.87
|
-3.91
|
-5.84
|
-3.32
|
-4.44
|
-4.44
|
Total Current Assets
|
|
|
|
|
|
|
Net PP&E
|
0.32
|
0.42
|
0.4
|
0.26
|
0.24
|
0.24
|
Intangibles
|
1.14
|
1.11
|
1.03
|
0.93
|
0.82
|
0.82
|
Other Long-Term Assets
|
-1.47
|
-1.54
|
-1.42
|
-1.19
|
-1.06
|
-1.06
|
Total Assets
|
100
|
100
|
100
|
100
|
100
|
100
|
Accounts Payable
|
|
|
|
|
|
|
Short-Term Debt
|
17.91
|
17.45
|
17.22
|
17.76
|
18.83
|
18.83
|
Taxes Payable
|
|
|
|
|
|
|
Accrued Liabilities
|
|
|
|
|
|
|
Other Short-Term Liabilities
|
-17.91
|
-17.45
|
-17.22
|
-17.76
|
-18.83
|
-18.83
|
Total Current Liabilities
|
|
|
|
|
|
|
Long-Term Debt
|
1.47
|
1.67
|
1.92
|
2.36
|
2.3
|
2.3
|
Other Long-Term Liabilities
|
-1.47
|
-1.67
|
-1.92
|
-2.36
|
-2.3
|
-2.3
|
Total Liabilities
|
93.99
|
93.54
|
93.53
|
93.09
|
92.87
|
92.87
|
Total Stockholders' Equity
|
6.01
|
6.46
|
6.47
|
6.91
|
7.13
|
7.13
|
Total Liabilities & Equity
|
100
|
100
|
100
|
100
|
100
|
100
|
Business
Financial performance of the commonwealth bank of Australia
If the financial
performance of the organization is analyzed then it can be said the corporation
needs to improve its financial performance. The liquidity ratios of the
organization indicate that the organization does not have enough cash to pay
its short term obligations. The organization’s ROA and ROE ratios are showing
that corporate profitability is low and a significant amount of effort will
have to be taken to improve the financial performance of the organization (Fridson & Alvarez, 2011).
Business
Financial Potential of the commonwealth bank of Australia
The business's current
financial performance indicates that the organization needs to improve its
financial performance. If the organization wants to sustain in the long run
than the business will have to take initiatives for improving the profitability
of the business. By increasing its efficiency the organization can improve its
profitability up to a lot of extents (Mohana, 2011).
Business
Future Funding of the commonwealth bank of Australia
In the future, it can be
said that the business will need to borrow more funds if the organization wants
to expand its business into different parts of the world. The organization can
finance its assets from both debt and equity. It is recommended to the
organization to maintain the optimum capital structure (Pandey, 2015).
Business
Legal Obligations of the commonwealth bank of Australia
The business is working
according to the legal standards set by the authorities. The organization is
following the legal requirements of the industry in which it is operating.
Conclusion
of the commonwealth bank of Australia
It is concluded that if
the financial performance of the organization is analyzed then it can be said
the corporation needs to improve its financial performance. The liquidity
ratios of the organization indicate that the organization does not have enough
cash to pay its short term obligations. The organization’s ROA and ROE ratios
are showing that corporate profitability is low and a significant amount of
efforts will have to be taken to improve the financial performance of the
organization.
Task 2
Cost of Production Budget
For the ending 30th September 2017
|
|
July
|
August
|
September
|
Total
|
Dinner
Table
|
|
$
|
$
|
$
|
$
|
Raw
Material
|
Ash
|
39,000
|
40,500
|
51,000
|
130,500
|
Pine-2
pack
|
2,340
|
2,430
|
3,060
|
7,830
|
Direct
Labor cost
|
18,720
|
21,330
|
25,160
|
65,210
|
Manufacturing
Overhead
|
827.5
|
955
|
910.5
|
2,693
|
Total
|
60,887.5
|
65,215
|
80,130.5
|
206,233
|
|
|
|
|
|
|
Buffet
|
|
|
|
|
|
Raw
Material
|
Redwood
|
62,400
|
63,360
|
69,120
|
194,880
|
Pine-2 pack
|
7,800
|
7,920
|
8,640
|
24,360
|
Direct
Labor cost
|
77,350
|
79,860
|
94,320
|
251,530
|
Manufacturing
Overhead
|
827.50
|
955
|
910.5
|
2,693
|
Total
|
148,377.5
|
152,095
|
172,990.5
|
473,463
|
GRAND
TOTAL
|
209.265
|
217,310
|
252,121
|
679,696
|
The production cost at
the ending of September 2017 was $679,696. The costs contain raw material cost,
direct labor cost, and overhead costs that are incurred in the manufacturing of
dining tables and buffets (Warren, et al., 2016).
The raw material cost is
evaluated on the basis of the following data:
Cost of Goods Sold (COGS) Budget
Cost of Goods Sold Budget
For the ending 30th
September 2017
|
Dining Table ($)
|
Buffet ($)
|
Total ($)
|
Opening the inventory of finished goods
|
30,000
|
72,000
|
102,000
|
+
opening raw material inventory
|
1,020
|
1,560
|
2,580
|
+
Production cost
|
206,233
|
473,463
|
679,696
|
-Closing inventory of finished goods
|
59,160
|
112,224
|
171,384-
|
-Closing raw material inventory
|
1,980
|
2,580
|
4,560
|
CoGS
|
176,113
|
432,219
|
608,332
|
The closing and opening
inventory of finished goods are evaluated using the following data:
Opening July inventory of
finished goods:
Closing Sept inventory of
finished goods:
The closing and opening
inventory of raw material are evaluated using the following data:
Opening July raw
materials inventory:
Expected closing
September raw materials inventory:
Task 3
The selling price is
determined based on a mark-up of 40% over the Cost of Goods Sold.
|
Dining Table
|
Buffet
|
CoGS ($)
|
176,113
|
432,219
|
Sales forecast 1st quarter
(units)
|
75
|
370
|
Cost/unit ($)
|
2,348
|
1,168
|
Selling price/unit after 40% markup ($)
|
3,287
|
1,635
|
Sales budget
From July to September 2017
|
July
|
August
|
September
|
Total
|
Dining Table
|
|
|
|
|
Sale forecast
|
20
|
30
|
25
|
75
|
Unit
Selling Price ($)
|
3,287
|
3,287
|
3,287
|
|
Budgeted
Sales ($)
|
65,740
|
98,610
|
82,175
|
246,525
|
Cash Budget
From July to September 2017
($)
|
July
|
August
|
September
|
Total
|
Beginning cash
|
121,000
|
|
|
|
Budgeted Sales
|
229,240
|
343,860
|
278,375
|
851,475
|
Sources
of cash
|
|
|
|
|
Cash Sale
|
183,392
|
275,088
|
222,700
|
681,180
|
Credit Sale from last month (Discount-2%)
|
15,000
(14,700)
|
34,386
(33,698)
|
51,579
(50,547)
|
98,945
|
Credit sale from 2 months prior
|
1,050
|
5,000
|
11,462
|
17,512
|
Total cash
|
199,142
|
313,786
|
284,709
|
797,637
|
Cash Budget is prepared
on the basis of the following policies:
Task:
4
MASTER BUDGET
|
|
|
|
|
|
|
Quarter 1
|
Quarter 2
|
Quarter 3
|
Quarter 4
|
Total
|
Budgeted Sales
|
851,475
|
936,623
|
953,652
|
987,711
|
3,729,461
|
Raw material costs
|
357,570
|
386,176
|
410,070
|
450,436
|
1,611,252
|
Direct Labour costs
|
316,740
|
316,740
|
316,740
|
316,740
|
1,266,960
|
Factory overheads
|
5,386
|
6,463
|
7,756
|
9,307
|
28,912
|
Discounts
|
2,153
|
2,153
|
2,153
|
2,153
|
8,612
|
INCOME STATEMENT
|
|
|
|
|
|
|
Quarter 1
|
Quarter 2
|
Quarter 3
|
Quarter 4
|
Total
|
Sales
|
851,475
|
936,623
|
953,652
|
987,711
|
3,729,461
|
-CoGS
|
608,332
|
669,165
|
681,332
|
705,665
|
2,664,494
|
Gross profit
|
243,143
|
267,458
|
272,320
|
282,046
|
1,064,967
|
|
|
|
|
|
|
-Expenses
|
|
|
|
|
|
Fixed
|
17,130
|
17,130
|
17,130
|
17,130
|
68,520
|
Variable
|
6,641
|
6,972
|
7,320
|
7,686
|
28,619
|
Discounts
|
2,153
|
2,153
|
2,153
|
2,153
|
8,612
|
Total Expenses
|
25,924
|
26,255
|
26,603
|
26,969
|
105,751
|
|
|
|
|
|
|
Net profit
|
217,219
|
241,203
|
245,717
|
255,077
|
959,216
|
|
|
|
|
|
|
Budget Objectives
Companies use budgets to
develop plans for future business operations and manufacturing of products. The
following are the objectives for budgets:
1) To
develop a plan for future production of a product.
2) To
better manage the financial performance of the company
3) To
expand companies' operations in the future.
4) To
measure the performance outcomes of the company.
Budget Components of the
commonwealth bank of Australia
Budgets are consist of several
components including revenue, direct and indirect cost, expenditure, and net
profit of the business operation or project for which budget is developed. Moreover,
components of a master budget include Direct labor budget, Direct materials
budget, Ending finished goods budget, MOH, production budget (containing
information about to be produced products), sales budget, and income statement (Fridson & Alvarez, 2011).
Assumptions used in
various budgets of the commonwealth bank of Australia
Key assumptions used in
the budgets are stated below under the relevant budget name.
v Cash
Budget of the commonwealth bank of Australia
ü The
budgeted sales of the company are $10,000 and $2100 for June and May respectively.
ü The
cash sales were a total of 80% of overall sales.
ü Remaining
20% sales are representing the following
·
15% received next month
o
5% received the second month after sales
at 2% discount
v Production
Budget of the commonwealth bank of Australia
1) 50%
of manufacturing overhead cost for the buffet
2) 50%
of manufacturing overhead cost for the dining table.
v Operating
Expenses Budget of the commonwealth bank of Australia
1) Variable
cost is increased by 20% for the month of August
2) Variable
cost is increased by 25% for the month of September
v The
Master Operating Budget for the whole financial year – July 2017 to June 2018
1) In
each quarter sales are increased.
2) Raw
material cost is increased by 8%
3) No
changes are made in the direct labor cost and discount levels.
4) MOH
will have increase by 20%
v Income
Statement
1) The
cost of goods sold is increased in quarters 2, 3, and 4 by the percentage of 10%,
12%, and 16% respectively (Warren, et al., 2016).
2) No
changes are made in discounts and fixed expenses
3) The
variable cost is increased by 5%.
Communicating the budget
to the company
Communicating the budget
to the company can give several benefits in monetary and non-monetary terms. The
company can communicate about its budget in the following ways:
1) Organizing
weekly meetings for discussion about future plans and current organizational
performance
2) Prompt
discussion of recent data with financial details
3) Setting
rules and regulations for each department based on new budgets
4) Setting
SMART goals for each department
Key Milestones and
Performance Indicators
Some common milestones
and performance indicators can be used by the company. For instance, Breakeven
sales, Gross profit margin, Debtors turnover, Debt/ Equity, Return on
Investment, Current ratio, Interest coverage, and inventory turnover in a specific
time duration. By using these performance indicators and milestones companies
can measure their profitability, liquidity condition, and efficiency in
resource utilization (Mulford & Comiskey, 2011).
Conclusion of the
commonwealth bank of Australia
The whole discussion
concludes that the company develop its budget for future business operations
and to measure performance outcomes. Several components of budgets include
revenue, expense, and cost. Budgets are usually developed on some assumptions
concerning with increases and decreases of values. Budgets should be
communicated within the organization at meetings.
References
of the commonwealth bank of Australia
Chandra, P., 2011. Financial Management. s.l. Tata
McGraw-Hill Education.
Fridson,
M. S. & Alvarez, F., 2011. Financial Statement Analysis: A
Practitioner's Guide. s.l.: John Wiley & Sons.
Mohana,
R. P., 2011. Financial Statement Analysis and Reporting. s.l.: PHI
Learning Pvt. Ltd.
Mulford,
C. W. & Comiskey, E. E., 2011. The Financial Numbers Game: Detecting
Creative Accounting Practices. s.l.: John Wiley & Sons.
Pandey,
I., 2015. Financial Management. s.l. Vikas Publishing House.
Warren,
C., Reeve, J. M. & Duchac, J., 2016. Financial & Managerial
Accounting. s.l. Cengage Learning.