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
Course title Corporate Finance |
|
Coursework rubric |
|
Submission deadline day of the month 24/12/2014 |
|
Word count of this coursework |
|
Declaration:
- 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.
- I confirm that I have kept a transcript of my work.
Signature:Date:
Section 2: To be completed by the marker
Faculty signature |
Date |
|
|
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
- 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 |
- 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 |
- 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 |
- 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