![Fundamentals of Financial Management, Concise Edition (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781305635937/9781305635937_largeCoverImage.gif)
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 balance sheet figures.
cCalculation is based on a 365-day year.
a.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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
Fundamentals of Financial Management, Concise Edition (MindTap Course List)
- 1. At the beginning of the year, a mutual fund has a NAV of $20. At the end of the year, the NAV is $21 and the fund has received no dividends or other distributions throughout the year. The return on the fund’s benchmark over the same period of time was 10%. What was the return to investors in the fund? Did the fund’s return to investors beat the benchmark return? a. 5%; No, the fund did not beat its benchmark b. 10%; No, the fund did not beat its benchmark c. 15%; No, the fund did not beat its benchmark d. 20%; Yes, the fund beat its benchmark e. None of the above 2. You are advising a pension fund that is required to have a portfolio risk of 5%. Which of the following would be the portfolio optimization problem for constructing their fund? a. Maximize return subject to a constraint that portfolio volatility is 5% b. Not enough information c. Maximize the Sharpe ratio with no additional constraints d. Minimize the risk needed to get their long-term return target e. None of the…arrow_forwardHow the Synthesizing Qualitative Research Methodology in Case Study Research can be used in case of the collapse of Circuit City? What cause the Circuit City Failed to Adapt to E-commerce? Why DMAIC, a data-driven problem-solving method, and Lean Six Sigma did not save Circuit City?arrow_forwardHow was the poor strategic decisions lead to economic downturns of Circuit City Company? What are the sequence of key events and problems that contribute to its collapse. Could you please explain each one them? How Lean Six Sigma businesses can reduce waste, improve efficiency, and enhance customer satisfaction?arrow_forward
- Suppose you deposit $9500 into an savings account earning 5% annual interest compounded continuously. To pay for all your music downloads, each year you withdraw $1000 in a continuous way. Let A(t) represent the amount of money in your savings account t years after your initial deposit. (A) Write the DE model for the time rate of change of money in the account. Also state the initial condition. dA dt A(0) (B) Solve the IVP to find the amount of money in the account as a function of time. A(t)= (C) When will your money run out? t = yearsarrow_forwardWhat support comment would be for the Creating Problem Statements and Applicable Research Questions for Sears collapse? Could explain and show the problem is happening from the perspective of the leader who has the problem in Sears company? How Sear problem would be soved? What are other elements of the problem, could you give some assumptions about the problem, or give recommendations to mitigate the problem?arrow_forwardAn S corporation earns 59.10 per share before taxes. The corporate tax rate is 39%, the personal tax rate on dividends is 15%, and the personal tax rate on non-dividend income is 36%. What is the total amount of earnings after - taxes? a. $3.28 b. $3.93 c. $2.62 d. $4.59arrow_forward
- You want to buy a new sports car from Muscle Motors for $36,000. The contract is in the form of an annuity due for 60 months at an APR of 8.00 percent. What will your monthly payment be?arrow_forwardUse the following information to answer this question: Net sales Windswept, Incorporated 2024 Income Statement Cost of goods sold Depreciation ($ in millions) Earnings before interest and taxes Interest paid Taxable income Taxes Net income $ 14,150 8,150 515 $ 5,485 108 $ 5,377 1,129 $ 4,248 Windswept, Incorporated 2023 and 2024 Balance Sheets ($ in millions) 2023 2024 2023 2024 Cash Accounts received $ 300 $ 330 Accounts payable $ 1,980 $1,955 1,190 1,090 Long-term debt 1,110 1,430 Inventory 2,120 1,795 Common stock 3,440 3,080 Total $ 3,610 $ 3,215 Retained earnings 690 940 Net fixed assets 3,610 Total assets $ 7,220 4,190 $ 7,405 Total liabilities & equity $ 7,220 $ 7,405 What is the fixed asset turnover for 2024?arrow_forward9. Calculating Payments [LO3] The Bandon Pine Corporation's purchases from suppliers in a quarter are equal to 75 percent of the next quarter's forecast sales. The payables period is 60 days. Wages, taxes, and other expenses are 20 percent of sales, and interest and dividends are $110 per quarter. No capital expenditures are planned. Projected quarterly sales are shown here: Sales Q1 $2,250 Q2 $2,730 Sales for the first quarter of the following year are projected at $2,475. Calculate the company's cash outlays by completing the following: Payment of accounts Wages, taxes, other expenses Long-term financing expenses (interest and dividends) Total Q3 $2,390 Q4 $2,190 Q1 Q2 Q3 Q4arrow_forward
- The average daily net transaction accounts of a local bank during the most recent reserve computation period is $341 million. The amount of average daily reserves at the Fed during the reserve maintenance period is $26.20 million, and the average daily vault cash corresponding to the maintenance period is $5.8 million. (Example13-2). a. Under the rules effective in 2020, what is the average daily reserve balance required to be held by the bank during the maintenance period? b. Is the bank in compliance with the reserve requirements?arrow_forwardWhat are the LSS and characteristics of LSS tools used in a research study? What is Lean Six Sigma and what is the possible benefits of using Lean Six Sigma? What are the seven LSS tools, could you please explain the characteristics of each tool, and state how the tool would be used to in a case study? How Lean Six Sigma brings a hint of all three traditional types of research (qualitative, quantitative, and mixed methods) to bear on Case Study research and business solutions?arrow_forwardSelect a real-world case situation. Use this case which you either know about already or have identifiedthrough research and address the following questions in essay format:.i. Outline and discuss what “triggered” the regulatory body to intervene? ii. How effective do you think the response was to such a crisis? iii. Outline and discuss two ways that could be used to strengthen the current regulatoryarrow_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
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337690881/9781337690881_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781285065137/9781285065137_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305635937/9781305635937_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781285190907/9781285190907_smallCoverImage.gif)