Homework Help is Here – Start Your Trial Now!
Business
Finance
• 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

Essentials Of Investments
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
See similar textbooks
icon
Related questions
Question
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. STATEMENT OF INCOME 2020-12-31 2019-12-31 2018-12-31 2017-12-31 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 Sales 768,109,000 1,105,696,000 1,194,376,000 835,983,000 the income statement and balance sheet. Sales Cost BALANCE SHEET 12/31/2020 12/31/2019 12/31/2018 12/31/2017 Total Income 768,109,000 1,105,696,000 1,194,376,000 835,983,000 Current Assets 340,079,000 320,122,000 339,609,000 213,006,000 Other Revenues 93,982,000 131,089,000 152,641,000 150,176,000 Inventory 51,999,000 42,607,000 43,580,000 34,013,000 Total Revenues 862,091,000 1,236,785,000 1,347,017,000 986,159,000 Investments 95,638,000 85,161,000 39,987,000 52,329,000 46,970,000 36,647,000 31.250.000 29,606,000 Admin and Marketing Expenses Depreciation Fixed Assets 1,209,460,000 982,014,000 873,827,000 751,134,000 76,208,000 50,266,000 41,334,000 36,894,000 Other Assets 217,085,000 64,222,000 49,889,000 52,071,000 Other Expenses 366,489,000 483,131,000 476,537,000 338,221,000 Total Assets 1,914,261,000 1,494,126,000 1,346,892,000 1,102,553,000 Total Expenses 489,667,000 570,044,000 549,121,000 404,721,000 Current Liabilities 243,211,000 215,571,000 184,436,000 149,050,000 Net Income Before Zakat 372,424,000 666,741,000 797,896,000 581,438,000 Non-Current 569,956,000 232,320,000 134,021,000 127,189,000 Zakat 188,661,000 336,048,000 296,819,000 381.378.000 Liabilities Net Income 183,763,000 330,693,000 416,518,000 284,619,000 Other Liabilities Balance First Period Shareholders Equity 990,848,000 1,035,065,000 1,016,782,000 813,758,000 Reserves Total Liabilities and 1,914,261,000 1,494,126,000 1,346,892,000 1,102,553,000 Cash Dividends Shareholder Equity Other Distributions Balance End Period Minority Interests 110,246,000 11,170,000 11,653,000 12,556,000 All figures are in Thousands Thousands Thousands Thousands All figures are in Thousands Thousands Thousands Thousands Currency SAR SAR SAR SAR SAR Last Update Date 2021-03-25 2020-03-19 2020-03-19 2019-12-10 Currency SAR SAR SAR Last Update Date 3/25/2021 3/19/2020 3/19/2020 12/10/2019
Transcribed Image Text: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. STATEMENT OF INCOME 2020-12-31 2019-12-31 2018-12-31 2017-12-31 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 Sales 768,109,000 1,105,696,000 1,194,376,000 835,983,000 the income statement and balance sheet. Sales Cost BALANCE SHEET 12/31/2020 12/31/2019 12/31/2018 12/31/2017 Total Income 768,109,000 1,105,696,000 1,194,376,000 835,983,000 Current Assets 340,079,000 320,122,000 339,609,000 213,006,000 Other Revenues 93,982,000 131,089,000 152,641,000 150,176,000 Inventory 51,999,000 42,607,000 43,580,000 34,013,000 Total Revenues 862,091,000 1,236,785,000 1,347,017,000 986,159,000 Investments 95,638,000 85,161,000 39,987,000 52,329,000 46,970,000 36,647,000 31.250.000 29,606,000 Admin and Marketing Expenses Depreciation Fixed Assets 1,209,460,000 982,014,000 873,827,000 751,134,000 76,208,000 50,266,000 41,334,000 36,894,000 Other Assets 217,085,000 64,222,000 49,889,000 52,071,000 Other Expenses 366,489,000 483,131,000 476,537,000 338,221,000 Total Assets 1,914,261,000 1,494,126,000 1,346,892,000 1,102,553,000 Total Expenses 489,667,000 570,044,000 549,121,000 404,721,000 Current Liabilities 243,211,000 215,571,000 184,436,000 149,050,000 Net Income Before Zakat 372,424,000 666,741,000 797,896,000 581,438,000 Non-Current 569,956,000 232,320,000 134,021,000 127,189,000 Zakat 188,661,000 336,048,000 296,819,000 381.378.000 Liabilities Net Income 183,763,000 330,693,000 416,518,000 284,619,000 Other Liabilities Balance First Period Shareholders Equity 990,848,000 1,035,065,000 1,016,782,000 813,758,000 Reserves Total Liabilities and 1,914,261,000 1,494,126,000 1,346,892,000 1,102,553,000 Cash Dividends Shareholder Equity Other Distributions Balance End Period Minority Interests 110,246,000 11,170,000 11,653,000 12,556,000 All figures are in Thousands Thousands Thousands Thousands All figures are in Thousands Thousands Thousands Thousands Currency SAR SAR SAR SAR SAR Last Update Date 2021-03-25 2020-03-19 2020-03-19 2019-12-10 Currency SAR SAR SAR Last Update Date 3/25/2021 3/19/2020 3/19/2020 12/10/2019
Expert Solution
steps

Step by step

Solved in 9 steps with 8 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Balance Sheet Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS