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
Bundle: Fundamentals of Financial Management, Concise Edition, Loose-leaf Version, 9th + Aplia, 1 term Printed Access Card
- General Financearrow_forwardAs CFO for Everything.Com, you are shopping for 6,000 square feet of usable office space for 25 of your employees in Center City, USA. A leasing broker shows you space in Apex Atrium, a 10-story multitenanted office building. This building contains 360,000 square feet of gross building area. A total of 54,000 square feet is interior space and is nonrentable. The nonrentable space consists of areas contained in the basement, elevator core, and other mechanical and structural components. An additional 36,000 square feet of common area is the lobby area usable by all tenants. The 6,000 square feet of usable area that you are looking for is on the seventh floor, which contains 33,600 square feet of rentable area, and is leased by other tenants who occupy a combined total of 24,000 square feet of usable space. The leasing broker indicated that base rents will be $30 per square foot of rentable area Required: a. Calculate total rentable area in the building as though it would be rented to…arrow_forwardDon't used Ai solutionarrow_forward
- General Finance Questionarrow_forwardConsider the following simplified financial statements for the Yoo Corporation (assuming no income taxes): Income Statement Balance Sheet Sales Costs $ 40,000 Assets 34,160 $26,000 Debt Equity $ 7,000 19,000 Net income $ 5,840 Total $26,000 Total $26,000 The company has predicted a sales increase of 20 percent. Assume Yoo pays out half of net income in the form of a cash dividend. Costs and assets vary with sales, but debt and equity do not. Prepare the pro forma statements. (Input all amounts as positive values. Do not round intermediate calculations and round your answers to the nearest whole dollar amount.) Pro forma income statement Sales Costs $ 48000 40992 Assets $ 31200 Pro forma balance sheet Debt 7000 Equity 19000 Net income $ 7008 Total $ 31200 Total 30304 What is the external financing needed? (Do not round intermediate calculations. Negative amount should be indicated by a minus sign.) External financing needed $ 896arrow_forwardAn insurance company has liabilities of £7 million due in 10 years' time and £9 million due in 17 years' time. The assets of the company consist of two zero-coupon bonds, one paying £X million in 7 years' time and the other paying £Y million in 20 years' time. The current interest rate is 6% per annum effective. Find the nominal value of X (i.e. the amount, IN MILLIONS, that bond X pays in 7 year's time) such that the first two conditions for Redington's theory of immunisation are satisfied. Express your answer to THREE DECIMAL PLACES.arrow_forward
- An individual is investing in a market where spot rates and forward rates apply. In this market, if at time t=0 he agrees to invest £5.3 for two years, he will receive £7.4 at time t=2 years. Alternatively, if at time t=0 he agrees to invest £5.3 at time t=1 for either one year or two years, he will receive £7.5 or £7.3 at times t=2 and t=3, respectively. Calculate the price per £5,000 nominal that the individual should pay for a fixed-interest bond bearing annual interest of 6.6% and is redeemable after 3 years at 110%. State your answer at 2 decimal places.arrow_forwardThe one-year forward rates of interest, f+, are given by: . fo = 5.06%, f₁ = 6.38%, and f2 = 5.73%. Calculate, to 4 decimal places (in percentages), the three-year par yield.arrow_forward1. Give one new distribution channels for Virtual Assistance (freelance business) that is not commonly used. - show a chart/diagram to illustrate the flow of the distribution channels. - explain the rationale behind it. (e.g., increased market reach, improved customer experience, cost-efficiency). - connect the given distribution channel to the marketing mix: (How does it align with the overall marketing strategy? Consider product, price, promotion, and place.). - define the target audience: (Age, gender, location, interests, etc.). - lastly, identify potential participants: (Wholesalers, retailers, online platforms, etc.)arrow_forward
- An individual is planning for retirement and aims to withdraw $100,000 at the beginning of each year, starting from the first year of retirement, for an expected retirement period of 20 years. To fund this retirement plan, he intends to make 20 equal annual deposits at the end of each year during his working years. Assume a simple annual interest rate of 20% during his working years and a simple annual interest rate of 5% during retirement. What should his annual deposit amount be to achieve his desired retirement withdrawals? Please write down the steps of your calculation and explain result economic meaning.arrow_forwardAssume an investor buys a share of stock for $18 at t=0 and at the end of the next year (t=1), he buys 12 shares with a unit price of $9 per share. At the end of Year 2 (t=2), the investor sells all shares for $40 per share. At the end of each year in the holding period, the stock paid a $5.00 per share dividend. What is the annual time-weighted rate of return? Please write down the steps of your calculation and explain result economic meaning.arrow_forwardOn how far do you endorse this issue? Analyze the situation critically using official statistics and the literature.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