RATIO ANALYSIS The Corrigan Corporation’s 2015 and 2016 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 ratios, and determine how its valuation compares with peers and how it has changed over time.
- f. Calculate Corrigan’s ROE as well as the industry average KOE, using the DuPont equation. From this analysis, how does Corrigan’s financial position compare with the industry average numbers?
- g. What do you think would happen to its ratios if the company initiated cost-cutting measures that allowed it to hold lower levels of inventory and substantially decreased the cost of goods sold? No calculations are necessary. Think about which ratios would be affected by changes in these two accounts.
Corrigan Corporation: Balance Sheets as of December 31
2016 | 2015 | |
Cash | $ 72,000 | $ 65,000 |
Accounts receivable | 439,000 | 328,000 |
Inventories | 894,000 | 813,000 |
Total current assets | $1,405,000 | $1,206,000 |
Land and building | 238,000 | 271,000 |
Machinery | 132,000 | 133,000 |
Other fixed assets | 61,000 | 57,000 |
Total assets | $1,836,000 | $1,667,000 |
Accounts payable | $ 80,000 | $ 72,708 |
Accrued liabilities | 45,010 | 40,880 |
Notes payable | 476,990 | 457,912 |
Total current liabilities | $ 602,000 | $ 571,500 |
Long-term debt | 404,290 | 258,898 |
Common stock | 575,000 | 575,000 |
254,710 | 261,602 | |
Total liabilities and equity | $1,836,000 | $1,667,000 |
Corrigan Corporation: Income Statements for Years Ending December 31
2016 | 2015 | |
Sales | $4,240,000 | $3,635,000 |
Cost of goods sold | 3,680,000 | 2,980,000 |
Cross operating profit | $ 560,000 | $ 655,000 |
General administrative and selling expenses | 303,320 | 297,550 |
Depreciation | 159,000 | 154,500 |
EBIT | $ 97,680 | $ 202,950 |
Interest | 67,000 | 43,000 |
Earnings before taxes (EBT) | $ 30,680 | $ 159,950 |
Taxes (40%) | 12,272 | 63,980 |
Net income | $ 18,408 | $ 95,970 |
Per-Share Data
2016 | 2015 | |
EPS | $ 0.80 | $ 4.17 |
Cash dividends | $ 1.10 | $ 0.95 |
Market price (average) | $12.34 | $23.57 |
P/E ratio | 15.42× | 5.65× |
Number of shares outstanding | 23,000 | 23,000 |
Industry Financial Ratiosa
2016 | |
Current ratio | 2.7× |
Inventory turnoverb | 7.0× |
Days sales outstandingc | 32.0 days |
Fixed assets turnoverb | 13.0× |
Total assets turnoverb | 2.6× |
9.1% | |
18.2% | |
14.5% | |
Profit margin | 3.5% |
Debt-to-capital ratio | 50.0% |
P/E ratio | 6.0× |
aIndustry average ratios have been constant for the past 4 years.
bbased on year-end
cCalculation is based on a 365-day year.
a.
To determine: The liquidity position of C Corporation, comparison of liquidity position with peers and the changes in liquidity position over the time.
Ratio Analysis:
Ratio is used to compare two arithmetical figures. In case of the ratio analysis of the company the financial ratios are calculated. The financial ratios examine the performance of the company and is used in comparing with other same business. It indicates relationship of two or more parts of the financial statements.
Liquidity Position: The liquidity position of the company is indicated by liquidity ratios which gives the idea whether the firm has ability to pay back its liabilities which has less than one year of maturity.
Explanation of Solution
Current ratio
2015
Given,
Current asset is $1,206,000.
Current liabilities is $571,500.
The formula to calculate current ratio is,
Substitute $1,206,000 for current assets and $571,500 for current liabilities.
Thus, current ratio is 2.11 times.
2016
Given,
Current asset is $1,405,000.
Current liabilities is $602,000.
The formula to calculate current ratio is,
Substitute $1,405,000 for current assets and $602,000 for current liabilities in above formula.
Thus, current ratio is 2.33times.
Comparison:
Ratios | Year 2015 | Year 2016 | Industry |
Current ratio | 2.11 times | 2.33 times | 2.7 times |
Table (1)
The current ratio of the company in year 2016 has been increased so it can be said that the liquidity position of the company is improved.
Therefore, the liquidity position is improved in year 2016 as comparison to year 2015 but it is lower than industry average.
b.
To determine: The Assets management position of C Corporation, comparison of assets management position with peers and the changes in assets management position over the time.
Assets Management Position: The assets management position of the company is indicated by assets management ratios which give idea how well the company is using its assets.
Explanation of Solution
Inventory turnover ratio:
2015
Given,
Total sale is $3,635,000.
Total inventory is $813,000.
The formula of inventory turnover ratio is,
Substitute $3,635,000 for total sales and $813,000 for total inventory.
Thus, inventory turnover ratio is 4.47 times.
2016
Given,
Total sale is $4,240,000
Total inventory is $894,000.
The formula of inventory turnover ratio is:
Substitute $4,240,000 for total sales and $894,000 for total inventory.
Thus, inventory turnover ratio is 4.74 times.
Days sales outstanding
2015
Given,
Receivables are $328,000.
Annual sale is $3,635,000.
The formula to calculate days sales outstanding is,
Substitute $328,000 for account receivables and $3,635,000 for annual sales.
Thus, day’s sales outstanding is 32.94 days.
2016.
Given,
Receivables are $439,000.
Annual sale is $4,240,000.
The formula to calculate days sales outstanding is,
Substitute $439,000 for account receivables and $4,240,000 for annual sales.
Thus, days sales outstanding is 37.79 days.
Fixed assets turnover
2015
Given,
Sales are $3,635,000.
Total fixed assets are $461,000.
The formula to calculate fixed assets turnover is,
Substitute $3,635,000 for total sales and $461,000 for fixed assets.
Thus, fixed assets turnover is 7.89times.
Working notes:
Compute total fixed assets.
Given,
Land and building is$271,000.
Machinery is $133,000.
Other fixed assets are $57,000.
Calculation of total fixed assets,
Thus, total amount of fixed assets is $461,000.
2016
Given,
Sales are $4,240,000.
Total fixed assets are $431,000.
The formula to calculate fixed assets turnover is,
Substitute $4,240,000 for total sales and $431,000 for fixed assets.
Thus, fixed assets turnover is 9.84times.
Working notes:
Compute total fixed assets.
Given,
Land and building is $238,000.
Machinery is $132,000.
Other fixed assets are $61,000.
The total amount of the fixed assets is:
Thus, total amount of fixed assets is $431,000.
Total assets turnover
2015
Given,
Total sales are $3,635,000.
Total assets are $1,667,000.
The formula of total assets turnover is,
Substitute $3,635,000 for total sales and $1,667,000 for total assets.
Thus, total assets turnover is 2.18 times.
2016
Given,
Total sales are $4,240,000.
Total assets are $1,836,000.
The formula of total assets turnover is,
Substitute $4,240,000 for total sales and $1,836,000 for total assets.
Thus, total assets turnover is 2.31 times.
Comparison
Ratios | Year 2015 | Year 2016 | Industry |
Inventory turnover ratio | 4.47 times | 4.74 times | 7 times |
Days sales outstanding | 32.94 days | 37.79 days | 32 days |
Fixed assets turnover | 7.89 times | 9.84 times | 13 times |
Total assets turnover | 2.18 times | 2.31 times | 2.60times |
Table (2)
- The inventory turnover ratio has been improved in year 2016 comparing to 2015. However it is lower than industry average.
- Days sales outstanding is higher in 2016, the company should look over the receivables to be collected if the credit policy is same. It is somehow close to the industry average.
- Fixed assets turnover has been increased in 2016 comparing to 2015. But it is still below the industry average.
- Total assets turnover is increased in 2016 comparing it to 2015. The industry average seems higher than company.
Therefore, the assets management ratios are improved in 2016 comparing 2015 but ratios are still below the industry’s average.
c.
To determine: The debt management position of C Corporation, comparison of debt management position with peers and the changes in debt management position over the time.
Debt Management Position: Debt management position is indicated by the debt management ratios which give an idea how the company finances its assets as well as the capability to pay back its long-term debt.
Explanation of Solution
Debt-to capital ratio
2015
Given,
Total debt is $716,810.
Equity is $836,602.
The formula of debt-to-capital ratio is,
Substitute $716,810 for total debt and $836,602 for equity in above formula.
Thus, debt-to-capital ratio is 46.41%.
Working notes:
Compute total debt.
Given,
Long term debt is $258,898.
Notes payable is $457,912.
Calculation of total debt,
Thus, total debt is $716,810.
Compute the total value of equity.
Common stock is $575,000.
Retained earnings are $261,602.
Calculation of total equity value,
Thus, total equity value is $836,602.
2016
Given,
Total debt is $881,280.
Equity is $829,710.
The formula of debt-to-capital ratio is,
Substitute $881,280 for total debt and $829,710 for equity.
Thus, debt-to-capital ratio is 51.50%.
Working notes:
Compute total debt.
Long term debt is $404,290.
Notes payable is 476,990.
Calculation of total debt,
Thus, the total debt is $881,280.
Compute the total value of equity.
Common stock is $575,000.
Retained earnings are $254,710.
Calculation of total equity value
Thus, total equity value is $829,710.
Compute total debt.
Long term debt is $404,290.
Notes payable is 476,990.
Calculation of total debt,
Thus, the total debt is $881,280.
Comparison:
Ratios | Year 2015 | Year 2016 | Industry |
Debt-to-capital ratio | 46.41% | 51.50% | 50% |
Table (3)
The debt ratio of the company has been increased in year 2016 which is not good. In 2015 it was lower than industry average but in 2016 it is higher than industry average.
Therefore, the debt management position of the company is not good in year 2016 the company should improve its position by paying the liabilities.
d.
To determine: The profitability ratio of C Corporation, compare it with peers and the change in the profitability of the company over the time.
Profitability Ratios: These ratios give an idea whether the company is able to operate profitably and is efficient in using its assets.
Explanation of Solution
Return on assets
2015
Given,
Net income is $95,970.
Total asset is $1,667,000.
The formula of return on asset is,
Substitute $95,970 for net income and $1,667,000 for total value of assets.
Thus, return on assets is 5.76%.
2016
Given,
Net income is $18,408.
Total asset is $1,836,000.
The formula of return on asset is,
Substitute $18,408 for net income and $1,836,000 for total value of assets.
Thus, return on assets is 1%.
Return on equity
2015
Given,
Net income is $95,970.
Equity is $836,602.
The formula of return on equity is,
Substitute $95,970 for net income and $836,602 for equity.
Thus, return on equity is 11.47%.
Working notes:
Compute the total value of equity.
Common stock is $575,000.
Retained earnings are $261,602.
Calculation of total equity value,
Thus, total equity value is $836,602.
2016
Given,
Net income is $18,408.
Equity is$829,710.
The formula of return on equity is,
Substitute $18,408 for net income and $829,710 for equity.
Thus, return on equity is 2.21%.
Working note:
Compute the total value of equity.
Common stock is $575,000.
Retained earnings are $254,710.
Calculation of total equity value,
Thus, total equity value is $829,710.
Return on invested capital
2015
Given,
Earnings before interest and tax (EBIT) is $202,950.
Tax rate is 40%.
Total debt is $ 716,810.
Total equity is $836,602.
The formula of return on invested capital is,
Substitute $202,950 for EBIT, $716,810 for debt and $836,602 for equity.
Thus, return on invested capital is 7.83%.
Working note:
Compute total debt.
Long term debt is $258,898.
Notes payable is 457,912.
Calculation of total debt,
Thus, the total debt is $716,810.
2016
Given,
Earnings before interest and tax (EBIT) are $97,680.
Tax rate is 40%.
Total debt is $881,280.
Total equity is $829,710.
The formula of return on invested capital is,
Substitute $97,680 for EBIT, $881,280 for debt and $829,710 for equity.
Thus, return on invested capital is 3.42%.
Working note:
Compute total debt.
Long term debt is $404,290.
Notes payable is 476,990.
The total debt of the company is,
Thus, the total debt is $881,280.
Compute the total value of equity.
Common stock is $575,000.
Retained earnings are $254,710.
Calculation of total equity value,
Thus, total equity value is $829,710.
Profit margin
2015
Given,
Net income is $95,970.
Sales are $3,635,000.
The formula to calculate profit ratio is,
Substitute $95,970 for net income and $3,635,000 for sales.
Thus, profit ratio is 2.64%.
2016
Given,
Net income is $18,408.
Sales are $4,240,000.
The formula to calculate profit ratio is,
Substitute $18,408 for net income and $4,240,000 for sales.
Thus, profit ratio is 0.43%.
Comparison
Ratios | Year 2015 | Year 2016 | Industry |
Return on assets | 5.76% | 1% | 9.1% |
Return on equity | 11.47% | 2.21% | 18.2% |
Return on invested capital | 7.83% | 3.42% | 14.5% |
Profit margin | 2.64% | 0.43% | 3.5% |
Table (4)
- Return on assets has been declined in year 2016 comparing to 2015 and it I lower than industry average.
- Return on equity has been declined in year 2016 comparing to 2015 and it is lower than industry average
- Return on invested capital is declined in year 2016 comparing to 2015 and it is lower than industry average.
- The profit margin has fallen in 2016 comparing to 2015 and it is lower than industry average.
Therefore, the profitability ratios have been declined in year 2016 comparing to 2015 and are lower than the industry’s average.
e.
To determine: The market value ratios, comparison of ratios with peers and changes in market values over the time.
Market Value Ratios: The market value ratios give idea about the view of investors towards the company and company’s future scenario.
Explanation of Solution
Comparison
Ratios | Year 2015 | Year 2016 | Industry |
P/E ratio | 5.65 | 15.42 | 6 |
Table (5)
P/E ratio of 2015 is 5.65 times and P/E ratio in 2016 is 15.42. The P/E ratio has been increased in the year 2016 comparing to 2015. It is higher than industry average.
Therefore, the market value ratios have been improved in year 2016 and higher than industry average.
f.
To calculate: The ROE of the C company as well industry average ROE using DuPont equation and way of comparing of Company’s financial position with industry’s average numbers.
Return on Equity (ROE): Return on equity is the return from the equity. It is the ratio of net income and shareholders’ equity. This ratio measures the performance of the company and tells how well the company is performing. This ratio is used to compare own firm with competitors.
Du Pont Equation: Among all ratios, return on equity is very common. It shows the value of the firm. Improvement in the ROE is considered as valued addition to the firm. ROE can be linked with other ratios. Analysis of such ratios will indicate proper reason for change in ROE. The combination is known as Du Pont equation which is shown below:
Explanation of Solution
The formula of ROE is,
Year 2015
Given,
Net income of the company is $95,970.
Sales of the company are $3,635,000.
Total asset is $1,667,000
Total common equity is $836,602.
The Du point relation of the company’s ratios is shown below,
Simplify the above equation to get
2016
Given,
Net income of the company is $18,408.
Sales of the company are $4,240,000.
Total asset is $1,836,000.
Total common equity is $879,710.
The Du point relation of the company’s ratios is shown below,
Simplify the above equation to get
Industry average
The industry has return on equity 18.2%.
- The ROE calculated on the basis of Du Pont Equation shows the profit margin lower in comparison to 2015 in year 2016 and also lower than industry average.
- The firms total assets turnover has been improved comparing to 2015 in year 2016.
- The equity multiplier has been increased in 2016 comparing to the 2015.
Therefore, return on equity in year 2015, 2016 and of industry are 11.47% 2.21%and 18.2% and the return on equity has been decreased in year 2016 comparing to 2015 and is lower than industry average.
g.
To identify: The changes in the ratios if the company initiated cost-cutting measures that allowed it to hold lower level of the inventory and substantially deceased the cost of goods sold.
Answer to Problem 25SP
The profitability ratios and market value ratios will be improved. Similarly, there will be decrease in level of the inventory which would improve the current ratio liability as well
There would be improvement in inventory turnover and total asset turnover ratios. The reduction in cost will also improve debt ratio.
If the C Corporation initiated the cost-cutting measures this would increase its net income.
Explanation of Solution
If the C Corporation initiated the cost-cutting measures this would increase its net income because the cost will get decreased. And also the liabilities will get decreased.
Therefore, if the company initiated the cost cutting measures that allowed holding lower level of inventory and substantially decreased cost of goods sold, the ratios of the company will be improved and net income will increase.
Want to see more full solutions like this?
Chapter 4 Solutions
FUND. OF FINANCIAL MGMT CONCISE (LL)
- A firm needs to raise $950,000 but will incur flotation costs of 5%. How much will it pay in flotation costs? Multiple choice question. $55,500 $50,000 $47,500 $55,000arrow_forwardWhile determining the appropriate discount rate, if a firm uses a weighted average cost of capital that is unique to a particular project, it is using the Blank______. Multiple choice question. pure play approach economic value added method subjective approach security market line approacharrow_forwardWhen a company's interest payment Blank______, the company's tax bill Blank______. Multiple choice question. stays the same; increases decreases; decreases increases; decreases increases; increasesarrow_forward
- For the calculation of equity weights, the Blank______ value is used. Multiple choice question. historical average book marketarrow_forwardA firm needs to raise $950,000 but will incur flotation costs of 5%. How much will it pay in flotation costs? Multiple choice question. $50,000 $55,000 $55,500 $47,500arrow_forwardQuestion Mode Multiple Choice Question The issuance costs of new securities are referred to as Blank______ costs. Multiple choice question. exorbitant flotation sunk reparationarrow_forward
- What will happen to a company's tax bill if interest expense is deducted? Multiple choice question. The company's tax bill will increase. The company's tax bill will decrease. The company's tax bill will not be affected. The company's tax bill for the next year will be affected.arrow_forwardThe total market value of a firm is calculated as Blank______. Multiple choice question. the number of shares times the average price the number of shares times the future price the number of shares times the share price the number of shares times the issue pricearrow_forwardAccording the to the Blank______ approach for project evaluation, all proposed projects are placed into several risk categories. Multiple choice question. pure play divisional WACC subjectivearrow_forward
- To invest in a project, a company needs $50 million. Given its flotation costs of 7%, how much does the company need to raise? Multiple choice question. $53.76 million $46.50 million $50.00 million $53.50 millionarrow_forwardWhile determining the appropriate discount rate, if a firm uses a weighted average cost of capital that is unique to a particular project, it is using the Blank______. Multiple choice question. economic value added method pure play approach subjective approach security market line approacharrow_forwardWhat are flotation costs? Multiple choice question. They are the costs incurred to issue new securities in the market. They are the costs incurred to insure the payment due to bondholders. They are the costs incurred to meet day to day expenses. They are the costs incurred to keep a project in the business.arrow_forward
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningFundamentals of Financial Management, Concise Edi...FinanceISBN:9781285065137Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
- Fundamentals of Financial Management, Concise Edi...FinanceISBN:9781305635937Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning