Calculate the Horizontal (Trend) Analysis and horizontal analysis % change for the year 2020, 2019, 2020Please use excel to calculate the formula Thank you! Toyota Motor CorporationConsolidated Balance Sheet 202020192018Assets Current Assets Cash and Cash equivalents 419051835747043,052,269 Time Deposits 8282201126352901244 Marketable securities 67873111271601768360 Trade accounts and notes recievables 209489423727342219562 less A.F.D.A. Finance receivables, net 661417166477716438306 Other recievables 564854568156489338 Inventories 243491826563962539789 Prepaid expenses and other current assets 1236225805964833788 Total current assets 186425311887923718,242,656Noncurrent finance recievables, net 10423858102811189481618Investments and other assets: Marketable securities, and investments 734865174799267999323 Afffiliated companies 412345333137233162917 Employees receivables 214842168322562 Other 151893412757681221500 Total investmenrs and other assets 130125221209110012406302Property, plant and equipment: Land 134698813863081404611 Buildings 473078348021754659753 Machinery and equipment 119391211185742511535381 Vehicles and equipment on operating leases 592923361391635934393 Construction in progress 510963651713509851 Total property, plant and equipment, at cost 244570882483678424043989 Less – Accumulated depreciation -13855563-14151290-13776316 Total property, plant and equipment, net 106012521068549410267673Total assets 526804365193694950308249Liabilities Current liabilities: Short-term borrowings 528602653449735154913 Current portion of long-term debt 457404542542604186277 Accounts payable 243418026459842586657 Other payables 102027011028021048216 Accrued expenses 293605232224463104260 Income taxes payable 218117320998462327 Other current liabilities 144368713354751254241 Total current liabilities 179123771822693817796891Long-term liabilities Long-term deb 106921055094510006374 Accrued pension and severance costs 978626963406931182 Deferred income taxes 104316910148511118165 Other long-term liabilities 821515615599533561 Total long-term liabilities 135362081314480112589282Total liabilities 314385853137173930386173Mezzanine equity Model AA Class Shares, no par value, 504169498073491974 Shareholders' equity Toyota Motor Corporation shareholders' equity Common stock, no par value 397050397050397050 Additional paid-in capital 489334487162487502 Retained earnings 234276132198751519473464 Accumulated other comprehensive income (loss) -1166273-916650435699 Treasury stock, at cost -3087106-2606925-2057733 Total Toyota Motor Corporation shareholders' equity 200606181934815218735982Noncontrolling interests 677064718985694120Total shareholders' equity 207376822006713719430102Commitments and contingencies Total liabilities, mezzanine equity and shareholders' equity 526804362193694950308249

Answered: Image /qna-images/answer/27e7d79b-d04c-4791-8774-88970751e3ff.jpg

Answered: Calculate the Horizontal (Trend)…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

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 – Accumulated depreciation	-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
	Deferred income taxes	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
	Retained earnings	23427613	21987515	19473464
	Accumulated other comprehensive income (loss)	-1166273	-916650	435699
	Treasury stock, at cost	-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

Step by step

Solved in 6 steps with 5 images

SEE SOLUTION Check out a sample Q&A here

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.