Total Cash from Financing and Net Change in Cash
VerifiedAdded on  2019/12/03
|24
|5045
|246
Report
AI Summary
The provided content is an income statement for a company, showing fiscal data as of March 17, 2012. The revenue and gross profit are $22,294 and $1,211, respectively. Operating expenses include cost of revenue, selling, general and administrative expenses, depreciation/amortization, and other operating expenses. The net income before taxes is $799, with a provision for income taxes of $201, resulting in a net income after taxes of $598. Minority interest and extraordinary items are also reported. Finally, normalized income and EPS are presented.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
Table of Contents
Introduction......................................................................................................................................4
Part 1................................................................................................................................................4
1.1: Calculation of Ratios............................................................................................................4
1.2: Ratio Analysis.......................................................................................................................7
1.3: Summarized Report..............................................................................................................9
Part 2: Investment Appraisal for PLC plc......................................................................................10
2.1: Project Appraisal...............................................................................................................10
2.2: Payback Period Method......................................................................................................14
2.3: Advantages and disadvantages of the investment appraisal methods................................15
2.4: Summarized Report............................................................................................................16
CONCLUSION..............................................................................................................................17
Reference.......................................................................................................................................18
Appendix........................................................................................................................................19
Introduction......................................................................................................................................4
Part 1................................................................................................................................................4
1.1: Calculation of Ratios............................................................................................................4
1.2: Ratio Analysis.......................................................................................................................7
1.3: Summarized Report..............................................................................................................9
Part 2: Investment Appraisal for PLC plc......................................................................................10
2.1: Project Appraisal...............................................................................................................10
2.2: Payback Period Method......................................................................................................14
2.3: Advantages and disadvantages of the investment appraisal methods................................15
2.4: Summarized Report............................................................................................................16
CONCLUSION..............................................................................................................................17
Reference.......................................................................................................................................18
Appendix........................................................................................................................................19
List of Tables
Table 1: Ratio Analysis of Sainsbury..............................................................................................7
Table 2 : Summarized Report..........................................................................................................9
Table 3 : Cash Flow for Two Projects...........................................................................................10
Table 4 : NPV at 10%....................................................................................................................11
Table 5 : NPV of Project 1............................................................................................................12
Table 6 : NPV of Project 2............................................................................................................12
Table 7 : Payback Period of Project 1...........................................................................................14
Table 8 : Payback Period of Project 2...........................................................................................14
Table 1: Ratio Analysis of Sainsbury..............................................................................................7
Table 2 : Summarized Report..........................................................................................................9
Table 3 : Cash Flow for Two Projects...........................................................................................10
Table 4 : NPV at 10%....................................................................................................................11
Table 5 : NPV of Project 1............................................................................................................12
Table 6 : NPV of Project 2............................................................................................................12
Table 7 : Payback Period of Project 1...........................................................................................14
Table 8 : Payback Period of Project 2...........................................................................................14
Introduction
Financial analysis of a company indicates its position in the market. This can be done in 2
ways either through fundamental analysis or through technical analysis. Both these analysis
depicts companies’ financial information with a difference that former does in tabular form and
latter in chart forms. In modern world, analysts prefer to do technical analysis of the company.
Fundamental tool consists of various analysis of the company like that of ratio analysis, balance
sheet, income statement etc. It also helps in determining the suitability for investment of
company (Arnold, 2005).
Part 1
1.1: Calculation of Ratios
Sainsbury’s plc shares are traded on London Stock Exchange (LSE) and it is a part of FTSE-100
Index.
Ratio analysis – is the systematic use of available accounting information required to evaluate
the financial statements of the company. It also reveals the financial and operating performance
of the firm. Ratio analysis includes judgment for a valuable evaluation of the financial
statements. Sainsbury’s performance ratios include liquidity ratio, profitability margin, and
efficiency / turnover ratio (Atrill, and McLaney, 2008).
Liquidity Ratio –computes the current status of the firm whether it can pay its current liabilities
in short term or not. This ratio depicts financial solvency of a firm in short term. Every business
firm is aware that it should not suffer from lack of liquidity. If a firm is not capable to meet its
short term obligation that means it has a bad credit image. On the other hand, firm with high
liquidity is also not attractive as it implies that firm has funds, cash in hand which are not used to
earn anything. So, it is essential to balance between liquidity and lack of the same. Liquidity
ratio can be further classified as –
 Current Ratio –is the connection between current assets and liabilities. It computes the
short term solvency of a company and can be calculated by dividing current assets with
current liabilities.
Current Ratio = Current Asset / Current Liabilities
In this, current assets includes bank balance and cash in hand, debtors and inventory,
marketable securities excluding provision for doubtful debtors and bad debts, prepaid
expenses and bills receivables. Current liabilities entail bills payable, sundry creditors,
Financial analysis of a company indicates its position in the market. This can be done in 2
ways either through fundamental analysis or through technical analysis. Both these analysis
depicts companies’ financial information with a difference that former does in tabular form and
latter in chart forms. In modern world, analysts prefer to do technical analysis of the company.
Fundamental tool consists of various analysis of the company like that of ratio analysis, balance
sheet, income statement etc. It also helps in determining the suitability for investment of
company (Arnold, 2005).
Part 1
1.1: Calculation of Ratios
Sainsbury’s plc shares are traded on London Stock Exchange (LSE) and it is a part of FTSE-100
Index.
Ratio analysis – is the systematic use of available accounting information required to evaluate
the financial statements of the company. It also reveals the financial and operating performance
of the firm. Ratio analysis includes judgment for a valuable evaluation of the financial
statements. Sainsbury’s performance ratios include liquidity ratio, profitability margin, and
efficiency / turnover ratio (Atrill, and McLaney, 2008).
Liquidity Ratio –computes the current status of the firm whether it can pay its current liabilities
in short term or not. This ratio depicts financial solvency of a firm in short term. Every business
firm is aware that it should not suffer from lack of liquidity. If a firm is not capable to meet its
short term obligation that means it has a bad credit image. On the other hand, firm with high
liquidity is also not attractive as it implies that firm has funds, cash in hand which are not used to
earn anything. So, it is essential to balance between liquidity and lack of the same. Liquidity
ratio can be further classified as –
 Current Ratio –is the connection between current assets and liabilities. It computes the
short term solvency of a company and can be calculated by dividing current assets with
current liabilities.
Current Ratio = Current Asset / Current Liabilities
In this, current assets includes bank balance and cash in hand, debtors and inventory,
marketable securities excluding provision for doubtful debtors and bad debts, prepaid
expenses and bills receivables. Current liabilities entail bills payable, sundry creditors,
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
income – tax liability, short term loans and dividends payable and accrued expenses
(Atrill, 2009). Acid Test Ratio –is used to calculate the liquidity of the firm and is a corresponding ratio
to the current ratio.
Acid Test Ratio = Quick Assets / Current liabilities
In the above formula, quick assets are known as those assets which are immediately
converted in cash form without loss of its value. They include bank balance, cash in hand,
bill’s receivables, sundry debtors and marketable securities.
 Cash Ratio – it calculates relationship between super quick current assets and liabilities.
In this, ratio assets are described as bank balance, cash in hand and quick marketable
securities. It is calculated by dividing absolute liquid assets from current liabilities.
Cash Ratio = Absolute Liquid Assets / Current Liabilities
Efficiency / Turnover Ratio – by the use of this ratio a firm manage its current assets. There are
following ratios which help in judging efficiency of assets (Bennouna, Meredith, and Marchant,
2010).
 Inventory Turnover Ratio – inventory is the most important part of any business firm.
This ratio indicates that how many times a firm has converted its inventory into sales.
Inventory turnover ratio = Cost of goods sold / Average Inventory
Where average inventory = opening balance + closing balance / 2
But in some circumstances opening balance of the inventory is not given, and then the
closing balance is treated as average inventory.
 Creditor Turnover Ratio – it means how many times in a year firm is paying money to its
sundry creditors. It judges the requirements of paying cash to its sundry creditors.
Creditor Turnover Ratio = Net Credit Purchase / Average Trade Creditor
Where net credit purchase = gross credit purchase – purchase return
But when information about opening and closing balance, credit purchases of trade
creditors is not given then the ratio is calculated as:
Creditor Turnover Ratio = Total Purchase / Total Trade Creditors
 Debtor Turnover Ratio – this indicates that how much times debtors had paid or they are
converted into cash in a period. It is calculated as follows:
Debtor Turnover Ratio = Net Credit Sales / Average Trade Debtors
(Atrill, 2009). Acid Test Ratio –is used to calculate the liquidity of the firm and is a corresponding ratio
to the current ratio.
Acid Test Ratio = Quick Assets / Current liabilities
In the above formula, quick assets are known as those assets which are immediately
converted in cash form without loss of its value. They include bank balance, cash in hand,
bill’s receivables, sundry debtors and marketable securities.
 Cash Ratio – it calculates relationship between super quick current assets and liabilities.
In this, ratio assets are described as bank balance, cash in hand and quick marketable
securities. It is calculated by dividing absolute liquid assets from current liabilities.
Cash Ratio = Absolute Liquid Assets / Current Liabilities
Efficiency / Turnover Ratio – by the use of this ratio a firm manage its current assets. There are
following ratios which help in judging efficiency of assets (Bennouna, Meredith, and Marchant,
2010).
 Inventory Turnover Ratio – inventory is the most important part of any business firm.
This ratio indicates that how many times a firm has converted its inventory into sales.
Inventory turnover ratio = Cost of goods sold / Average Inventory
Where average inventory = opening balance + closing balance / 2
But in some circumstances opening balance of the inventory is not given, and then the
closing balance is treated as average inventory.
 Creditor Turnover Ratio – it means how many times in a year firm is paying money to its
sundry creditors. It judges the requirements of paying cash to its sundry creditors.
Creditor Turnover Ratio = Net Credit Purchase / Average Trade Creditor
Where net credit purchase = gross credit purchase – purchase return
But when information about opening and closing balance, credit purchases of trade
creditors is not given then the ratio is calculated as:
Creditor Turnover Ratio = Total Purchase / Total Trade Creditors
 Debtor Turnover Ratio – this indicates that how much times debtors had paid or they are
converted into cash in a period. It is calculated as follows:
Debtor Turnover Ratio = Net Credit Sales / Average Trade Debtors
Where net credit sales = gross credit sale – sales return
&
Average trade debtors = opening + closing balance / 2
But when information of trade debtors is not available then it is calculated by following
method:
Debtor Turnover Ratio = Total Sales / Trade Debtors
 Assets Turnover Ratio –shows the relationship between assets and sales. It is computed
by following formula:
Assets Turnover Ratio = Cost of goods sold / Average Total Assets
Profitability Raito – it measures the firms’ profitability. In the context of profitability, it
measures the operating efficiency of a firm and its ability to ensure adequate return in terms of
profits. Profitability ratio includes gross profit margin and net profit margin (Collier, 2012).
ï‚· Gross Profit Margin - it measures the relationship between gross profit and sales. It is
calculated by following formula:
Gross Profit Margin = (Gross profit / Net sales) * 100
It is the difference between sales and cost of goods sold.
ï‚· Net Profit Margin - it is a relationship between net profits and sales of a firm. Further, it
depicts the efficiency of firm’s management in administrating, manufacturing and selling
the products. It is calculated by the following formula:
Net Profit Margin = (Earnings after Tax / Net Sales) * 100
Performance Ratio – It provides relationship between returns of the firm and its total
investments. It is further divided in major four parts which are as follows (Dauber, 2012).
ï‚· Return on Assets - it provides a relationship between net profits and net assets. To
calculate this ratio net profits and assets can be determined in various ways.
Return on Assets = (Net Profit after Tax / Average total assets) * 100
 Return on Capital Employed – it provides relationship between capital employed and net
profit of the firm. Capital employed means funds are supplied by the owners and lenders.
Further it can be calculated as follows:
Return on Capital Employed = (Net Profit after Tax / Total capital Employed) * 100
&
Average trade debtors = opening + closing balance / 2
But when information of trade debtors is not available then it is calculated by following
method:
Debtor Turnover Ratio = Total Sales / Trade Debtors
 Assets Turnover Ratio –shows the relationship between assets and sales. It is computed
by following formula:
Assets Turnover Ratio = Cost of goods sold / Average Total Assets
Profitability Raito – it measures the firms’ profitability. In the context of profitability, it
measures the operating efficiency of a firm and its ability to ensure adequate return in terms of
profits. Profitability ratio includes gross profit margin and net profit margin (Collier, 2012).
ï‚· Gross Profit Margin - it measures the relationship between gross profit and sales. It is
calculated by following formula:
Gross Profit Margin = (Gross profit / Net sales) * 100
It is the difference between sales and cost of goods sold.
ï‚· Net Profit Margin - it is a relationship between net profits and sales of a firm. Further, it
depicts the efficiency of firm’s management in administrating, manufacturing and selling
the products. It is calculated by the following formula:
Net Profit Margin = (Earnings after Tax / Net Sales) * 100
Performance Ratio – It provides relationship between returns of the firm and its total
investments. It is further divided in major four parts which are as follows (Dauber, 2012).
ï‚· Return on Assets - it provides a relationship between net profits and net assets. To
calculate this ratio net profits and assets can be determined in various ways.
Return on Assets = (Net Profit after Tax / Average total assets) * 100
 Return on Capital Employed – it provides relationship between capital employed and net
profit of the firm. Capital employed means funds are supplied by the owners and lenders.
Further it can be calculated as follows:
Return on Capital Employed = (Net Profit after Tax / Total capital Employed) * 100
 Return on Equity – it renders relationship between return to the sources of funds or
