(a)
Concept introduction:
Horizontal analysis is a way of making a comparison among two years in which one year is taken to be the base year and the comparison is done with the like items and results are given in terms of percentage.
To prepare:
A statement showing the changes in revenue and expense from
(b)
Concept introduction:
Horizontal analysis is a way of making a comparison among two years in which one year is taken to be the base year and the comparison is done with the like items and results are given in terms of percentage.
The primary causes behind increase in net income in
![Check Mark](/static/check-mark.png)
Want to see the full answer?
Check out a sample textbook solution![Blurred answer](/static/blurred-answer.jpg)
Chapter 12 Solutions
Cengagenowv2, 1 Term Printed Access Card For Rich/jones' Cornerstones Of Financial Accounting, 4th
- The following select account data is taken from the records of Reese Industries for 2019. A. Use the data provided to compute net sales for 2019. B. Prepare a simple income statement for the year ended December 31, 2019. C. Compute the gross margin for 2019. D. Prepare a multi-step income statement for the year ended December 31, 2019.arrow_forwardIn the provided income statement image, can you plz calculate the profitability ratios: Gross Profit Margin for the 3 years (2021, 2020, 2019) and Profit Margin for 3 years) and could you discuss and explain the gross profit margin and profit margin and overall the company's profitability (or lack thereof).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
- VII. 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_forwardRequirements 1. Prepare a comparative common-size income statement for Mariner Designs, Inc. using the 2024 and 2023 data. Round percentages to one-tenth percent. 2. To an investor, how does 2024 compare with 2023 ? Explain your reasoningarrow_forwardSolve and perform the different financial ratios using the financial statements of XYZ Company for the year 2021. 1. Current Ratio 2. Quick Ratio 3. Receivables Turnover 4. Inventory Turnover 5. Debt Ratio 6. Equity Ratio 7. Times Interest Earned 8. Gross Profit Margin 9. Operating Profit Margin 10. Net Profit Marginarrow_forward
- Obtain Target Corporation's annual report for its 2018 fiscal year (year ended February 2, 2019) at http://investors.target.com a. What was Target's gross margin percentage for the fiscal year ended February 2, 2019 (2018) and 2017? Use "Sales" for these computations b. What was Target's Return on Sales percentage for 2018 and 2017? Use "Total Revenue" for these computations. c. Target's return on ales percentage for 2017 was higher than it was in 2018. Ignoring taxes, how much higher would Target's 2018 net income have been if it's return on sales percentage in 2018 had been the same as for 2017?arrow_forwardPerforming horizontal analysis—income statement Data for Mulberry Designs, Inc. follow: Requirements Prepare a horizontal analysis of the comparative income statement of Mulberry Designs, Inc. Round percentage changes to one decimal place. Why did 2018 net income increase by a higher percentage than net sales revenue?arrow_forwardd. Using the “Income Statement” worksheet, center the financial statement titlesacross the data below and bold and italicize the company name. e. Complete the formulas in cells provided for revenues* for 2021. 2021 revenues haveIncreased by 1/2% over 2020 values. f. Complete the formulas in cells provided for expenses for 2021. 2021 expenses have decreasedby 1/4% over 2020 values g. Using the correct function or formula calculate the total expenses and losses in the cellsprovided.arrow_forward
- All-Hands Property & Casualty Insurance Company has the following financial ratios. 2019 2018 Loss Ratio 67.8 68.1 Expense Ratio 24.2 25.1 Net Investment Yield 3.5 4.0 a. Calculate the Combined Ratio {Loss Ratio + Expense Ratio} for each year. Combined Ratio 2019 Combined Ratio 2018 b. Calculate the Overall Profitability Ratios Overall Profitability Ratio 2019 Overall Profitability Ratio 2018 why the Overall Profitability Ratio Changed in 2019 Based on the Loss Ratio, Expense Ratio, and Net Investment Yield Trends?arrow_forwarda) Based on the information provided, calculate the following ratios for the years ended 31December 2021 and 2020.You should give the formula for each ratio, in addition to your calculation.I. Gross profit marginII. Operating profit marginIII. Return on equityIV. Current ratioV. Gearing b) By comparing the financial information for years ended 31 December 2021 and 2020, andreviewing your ratio calculations, comment on the profitability, liquidity, and long-termsolvency of Mabel’s business over the past year. You should use the other information givento suggest reasons for any changes identified. c)If an investor was interested in buying Mabel’s business and was presented with theseresults, what further advice would you give them?arrow_forwardA.Perform horizontal analysisand vertical analysis (for 2020only)on the income statement. In your answer please remember to indicate if it is an INCREASE or (DECREASE) and round your findings to ONE decimal place [e.g. -32.996% is - 33.0% or minus 33.0% or (33.0%). B. Comment on the significant changes disclosed by the comparative statement of comprehensive income. What has caused the changes to occur? C. Prepare a statement of retained earnings for the year ended June 30, 2020. (Retained earnings at July 1, 2019 were $58,000, dividends declared and paid during the financial year were $37,000. D. Explain how profits for the year ended June 30, 2019 were $126,700 yet Retained Earnings at July 1, 2019 were only $58,000.arrow_forward
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337690881/9781337690881_smallCoverImage.gif)