Loading...

Messages

Proposals

Stuck in your homework and missing deadline?

Get Urgent Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework Writing

100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Report on Financial and Managerial Accounting of the commonwealth bank of Australia

Category: Finance Paper Type: Report Writing Reference: APA Words: 2100

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 (Discount2%)

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.

Our Top Online Essay Writers.

Discuss your homework for free! Start chat

Top Rated Expert

ONLINE

Top Rated Expert

1869 Orders Completed

ECFX Market

ONLINE

Ecfx Market

63 Orders Completed

Assignments Hut

ONLINE

Assignments Hut

1428 Orders Completed