a)
Horizontal Analysis and Vertical Analysis
Horizontal Analysis: Horizontal analysis is prepared to make comparison between the financial statements to determine the changes in the financial statements for the previous year to the current year. The changes of the company are measured in dollars as well as in percentage.
Formula:
Vertical Analysis: Vertical analysis is prepared to analyze the relationship among various financial statements with a particular base amount. Use the following formula to calculate vertical analysis percentage:
Formula:
This analysis is otherwise called as common-size statement.
To prepare: Horizontal analysis of Corporation N’s Comparative Balance Sheets data for 2016 and 2017.
b)
To prepare: Vertical analysis of Corporation N’s comparative condensed balance sheet data for 2017.
Want to see the full answer?
Check out a sample textbook solutionChapter 13 Solutions
Financial Accounting: Tools for Business Decision Making, 8th Edition
- I need assistance on the following regarding the attached balance sheet and income statement: Required: a) Calculate the following financial ratios for 2016 and 2017 19. Dividend payout ratioarrow_forwardVII. Direction: Compute and interpret. The following comparative financial statements are provided by Avatar Industries. You were asked to compute the different financial ratios and provide your interpretations with regards to profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template below to input your answer and solution. AVATAR INDUSTRIES AVATAR INDUSTRIES Comparative Statement of Financial Position For the years 2019 and 2018 Comparative Income Statement For the years 2019 and 2018 2019 2018 2019 2018 ASSETS Current Assets: Sales P200,000 P210,000 Cash & Cash Equivalent P65,000 P70,000 Sales Returns and Allowances 40,000 25,000 Accounts Receivable 40,000 35,000 Net Sales 160,000 185,000 Marketable Secuities 40,000 35,000 Cost of Goods Sold 100,000 115,625 Inventory 100,000 80,000 Gross Profit 60,000 69,375 Total Current Assets 220,000 200,000 160,000 P445,000 P380,000 245,000 Operating Expenses: Fixed Assets Selling Expenses 22,000 25,000 Total…arrow_forwardVII. Direction: Compute and interpret. The following comparative financial statements are provided by Avatar Industries. You were asked to compute the different financial ratios and provide your interpretations with regards to profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template below to input your answer and solution. AVATAR INDUSTRIES AVATAR INDUSTRIES Comparative Statement of Financial Position For the years 2019 and 2018 Comparative Income Statement For the years 2019 and 2018 2019 2018 2019 2018 ASSETS Current Assets: Sales P200,000 P210,000 Cash & Cash Equivalent P65,000 P70,000 Sales Returns and Allowances 40,000 25,000 Accounts Receivable 40,000 35,000 Net Sales 160,000 185,000 Marketable Securities 40,000 35,000 Cost of Goods Sold 100,000 115,625 Inventory 100,000 80,000 Gross Profit 60,000 69,375 Total Current Assets 245,000 220,000 Operating Expenses: Fixed Assets 200,000 160,000 Selling Expenses 22,000 25,000 Total Assets P445,000…arrow_forward
- a) Calculate the following ratios for 2016 and 2015, showing detailed calculations as to how you arrive at each number. A ROE B Gross profit margin C Total asset turnover D Inventory turnover E Current ratio F Debt-to-equity G Interest coverage ratio. b) Using the financial statements and the ratios calculated above (and any other ratios you like to calculate), discuss the performance of Cobham PLC in 2016. c) Critically discuss the need for the public limited companies to prepare a Statement of Cash Flows and explain the usefulness of the information contained therein from the perspective of a financial analyst.arrow_forwardA company’s comparative statements are given below. Please conduct the following analyses (hint: use of a spreadsheet is recommended for ease of computation):a. Horizontal analysis (trend analysis) on the income statement b. Vertical analysis (common size financial statement analysis) on the income statement c. Calculate the three profitability ratios for the year 2017 and show how ROE can be derived from the DuPont formula for this company. d. What do the analyses tell you about the company’s financial performance?arrow_forwardCalculate the Current Ratio, Debt Ratio, Return on Assets (ROA) and Return on Equity (ROE). For the ROA and ROE, you should use the average total assets and the average total equity in your calculations. (The average is the total across two years divided by two). Calculate these values for each of 2011-2014. Interpret your calculations: what does this information mean? How is the company doing?arrow_forward
- a. construct a balance sheet for 2016 and 2017. b. list all the working capital accounts. c. find the net working capital for the years ending 2016 and 2017. d. calculate the change in net working capital for the year 2017. a. construct a balance sheet for 2016 and 2017. Complete the balance sheet for 2016 below: (Round to the nearest dollar.) ASSETS Current assets Cash Accounts receivable Inventory Roman Corporation Balance Sheet as of December 31, 2016, and December 31, 2017 2016 2017 LIABILITIES Total current assets Fixed assets Accumulated depreciation (-) TOTAL ASSETS GA $ $ GA GA GA GA LA Current liabilities Total current liabilities Total liabilities OWNERS' EQUITY Total owners' equity TOTAL LIABILITIES AND OWNERS' EQUITY GA A GA GA 2016 2017arrow_forwardGiven the income statement for the MLC (Table 4–7) and balance sheet(Table 4–4), answer the following:a. Calculate the following ratios for 2012: operating profit margin, net profitmargin, operating return on assets, net return on assets, and return onequity.b. In a written explanation, describe what each ratio means.c. In a brief paragraph, describe the overall profitability of the MLC.arrow_forwardFinancial Statements Analysis and Interpretations Instructions: 1. Using the provided data below, prepare a Statement of Financial Position - Vertical Analysis. 2. Compute for the following financial ratios and provide interpretation for each item. a. Current Ratio b. Working Capital c. Debt-to-Equity Ratio d. Debt Ratio e. Asset Turnover Ratio 3. You may use any desired business name. 4. Use the space provided for your answer. Given: 2017 2016 P 358,950.00 P 184,560.00 P 365,450.00 P 450,355.00 P 252,260.00 P 653,550.00 P 300,000.00 P 600,000.00 P 943,105.00 P 65,000.00 P 277,145.00 P 68,505.00 P 285,000.00 P 235,000.00 P 345,650.00 P 745,000.00 P 150,000.00 P 700,000.00 P 800,000.00 Accounts Payable Accrued Expenses Accounts Receivable Cash Inventory Fixed Assets Marketable Securities Mortgage Payable Owner's Capital Prepaid Insurance 85,000.00arrow_forward
- Income statement and balance sheet data for The Athletic Attic are provided below.Required: 1. Calculate the following risk ratios for 2021 and 2022: a. Receivables turnover ratio. c. Current ratio. b. Inventory turnover ratio. d. Debt to equity ratio. 2. Calculate the following profitability ratios for 2021 and 2022: a. Gross profit ratio. c. Profit margin. b. Return on assets. d. Asset turnover. 3. Based on the ratios calculated, determine whether overall risk and profitability improved from 2021 to 2022.arrow_forwardA) Prepare the 2024 combined common-size, common-base year balance sheet. B) Calculate the following financial ratios for each year. Comment on each ratio and interpret the changes from 2023 to 2024. A. Current ratio B. debt to equity ratio C. total asset turnover D. ROE C) Use the DuPont analysis on each year and interpret your results.arrow_forwardQuestion 1 Mabel is a potter and sells her pottery at stalls that she rents in four tourist information centres across the south of England. Extracts from her financial statements for the years ended 31 December 2021 and 2020 are shown below. Statement of profit or loss for the year ended 31 December: 2021 28,900 |(16,500) 12,400 (3,800) 8,600 |(4,000) 4,600 2020 Revenue 27,200 (14,000) 13,200 (3,600) 9,600 Cost of sales Gross profit Operating expenses Operating profit Non-operating expenses Net profit 9,600 Statement of financial position as at 31 December: 2021 Non-current assets Current assets Total assets 22,660 4,360 27,020 2020 20,920 3,750 24,670 Equity Non-current liabilities Current liabilities Equity and liabilities 20,940 3,000 3,080 27,020 16,340 3,500 4,830 24,670 The following information is also relevant: In July 2021 the rent on one of Mabel's stalls was increased significantly for the third time in three years so she decided not to renew the annual contract. She sold…arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning