RATIO ANALYSIS The Corrigan Corporation's 2017 and 2018 financial
statements follow, along with some industry average ratios.
a. Assess Corrigan's liquidity position, and determine how it
compares with peers and how the liquidity position has changed
over time.
b. Assess Corrigan's asset management position, and determine
how it compares with peers and how its asset management
efficiency has changed over time.
c. Assess Corrigan's debt management position, and determine
how it compares with peers and how its debt management has
changed over time.
d. Assess Corrigan's profitability ratios, and determine how they
compare with peers and how its profitability position has changed
over time.
e. Assess Corrigan's market value ration, and determine how its
valuation compares with peers and how it has changed over time.
Assume the firm's debt is priced at par, so the market value of its
debt equals its book value.
f. Calculate Corrigan's ROE as well as the industry average ROE,
using this DuPont equation. From this analysis, how does
Corrigan's financial position compare with the industry average
numbers?
g. What do you think would happens to its ratios if the company
mil ailed cost-culling measures that allowed it to hold lower levels
of inventory and substantially decreased the cost of goods sold? No
calculations die necessary. Think about which ratios would be
affected by changes in these two accounts.
Corrigan Corporation: Balance Sheets as of December 31
2018 | 2017 |
cash | $72,000 | $65,000 |
Account recivable | 439,000 | 328.000 |
Inventories | 894,000 | 813,000 |
Tount current assets | $1,405,000 | $1,206,000 |
Land and bullding | 258.000 | 271.000 |
Mechinary | 132.000 | 133,000 |
Other fixed assets | 61.000 | 57,000 |
Total assets | $1,836,000 | $1,667,000 |
Accounts payeble | $80,000 | $72,706 |
Accured liabilities | 45,010 | 40,880 |
Notes payeble | 476,990 | 457,912 |
Total current liablities | $602.000 | $571,500 |
Long term dept | 404,290 | 258,898 |
Common stock | 575,000 | 575,000 |
254,710 | 261,602 |
Total liabilities and equity | $1,836,000 | $1,667,000 |
corigan corporation: income statement for years ending December 31
2018 | 2017 |
sales | $4,240,000 | $36,35,000 |
cost of goods sold | 3,680,600 | 2,980,000 |
Gross operating profits | $560,000 | $655,000 |
General adiministrative and selling express | 303,320 | 297,550 |
159,000 | 154,500 |
EBIT | $97,680 | V 201050 |
Interest | 67,000 | 43,000 |
Earning before taxes(EBT) | $30,680 | $159,950 |
Taxes(40) | 12,272 | 63,970 |
Net income | $18,400 | $95,970 |
Per share data
2018 | 2017 |
EPS | $080 | $417 |
Cash dividends | $1.10 | $095 |
Market price (average) | $12.34 | $23 57 |
P/E ratio | 15.42x | 5.65x |
Number of share outstanding | 23,000 | 23,000 |
Industry Financial Ratio
2018 |
2.7* |
Inventory Turnover | 7.0* |
Days sales outstanding | 32.0 days |
Fixed assetsTurnover | 13.0* |
Total assets turnover | 2.6* |
Return on assets | 9.1% |
Return on equity | 18.2% |
Return on invested capital | 14.5% |
Profit margin | 3.5% |
Debt-to-capital ratio | 50.0% |
P/E ratio | 6.0* |
M/B ratio | 1.5 |
EV/EBITDA ratio | 6.0 |
*Industry average ratios have been constant for the past 4 years.
*Based on year-end
*Calculation is based on a 365 day year.
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps
- Please complet the vertical analysis table and summurize your observations about changes in finacial trends, in the following income statement line items ( net sales, operting income and net earnings attributable to proter and gamble)arrow_forwardCostco Financial Analysis. Perform the following ratio analysis for 2021, 2022, and 2023 for Costco using the attached financial statements. a. Profitability ratios b. Liquidity ratios c. Leverage ratios d. Activity ratios e. Price to earnings ratioarrow_forwardMatch each ratio that follows to its use. Items may be used more than once.arrow_forward
- Calculate the following profitability ratios for 2018 and 2019. a. Gross profit ratio b. Return on assets c. Profit margin d. assets turnoverarrow_forwardCalculate the ratios of Woolworths Group (Australian retail company) for the year 2021: Ratios to calculate: Profitability (ROSF, ROCE, Gross margin, Operating profit margin, Cash flow to Sales*) Efficiency (Inventory turnover period, Average settlement period, Sales revenue to capital employed) Liquidity (Current ratio, Acid test (quick) ratio, Cash flow ratio*). Stability/Capital Structure (Gearing ratio, Interest cover ratio, Debt coverage ratio*) Investment/Market Performance (Earnings per share, Price earnings ratio, Operating cash flow per share*)arrow_forwardUsing the financial statements in the image, calculate the following ratios for both the FY 2017 and FY 2018: Current Ratio Quick Ratio Total Asset Turnover Average Collection Total Debt to Total Assets Times Interest Earned Net Profit Margin Return on Assets Return on Equity Modified Du Point Equation for FY 2018 PE Ratio Market to Book Ratioarrow_forward
- Compute Liquidity and Solvency Ratios for Competing Firms Halliburton and Schlumberger compete in the oil field services sector. Refer to the following 2018 financial data for the two companies to answer the requirements. $ millions Cash and equivalents Short-term investments Accounts receivable Current assets Current liabilities Total liabilities Total equity Earnings before interest and tax (EBIT) Interest expense, gross HAL SLB $2,008 $1,433 1,344 5,391 8,117 11,151 15,731 4,946 13.891 16,438 33,921 1. Current ratio 2. Quick ratio 3. Times interest earned 4. Liabilities-to-equity 9,830 37,684 2,541 3,142 554 537 a. Compute the following measures for both companies. Note: Round your final answers to two decimal places (for example, enter 6.78 for 6.77555). HAL SLB b. Which company appears more liquid? c. Which company appears more solvent? ◆arrow_forwardCalculate the Rate of Return on Assets (ROA) for 2011. Disaggregate ROA into the profit margin for ROA and total assets turnover components. Calculate the Rate of Return on Common Stockholders’ Equity (ROCE) for 2011. Disaggregate ROCE into the profit margin for ROCE, total assets turnover and capital structure leverage components.arrow_forwardPrepare a financial statement analysis in terms of liquidity, solvency, profitability and efficiency of the following company. Financial Ratios Fiscal Year Ended Previous Fiscal Year Formula Dec 31, 2019 Dec 31, 2018 Liquidity Analysis Ratios: Current Assets / Current Liabilities Current Ratio or 1.46 1.36 Working Capital Ratio (Current Assets - Inventory - Prepayments) / Current Liabilities Quick Ratio 0.96 0.86 Solvency Ratio Total Assets / Total Liabilities 1.46 1.44 Financial Leverage Ratios Debt Ratio Total Debt/Total Assets 0.47 0.48 Total Debt/Total Stockholders Equity Debt-to-Equity Ratio 1.48 1.57 Earnings Before Interest and Taxes (EBIT) / Interest Charges Total Assets / Total Stockholders' Equity Interest Coverage 2.38 2.61 Asset to Equity Ratio 3.16 3.28 Profitability Ratios Gross Profit Margin Sales - Cost of Goods Sold or Cost of Service / Sales 19.76 19.43 Net Profit Margin Net Profit / Sales 11.34 11.42 Net Income / Total Assets 2.67 2.9 Return on Assets Net Income /…arrow_forward
- a) Consider the financial ratios of ABK Bank and the average ratios of peer banks based on 2015 year-end data shown in the table below: Ratios ABK Bank Peer Banks Return on equity (ROE) 14.50% 7.40% Return on assets (ROA) Asset utilisation (AU) Expense ratio (ER) 1.68% 0.85% 6.65% 5.50% 4.95% 4.62% TAX 0.02% 0.03% Note that TAX = applicable income tax/total assets Compare and critically discuss the performance of ABK Bank and that of its peer banks. Conduct a return on equity decomposition analysis for ABK bank and the peer banks as part of your discussion. What are the possible limitations in your analysis?arrow_forwardBased on this analysis how would I assess the financial stability and operational efficiency of this company? Ratio and Ratio Formula (in thousands) 2015 2014 2013 Current Industry Average Liquidity Current Ratio =Current Asset / Current Liability 9,900/6,300 1.57 1.61 1.62 1.63 Acid Test Ratio or Quick Ratio = (Cash + Marketable securities + Accounts receivable)/Current liabilities (400+300+3,200)/6,300 0.62 0.64 0.63 0.68 Solvency Times Interest Earned =Earnings before interest & taxes/interest expense, gross (7,060+900)/900 8.84 8.55 8.5 8.45 Profitability Profit margin on sales = net income/sales 7,060/30,500 14% 13.20% 12.10% 13.00% Productivity Asset turnover = sales/avg total assets 30,500/6,000+5,400)/2) 1.85 1.84 1.83 1.84 Inventory turnover = COGS/avg inv 17,600/ (6,000+5,400)/2) 3.09 3.17 3.21 3.18arrow_forwardCalculate the ratios of Coles group of Australia for the year 2019: Ratios to calculate: Profitability (ROSF, ROCE, Gross margin, Operating profit margin, Cash flow to Sales*) Efficiency (Inventory turnover period, Average settlement period, Sales revenue to capital employed) Liquidity (Current ratio, Acid test (quick) ratio, Cash flow ratio*). Stability/Capital Structure (Gearing ratio, Interest cover ratio, Debt coverage ratio*) Investment/Market Performance (Earnings per share, Price earnings ratio, Operating cash flow per share*)arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education