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!
Financial Accounting: The Impact on Decision Makers
10th Edition
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Gary A. Porter, Curtis L. Norton
Chapter12: The Statement Of Cash Flows
Section: Chapter Questions
Problem 12.2DC
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
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning