Calculate the Horizontal (Trend) Analysis and horizontal analysis % change for the year 2020, 2019, 2020 Please use excel to calculate the formula Thank you!
Calculate the Horizontal (Trend) Analysis and horizontal analysis % change for the year 2020, 2019, 2020 Please use excel to calculate the formula Thank you!
Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter10: Stockholder's Equity
Section: Chapter Questions
Problem 88PSA: Ratio Analysis Consider the following information taken from the stockholders equity section: How do...
Related questions
Question
100%
Calculate the Horizontal (Trend) Analysis and horizontal analysis % change for the year 2020, 2019, 2020
Please use excel to calculate the formula
Thank you!
Toyota Motor Corporation | ||||||
Consolidated Balance Sheet | ||||||
2020 | 2019 | 2018 | ||||
Assets | ||||||
Current Assets | ||||||
Cash and Cash equivalents
|
4190518 | 3574704 | 3,052,269 | |||
Time Deposits | 828220 | 1126352 | 901244 | |||
Marketable securities
|
678731 | 1127160 | 1768360 | |||
Trade accounts and notes recievables
|
2094894 | 2372734 | 2219562 | |||
less A.F.D.A. | ||||||
Finance receivables, net
|
6614171 | 6647771 | 6438306 | |||
Other recievables
|
564854 | 568156 | 489338 | |||
Inventories | 2434918 | 2656396 | 2539789 | |||
Prepaid expenses and other current assets
|
1236225 | 805964 | 833788 | |||
Total current assets
|
18642531 | 18879237 | 18,242,656 | |||
Noncurrent finance recievables, net
|
10423858 | 10281118 | 9481618 | |||
Investments and other assets:
|
||||||
Marketable securities, and investments
|
7348651 | 7479926 | 7999323 | |||
Afffiliated companies
|
4123453 | 3313723 | 3162917 | |||
Employees receivables
|
21484 | 21683 | 22562 | |||
Other | 1518934 | 1275768 | 1221500 | |||
Total investmenrs and other assets
|
13012522 | 12091100 | 12406302 | |||
Property, plant and equipment:
|
||||||
Land | 1346988 | 1386308 | 1404611 | |||
Buildings | 4730783 | 4802175 | 4659753 | |||
Machinery and equipment
|
11939121 | 11857425 | 11535381 | |||
Vehicles and equipment on operating leases
|
5929233 | 6139163 | 5934393 | |||
Construction in progress
|
510963 | 651713 | 509851 | |||
Total property, plant and equipment, at cost
|
24457088 | 24836784 | 24043989 | |||
Less –
|
-13855563 | -14151290 | -13776316 | |||
Total property, plant and equipment, net
|
10601252 | 10685494 | 10267673 | |||
Total assets | 52680436 | 51936949 | 50308249 | |||
Liabilities | ||||||
Current liabilities: | ||||||
Short-term borrowings
|
5286026 | 5344973 | 5154913 | |||
Current portion of long-term debt
|
4574045 | 4254260 | 4186277 | |||
Accounts payable
|
2434180 | 2645984 | 2586657 | |||
Other payables | 1020270 | 1102802 | 1048216 | |||
Accrued expenses
|
2936052 | 3222446 | 3104260 | |||
Income taxes payable
|
218117 | 320998 | 462327 | |||
Other current liabilities
|
1443687 | 1335475 | 1254241 | |||
Total current liabilities
|
17912377 | 18226938 | 17796891 | |||
Long-term liabilities | ||||||
Long-term deb | 10692 | 10550945 | 10006374 | |||
Accrued pension and severance costs
|
978626 | 963406 | 931182 | |||
|
1043169 | 1014851 | 1118165 | |||
Other long-term liabilities
|
821515 | 615599 | 533561 | |||
Total long-term liabilities
|
13536208 | 13144801 | 12589282 | |||
Total liabilities | 31438585 | 31371739 | 30386173 | |||
Mezzanine equity | ||||||
Model AA Class Shares, no par value,
|
504169 | 498073 | 491974 | |||
Shareholders' equity
|
||||||
Toyota Motor Corporation shareholders' equity
|
||||||
Common stock, no par value
|
397050 | 397050 | 397050 | |||
Additional paid-in capital
|
489334 | 487162 | 487502 | |||
|
23427613 | 21987515 | 19473464 | |||
Accumulated other comprehensive income (loss)
|
-1166273 | -916650 | 435699 | |||
|
-3087106 | -2606925 | -2057733 | |||
Total Toyota Motor Corporation shareholders' equity
|
20060618 | 19348152 | 18735982 | |||
Noncontrolling interests
|
677064 | 718985 | 694120 | |||
Total shareholders' equity
|
20737682 | 20067137 | 19430102 | |||
Commitments and contingencies
|
||||||
Total liabilities, mezzanine equity and shareholders' equity
|
52680436 | 21936949 | 50308249 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 6 steps with 5 images
Knowledge Booster
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.Recommended textbooks for you
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning