Create a new sheet named vertical analysis in the Excel workbook and insert thenecessary equations or functions in related cells to calculate vertical analysis forthe income statement and balance sheet.STATEMENT OF INCOME 2020-12-312019-12-312018-12-312017-12-31Create a new sheet named horizontal analysis in the Excel workbook and insert thenecessary equations or functions in related cells to calculate horizontal analysis forSales768,109,000 1,105,696,000 1,194,376,000 835,983,000the income statement and balance sheet.Sales CostBALANCE SHEET12/31/202012/31/201912/31/201812/31/2017Total Income768,109,000 1,105,696,000 1,194,376,000 835,983,000Current Assets340,079,000320,122,000339,609,000213,006,000Other Revenues93,982,000 131,089,000152,641,000150,176,000Inventory51,999,00042,607,00043,580,00034,013,000Total Revenues862,091,000 1,236,785,000 1,347,017,000 986,159,000Investments95,638,00085,161,00039,987,00052,329,00046,970,000 36,647,00031.250.00029,606,000Admin and MarketingExpensesDepreciationFixed Assets1,209,460,000982,014,000873,827,000751,134,00076,208,000 50,266,00041,334,00036,894,000Other Assets217,085,00064,222,00049,889,00052,071,000Other Expenses366,489,000 483,131,000476,537,000338,221,000Total Assets1,914,261,000 1,494,126,000 1,346,892,000 1,102,553,000Total Expenses489,667,000 570,044,000549,121,000 404,721,000Current Liabilities243,211,000215,571,000184,436,000149,050,000Net Income Before Zakat372,424,000 666,741,000797,896,000 581,438,000Non-Current569,956,000232,320,000134,021,000127,189,000Zakat188,661,000 336,048,000296,819,000381.378.000LiabilitiesNet Income183,763,000 330,693,000416,518,000284,619,000Other LiabilitiesBalance First PeriodShareholders Equity990,848,000 1,035,065,000 1,016,782,000813,758,000ReservesTotal Liabilities and 1,914,261,000 1,494,126,000 1,346,892,000 1,102,553,000Cash DividendsShareholder EquityOther DistributionsBalance End PeriodMinority Interests110,246,00011,170,00011,653,00012,556,000All figures are inThousandsThousandsThousandsThousandsAll figures are inThousandsThousandsThousandsThousandsCurrencySARSARSARSARSARLast Update Date2021-03-25 2020-03-192020-03-192019-12-10CurrencySARSARSARLast Update Date3/25/20213/19/20203/19/202012/10/2019

Vertical analysis is a method of proportional analysis of financial statements where an item of the…

• Create a new sheet named vertical analysis in the Excel workbook and insert the necessary equations or functions in related cells to calculate vertical analysis for the income statement and balance sheet • Create a new sheet named horizontal analysis in the Excel workbook and insert the necessary equations or functions in related cells to calculate horizontal analysis for the income statement and balance sheet. BALANCE SHEET 12/31/2020 12/31/2019 12/31/2018 12/31/2017 Current Assets 340,079,000 320,122,000 339,609,000 213,006,000 Inventory 51,999,000 42,607,000 43,580,000 34,013,000 investments 95,638,000 85,161,000 39,987,000 52,329,000 Fixed Assets 1,209,460,000 982,014,000 873,827,000 751,134,000

• Create a new sheet named vertical analysis in the Excel workbook and insert the necessary equations or functions in related cells to calculate vertical analysis for the income statement and balance sheet • Create a new sheet named horizontal analysis in the Excel workbook and insert the necessary equations or functions in related cells to calculate horizontal analysis for the income statement and balance sheet. BALANCE SHEET 12/31/2020 12/31/2019 12/31/2018 12/31/2017 Current Assets 340,079,000 320,122,000 339,609,000 213,006,000 Inventory 51,999,000 42,607,000 43,580,000 34,013,000 investments 95,638,000 85,161,000 39,987,000 52,329,000 Fixed Assets 1,209,460,000 982,014,000 873,827,000 751,134,000

Intermediate Accounting: Reporting And Analysis

3rd Edition

ISBN:9781337788281

Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Chapter5: The Income Statement And The Statement Of Cash Flows

Section: Chapter Questions

Problem 15E

See similar textbooks

Similar questions

Prepare a vertical analysis scheduleHere is the operating data for Yalis Cleaning, Inc.:2021 2020Service revenue $523,000 $476,000Operating expenses 385,500 319,800Income tax expense 34,375 39,050Net income $103,125 $117,150PurposeThe purpose of this problem is to demonstrate an understanding of preparing a vertical analysis schedule.InstructionsAfter analyzing the transactions, prepare a vertical analysis schedule for the company for 2021 and 2020 using service revenueas the base amount. Round percentages to two decimal places.GuidanceFor formatting guidance, see the vertical analysis examples that are provided in Chapter 13 of the textbook.
the information in the screenshot we should use to to do the follwoing for year ending sep 30 2020. Trial balance statment lf profit and loss statement of finincial position workings must show workings used to get the trial balance such as the statment of affairs and control accounts. Please avoid solution in image format thank you
Insert a pie chart with a 2-D visual effect for 2018 using all expense items in a new worksheet called, “Comparing Expenses”. Include all relevant labels, titles (not shown) and legends while changing the default colors. Thom-Pierre Consultants (TPC) Tax Rate COMPARITIVE INCOME STATEMENT 30% for years ended 31 December 2018 2019 Revenues and gains *Sales revenue *Interest revenue *Investment Income *Other revenue Total revenue and gains Expenses and losses **Cost of goods sold 460,000 **Selling and admin administrative 195,000 ***Computer (operating) **Depreciation 55,000 **Interest expense 25,200 Total expenses and losses Income before taxes Income tax expense (30%) Net Income
The following information is taken from the records of Rosebloom Flowers for the year 2019. A. Calculate net income or net loss for January. B. Calculate net income or net loss for February. C. Calculate net income or net loss for March. D. For each situation, comment on how a stakeholder might view the firms performance. (Hint: think about the source of the income or loss.)
The accountant wishes you to provide an analysis of the company’s annual operating expenses. Add an extra worksheet called “Expense analysis”, and add your 20Y3 data next to the given 20Y2 data. You must link this new Expense Analysis table/worksheet (relevant cells in column “E”) with the respective data from your 20Y3 income statement. Do not hard code the 20Y3 data. Use appropriate formula to calculate the total expenses in cell E10, E12 and percentages in column F and G.
a) Prepare the adjusted trial balance. For each adjustment, describe your workings and justify them. b) Use the adjusted trial balance to prepare the income statement for 2020. c) Use the adjusted trial balance to prepare the balance sheet for 2020.
Using this link: https://massygroup.com/wp-content/uploads/2022/11/MASSY-DIGITAL-ANNUALREPORT-2022-updated.pdf answer the following questions Working Capital Management: a) Assess the company’s working capital position by analyzing its current assets and liabilities using common methods and measures. b) Evaluate the efficiency of the company’s working capital management strategies, including inventory management, accounts receivable, and accounts payable. c) Based on your assessment and evaluation above, provide brief recommendations in point form for improving the company’s working capital management practices.
Use the following information to answer Exercises E5-23 through E5-25. The adjusted trial balance of Quality Office Systems at March 31, 2018, follows: Preparing a multi-step income statement Prepare Quality Office’s multi-step income statement for the year ended March 31, 2018.
Requirement 1: Calculate eagles operating income for 2019, fill in the blanks in the chart please Then answer requirements 2 and 3 and provide all work for each requirement.
Use the following information to answer Exercises E5-23 through E5-25. The adjusted trial balance of Quality Office Systems at March 31, 2018, follows: Preparing a single-step income statement Prepare Quality Office’s single-step income statement for the year ended March 31, 2018.
After analyzing the transactions, prepare a vertical analysis schedule for the company for 2021 and 2020 using service revenue as the base amount. Round percentages to two decimal places. Here is the operating data for Yalis Cleaning, Inc.: 2021 2020Service revenue $523,000 $476,000Operating expenses 385,500 319,800Income tax expense 34,375 39,050Net income $103,125 $117,150
Adjusting entries bring accounts up to date so the correct account balances appear on rev: 03_04_2020_QC_CS-203083 Multiple Choice All of these answers are correct. Financial reports Managerial reports Auditing reports