Financial analysis of Aluminium Bahrain (ALBA) Company Essay

Coursework Cover Sheet

All written assessed work other than timed scrutinies must be submitted with this cover sheet. When your work is marked, the marker will compose on the screen sheet the class awarded and any remarks or feedback on the work. The feedback will assist you to understand the facets of the work that were strong, and what action you could take to better your public presentation. It is an of import portion of the acquisition procedure.

Section 1: To be completed by the pupil

We will write a custom essay sample on
Financial analysis of Aluminium Bahrain (ALBA) Company Essay
or any similar topic only for you
Order now

Course title Corporate Finance

Coursework rubric

Submission deadline day of the month 24/12/2014

Word count of this coursework

Declaration:

  1. I confirm that the work is my ain, that I have non copied another’s work or allowed anyone to copy my work, and that I have referenced the work of others in an appropriate manner.
  1. I confirm that I have kept a transcript of my work.

Signature:Date:

Section 2: To be completed by the marker

Faculty signature

Date

Feedback

Table of Content

Subject

Page No.

Pro Forma

Income Statement ( POS Method )

2

St. of Financial Position ( Judgemental Approach )

3

Notes

4

Ratios

Profitability ratios

6

Liquidity ratios

6

Activity ratios

6

Debt Ratios

6

Forecasted Cash Flow

8

Appendix

9

Undertakings

A )

Aluminum Bahrain ( ALBA ) Company

Pro forma Statement of comprehensive income for the twelvemonth stoping 31 December 2014 ( POS Method )

Description

2014 $ ( 000 ‘s )

2013 $ ( 000 ‘s )

Gross saless

899205.6

749338

Cog

-762517

-640751

Gross Net income

136688.6

108587

Other Income

8764.8

7304

Selling & A ; Distribution Expenses

-21088.8

-17574

Administration Expenses

-36730.8

-30609

Addition on Forex interlingual rendition

232.1

211

Directors ‘ fees

-209

-190

Finance costs

-6987.6

-5823

Net income for the twelvemonth before derivitives

80669.3

61906

Addition on revaluation/settlement of derivitive

19658.1

17871

Entire Comperhensive Income of the twelvemonth

100327.4

79777

Aluminum Bahrain ( ALBA ) Company

Pro forma Statement of Financial Position as at 31 December 2014 ( Judgemental Approach )

Description

2014 $ ( 000 ‘s )

2013 $ ( 000 ‘s )

Assets

Non-current assets

Property, works and equipment ( Note 1 )

1283566

868318

Long term receivable

7564.7

6877

Entire Non-current Assetss

1291130.7

875195

Current assets

Inventories

173916

144930

Current part of long term receivable

3781.8

3438

Histories receivable and prepayment ( Note 2 )

101210.2

85375

Other assets

5280

4800

Derivative fiscal instruments

Bank balances and hard currency

74221

64540

Entire Current Assets

358409

303083

Entire Assetss

1649539.7

1178278

EQUITY AND LIABILITIES

Equity

Share capital

142000

142000

Treasury portions

-5672.7

-5157

Statutory modesty

71000

71000

Capital modesty

249

249

Retained net incomes ( Note 3 )

667135.9

629381

Proposed dividend

34075.8

30978

Entire equity

908788

868451

Non-current liabilities

Borrowings

92842.2

84402

Derivative fiscal instruments

5844.3

5313

Employees’ terminal of service benefits

1023

930

Entire Non-Current Liabilitiess

99709.5

90645

Current liabilities

Borrowings

128075.2

116432

Histories collectible and accumulations ( Note 4 )

113216.6

97960

Derivative fiscal instruments

5269

4790

Entire Current Liabilitiess

246560.8

219182

Entire liabilities

346270.3

309827

External funding required

394481.4

Entire EQUITY AND LIABILITIES

1255058.3

1178278

Analysis of the Pro forma Percentage of Gross saless Method and Judgemental Approach

After fixing the pro forma statement of both, statement of comprehensive income ( per centum of gross revenues method ) and the statement of fiscal place ( Judgemental attack ) for the twelvemonth stoping 31 December 2014, we came up with the decision that Alba Company has higher assets than both liabilities and equity hence, Alba should take into consideration that they need external funding of BD 320260.4 ( 000’s ) in order to cover up for their assets.

Notes

  1. Non-Current Asset Calculations

Calculations

BD ( 000 ‘s )

Addition in PPE value

Cost of Property, Plant & A ; Equipment

1933643 ten 130 %

2513735.9

580092.9

Depreciation

87013.9 + 1065325 + 77831

1230169

( 580092.9 x 15 % ) 87013.9

Net Book Value

1283566

493079

  1. Account Receivables and Prepayments Calculations

Calculations

BD ( 000 ‘s )

Trade histories receivable

( 72977/749338 ) x 899205.6

87572.4

Other receivables

9820 ten 110 %

10802

Prepayments

2578 ten 110 %

2835.8

Entire A/Receivables and Prepayments

101210.2

  1. Retained Net incomes Calculations

Calculations

BD ( 000 ‘s )

Balance as at 31/12/2013

629381

Net income for twelvemonth

93943.2

Interim dividends 2014

19729 ten 110 %

-21701.9

Final dividend 2014

30978 ten 110 %

-34075.8

Excess of concluding dividends 2012

14

loss on resale of exchequer

386 ten 110 %

-424.6

Entire Retained Net incomes

667135.9

  1. Account Payables and Accruals Calculations

Calculations

BD ( 000 ‘s )

Trade payables

( 54606/749338 ) x 899205.6

65527.2

Retentions collectible

94 ten 110 %

103.4

Employee related accumulations

30582 ten 110 %

33640.2

Accrued disbursals

9709 ten 110 %

10679.9

Progresss from clients

1667 ten 110 %

1833.7

Alba Savings Benefit Scheme

501 ten 110 %

551.1

Social Insurance Organisation

801 ten 110 %

881.1

Entire A/ Payables and Accumulations

113216.6

B )

2014

2013

Profitability Ratios

Gross Profit Margin

15.20 %

14.49 %

Net income before Derivitives

8.97 %

8.26 %

Comp. Income for the twelvemonth

11.16 %

10.65 %

Liquidity Ratios

Current Ratio

1.45

1.38

Quick Ratio

0.75

0.72

Working Capital Ratios ( Days )

Inventory Employee turnover

-2.39

-2.02

Average Collection period

35.55

35.55

Average Payment period

29.98

31.04

Debt Ratios

Debt Ratio

20.99 %

26.29 %

Timess involvement earned ratio

-10.54

-11.63

We have calculated certain accounting ratios that we found of import to a company like Alba. We have calculated the profitableness, liquidness, activity and debt ratios of the company. We will analyze and compare ratios of 2013 twelvemonth terminal and the projected twelvemonth terminal of 2014 ( pro forma in Task A ) . Overall, Alba’s public presentation when it comes to comparing ratios is rather extraordinary except in certain countries in which they need to concentrate more on.

When it comes to Profitability ratios, we can see that there is a minor addition in all the ratios which is a good thing. Although 2014 profitableness ratios have increased than the old twelvemonth, Alba needs to cut down their cost of gross revenues and other disbursals in order to increase their net incomes.

On a positive note, Alba has improved their liquidness position. The company’s current ratio increased by 0.07 and their acerb trial ratio increased by 0.03. Although it is a minor alteration, the company is making good when it comes to how fast they liquidate their assets over liabilities. However, even though Alba has improved in their liquidness ratios, the company’s acerb trial ratio is lesser than 1 which means that they to a great extent rely on their stock lists. For a company like Alba, yes the speedy ratio will be low because they produce aluminum and their stock list is of import to them.

Similarly, when it comes to comparing their activity ratios, Alba is in a little downhill. The stock list turnover of the company increased by 0.37 times which means that the company is traveling off their stock lists slower and they need to cut down it. The lower the value stock list turnover, the better the position of the company will be. Nevertheless, there is no alteration in the aggregation period of Alba. The company pays of their trade receivables every 35.55 yearss in both old ages. Whereas, the payment period of the company has decreased which means that Alba have to pay their trade payables 1.06 yearss less in 2014.

Last, the company is traveling through a debt state of affairs between the 2 old ages. The debt ratio of Alba decreased significantly by 5.3 % and this is a bad mark for the company because the lower the sum of other’s people money is being used to bring forth net incomes which means that Alba are bring forthing net incomes from their ain money.

D )

Forecasted Cash FlowIR = 12 %

0 12345

165882 196175.808 228424.3006 262734.0188 291216.9785337991.0189

X0.893

175184.996X0.797×0.712×0.636×0.567

182054.167

187066.616

190301.998

191640.907

1092130.687

For this inquiry, we have used the individual sedimentation discounting tabular array In order to happen out the present values of each hard currency flow through old ages 1 to 5. The ground behind utilizing this table alternatively of the rente factor tabular array is because the hard currency flows are assorted watercourse. In add-on, we added the basal twelvemonth hard currency flow to the discounted PV’s because we do non dismiss the hard currency flow of twelvemonth 0.

1

×

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out