Homework Help is Here – Start Your Trial Now!
Business
Accounting
Calculate the horizontal (trend) analysis, and horizontal % change for 2020, 2019, 2018 in excel. Please use excel and display the formula's used.  Thank you! Toyota Motor Corporation Income Statement 2018-2020         2020 2019 2018               Sales       29929992 30225681 29379510 Cost of Goods Sold       24522364 24781785 23889153 Gross Profit       5407628 5443896 5490357 Selling, general and administrative       2964759 2976351 3090495 Operating Income       2442869 2467545 2399862 Other income (expense)               Interest and dividend income     232870 225495 179541   Interest expense     -32217 -28078 -27586   Foreign exchange gain, net     -79020 12400 22664   Unrealized gains (losses)     -24600 -341054 0   Other income (loss), net     14705 -50843 45948   Total other income (expense)     111738 -182080 220567 Income before income taxes and equity       2554607 2285465 2620429 Provision for income taxes       -683430 -659944 -504406 Equity in earnings of affiliated companies       271152 360066 470083 Net income       2142329 1985587 2586106 Less – Net income attributable to noncontrolling interests       -66146 -102714 -92123 Net income attributable to Toyota Motor Corporation       2076183 1882873 2493983

Calculate the horizontal (trend) analysis, and horizontal % change for 2020, 2019, 2018 in excel. Please use excel and display the formula's used.  Thank you! Toyota Motor Corporation Income Statement 2018-2020         2020 2019 2018               Sales       29929992 30225681 29379510 Cost of Goods Sold       24522364 24781785 23889153 Gross Profit       5407628 5443896 5490357 Selling, general and administrative       2964759 2976351 3090495 Operating Income       2442869 2467545 2399862 Other income (expense)               Interest and dividend income     232870 225495 179541   Interest expense     -32217 -28078 -27586   Foreign exchange gain, net     -79020 12400 22664   Unrealized gains (losses)     -24600 -341054 0   Other income (loss), net     14705 -50843 45948   Total other income (expense)     111738 -182080 220567 Income before income taxes and equity       2554607 2285465 2620429 Provision for income taxes       -683430 -659944 -504406 Equity in earnings of affiliated companies       271152 360066 470083 Net income       2142329 1985587 2586106 Less – Net income attributable to noncontrolling interests       -66146 -102714 -92123 Net income attributable to Toyota Motor Corporation       2076183 1882873 2493983

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question

Calculate the horizontal (trend) analysis, and horizontal % change for 2020, 2019, 2018 in excel. Please use excel and display the formula's used. 

Thank you!

Toyota Motor Corporation
Income Statement 2018-2020
        2020 2019 2018
             
Sales       29929992 30225681 29379510
Cost of Goods Sold       24522364 24781785 23889153
Gross Profit       5407628 5443896 5490357
Selling, general and administrative
       2964759 2976351 3090495
Operating Income       2442869 2467545 2399862
Other income (expense)
            
 
Interest and dividend income
     232870 225495 179541
 
Interest expense
     -32217 -28078 -27586
 
Foreign exchange gain, net
     -79020 12400 22664
 
Unrealized gains (losses)
     -24600 -341054 0
 
Other income (loss), net
     14705 -50843 45948
 
Total other income (expense)
     111738 -182080 220567
Income before income taxes and equity
       2554607 2285465 2620429
Provision for income taxes
       -683430 -659944 -504406
Equity in earnings of affiliated companies
       271152 360066 470083
Net income       2142329 1985587 2586106
Less – Net income attributable to
noncontrolling interests
       -66146 -102714 -92123
Net income attributable to Toyota Motor Corporation
       2076183 1882873 2493983

 

Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Income Statement Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS