Financial Statement for WABTEC CORP Fiscal Years 2020 to 2022 2020 2021 2022 BALANCE SHEET ASSETS Cash and Short Term Investments 598 700 473 000 541 000 Cash 598 700 473 000 534 000 Short Term Investments 0 000 0 000 7 000 Receivables 1,412 500 1,477 000 1,519 000 Receivables Trade 1,412 500 1,477 000 1,519 000 Income Tax Refund 0 000 0 000 0 000 Current Receivables Other 0 000 0 000 0 000 Inventories Total 1,642 100 1,689 000 2,034 000 Inventories Raw Materials 669 400 757 000 878 000 Inventories Work in Process 339 400 316 000 515 000 Inventories Finished Goods 633 300 616 000 641 000 Inventories Other 0 000 0 000 0 000 Current Assets Other 226 500 193 000 233 000 Prepaid Expense 0 000 0 000 0 000 Other Curr Asst, Excl Ppd Exp 226 500 193 000 233 000 Current Assets Total 3,879 800 3,832 000 4,327 000 Prop Plant Equip Total (Net) 1,601 600 1,497 000 1,429 000 P P E Total (Gross) 2,373 300 2,403 000 2,479 000 Deprec Depl Amort 771 700 906 000 1,050 000 Invest Advances Eq Meth 100 000 96 000 105 000 Invest Advances Other 101 000 153 000 162 000 Intangibles 12,354 400 12,292 000 11,910 000 Assets Other 417 700 584 000 583 000 Deferred Charges Other Asst , Excl Def Chg 417 700 584 000 583 000 Assets Total 18,454 500 18,454 000 18,516 000 LIABILITIES Debt in Current Liabilities 447 200 2 000 251 000 Notes Payable 0 000 0 000 0 000 Debt Due in One Year 447 200 2 000 251 000 Accounts Payable 909 400 1,012 000 1,301 000 Income Taxes Payable 0 000 0 000 0 000 Current Liabilities Other 1,869 700 1,896 000 1,915 000 Accrued Expense 988 100 1,050 000 940 000 Other Curr Liab , Excl Accr Exp 881 600 846 000 975 000 Current Liabilities Total 3,226 300 2,910 000 3,467 000 Long Term Debt Total 3,792 200 4,056 000 3,751 000 Debt Convertible (Total) 0 000 0 000 0 000 Debt Subordinated Convertible 0 000 0 000 0 000 Debt Senior Convertible 0 000 0 000 0 000 Debt Subordinated 0 000 0 000 0 000 Debt Notes 3,481 100 4,046 000 3,743 000 Debt Debentures 0 000 0 000 0 000 Long Term Debt Other 311 100 10 000 8 000 Debt Cap Lease Oblig Liabilities Other 1,114 900 961 000 825 000 Def Taxes and Invest Tax Cred 168 400 288 000 326 000 Deferred Taxes 168 400 288 000 326 000 Investment Tax Credit 0 000 0 000 0 000 Noncontrolling Interest Redeemable 0 000 0 000 0 000 Liabilities Total 8,301 800 8,215 000 8,369 000 SHAREHOLDERS' EQUITY Preferred Stock Carrying Value 0 000 0 000 0 000 Pref Stock Redeemable 0 000 0 000 0 000 Pref Stock Nonredeemable 0 000 0 000 0 000 Common Equity Total 10,201 000 10,102 000 Common Stock 2 000 2 000 2 000 Capital Surplus 7,880 600 7,916 000 7,953 000 Retained Earnings 3,249 800 3,589 000 3,916 000 Less Treas Stock Total $ Amt 1,010 100 1,306 000 1,769 000 Shareholders Equity Parent 10,122 300 10,201 000 10,102 000 Noncontrolling Interest Nonredeemable 30 400 38 000 45 000 Shareholders Equity Total 10,152 700 10,239 000 10,147 000 Total Liabilities and Shareholders Equity 18,454 500 18,454 000 18,516 000 For this assignment, you will only need to complete a table with the following ten ratios and Industry averages Current Ratio (Current Assets Current Liabilities) Quick Ratio (Current Assets Inventory) (Current Liabilities) Operating Profit Margin (Operating Profit Sales) Use operating income BEFORE depreciation Net Profit Margin (Net Income Sales) Operating Return on Assets (Operating Income Total Assets) Use operating income BEFORE depreciation WRDS calls it Return on Assets Return on Equity (Net Income Book Equity) Inventory Turnover (COGS Inventory) Total Asset Turnover (Sales Total Assets) WRDS calls it Asset Turnover Debt Equity Ratio (Total Liabilities Equity) WRDS calls it Total Debt Equity Debt Ratio (Total Liabilities Total Assets) WRDS calls it Total Debt Total Asset

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 22, 2024

Financial Statement for: WABTEC CORP Fiscal Years: 2020 to 2022 2020 2021 2022 BALANCE SHEET ASSETS Cash and Short-Term Investments 598.700 473.000 541.000 Cash 598.700

