1.
Prepare horizontal analysis of the comparative income statement and balance sheet.
1.
Explanation of Solution
Ratio analysis: The analysis of a company using the financial ratios and comparing its trends and measure its performance within the company and the companies of the industry is known as ratio analysis. The main categories of ratio analyses are liquidity ratios, profitability ratios, activity ratios, and leverage ratios.
Horizontal analysis: The comparison of an item of a financial statement of one year against the same item of the same financial statement of another year, to determine the relation between the two items, is referred to as horizontal analysis. The horizontal analysis percentage is calculated by using the given formula:
Prepare horizontal analysis of the comparative income statement of Company NPC.
Company CPC | ||||
Comparative Income Statement | ||||
For the Year Ended December 31, 20-2 and 20-1 | ||||
Particulars |
20-2 (A) |
20-1 (B) | Increase (Decrease) | |
Amount (C) | Percentage (C÷B)×100 | |||
Net sales | $466,451 | $291,613 | $174,838 | 60.0 |
Cost of goods sold | $285,889 | $188,626 | $97,263 | 51.6 |
Gross Profit | $180,562 | $102,987 | $77,575 | 75.3 |
operating expenses | $125,650 | $78,200 | $47,450 | 60.7 |
Operating income | $54,912 | $24,787 | $30,125 | 121.5 |
Interest expenses | $1,200 | $500 | $700 | 140.0 |
Income before income taxes | $53,712 | $24,287 | $29,425 | 121.2 |
Income tax expense | $18,250 | $7,285 | $10,965 | 150.5 |
Net income | $35,462 | $17,002 | $18,460 | 108.6 |
Table (1)
Prepare horizontal analysis of the comparative balance sheet of Company NPC.
Company NPC | ||||
Comparative Balance Sheet | ||||
For the Year Ended December 31, 20-2 and 20-1 | ||||
Particulars |
20-2 (A) |
20-1 (B) | Increase (Decrease) | |
Amount (C) | Percentage (C÷B)×100 | |||
Assets | ||||
Current assets: | ||||
Cash | $8,600 | $7,500 | $1,100 | 14.7 |
Government notes | $3,000 | $2,000 | $1,000 | 50.0 |
Receivables (net) | $10,500 | $8,600 | $1,900 | 22.1 |
Merchandise inventory | $53,600 | $33,200 | $20,400 | 61.4 |
Supplies and prepayments | $4,500 | $3,200 | $1,300 | 40.6 |
Total current assets | $80,200 | $54,500 | $25,700 | 47.2 |
Property, plant and equipment: | ||||
Land | $40,000 | $40,000 | $0 | 0.0 |
Building | $200,000 | $150,000 | $50,000 | 33.3 |
Delivery equipment | $13,000 | $15,000 | ($2,000) | -13.3 |
Office equipment (net) | $5,400 | $6,000 | ($600) | -10.0 |
Patents | $5,000 | $6,000 | ($1,000) | -16.7 |
Factory equipment (net) | $200,000 | $52,930 | $147,070 | 277.9 |
Total property, plant and equipment | $263,400 | $217,000 | $46,400 | 21.4 |
Total Assets | $343,600 | $271,500 | $72,100 | 26.6 |
Liabilities | ||||
Current liabilities: | ||||
Notes payable | $5,000 | $3,000 | $2,000 | 66.7 |
Accounts payable | $28,700 | $22,300 | $6,400 | 28.7 |
Accrued interest payable | $500 | $1,700 | ($1,200) | -70.6 |
Accrued and withheld payment taxes | $4,200 | $5,600 | ($1,400) | -25.0 |
Total current liabilities | $38,400 | $32,600 | $5,800 | 17.8 |
Long-term liabilities: | ||||
Bonds payable | $50,000 | $20,000 | $30,000 | 150.0 |
Total liabilities | $88,400 | $52,600 | $35,800 | 68.1 |
Common stock | $115,000 | $100,000 | $15,000 | 15.0 |
Paid in capital in excess of par | $65,000 | $60,000 | $5,000 | 8.3 |
$75,200 | $58,900 | $16,300 | 27.7 | |
Total stockholders' equity | $255,200 | $218,900 | $36,300 | 16.6 |
Total liabilities and stockholders' equity | $343,600 | $271,500 | $72,100 | 26.6 |
Table (2)
2.
Prepare vertical analysis of the comparative income statement and balance sheet of Company NPC.
2.
Explanation of Solution
Vertical Analysis: Vertical analysis is prepared to analyze the relationship among various financial statements with a particular base amount. This analysis is otherwise called as common-size statement.
Formula:
Prepare vertical analysis of the comparative income statement of Company NPC.
Company NPC | ||||
Comparative Income Statement | ||||
For Years Ended December 31, 20-2 and 20-1 | ||||
Particulars | 20-2 | 20-1 | ||
Amount | percent | Amount | Percent | |
Net sales | $466,451 | 100% | $291,613 | 100% |
Cost of goods sold | 285,889 | 61.30% | 188,626 | 64.70% |
Gross profit | $180,562 | 38.70% | $102,987 | 35.30% |
Operating expenses | 125,650 | 26.90% | 78,200 | 26.80% |
Operating income | $54,912 | 11.80% | $24,787 | 8.50% |
Other expenses | 1,200 | 0.30% | 500 | 0.20% |
Income before income taxes | $53,712 | 11.50% | $24,287 | 8.30% |
Income tax expense | 18,250 | 3.90% | 7,285 | 2.50% |
Net income | $35,462 | 7.60% | $17,002 | 5.80% |
Table (3)
Prepare vertical analysis of the comparative balance sheet of Company NPC.
Company NPC | ||||
Comparative Balance Sheet | ||||
December 31, 20-2 and 20-1 | ||||
20-2 | 20-1 | |||
Amount | Percent | Amount | Percent | |
Assets | ||||
Current assets: | ||||
Cash | $8,600 | 2.50% | $7,500 | 2.80% |
Government notes | 3,000 | 0.90% | 2,000 | 0.70% |
Accounts receivable (net) | 10,500 | 3.10% | 8,600 | 3.20% |
Merchandise inventory | 53,600 | 15.60% | 33,200 | 1.20% |
Supplies and prepayments | 4,500 | 1.30% | 3,200 | 1.20% |
Total current assets | $80,200 | 23.30% | $54,500 | 20.10% |
Property, plant, and equipment: | ||||
Land | $40,000 | 11.60% | $40,000 | 14.70% |
Building (net) | 200,000 | 58.20% | 150,000 | 55.20% |
Delivery equipment (net) | 13,000 | 3.80% | 15,000 | 5.50% |
Office equipment (net) | 5,400 | 1.60% | 6,000 | 2.20% |
Patents | 5,000 | 1.50% | 6,000 | 2.20% |
Total property, plant, and equipment | $263,400 | 76.70% | $217,000 | 79.90% |
Total assets | $343,600 | 100% | $271,500 | 100% |
Liabilities | ||||
Current liabilities: | ||||
Notes payable | $5,000 | 1.50% | $3,000 | 1.10% |
Accounts payable | 28,700 | 8.40% | 22,300 | 8.20% |
Accrued and withheld payroll taxes | 4,200 | 1.20% | 5,600 | 2.10% |
Accrued interest payable | 500 | 0.10% | 1,700 | 0.60% |
Total current liabilities | $38,400 | 11.20% | $32,600 | 12% |
Long-term liabilities: | ||||
Bonds payable | 50,000 | 14.60% | 20,000 | 7.40% |
Total liabilities | $88,400 | 25.70% | $52,600 | 19.40% |
Stockholders’ Equity | ||||
Common stock ($5 par) | $115,000 | 33.50% | $100,000 | 36.80% |
Paid-in capital in excess of par | 65,000 | 18.90% | 60,000 | 22.10% |
Retained earnings | 75,200 | 21.90% | 58,900 | 21.70% |
Total stockholders’ equity | $255,200 | 74.30% | $218,900 | 80.60% |
Total liabilities and stockholders' equity | $343,600 | 100% | $271,500 | 100% |
Table (4)
3.
Compute the following liquidity measures for 20-2.
- (a)
Working capital - (b)
Current ratio - (c) Quick or acid –test ratio
3.
Explanation of Solution
Liquidity measures:
Liquidity measures denote a company’s capacity to meet its current liabilities. These measures focus on balance sheet amounts initially and on the ability of the company to generate funds to liquidate its current obligations.
(a)
Calculate working capital on December 31, 20-2.
(b)
Calculate current ratio on December 31, 20-2.
(c)
Calculate quick or acid test ratio on December 31, 20-2.
4.
Activity measures:
Activity measures initially focus on how efficiently the assets are used. For example, the speed of the receivables collected and inventories sold, as well as the usage of the assets to generate revenue.
Calculate the following activity measures for 20-2.
- (a) Accounts receivable and average number of days to collect.
- (b) Merchandise inventory turnover and average number of days to sell inventory.
- (c) Asset turnover
4.
Explanation of Solution
(a)
Calculate accounts receivable turnover.
Calculate average collection period.
(b)
Calculate merchandise inventory turnover.
Calculate average days to sell inventory.
(c)
Calculate asset turnover.
5.
Compute the following profitability measures for 20-2.
- (a) Profit margin ratio
- (b) Return on assets
- (c) Return on common stockholders’ equity
- (d) Earnings per share of common stock
5.
Explanation of Solution
Profitability measures:
Profitability measures show the ability of the company to earn income by operating proficiently (satisfactory
(a)
Calculate profit margin ratio.
(b)
Calculate return on assets for 20-2.
(c)
Calculate return on common stockholders’ equity for 20-2.
(d)
Calculate earnings per share of common stock.
Calculate beginning common shares outstanding.
Calculate ending common shares outstanding.
6.
Leverage measures:
Leverage measures overlook the mixture of debt and equity which is required for analyzing the ability of the Company to meet its debt obligations as they become due. Debt to equity ratio: Assets-to-equity ratio, Times interest earned ratio are the leverage measures.
Compute the following leverage ratios.
- (a) Debt-to-equity ratio
- (b) Times interest earned ratio.
6.
Explanation of Solution
(a)
Calculate debt-to-equity ratio.
(b)
Calculate times interest earned ratio.
7.
Calculate the following market measures for 20-2.
- (a) Price earnings ratio
- (b) Book value per share of common stock.
7.
Explanation of Solution
(a)
Calculate price earnings ratio.
(b)
Calculate book value per share of common stock.
Want to see more full solutions like this?
Chapter 24 Solutions
College Accounting, Chapters 1-9 (New in Accounting from Heintz and Parry)
- Effect of transactions on current position analysis Data pertaining to the current position of Newlan Company are as follows: Instructions Compute (a) the working capital, (h) the current ratio, and (c) the quick ratio.arrow_forwardEffect of transactions on current position analysis Data pertaining to the current position of Lucroy Industries Inc. follow: Instructions 1. Compute (a) the working capital, (b) the current ratio, and (c) the quick ratio. Round ratios in parts b through j to one decimal place. 2. List the following captions on a sheet of paper: Compute the working capital, the current ratio, and the quick ratio after each of the following transactions and record the results in the appropriate columns. Consider each transaction separately and assume that only that transaction affects the data given. Round to one decimal place. a. Sold marketable securities at no gain or loss, 500,000. b. Paid accounts payable, 287,500. c. Purchased goods on account, 400,000. d. Paid notes payable, 125,000. e. Declared a cash dividend, 325,000. f. Declared a common stock dividend on common stock, 150,000. g. Borrowed cash from bank on a long-term note, 1,000,000. h. Received cash on account, 75,000. i. Issued additional shares of stock for cash, 2,000,000. j. Paid cash for prepaid expenses, 200,000.arrow_forwardUsing the following Balance Sheet summary information, for the two years presented calculate: A. working capital B. current ratioarrow_forward
- Using the following Balance Sheet summary information, calculate for the two companies presented: A. working capital B. current ratioarrow_forwardChapter 5, page 344 and 349: EA12. 5.3 Using the following Balance Sheet summary information, calculate for the two years presented: A. working capital B. current ratio 12/31/2018 12/31/2019 $76,000 48,000 Current assets $295,000 Current liabilities 163,500 After computing liquidity ratios, comment on the performance of an entity using acceptable standards of liquidity performancearrow_forwardDo npt give image formatarrow_forward
- see attached 1-3 and 1-5 to answer this Refer to the financial statements of Mixon Company in Exercises 1–3 and 1–5. Evaluate the effi- ciency and profitability of the company by computing the following: (a) net profit margin, (b) total asset turnover, and (c) return on total assets. Comment on these ratio results.arrow_forwardRequired: (a) You are required to calculate the following ratios:(iv) Return on Capital Employed(v) Asset turnover(vi) Non-current asset turnover(vii) Current Ratio(viii) Quick Ratio(ix) Inventory days(x) Receivables days(xi) Payable days(xii) Interest cover (b) In light of your calculations comment on the performance of the company over thelast two years.arrow_forwardConsider this simplified balance sheet for Geomorph Trading: Current assets Long-term assets $ 110 510 Net working capital $ 620 a. Debt-equity ratio b Long-term debt-to-capital ratio C. d. Current ratio a. What is the company's debt-equity ratio? (Round your answer to 2 decimal places.) b. What is the ratio of total long-term debt to total long-term capital? (Round your answer to 2 decimal places.) c. What is its net working capital? d. What is its current ratio? (Round your answer to 2 decimal places.) Current liabilities Long-term debt Other liabilities Equity $ 65 275 80 200 $ 620arrow_forward
- .arrow_forward= The current year financial statements for Blue Water Company and Prime Fish Company are presented below. Prime Fish Balance sheet Cash Accounts receivable (net) Inventory Property & equipment (net) Other assets Total assets Current liabilities Long-term debt (interest rate: 15%) Capital stock ($10 par value) Additional paid-in capital Retained earnings Total liabilities and stockholders' equity Income statement Sales revenue (1/2 on credit) Cost of goods sold Operating expenses Net income Other data Per share stock price at end of current year Blue Water $ 42,300 44,500 92,500 159,500 85,300 $ 424,100 $ 92,500 74,100 157,100 30,300 70,100 $ 424,100 $ 427,500 (234,500) (163,600) $ 29,400 $ 23.3 45% $ 19,700 34,900 47,800 416,600 318,000 $ 34,300 $ 837,000 $ 68,500 62,600 525,000 107,300 73,600 $ 837,000 $ 789,000 (401,300) (312,300) $ 75,400 $28 45% Average income tax rate Dividends declared and paid in current year Both companies are in the fish catching and manufacturing business.…arrow_forwardBelow are the two basic financial statements of Chiz Trading Company. You are tasked to prepare an analysis using Horizontal and Vertical Analysis of their two-dated financial statements. In addition to this you have been tasked to prepare financial ratios measuring the company’s: Liquidity Status Current Ratios Quick Asset Ratios Efficiency Status Asset Turnover Fixed Asset Turnover Inventory Turnover Days in Inventory Accounts Receivable Turnover Days in Receivable Profitability Status: Gross Profit margin Ratio Operating Income Ratio Net Profit Ratio Return on Assets Return on Equityarrow_forward
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning