You are a recent MBA graduate and are tasked with reviewing the Income Statement and Balance Sheet trends for Competition Bikes Inc. (Please see the attachment.) Discuss the companies strong and weak points with the balance sheet and income statement. List any sources you may have used to support your analysis.© BrainMass Inc. brainmass.com October 17, 2018, 10:28 am ad1c9bdddf
1) Between years 6 and 7, net sales and gross profit increased 30%.
2) COGS decreased 15% in year 8.
3) Operating income more than doubled between years 6 and 7.
4) EBITs quadrupled between years 6 and 7.
5) Net earnings quadrupled between years 6 and 7.
1) Flat net sales and gross profit in year 8.
2) COGS increased 30% between years 6 and 7.
3) SGA costs increased 20% over 3-year span.
4) Operating income decreased 70% in year 8.
5) EBITs declined nearly five times in year 8.
6) Net earnings declined five times in year 8.
1) Strong ...
Solution is comprised of an analysis following 3-year trending for Competition Bikes, Inc. balance sheet and income statement. Also includes key financial ratio analysis.
Financial Analysis - Case Study
Module 1: Case Study
A. What effect did the expansion have on sales and net income? What effect did the expansion have on the asset side of the balance sheet? What effect did it have on liabilities and equity?
The sales increased by $2.4 million in 2013 over 2012. The net income decreased by $183,096. The assets increased by $1,417,792. Liabilities increased by $1,523,928 and equity decreased by $10,136.
B. What do you conclude from the statement of cash flows?
Based on the statement of cash flows, we trust that there was an increase in current and fixed assets to support the increase in sales. The build up of accounts receivables and inventories resulted in a negative cash flow of $503,936 from operating activities. The fixed assets required $711,850. The requirement for cash was met through sale of short-term investments and an increase in borrowing. The change in cash balance was only -$1,718.
C. What is free cash flow? Why is it important? What are the five uses of FCF?
Free cash flow is cash flow from operating activities - capital expenditure. This is the cash left after meeting the requirements of investments in working capital and fixed assets. This cash is available for distribution to the capital providers of the firm.
FCF is important since the value of a firm is the present value of all free cash flows generated by the firm.
The five uses of Free Cash Flow are:
1. Payment of interest on debt
2. Payment of dividends
3. Repayment of borrowings
4. Repurchase of stock
5. Investment in marketable securities
D. What is Computron's net operating profit after taxes (NOPAT)? What are operating current assets? What are operating current liabilities? How much net operating working capital and total net operating capital does Computron have?
Operating current assets are the current assets, which are required for the operations of the firm such as cash, receivables and inventories. These do not include short-term investments since they are not used in the operations of the firm.
Operating current liabilities and spontaneous current liabilities, which support the operations of the firm such as accounts payable and accrued expenses. Short-term borrowing is a form of financing and not operating current liabilities.
Net operating working capital = Operating current assets - operating current liabilities
Operating current assets = $7,282 + $632,160 + $1,287,360 = 1,926,802
Operating current liabilities = $324,000 + $284,960 = 608,960
Net operating working capital = 1,926,802-608,960 = $1,317,842
Total net operating capital = Net operating working capital + net fixed assets
= $1,317,842 + $939,790 = $2,257,632
Net operating working capital = $793,800
And Net operating capital = $1,138,600.
E. What is Computron's free cash flow (FCF)? What are Computron's "net uses" of its FCF?
NOPAT = EBIT X (1-tax rate) = 17,440 X (1-0.4) = $10,464
Free Cash Flow = NOPAT + depreciation - capital expenditure - changes in working capital
Capital expenditure is 711,950
Change in working capital is (793,800-1,317,842) = -524,042
FCF = 10,464 +116,960 - 711,950 - 524,042 = -1,108,568
F. Calculate Computron's return on invested capital. Computron has a cost of capital (WACC). Do you think Computron's growth added value?
Return on invested capital = NOPAT/Net operating Capital
ROIC = 10,464/2,257,632= 0.46%
The growth has not added value, as the ROIC is less than the cost of capital of 10%
G. Cochran also has asked you to estimate Computron's EVA. She estimates that the after-tax cost of capital was in both years.
EVA = NOPAT - Net operating Capital X After tax cost of capital
Net Operating Capital = 2,257,632
EVA = 10,464 - 2,257,632X 10% = $-215,299
EVA =$125,460 - (0.10)($1,138,600)
= $125,460 - $113,860
H. What happened to Computron's Market Value Added (MVA)?
Market Value Added = Market value - Book value.
Market value = 8.50X100,000 = $850,000
Book Value = Shareholders equity = 663,678
MVA =850,000-663,678 = 186,322.
Market value - 6X100,000=600,000
Book Value = Shareholders equity = 557,532.
MVA = 600,000-557,532 42,368.
During the year MVA decreased by $143,954.
I. Assume that a corporation has of taxable income from operations plus of interest income and of dividend income. What is the company's federal tax liability?
The taxable income is:
Income from operation 100,000
Interest income 5,000
Taxable dividend income 3,000
Total taxable income 108,000
Taxable income = $22,250 + ($108,000 - $100,000)0.39 = $25,370.
70% of dividends are excluded from tax
J. Assume that you are in the marginal tax bracket and that you have to invest. You have narrowed your investment choices down to California bonds with a yield of or equally risky ExxonMobil bonds with a yield of. Which one should you choose and why? At what marginal tax rate would you be indifferent to the choice between California and ExxonMobil bonds?
We should choose which ever offers a higher after tax yield.
The California bond is tax exempt and so the after tax yield is 7%.
ExxonMobil - After tax yield = 10% X (1-0.25) = 7.25%
We should choose ExxonMobil
We would be indifferent when the after tax yields are the same.
7% = 10% X (1-tax rate)
Tax rate = 30%
K. Why are ratios useful? What three groups use ratio analysis and for what reasons?
Financial ratios are useful in that they can be used as a means of measuring a firm's performance
against peer companies in their industry and as a means of measuring progress against their own
There are three business groups that use ratio analysis: management, as a means improving their
firm's performance; lenders, as a means of determining a firm's creditworthiness; and stockholders,
as a means of forecasting future earnings and dividend payouts.
L. Calculate the 2014 current and quick ratios based on the projected balance sheet and income statement data. What can you say about the company's liquidity position in 2012, 2013, and as projected for 2014? We often think of ratios as being useful
a. (1) to managers to help run the business,
b. (2) to bankers for credit analysis, and
c. (3) to stockholders for stock valuation.
Current ratio = current assets / current liabilities
Current ratio = $2,680,112 / $3,516,952 = 2.6
Quick ratio = (current assets - inventory) / current liabilities
Quick ratio = ($2,680,112 - $1,716,480) / $3,516,952 = 0.3
Computron's 2014 current ratio is the highest relative to its 2013 and 2012 current ratios, which
although still below the industry average, is a marked improvement in the company's
performance over its 2013 and 2012 figures.
Conversely, the company's quick ratio for 2014 is the lowest compared to its 2013 and
2012 quick ratios, with the company's quick ratios for all three years being lower than the
industry average. The low 2011 quick ratio serves as an indication that the company might
experience difficulty quickly repaying its debts if the need arose.
M. Would these different types of analysts have an equal interest in the liquidity ratios?
Liquidity ratios, which are used to means to measure how effectively a company can pay off its
short-term obligations would be of great importance to all three types of analysis, as a
company's survivability as an ongoing operation is highly dependent on its ability to satisfy
its debt obligations.
N. Calculate the 2014 inventory turnover, days sales outstanding (DSO), fixed assets turnover, and total assets turnover. How does Computron's utilization of assets stack up against that of other firms in its industry?
Inventory turnover ratio = sales / inventory
Inventory turnover ratio = $7,035,600 / $1,716,480 = 4.1
DSO = Accounts Receivables / (Sales / 360)
DSO = $878,000 / ($7,035,600 / 360) = 44.9 Days
Fixed assets turnover = Sales / Net fixed assets
Fixed assets turnover = $7,035,600 / $836,840 = 8.4
Total assets turnover = Sales / Total assets
Total assets turnover = $7,035,600 / $3,516,952 = 2.0
Computron's inventory ratio has steadily declined over the past three years, now well below
the industry average. This indicates the company's inability to effectively move its older inventory
items out of stock. The company's days sales outstanding conversely, has steadily increased to a
point well above the industry average, in indication that the company is not very successful in
its collection efforts. Turning over the fixed assets of the company, while improving, is still well
above industry standards, which combined with the company's still below average total assets
turnover ratio, is indicative of the company's ongoing inability to effectively manage its assets.
O. Calculate the 2014 debt ratio, liabilities-to-assets ratio, times-interest-earned, and EBITDA coverage ratios. How does Computron compare with the industry with respect to financial leverage? What can you conclude from these ratios?
Debt ratio = Total debt / Total assets
Debt ratio = ($1,039,800 + $500,000) / $3,516,952 = 43.8%
TIE = EBIT / Interest expense
TIE = $502,640 / $80,000 = 6.3
EBITDA Coverage = (EBITDA + Lease Payments) / (Interest + Loan Repayments + Lease Payments)
EBITDA Coverage = ($502,640 + $120,000 + $40,000) / ($80,000 + $40,000) = 5.5
Computron's debt and EBITDA coverage ratios for 2014, while forecasted to improve over 2013
results are still below industry standards. This is an indication that the firm while having improved
in its debt management efforts, still has a way to go before it reaches industry standards.
The firm's projected TIE or times-interest-earned ratio is forecasted to place the firm's figure slightly
above industry standards, which means that the firm will effectively be managing the interest
on its debt obligations.
P. Calculate the 2014 profit margin, basic earning power (BEP), return on assets (ROA), and return on equity (ROE). What can you say about these ratios?
Profit margin = Net income / sales
Profit margin = $253,584 / $7,035,600 = 3.6%
Basic earning power = EBIT / Total assets
Basic earning power = $502,640 / $3,516,952 = 14.3%
ROA = Net income / Total assets
ROA = $253,584 / $3,516,952 = 7.2%
ROE = Net income / Common equity
ROE = $253,584 / $1,977,152 = 12.8%
Computron's forecast for its 2014 profit margin will match industry standards. While its forecasted
results for its basic earning power, ROA, and ROE will having improved, will still result in the firm
being below industry standards for the year. Another indication that the firm has a way to go
before it can be said that it is effectively utilizing its assets to generate higher returns.
Q. Calculate the 2014 price/earnings ratio, price/cash flow ratio, and market/book ratio. Do these ratios indicate that investors are expected to have a high or low opinion of the company?
EPS = Net income / Shares Outstanding
EPS = $253,584 / 250,000 = $1.01
Price / Earnings = Price Per Share / Earnings Per Share
Price / Earnings = $12.17 / $1.01 = 12.0
Cash flow / Share = (Net income + Depreciation expense) / Shares
Cash flow / Share = ($253.584 + $120,000) / 250,000 = $1.49
Price / Cash flow = $12.17 / $1.49 = 8.1
Book value per share = Common equity / Shares outstanding
Book value per share = $1,977,152 / 250,000 =
Market / Book = Market Price Per Share / Book Value Per Share
Market / Book = $12.17 / $7.91 = 1.5
In looking at Computron's price/earnings, price/cash flow, and market/book ratios, it can be
seen that the forecasted 2001 figures will be a substantial improvement over prior year results, with
the company's forecasted price/cash flow ratio exceeding the industry average.
However, the forecasted price/earnings and market/book ratios will still be below industry
standards, another indication that the company will still have to make an improvement on its ability
to generate profit from its available assets.
R. Perform a common size analysis and percentage change analysis. What do these analyses tell you about Computron?
From the common size analysis performed on Computron's balance sheet, it can clearly be seen that
for 2014, that the company plans to increase its total current assets over its 2013 results, while at the
same time reducing its fixed asset base a corresponding amount for the upcoming year. The firm
also plans to reduce its current and long-term debt obligations in 2014, primarily through the issuance
of common stock which is expected to increase from 15.9% of total liabilities and owners' equity in
2010 to 47.8% of total liabilities and owners' equity in 2014.
The company's common size income statement is projecting a reduction in Computron's cost of goods
sold for 2014, which will result in a similar increase in the company's EBIT, EBT and Net income for
the upcoming year.
S. Use the extended DuPont equation to provide a summary and overview of Computron's financial condition as projected for 2014. What are the firm's major strengths and weaknesses?
Du Pont Equation = Profit margin ratio x Total assets turnover x Equity Multiplier
Du Pont Equation = Profit margin ratio x Total assets turnover x (Total Assets / Total Stockholders' Equity)
2014 Du Pont Equation = 3.6% x 2.0 x (3,516,952 / 1,977,152) = 12.8%
2013 Du Pont Equation = -1.6% x 2.0 x (2,886,592 / 557,632) = -16.6%
2012 Du Pont Equation = 2.6% x 2.3 x ( 1,468,800 / 663,768 ) = 13.2%
In viewing the resulting Du Pont equations for the years 2014, 2013 and 2012, it can readily be
seen that the company while experiencing severe problems in utilizing its assets to generate
a profit in 2013, did manage to basically return to its 2012 level of efficiency in 2014, which in
turn increased the financial leverage of the firm to a more respectable level.
Some of Computron's the most notable strengths are its ongoing effort to reduce its debts, which can be
seen in the company's steadily decreasing quick and debt ratios. As the company plans to reduce both
its short and long-term debt in 2014, its quick and debt ratios will ultimately be lower than the industry
standards in the upcoming year.
The company has also been very effective at managing its expenses, bringing expenses from a high of
an 111.8% increase over 2012 results, to an all-time low of 80.3% over 2012 results in 2014. A substantial
savings that will add greatly to the company's 2014 bottom line.
While effective at minimizing its debt, Computron has not been very effective at utilizing its assets,
short term and fixed to generate increased profitability for the firm. The firm's basic earning power
ratio, along with its ROA, and ROE ratios are down in comparison to industry standards, which means
that the company is not as profitable as it could be. The firm's extremely high days sales outstanding,
along with its relatively low total assets turnover ratio, are also indicative of operational inefficiencies,
another operational problem that could be rectified with more effective management.
Rebounding from 2013, a forgettable year in which the company was hit by an 80% increase in its Cost of
Goods Sold, and a staggering 182% increase in Interest Expense, Computron is looking forward to a return
to profitability in 2014. With an estimated 21% increase in Sales Revenue forecasted for 2014, combined
with an anticipated decrease in its Total Operating Costs to 2012 year levels (93% of Sales Revenue),
primarily due to effective management of its assets, Computron expects to generate a Net Income of
$253,584, which would be a vast improvement over the firm's $95,136 Net Income loss in 2013.
f. T. What are some potential problems and limitations of financial ratio analysis?
Financial ratio analysis is a form of financial statement analysis that can be used to obtain a relatively
quick indication of a firm's financial performance in several key areas, making the practice one of the
most powerful tools of financial management.
However, because financial ratios are based on accounting information (data), it is subject to errors,
both human and mechanical.
The limitation of financial statements - Ratios are based only on the information which has been
recorded in financial statements. Financial statements are subject to several limitations. Thus ratios
derived there from, are also subject to those limitations.
Comparative study is required - Ratios are useful in judging the efficiency of a business only when
they are compared with past results of the business. Such a comparison only provides a glimpse
of past performance and forecasts for the future may not prove correct, since several other
factors like market conditions, management policies, etc. may affect future operations
Ratios alone are not adequate - Ratios are only indicators, they cannot be taken as final regarding
good or bad financial position of a business. Other things have also to be seen.
Problems of price level change - A change in price level can affect the validity of ratios
calculated for different time periods. In such a case a ratio analysis may not clearly indicate the
trend in solvency and profitability of a company. The financial statements should therefore be
adjusted, if a meaningful comparison is to be made through accounting ratios.
Lack of adequate standard - No fixed standard can be laid down for ideal ratios. There are no
well accepted standards or rule of thumb for all ratios which can be accepted as norm, making
the interpretation of ratios difficult.
Limited use of single ratios - A single ratio, usually, does not convey much of a sense. To make a
better interpretation, a number of ratios have to be calculated, which is like to confuse an
analyst rather than help him or her to make a god decision.
Personal bias - Ratios are only a means of financial analysis, and not an end in itself. Ratios have
to be interpreted and different people may interpret the same ratio in a different way.
Incomparability - Not only do industries differ in their nature, but also the firms in a similar business
widely differ in their size and accounting procedures, etc., making the comparison of their
respective ratios difficult and/or misleading.
U. What are some qualitative factors that analysts should consider when evaluating a company's likely future financial performance?
A thorough financial analysis involves much more than just calculating numbers. There are also
qualitative factors that should be considered when attempting to evaluate a company's past, present,
and most importantly - when forecasting future performance
Some of the qualitative factors that an analyst should consider when attempting to evaluate a company's
likely future performance are:
- What does the company do?
- Who are the company's senior officers and management team?
- What is the corporate culture?
- What is the company's corporate governance model?
- What is the company's business model?
- What are the company's goals and/or business objectives?
- To who is the company's revenues tied to?
- How many products are the company's revenue dependent upon?
- What is company's competitive situation?
- Is there a mark for the company products?
- What is the company's legal and/or regulatory environment?
- What does the future hold in for the company and its industry?
- What is the relationship between the company and its suppliers?
- Does the company have overseas operations?
These are but a few factors that should be examined when conducting an evaluation of company's
likely future performance, as each can, and does have an impact on the company's bottom line.
Brigham, Eugene F., and Michael C. Ehrhardt. Financial Management: Theory and Practice. Mason, OH: South-Western, 2014. Print.View Full Posting Details