Financial Statement for: WABTEC CORP
Fiscal Years: 2020 to 2022
	2020	2021	2022

BALANCE SHEET
ASSETS
Cash and Short-Term Investments	598.700	473.000	541.000
Cash	598.700	473.000	534.000
Short-Term Investments	0.000	0.000	7.000
Receivables	1,412.500	1,477.000	1,519.000
Receivables - Trade	1,412.500	1,477.000	1,519.000
Income Tax Refund	0.000	0.000	0.000
Current Receivables - Other	0.000	0.000	0.000
Inventories - Total	1,642.100	1,689.000	2,034.000
Inventories - Raw Materials	669.400	757.000	878.000
Inventories - Work in Process	339.400	316.000	515.000
Inventories - Finished Goods	633.300	616.000	641.000
Inventories - Other	0.000	0.000	0.000
Current Assets - Other	226.500	193.000	233.000
Prepaid Expense	0.000	0.000	0.000
Other Curr.Asst, Excl.Ppd.Exp.	226.500	193.000	233.000
Current Assets - Total	3,879.800	3,832.000	4,327.000
Prop.Plant & Equip.- Total (Net)	1,601.600	1,497.000	1,429.000
P.P.& E.- Total (Gross)	2,373.300	2,403.000	2,479.000
Deprec.Depl.& Amort.	771.700	906.000	1,050.000
Invest. & Advances - Eq.Meth.	100.000	96.000	105.000
Invest. & Advances - Other	101.000	153.000	162.000
Intangibles	12,354.400	12,292.000	11,910.000
Assets - Other	417.700	584.000	583.000
Deferred Charges	.	.	.
Other Asst., Excl.Def.Chg.	417.700	584.000	583.000
Assets - Total	18,454.500	18,454.000	18,516.000
LIABILITIES
Debt in Current Liabilities	447.200	2.000	251.000
Notes Payable	0.000	0.000	0.000
Debt - Due in One Year	447.200	2.000	251.000
Accounts Payable	909.400	1,012.000	1,301.000
Income Taxes Payable	0.000	0.000	0.000
Current Liabilities - Other	1,869.700	1,896.000	1,915.000
Accrued Expense	988.100	1,050.000	940.000
Other Curr.Liab., Excl.Accr.Exp.	881.600	846.000	975.000
Current Liabilities - Total	3,226.300	2,910.000	3,467.000
Long-Term Debt - Total	3,792.200	4,056.000	3,751.000
Debt - Convertible (Total)	0.000	0.000	0.000
Debt - Subordinated Convertible	0.000	0.000	0.000
Debt - Senior Convertible	0.000	0.000	0.000
Debt - Subordinated	0.000	0.000	0.000
Debt - Notes	3,481.100	4,046.000	3,743.000
Debt - Debentures	0.000	0.000	0.000
Long-Term Debt - Other	311.100	10.000	8.000
Debt - Cap. Lease Oblig.	.	.	.
Liabilities - Other	1,114.900	961.000	825.000
Def. Taxes and Invest.Tax Cred.	168.400	288.000	326.000
Deferred Taxes	168.400	288.000	326.000
Investment Tax Credit	0.000	0.000	0.000
Noncontrolling Interest - Redeemable	0.000	0.000	0.000
Liabilities - Total	8,301.800	8,215.000	8,369.000
SHAREHOLDERS' EQUITY
Preferred Stock - Carrying Value	0.000	0.000	0.000
Pref. Stock - Redeemable	0.000	0.000	0.000
Pref. Stock - Nonredeemable	0.000	0.000	0.000
Common Equity - Total		10,201.000	10,102.000
Common Stock	2.000	2.000	2.000
Capital Surplus	7,880.600	7,916.000	7,953.000
Retained Earnings	3,249.800	3,589.000	3,916.000
Less: Treas.Stock - Total $ Amt.	1,010.100	1,306.000	1,769.000
Shareholders Equity - Parent	10,122.300	10,201.000	10,102.000
Noncontrolling Interest - Nonredeemable	30.400	38.000	45.000
Shareholders Equity - Total	10,152.700	10,239.000	10,147.000
Total Liabilities and Shareholders Equity	18,454.500	18,454.000	18,516.000

For this assignment, you will only need to complete a table with the following ten ratios and Industry averages.

Current Ratio: (Current Assets/Current Liabilities)
Quick Ratio: (Current Assets Inventory)/(Current Liabilities)
Operating Profit Margin: (Operating Profit/Sales) Use operating income BEFORE depreciation
Net Profit Margin: (Net Income/Sales)
Operating Return on Assets: (Operating Income/Total Assets) Use operating income BEFORE depreciation. WRDS calls it Return on Assets
Return on Equity: (Net Income/Book Equity)
Inventory Turnover: (COGS/Inventory)
Total Asset Turnover: (Sales/Total Assets) WRDS calls it Asset Turnover
Debt/Equity Ratio: (Total Liabilities/Equity) WRDS calls it Total Debt/Equity
Debt Ratio: (Total Liabilities/Total Assets) WRDS calls it Total Debt/Total Asset