relationship between net profits and equity shareholders funds of the firm. It is calculated
as following:
Return on Equity = Net Profit after Tax / Total Shareholder's Equity
 Earnings per Share – it measures the profit available for the shareholders on per share. It
is calculated as follows:
Earnings per Share = Net Profit Available to Equity Holders / Number of shares
Sainsbury’s ratios for three years are shown in the table below:
Table 1: Ratio Analysis of Sainsbury
Ratios of Sainsbury 2012 2011 2010
Liquidity Ratio
Current Ratio 0.6282 0.5849 0.6634
Acid Test Ratio 0.3193 0.2878 0.3967
Cash Ratio 0.3037 0.2658 0.3612
Efficiency / Turnover Ratio
Inventory Turnover Ratio 2.27 2.19 2.86
Credit Turnover Ratio 0.5612 0.5114 0.4736
Debtor Turnover Ratio 0.3909 0.3692 0.3361
Assets Turnover Ratio 0.1729 0.1482 0.1853
Profitability Raito
Gross Profit Margin 5.45% 5.03% 5.23%
Net Profit Margin 2.71% 2.36% 2.62%
Performance Ratio
Return on Assets 5.02% 7.20% 6.75%
Return on Capital Employed 8.68% 9.77% 9.09%
Return on Equity 11.05% 7.25% 6.75%
Earnings per Share 3.21% 3.41% 3.22%
1.2: Ratio Analysis
From the above table of company’s financial position can be depicted.
The standard current ratio is 2:1 which means company have a good liquidity position;
Sainsbury’s current ratio is maintained from last three years. There is no huge change in the
current ratio of the company; in the present company’s current ratio is 0.6282 which means
company has less liquidity in comparison with its current assets. Company should increase its
liquidity to meet the short term obligations.
relationship between net profits and equity shareholders funds of the firm. It is calculated
as following:
Return on Equity = Net Profit after Tax / Total Shareholder's Equity
 Earnings per Share – it measures the profit available for the shareholders on per share. It
is calculated as follows:
Earnings per Share = Net Profit Available to Equity Holders / Number of shares
Sainsbury’s ratios for three years are shown in the table below:
Table 1: Ratio Analysis of Sainsbury
Ratios of Sainsbury 2012 2011 2010
Liquidity Ratio
Current Ratio 0.6282 0.5849 0.6634
Acid Test Ratio 0.3193 0.2878 0.3967
Cash Ratio 0.3037 0.2658 0.3612
Efficiency / Turnover Ratio
Inventory Turnover Ratio 2.27 2.19 2.86
Credit Turnover Ratio 0.5612 0.5114 0.4736
Debtor Turnover Ratio 0.3909 0.3692 0.3361
Assets Turnover Ratio 0.1729 0.1482 0.1853
Profitability Raito
Gross Profit Margin 5.45% 5.03% 5.23%
Net Profit Margin 2.71% 2.36% 2.62%
Performance Ratio
Return on Assets 5.02% 7.20% 6.75%
Return on Capital Employed 8.68% 9.77% 9.09%
Return on Equity 11.05% 7.25% 6.75%
Earnings per Share 3.21% 3.41% 3.22%
1.2: Ratio Analysis
From the above table of company’s financial position can be depicted.
The standard current ratio is 2:1 which means company have a good liquidity position;
Sainsbury’s current ratio is maintained from last three years. There is no huge change in the
current ratio of the company; in the present company’s current ratio is 0.6282 which means
company has less liquidity in comparison with its current assets. Company should increase its
liquidity to meet the short term obligations.
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
A satisfactory acid test ratio is 1:1 which means a firm having equal liquidity to its
current assets. Sainsbury’s acid test ratio is approximately same for the last three years. But
when it is compared to standard it did not seems quite well. Company should decrease its current
liabilities because the current assets are the in a good position (Drury, 2008).
Cash ratios of Sainsbury depicts that company did not have much cash in hand or cast at
bank. But they are capable enough to meet their day to day expenses. Company should
concentrate on sale which can increase its profits and liquidity.
A turnover ratio of the company depicts the good position of its turnover.
In the last year company had inventory turnover ratio at 2.27, which means company in turning
its goods into sales more than two times in year. Conversion of goods into sales will results it in
maintaining cash and liquidity. From the last two years the ratio is decreasing which is quite
thoughtful for its managers.
Credit turnover ratio of the company is increasing from the last two years which means
company is able to make payments to its creditors. In the current situation company is paying
more than three times in a year, which means company had a good liaising with its creditor and
suppliers.
Debtor turnover ratio of the company is increasing from the last two years which means
company’s debtors are paying them at time. The debtor turnover ratio in the FY 2012 is at
0.3909 which means company is able to collect money 4 times in a year.
Assets turnover ratio of the company is good in the current situation; it means company is
capable to generate money, in the comparison with its current assets. In the FY year 2012 the
asset turnover ratio of company is 0.1729, which means company can meet any kind of short
term obligations (Mclaney, 2006).
Profitability Ratio depicts the current position of the company, whether it can sustain in
long run or not. Profitability there is two types of profitability ratio is calculated for the
company.
Gross Profit Margin or Ratio of the company is 5.45% for the FY 2012. It is increasing
from last year. Gross profit margin is calculated after deducting tax, dividend and interest.
Sainsbury’s net operating income is high but there net income is very low which means company
is paying good dividend to its stake holders.
current assets. Sainsbury’s acid test ratio is approximately same for the last three years. But
when it is compared to standard it did not seems quite well. Company should decrease its current
liabilities because the current assets are the in a good position (Drury, 2008).
Cash ratios of Sainsbury depicts that company did not have much cash in hand or cast at
bank. But they are capable enough to meet their day to day expenses. Company should
concentrate on sale which can increase its profits and liquidity.
A turnover ratio of the company depicts the good position of its turnover.
In the last year company had inventory turnover ratio at 2.27, which means company in turning
its goods into sales more than two times in year. Conversion of goods into sales will results it in
maintaining cash and liquidity. From the last two years the ratio is decreasing which is quite
thoughtful for its managers.
Credit turnover ratio of the company is increasing from the last two years which means
company is able to make payments to its creditors. In the current situation company is paying
more than three times in a year, which means company had a good liaising with its creditor and
suppliers.
Debtor turnover ratio of the company is increasing from the last two years which means
company’s debtors are paying them at time. The debtor turnover ratio in the FY 2012 is at
0.3909 which means company is able to collect money 4 times in a year.
Assets turnover ratio of the company is good in the current situation; it means company is
capable to generate money, in the comparison with its current assets. In the FY year 2012 the
asset turnover ratio of company is 0.1729, which means company can meet any kind of short
term obligations (Mclaney, 2006).
Profitability Ratio depicts the current position of the company, whether it can sustain in
long run or not. Profitability there is two types of profitability ratio is calculated for the
company.
Gross Profit Margin or Ratio of the company is 5.45% for the FY 2012. It is increasing
from last year. Gross profit margin is calculated after deducting tax, dividend and interest.
Sainsbury’s net operating income is high but there net income is very low which means company
is paying good dividend to its stake holders.
Net profit margin of the company is 2.71% which means either company is keeping more
reserves, or paying large amount of tax. The current situation of Sainsbury is quite well, because
it is not having much liability to pay. Further it is paying a good amount to its stake holders in
the form of dividend and interest.
Performance ratios depicts the overall position of the company in the market, this ratio
includes some ratios.
Return on assets depicts that how much money a company is generating on its assets;
Sainsbury ROA is 5.02% for the FY 2012 but in the FY it was 7.20%. There is a sharp decline
on assets of the Sainsbury. Still company is on the positive side. In the current situation it can be
depicted that either company had sold some its asset to meet the short term liability or it had
taken a long term loan to meet future demands.
Return on capital employed is also decreasing for the company form last two years,
which means employees of the company are not doing well, to generate profits and sales. At the
financial year ended 2012 its ROCE was 8.68% only but in the past it was 9.77%. Company may
have loosened long term funds from lenders or its supplier had not made payment at time. Which
is affecting the company’s ROCE.
Return on equity is increasing from the last year which means company is performing
well in the market. For the FY year company’s return on equity was 11.05% which means there
share prices are increasing and company is adequately generating funds.
Earnings per share are maintained at 3.21% which means company’s shares are giving
good value to its customers. It also results in increasing number of share holders for the company
(Neale, and McElroy, 2004).
1.3: Summarized Report
Table 2 : Summarized Report
Ratios of Sainsbury 2012 2011 2010 Remarks
Liquidity Ratio
Current Ratio
0.628
2
0.584
9
0.663
4
company should maintain this for long
run
Acid Test Ratio
0.319
3
0.287
8
0.396
7 it should always be maintained in 1:1,
company should work for it
Cash Ratio
0.303
7
0.265
8
0.361
2
to sustain in long run company should
increase its cash position
Efficiency / Turnover
reserves, or paying large amount of tax. The current situation of Sainsbury is quite well, because
it is not having much liability to pay. Further it is paying a good amount to its stake holders in
the form of dividend and interest.
Performance ratios depicts the overall position of the company in the market, this ratio
includes some ratios.
Return on assets depicts that how much money a company is generating on its assets;
Sainsbury ROA is 5.02% for the FY 2012 but in the FY it was 7.20%. There is a sharp decline
on assets of the Sainsbury. Still company is on the positive side. In the current situation it can be
depicted that either company had sold some its asset to meet the short term liability or it had
taken a long term loan to meet future demands.
Return on capital employed is also decreasing for the company form last two years,
which means employees of the company are not doing well, to generate profits and sales. At the
financial year ended 2012 its ROCE was 8.68% only but in the past it was 9.77%. Company may
have loosened long term funds from lenders or its supplier had not made payment at time. Which
is affecting the company’s ROCE.
Return on equity is increasing from the last year which means company is performing
well in the market. For the FY year company’s return on equity was 11.05% which means there
share prices are increasing and company is adequately generating funds.
Earnings per share are maintained at 3.21% which means company’s shares are giving
good value to its customers. It also results in increasing number of share holders for the company
(Neale, and McElroy, 2004).
1.3: Summarized Report
Table 2 : Summarized Report
Ratios of Sainsbury 2012 2011 2010 Remarks
Liquidity Ratio
Current Ratio
0.628
2
0.584
9
0.663
4
company should maintain this for long
run
Acid Test Ratio
0.319
3
0.287
8
0.396
7 it should always be maintained in 1:1,
company should work for it
Cash Ratio
0.303
7
0.265
8
0.361
2
to sustain in long run company should
increase its cash position
Efficiency / Turnover
Ratio
Inventory Turnover
Ratio 2.27 2.19 2.86 company should try to cover at least 3
times inventory in a year
Credit Turnover Ratio
0.561
2
0.511
4
0.473
6
company should maintain this in future
also
Debtor Turnover Ratio
0.390
9
0.369
2
0.336
1 this is good ratio company should
maintain its performance
Assets Turnover Ratio
0.172
9
0.148
2
0.185
3
it depicts that company is able to
generate sufficient money to meet short
term obligations
Profitability Raito
Gross Profit Margin 5.45% 5.03% 5.23% company is increasing its performance
from last year
Net Profit Margin 2.71% 2.36% 2.62% company should decrease its amount of
taxes
Performance Ratio
Return on Assets 5.02% 7.20% 6.75% company should try to increase its
return on assets
Return on Capital
Employed 8.68% 9.77% 9.09% company should try to maintain this
ratio with its past positions
Return on Equity
11.05
% 7.25% 6.75% company is in good position, should
maintained this in the future also
Earnings per Share 3.21% 3.41% 3.22% eps of the company's share yielding
good results
Part 2: Investment Appraisal for PLC plc.
2.1: Project Appraisal
Table 3 : Cash Flow for Two Projects
Project 1 (£000) 2 (£000)
Initial Outlay (1100) (800)
Year 1 (110) (20)
Year 2 200 140
Year 3 400 250
Year 4 500 300
Year 5 520 380
Residual Value 150 80
Inventory Turnover
Ratio 2.27 2.19 2.86 company should try to cover at least 3
times inventory in a year
Credit Turnover Ratio
0.561
2
0.511
4
0.473
6
company should maintain this in future
also
Debtor Turnover Ratio
0.390
9
0.369
2
0.336
1 this is good ratio company should
maintain its performance
Assets Turnover Ratio
0.172
9
0.148
2
0.185
3
it depicts that company is able to
generate sufficient money to meet short
term obligations
Profitability Raito
Gross Profit Margin 5.45% 5.03% 5.23% company is increasing its performance
from last year
Net Profit Margin 2.71% 2.36% 2.62% company should decrease its amount of
taxes
Performance Ratio
Return on Assets 5.02% 7.20% 6.75% company should try to increase its
return on assets
Return on Capital
Employed 8.68% 9.77% 9.09% company should try to maintain this
ratio with its past positions
Return on Equity
11.05
% 7.25% 6.75% company is in good position, should
maintained this in the future also
Earnings per Share 3.21% 3.41% 3.22% eps of the company's share yielding
good results
Part 2: Investment Appraisal for PLC plc.
2.1: Project Appraisal
Table 3 : Cash Flow for Two Projects
Project 1 (£000) 2 (£000)
Initial Outlay (1100) (800)
Year 1 (110) (20)
Year 2 200 140
Year 3 400 250
Year 4 500 300
Year 5 520 380
Residual Value 150 80
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
A: Net Present Value Method
Table 4 : NPV at 10%
Year
Project 1
(£000)
Project 2
(£000)
PV Factor
@ 10%
Present
Value of
Project 1
Present
Value of
Project 2
Year 1 (110) (20) 0.909 -99.99 -18.18
Year 2 200 140 0.826 165.2 115.64
Year 3 400 250 0.751 300.4 187.75
Year 4 500 300 0.682 341 204.6
Year 5 520 380 0.621 322.92 235.98
Residual Value 150 80 0.621 93.15 49.68
1122.68 775.47
Net Present Value=Present Value−Initial Investment
Net Present Value of Project 1=1122.68−1100
NPV of Project 1=£ 22680
Net Present Valueof Project 2=775.47−800
NPV of Project 2=£−24530
It is clear from the above table and calculation from the formula that project 1 is yielding a
positive value, and project 2 yields negative. According to NPV method project 1 can be go
ahead (Young, Owen, and Connor, 2011).
B: Internal Rate of Return Method
At 10 % NPV of project 1 yielding positive value and project 2 yielding negative value,
which results in internal rate of return of the projects. Internal rate of return of project 1 will be
more than 10% and IRR of project 2 will be less than 10%. Further using HIT and TRIAL
method, the NPV of project 1 is calculated at 11% and project 2 is calculated at 9%.
Table 4 : NPV at 10%
Year
Project 1
(£000)
Project 2
(£000)
PV Factor
@ 10%
Present
Value of
Project 1
Present
Value of
Project 2
Year 1 (110) (20) 0.909 -99.99 -18.18
Year 2 200 140 0.826 165.2 115.64
Year 3 400 250 0.751 300.4 187.75
Year 4 500 300 0.682 341 204.6
Year 5 520 380 0.621 322.92 235.98
Residual Value 150 80 0.621 93.15 49.68
1122.68 775.47
Net Present Value=Present Value−Initial Investment
Net Present Value of Project 1=1122.68−1100
NPV of Project 1=£ 22680
Net Present Valueof Project 2=775.47−800
NPV of Project 2=£−24530
It is clear from the above table and calculation from the formula that project 1 is yielding a
positive value, and project 2 yields negative. According to NPV method project 1 can be go
ahead (Young, Owen, and Connor, 2011).
B: Internal Rate of Return Method
At 10 % NPV of project 1 yielding positive value and project 2 yielding negative value,
which results in internal rate of return of the projects. Internal rate of return of project 1 will be
more than 10% and IRR of project 2 will be less than 10%. Further using HIT and TRIAL
method, the NPV of project 1 is calculated at 11% and project 2 is calculated at 9%.
Table 5 : NPV of Project 1
Year
Project 1
(£000)
PV Factor @
11%
Present Value
of project 1
Year 1 -110 0.901 -99.11
Year 2 200 0.812 162.4
Year 3 400 0.731 292.4
Year 4 500 0.659 329.5
Year 5 520 0.593 308.36
Residual Value 150 0.593 88.95
1082.5
NPV of Project 1=1082.5−1100
NPV of project 1=£−17500
Table 6 : NPV of Project 2
Year
Project 2
(£000)
PV Factor @
9%
Present
Value of
Project 2
Year 1 -20 0.917 -18.34
Year 2 140 0.842 117.88
Year 3 250 0.772 193
Year 4 300 0.708 212.4
Year 5 380 0.65 247
Residual Value 80 0.65 52
803.94
NPV of Project 2=803.94−800
NPV of Project 2=£ 3940
From the table 5 and table 6 the Internal Rate of Return of both project is been shown. IRR of
project will be in between 10% to 11% and IRR of project 2 will be in between 9% - 10%.
IRR of project 1:
IRR=10+ 1122.68−1100
1122.68−1082.5∗1
Year
Project 1
(£000)
PV Factor @
11%
Present Value
of project 1
Year 1 -110 0.901 -99.11
Year 2 200 0.812 162.4
Year 3 400 0.731 292.4
Year 4 500 0.659 329.5
Year 5 520 0.593 308.36
Residual Value 150 0.593 88.95
1082.5
NPV of Project 1=1082.5−1100
NPV of project 1=£−17500
Table 6 : NPV of Project 2
Year
Project 2
(£000)
PV Factor @
9%
Present
Value of
Project 2
Year 1 -20 0.917 -18.34
Year 2 140 0.842 117.88
Year 3 250 0.772 193
Year 4 300 0.708 212.4
Year 5 380 0.65 247
Residual Value 80 0.65 52
803.94
NPV of Project 2=803.94−800
NPV of Project 2=£ 3940
From the table 5 and table 6 the Internal Rate of Return of both project is been shown. IRR of
project will be in between 10% to 11% and IRR of project 2 will be in between 9% - 10%.
IRR of project 1:
IRR=10+ 1122.68−1100
1122.68−1082.5∗1
IRR=10.56 %
IRR of project 2:
IRR=9+ 803.94−800
803.94−775.47∗1
IRR=9.14 %
From the above calculations and tables it can be depicted that internal rate of return of project 1
is more than 10% and IRR of project 2 is less than 10%, so the company should invest in project
1only.
C: Average Rate of Return
Average rate of return of project 1:
Average rate of Return= Average Annual Profits after Taxes
Average Investment
the life of the project
∗100
Average Annual Profit after Tax=−110+200+ 400+500+520
5
Average Annual Profit after Tax=£ 332000
Average Investment=Salvage Value+ 1
2 (Cost of Machine−Salvage Value)
Average Investment=150+ 1
2 (1100−150 )
Average Investment=£ 625000
Average rate of return= 332000
625000∗100
Average rate of return=53.12 %
Average rate of return of project 2:
Average Annual Profit after Ta x=−20+140+250+ 300+380
5
Average Annual Profit after Tax=£ 226000
Average Investment=80+1
2 ( 800−80 )
Average Investment=£ 440000
Average rate of return= 226000
440000∗100
Average rate of return=51.36 %
IRR of project 2:
IRR=9+ 803.94−800
803.94−775.47∗1
IRR=9.14 %
From the above calculations and tables it can be depicted that internal rate of return of project 1
is more than 10% and IRR of project 2 is less than 10%, so the company should invest in project
1only.
C: Average Rate of Return
Average rate of return of project 1:
Average rate of Return= Average Annual Profits after Taxes
Average Investment
the life of the project
∗100
Average Annual Profit after Tax=−110+200+ 400+500+520
5
Average Annual Profit after Tax=£ 332000
Average Investment=Salvage Value+ 1
2 (Cost of Machine−Salvage Value)
Average Investment=150+ 1
2 (1100−150 )
Average Investment=£ 625000
Average rate of return= 332000
625000∗100
Average rate of return=53.12 %
Average rate of return of project 2:
Average Annual Profit after Ta x=−20+140+250+ 300+380
5
Average Annual Profit after Tax=£ 226000
Average Investment=80+1
2 ( 800−80 )
Average Investment=£ 440000
Average rate of return= 226000
440000∗100
Average rate of return=51.36 %
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
From the above calculation it can be depicted that project 1 has 53.12% of average rate of return
and project 2 has 51.36% of average rate of return. So it clear that company should invest in the
project 1.
2.2: Payback Period Method
Payback Period for project 1
Table 7 : Payback Period of Project 1
Year
Project 1
(£000) Cumulative (£000)
Year 1 -110 -110
Year 2 200 90
Year 3 400 490
Year 4 500 990
Year 5 520 1510
Residual Value 150
From the above table it is clear that payback period of project 1 will be within 4-5 years.
Accurate payback period will be:
1100−990
520 ∗12=2.53
The above calculation shows that payback period of the project 1 will be 4 years and more two
months.
Payback Period for project 2:
Table 8 : Payback Period of Project 2
Year
Project 2
(£000)
Cumulative
(£000)
Year 1 -20 -20
Year 2 140 120
Year 3 250 370
Year 4 300 670
Year 5 380 1050
Residual
Value 80
and project 2 has 51.36% of average rate of return. So it clear that company should invest in the
project 1.
2.2: Payback Period Method
Payback Period for project 1
Table 7 : Payback Period of Project 1
Year
Project 1
(£000) Cumulative (£000)
Year 1 -110 -110
Year 2 200 90
Year 3 400 490
Year 4 500 990
Year 5 520 1510
Residual Value 150
From the above table it is clear that payback period of project 1 will be within 4-5 years.
Accurate payback period will be:
1100−990
520 ∗12=2.53
The above calculation shows that payback period of the project 1 will be 4 years and more two
months.
Payback Period for project 2:
Table 8 : Payback Period of Project 2
Year
Project 2
(£000)
Cumulative
(£000)
Year 1 -20 -20
Year 2 140 120
Year 3 250 370
Year 4 300 670
Year 5 380 1050
Residual
Value 80
From the above table it is clear that payback period of project 2 will be within 4 – 5 years. The
accurate payback period will be:
800−670
380 ∗12=4.11
From the calculation it is clear that payback period of the project 2 will be 4 year and more than
4 months.
As the results suggest of payback period method, the company should invest in the project 1
because it payback period is less than project 2 payback period.
2.3: Advantages and disadvantages of the investment appraisal methods
Average Rate of Return: This method is based on accounting information rather than the cash
flows. Time value of money is not considered in this method. There is no annuity in this method.
Advantages:
ï‚· This method is easily understandable and to use
ï‚· Attractiveness of the investment can be identified
ï‚· Calculations are not very complicated
Disadvantages:
ï‚· It does not consider the concept of time value of money
ï‚· Terminal value is ignored in this
Payback period: Through this method, company or investors can identify the time in which the
cost of the investment will be recovered.
Advantages:
ï‚· Easiest method
ï‚· Highlights liquidity
ï‚· Risk associated with the projects are taken care of
Disadvantages:
ï‚· Ignore the concept of time value of money
ï‚· It ignores the profitability of the project and consider only payback period
ï‚· Ignores cash flows generated after payback period
Net Present Value: It considers the concept of time value of money while determining the future
value of the present cans or present value of the future cash flow. Those projects are considered
accurate payback period will be:
800−670
380 ∗12=4.11
From the calculation it is clear that payback period of the project 2 will be 4 year and more than
4 months.
As the results suggest of payback period method, the company should invest in the project 1
because it payback period is less than project 2 payback period.
2.3: Advantages and disadvantages of the investment appraisal methods
Average Rate of Return: This method is based on accounting information rather than the cash
flows. Time value of money is not considered in this method. There is no annuity in this method.
Advantages:
ï‚· This method is easily understandable and to use
ï‚· Attractiveness of the investment can be identified
ï‚· Calculations are not very complicated
Disadvantages:
ï‚· It does not consider the concept of time value of money
ï‚· Terminal value is ignored in this
Payback period: Through this method, company or investors can identify the time in which the
cost of the investment will be recovered.
Advantages:
ï‚· Easiest method
ï‚· Highlights liquidity
ï‚· Risk associated with the projects are taken care of
Disadvantages:
ï‚· Ignore the concept of time value of money
ï‚· It ignores the profitability of the project and consider only payback period
ï‚· Ignores cash flows generated after payback period
Net Present Value: It considers the concept of time value of money while determining the future
value of the present cans or present value of the future cash flow. Those projects are considered
attractive whose NPV is positive. The project which yields high value should be selected among
the different projects (Singh, Jain, and Yadav, 2012).
Advantages:
ï‚· Follows concept of Time value of money
ï‚· All the cash flows are taken care of
ï‚· Considers both profitability and risk
Disadvantages:
ï‚· Practical implication of this project is difficult because external factors are always
changeable.
ï‚· Implication of this method cannot be done, where projects are not similar in the nature.
Internal Rate of Return: IRR is the rate at which the cash inflow becomes equal to cash outflow,
or the rate at which difference between initial outlay cash inflow becomes zero.
Advantages:
ï‚· Follows concept of time value of money;
ï‚· All the cash flows are considered.
Disadvantages:
ï‚· Most difficult method to implement;
ï‚· Economy of scale is ignored.
Most frequent capital budgeting method used by the companies and the investors are
NPV and IRR. These are widely used as they consider the concept of time value of money, so
results derived from such methods are more accurate and authentic than other methods of
appraisal.
2.4: Summarized Report
Project 1 Project 2
NPV £22680 £-24530
IRR 10.56% 9.14%
Payback Period 4 Years and 2 months 4 years and 4 months
ARR 53.12% 51.36%
From the above table, it can be concluded that project 1 is better that project 2 in all respects. So
PLC Plc. must invest in project 1 as it is more attractive (Obura, and Bukenya, 2008).
the different projects (Singh, Jain, and Yadav, 2012).
Advantages:
ï‚· Follows concept of Time value of money
ï‚· All the cash flows are taken care of
ï‚· Considers both profitability and risk
Disadvantages:
ï‚· Practical implication of this project is difficult because external factors are always
changeable.
ï‚· Implication of this method cannot be done, where projects are not similar in the nature.
Internal Rate of Return: IRR is the rate at which the cash inflow becomes equal to cash outflow,
or the rate at which difference between initial outlay cash inflow becomes zero.
Advantages:
ï‚· Follows concept of time value of money;
ï‚· All the cash flows are considered.
Disadvantages:
ï‚· Most difficult method to implement;
ï‚· Economy of scale is ignored.
Most frequent capital budgeting method used by the companies and the investors are
NPV and IRR. These are widely used as they consider the concept of time value of money, so
results derived from such methods are more accurate and authentic than other methods of
appraisal.
2.4: Summarized Report
Project 1 Project 2
NPV £22680 £-24530
IRR 10.56% 9.14%
Payback Period 4 Years and 2 months 4 years and 4 months
ARR 53.12% 51.36%
From the above table, it can be concluded that project 1 is better that project 2 in all respects. So
PLC Plc. must invest in project 1 as it is more attractive (Obura, and Bukenya, 2008).
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
CONCLUSION
After studying the above two cases, it can be said that financial analysis is very important
for the managers and the management as it aids in the evaluation of the performance of the
company and further can appraise different investment opportunities.
After studying the above two cases, it can be said that financial analysis is very important
for the managers and the management as it aids in the evaluation of the performance of the
company and further can appraise different investment opportunities.
References
Arnold, G., 2005. Corporate Financial Management. 3rd ed. Financial Times/Prentice Hall.
Atrill, P. and McLaney, E., 2008. Accounting and Finance for Non-Specialists. 6th ed. Financial
Times/Prentice Hall.
Atrill, P., 2009. Financial Management for Decision Makers. 5th ed. Financial Times/Prentice
Hall.
Bennouna, K., Meredith, G. G. and Marchant, T., 2010. Improved capital budgeting decision
making: evidence from Canada. Management Decision. 48(2). pp.225 – 247
Collier, P.M., 2012. Accounting for Managers. 4th ed. Wiley.
Dauber, D., 2012 . Opposing positions in M&A research: culture, integration and performance.
Cross Cultural Management. An International Journal. 19(3). pp.375 - 398
Drury, C., 2008. Management and Cost Accounting. 7th ed. South Western Cengage Learning.
Mclaney, E.I., 2006. Business Finance Theory and Practice. 7th ed. Financial Times/Prentice
Hall.
Neale, B. and McElroy, T., 2004. Business Finance- A Value Based Approach. 1st ed. Financial
Times/Prentice Hall.
Obura, O. and Bukenya, K., 2008. Financial management and budgeting strategies for LIS
programmes: Uganda's experience. Library Review. 57(7). pp.514 - 527
Singh, S., Jain, K.P. and Yadav, S. S., 2012. Capital budgeting decisions: evidence from India.
Journal of Advances in Management Research. 9(1). pp.96 – 112
Young, M., Owen, J. and Connor, J., 2011. Whole of enterprise portfolio management: A case
study of NSW Government and Sydney Water Corporation. International Journal of
Managing Projects in Business. 4(3). pp.412 – 435.
Arnold, G., 2005. Corporate Financial Management. 3rd ed. Financial Times/Prentice Hall.
Atrill, P. and McLaney, E., 2008. Accounting and Finance for Non-Specialists. 6th ed. Financial
Times/Prentice Hall.
Atrill, P., 2009. Financial Management for Decision Makers. 5th ed. Financial Times/Prentice
Hall.
Bennouna, K., Meredith, G. G. and Marchant, T., 2010. Improved capital budgeting decision
making: evidence from Canada. Management Decision. 48(2). pp.225 – 247
Collier, P.M., 2012. Accounting for Managers. 4th ed. Wiley.
Dauber, D., 2012 . Opposing positions in M&A research: culture, integration and performance.
Cross Cultural Management. An International Journal. 19(3). pp.375 - 398
Drury, C., 2008. Management and Cost Accounting. 7th ed. South Western Cengage Learning.
Mclaney, E.I., 2006. Business Finance Theory and Practice. 7th ed. Financial Times/Prentice
Hall.
Neale, B. and McElroy, T., 2004. Business Finance- A Value Based Approach. 1st ed. Financial
Times/Prentice Hall.
Obura, O. and Bukenya, K., 2008. Financial management and budgeting strategies for LIS
programmes: Uganda's experience. Library Review. 57(7). pp.514 - 527
Singh, S., Jain, K.P. and Yadav, S. S., 2012. Capital budgeting decisions: evidence from India.
Journal of Advances in Management Research. 9(1). pp.96 – 112
Young, M., Owen, J. and Connor, J., 2011. Whole of enterprise portfolio management: A case
study of NSW Government and Sydney Water Corporation. International Journal of
Managing Projects in Business. 4(3). pp.412 – 435.
Appendix
Balance Sheet
Fiscal data as of Mar 17 2012 2012 2011 2010
ASSETS
Cash And Short Term Investments 739 501 837
Total Receivables, Net 225 281 172
Total Inventory 938 812 702
Prepaid expenses 61 62 43
Other current assets, total 69 65 99
Total current assets 2,032 1,721 1,853
Property, plant & equipment, net 9,329 8,784 8,203
Goodwill, net 100 100 100
Intangibles, net 60 51 44
Long term investments 744 678 599
Note receivable - long term 38 36 35
Other long term assets 37 29 21
Total assets 12,340 11,399 10,855
LIABILITIES
Accounts payable 1,903 1,836 1,782
Accrued expenses 257 250 223
Notes payable/short-term debt 0 1 3
Current portion long-term debt/capital leases 150 73 70
Other current liabilities, total 826 782 715
Total current liabilities 3,136 2,942 2,793
Total long term debt 2,617 2,339 2,357
Total debt 2,767 2,413 2,430
Deferred income tax 286 172 144
Balance Sheet
Fiscal data as of Mar 17 2012 2012 2011 2010
ASSETS
Cash And Short Term Investments 739 501 837
Total Receivables, Net 225 281 172
Total Inventory 938 812 702
Prepaid expenses 61 62 43
Other current assets, total 69 65 99
Total current assets 2,032 1,721 1,853
Property, plant & equipment, net 9,329 8,784 8,203
Goodwill, net 100 100 100
Intangibles, net 60 51 44
Long term investments 744 678 599
Note receivable - long term 38 36 35
Other long term assets 37 29 21
Total assets 12,340 11,399 10,855
LIABILITIES
Accounts payable 1,903 1,836 1,782
Accrued expenses 257 250 223
Notes payable/short-term debt 0 1 3
Current portion long-term debt/capital leases 150 73 70
Other current liabilities, total 826 782 715
Total current liabilities 3,136 2,942 2,793
Total long term debt 2,617 2,339 2,357
Total debt 2,767 2,413 2,430
Deferred income tax 286 172 144
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
Minority interest 0 -- --
Other liabilities, total 672 522 595
Total liabilities 6,711 5,975 5,889
SHAREHOLDERS EQUITY
Common stock 538 535 532
Additional paid-in capital 1,061 1,048 1,033
Retained earnings (accumulated deficit) 4,053 3,864 3,424
Treasury stock - common -22 -22 -22
Unrealized gain (loss) -- -- --
Other equity, total -1 -1 -1
Total equity 5,629 5,424 4,966
Total liabilities & shareholders' equity 12,340 11,399 10,855
Total common shares outstanding 1,883 1,871 1,861
Treasury shares - common primary issue -- -- --
Cash Flows
Fiscal data as of Mar 17 2012 2012 2011 2010
OPERATIONS
Net income 799 827 710
Depreciation/depletion 486 468 466
Non-Cash items -60 -93 -75
Cash taxes paid, supplemental 82 158 89
Cash interest paid, supplemental 147 130 114
Changes in working capital -171 -362 -108
Total cash from operations 1,067 854 1,006
INVESTING
Other liabilities, total 672 522 595
Total liabilities 6,711 5,975 5,889
SHAREHOLDERS EQUITY
Common stock 538 535 532
Additional paid-in capital 1,061 1,048 1,033
Retained earnings (accumulated deficit) 4,053 3,864 3,424
Treasury stock - common -22 -22 -22
Unrealized gain (loss) -- -- --
Other equity, total -1 -1 -1
Total equity 5,629 5,424 4,966
Total liabilities & shareholders' equity 12,340 11,399 10,855
Total common shares outstanding 1,883 1,871 1,861
Treasury shares - common primary issue -- -- --
Cash Flows
Fiscal data as of Mar 17 2012 2012 2011 2010
OPERATIONS
Net income 799 827 710
Depreciation/depletion 486 468 466
Non-Cash items -60 -93 -75
Cash taxes paid, supplemental 82 158 89
Cash interest paid, supplemental 147 130 114
Changes in working capital -171 -362 -108
Total cash from operations 1,067 854 1,006
INVESTING
Capital expenditures -1,252 -1,151 -1,047
Other investing and cash flow items, total 369 249 147
Total cash from investing -883 -902 -900
FINANCING
Financing cash flow items -5 -4 -3
Total cash dividends paid -285 -269 -241
Issuance (retirement) of stock, net 14 17 250
Issuance (retirement) of debt, net 331 -30 123
Total cash from financing 55 -286 129
NET CHANGE IN CASH
Foreign exchange effects -- -- --
Net change in cash 239 -334 235
Net cash-begin balance/reserved for future use 500 834 599
Net cash-end balance/reserved for future use 739 500 834
SUPPLEMENTAL INCOME
Depreciation, supplemental 486 468 466
Cash interest paid, supplemental 147 130 114
Cash taxes paid, supplemental 82 158 89
Other investing and cash flow items, total 369 249 147
Total cash from investing -883 -902 -900
FINANCING
Financing cash flow items -5 -4 -3
Total cash dividends paid -285 -269 -241
Issuance (retirement) of stock, net 14 17 250
Issuance (retirement) of debt, net 331 -30 123
Total cash from financing 55 -286 129
NET CHANGE IN CASH
Foreign exchange effects -- -- --
Net change in cash 239 -334 235
Net cash-begin balance/reserved for future use 500 834 599
Net cash-end balance/reserved for future use 739 500 834
SUPPLEMENTAL INCOME
Depreciation, supplemental 486 468 466
Cash interest paid, supplemental 147 130 114
Cash taxes paid, supplemental 82 158 89
Income Statement
Fiscal data as of Mar 17 2012 2012 2011 2010
REVENUE AND GROSS PROFIT
Total revenue 22,294 21,102 19,964
OPERATING EXPENSES
Cost of revenue total 21,083 19,942 18,882
Selling, general and admin. expenses, total 419 417 399
Depreciation/amortization -- -- --
Unusual expense(income) -- -- --
Other operating expenses, total -82 -108 -27
Total operating expense 21,420 20,251 19,254
Operating income 874 851 710
Other, net 14 0 -26
INCOME TAXES, MINORITY INTEREST AND EXTRA ITEMS
Net income before taxes 799 827 733
Provision for income taxes 201 187 148
Net income after taxes 598 640 585
Minority interest -- -- --
Net income before extra. Items 598 640 585
Total extraordinary items -- -- --
Net income 598 640 585
Inc.avail. to common excl. extra. Items 598 640 585
Inc.avail. to common incl. extra. Items 598 640 585
EPS RECONCILIATION
Fiscal data as of Mar 17 2012 2012 2011 2010
REVENUE AND GROSS PROFIT
Total revenue 22,294 21,102 19,964
OPERATING EXPENSES
Cost of revenue total 21,083 19,942 18,882
Selling, general and admin. expenses, total 419 417 399
Depreciation/amortization -- -- --
Unusual expense(income) -- -- --
Other operating expenses, total -82 -108 -27
Total operating expense 21,420 20,251 19,254
Operating income 874 851 710
Other, net 14 0 -26
INCOME TAXES, MINORITY INTEREST AND EXTRA ITEMS
Net income before taxes 799 827 733
Provision for income taxes 201 187 148
Net income after taxes 598 640 585
Minority interest -- -- --
Net income before extra. Items 598 640 585
Total extraordinary items -- -- --
Net income 598 640 585
Inc.avail. to common excl. extra. Items 598 640 585
Inc.avail. to common incl. extra. Items 598 640 585
EPS RECONCILIATION
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Basic/primary weighted average shares 1,870 1,859 1,822
Basic/primary eps excl. extra items 0.32 0.34 0.32
Basic/primary eps incl. extra items 0.32 0.34 0.32
Dilution adjustment 10 10 6
Diluted weighted average shares 1,930 1,921 1,873
Diluted eps excl. extra items 0.32 0.34 0.32
Diluted eps incl. extra items 0.32 0.34 0.32
COMMON STOCK DIVIDENDS
DPS - common stock primary issue 0.16 0.15 0.14
Gross dividend - common stock 302 281 263
PRO FORMA INCOME
Pro forma net income -- -- --
Interest expense, supplemental 124 113 110
SUPPLEMENTAL INCOME
Depreciation, supplemental 486 468 466
Total special items -86 -113 -39
NORMALIZED INCOME
Normalized income before taxes 713 714 694
Effect of special items on income taxes -22 -26 -7.87
Income tax excluding impact of special items 179 161 140
Normalized income after tax 534 553 554
Basic/primary eps excl. extra items 0.32 0.34 0.32
Basic/primary eps incl. extra items 0.32 0.34 0.32
Dilution adjustment 10 10 6
Diluted weighted average shares 1,930 1,921 1,873
Diluted eps excl. extra items 0.32 0.34 0.32
Diluted eps incl. extra items 0.32 0.34 0.32
COMMON STOCK DIVIDENDS
DPS - common stock primary issue 0.16 0.15 0.14
Gross dividend - common stock 302 281 263
PRO FORMA INCOME
Pro forma net income -- -- --
Interest expense, supplemental 124 113 110
SUPPLEMENTAL INCOME
Depreciation, supplemental 486 468 466
Total special items -86 -113 -39
NORMALIZED INCOME
Normalized income before taxes 713 714 694
Effect of special items on income taxes -22 -26 -7.87
Income tax excluding impact of special items 179 161 140
Normalized income after tax 534 553 554
Normalized income avail. to common 534 553 554
Basic normalized EPS 0.29 0.3 0.3
Diluted normalized EPS 0.28 0.29 0.3
Basic normalized EPS 0.29 0.3 0.3
Diluted normalized EPS 0.28 0.29 0.3
1 out of 24
Related Documents
Your All-in-One AI-Powered Toolkit for Academic Success.
 +13062052269
info@desklib.com
Available 24*7 on WhatsApp / Email
Unlock your academic potential
© 2024  |  Zucol Services PVT LTD  |  All rights reserved.