1. Suppose Steelcase doubled the amount of time to pay trade creditors. Use the proforma sheet to indicate the impact on the financial statements. What are the new plug figure to make the balance sheet balance? State answer omitting the last 000,000's consistent with proforma.

2. Suppose Steelcase has a change in operations, assuming Days Sales Outstanding and Days in Inventory both double, causing the operating cycle to double in length. What is the new Proforma Net Income? State answer omitting the last 000,000's consistent with proforma.

3.What is the RMA Industry's ROE? (Answer in terms of %, so 1.23% would just be 1.23).

4.What is the RMA Industry's Equity Multiplier?

5.What is the RMA Industry's ROA? (Answer in terms of %, so 1.23% would just be 1.23).

6.What is the inventory period for the industry (in days?)

Transcribed Image Text:

Steelcase Balance Sheet (000,000's omitted) Inputs are highlighted Common Size RMA FYE % FYE % FYE % FYE % FYE % of Industry ASSETS 2/23/2018 Chng 2/22/2019 Chng 2/28/2020 Chng 2/26/2021 Chng 2/25/2022 Tot Assets Comp Cash & Cash Equivalents 283.1 -8% 261.3 107% 541.0 -9% 489.8 -59% 200.9 8.9% 4.5% Marketable Securities 0.0 0.0 0.0 0.0 0.0 0.0% 2.0% Acct. Rec., less allowances 300.3 30% 390.3 -5% 372.4 -27% 270.3 26% 340.4 15.1% 40.3% Inventory 184.6 22% 224.8 -4% 215.0 -10% 193.5 69% 326.2 14.4% 29.2% Prepaid Expenses 19.2 2% 19.5 11% 21.6 -3% 20.9 15% 24.0 1.1% 2.0% Income Taxes Receivable 13.4 0.0 49.5 -16% 41.7 1.8% Other Current Assets 53.3 52.7 38.8 21.4 21% 26.0 1.1% Total Current Assets 853.9 11% 948.6 25% 1188.8 -12% 1045.4 -8% 959.2 42.4% 78.0% Net Property, Plant, & Equip 435.1 5% 455.5 -6% 426.3 -4% 410.8 -4% 392.8 17.4% Fixed Assets (Net) 435.1 5% 455.5 -6% 426.3 -4% 410.8 -4% 392.8 17.4% 16.7% Company Own Life Ins 172.2 156.1 160.0 169.5 -1% 168.0 7.4% 0.0% Deferred Income Taxes 135.4 135.8 124.6 113.3 121.2 Goodwill 138.2 240.8 233.6 218.1 242.8 Other Intangible Assets 45.6 119.3 102.9 90.4 85.5 Investments in Affiliates 48.4 18% 56.9 -8% 52.3 -2% 51.5 3% 53.1 2.3% 7.4% Right-of-use Operating Lease 0.0 0.0 237.9 225.4 -7% 209.8 9.3% 0.0% Other Assets 30.4 -3% 29.4 33% 39.0 -24% 29.6 -3% 28.6 1.3% 7.4% Total Assets 1859.2 15% 2142.4 20% 2565.4 -8% 2354.0 -4% 2261.0 100.0% 100.0% LIABILITIES Notes Payable - Bank & CM 2.8 4.1 Accounts Payable 223.1 Current Operating Lease 145.0 8% 16% 241.2 168.1 -74% 1% 2.9 244.3 43.1 4.7 5.1 0.2% 12.5% -26% 181.3 34% 243.6 10.8% 18.7% 2% 43.8 1% 44.2 2.0% 0.6% Accruals Employee Compensation 39.2 37.1 191.7 90.1 75.6 3.3% 1.3% Employee benefit plan 25.5 27.7 44.7 24.9 25.4 1.1% 1.3% Accrued promotions 28.2 -29% 20.0 77% 35.3 -21% 27.8 18% 32.9 1.5% 0.6% Contract with Customer, Liab 18.1 16.4 28.6 33.7 53.4 2.4% 1.3% Other Accrued Liabilities 72.8 80.6 100.3 108.7 87.0 3.8% 8.5% Total Current Liabilities 554.7 7% 595.2 16% 690.9 -25% 515.0 10% 567.2 25.1% 44.8% Long Term Debt (LTD) 292.2 65% 482.9 0% 481.4 0% 479.2 0% 477.4 21.1% 6.7% Employee Benefit Plans 130.8 141.6 148.3 152.9 126.7 Operating Lease Liability 0.0 214.0 199.5 182.2 Other Long Term Liabilities 68.2 7% 72.9 -17% 60.4 -22% 46.9 18% Total Liabilities 1045.9 24% 1292.6 23% 1595.0 -13% 1393.5 Redeemable NonControlling Inte 0.0 0% 0.0 0% 0.0 0% 0.0 Preferred Stock 0.0 0% 0.0 0% 0.0 0% 0.0 do do do do 55.3 2.4% 7.2% 1408.8 62.3% 58.7% 0.0% 0.0% Common Stock 0.0 0.0 0.0 0.0% Additional Paid-In Capital 4.6 257% 16.4 73% 28.4 -56% Retained Earnings 819.0 Accum. Other Comprehen. 8% (10.3) 359% Key Exec & Noncontrol Int Total Equity 0.0 813.3 Total Liabilities & Equity 1859.2 4% 15% 880.7 15% (47.3) 47% 0.0 #DIV/0! 849.8 14% 2142.4 1011.3 -2% (69.3) -42% 12.5 988.0 -9% (40.0) 27% -88% 1.5 0.1% 901.3 39.9% (50.6) -2.2% 0.0% 970.4 20% 2565.4 -1% 960.5 -11% -8% 2354.0 -4% 852.2 2261.0 37.7% 100.0% 100.0% 44.3% Steelcase Balance Sheet (000,000's omitted) Inputs are highlighted Common Size RMA FYE % FYE % FYE % FYE % FYE % of Industry ASSETS 2/23/2018 Chng 2/22/2019 Chng 2/28/2020 Chng 2/26/2021 Chng 2/25/2022 Tot Assets Comp Cash & Cash Equivalents 283.1 -8% 261.3 107% 541.0 -9% 489.8 -59% 200.9 8.9% 4.5% Marketable Securities 0.0 0.0 0.0 0.0 0.0 0.0% 2.0% Acct. Rec., less allowances 300.3 30% 390.3 -5% 372.4 -27% 270.3 26% 340.4 15.1% 40.3% Inventory 184.6 22% 224.8 -4% 215.0 -10% 193.5 69% 326.2 14.4% 29.2% Prepaid Expenses 19.2 2% 19.5 11% 21.6 -3% 20.9 15% 24.0 1.1% 2.0% Income Taxes Receivable 13.4 0.0 49.5 -16% 41.7 1.8% Other Current Assets 53.3 52.7 38.8 21.4 21% 26.0 1.1% Total Current Assets 853.9 11% 948.6 25% 1188.8 -12% 1045.4 -8% 959.2 42.4% 78.0% Net Property, Plant, & Equip 435.1 5% 455.5 -6% 426.3 -4% 410.8 -4% 392.8 17.4% Fixed Assets (Net) 435.1 5% 455.5 -6% 426.3 -4% 410.8 -4% 392.8 17.4% 16.7% Company Own Life Ins 172.2 156.1 160.0 169.5 -1% 168.0 7.4% 0.0% Deferred Income Taxes 135.4 135.8 124.6 113.3 121.2 Goodwill 138.2 240.8 233.6 218.1 242.8 Other Intangible Assets 45.6 119.3 102.9 90.4 85.5 Investments in Affiliates 48.4 18% 56.9 -8% 52.3 -2% 51.5 3% 53.1 2.3% 7.4% Right-of-use Operating Lease 0.0 0.0 237.9 225.4 -7% 209.8 9.3% 0.0% Other Assets 30.4 -3% 29.4 33% 39.0 -24% 29.6 -3% 28.6 1.3% 7.4% Total Assets 1859.2 15% 2142.4 20% 2565.4 -8% 2354.0 -4% 2261.0 100.0% 100.0% LIABILITIES Notes Payable - Bank & CM 2.8 4.1 Accounts Payable 223.1 Current Operating Lease 145.0 8% 16% 241.2 168.1 -74% 1% 2.9 244.3 43.1 4.7 5.1 0.2% 12.5% -26% 181.3 34% 243.6 10.8% 18.7% 2% 43.8 1% 44.2 2.0% 0.6% Accruals Employee Compensation 39.2 37.1 191.7 90.1 75.6 3.3% 1.3% Employee benefit plan 25.5 27.7 44.7 24.9 25.4 1.1% 1.3% Accrued promotions 28.2 -29% 20.0 77% 35.3 -21% 27.8 18% 32.9 1.5% 0.6% Contract with Customer, Liab 18.1 16.4 28.6 33.7 53.4 2.4% 1.3% Other Accrued Liabilities 72.8 80.6 100.3 108.7 87.0 3.8% 8.5% Total Current Liabilities 554.7 7% 595.2 16% 690.9 -25% 515.0 10% 567.2 25.1% 44.8% Long Term Debt (LTD) 292.2 65% 482.9 0% 481.4 0% 479.2 0% 477.4 21.1% 6.7% Employee Benefit Plans 130.8 141.6 148.3 152.9 126.7 Operating Lease Liability 0.0 214.0 199.5 182.2 Other Long Term Liabilities 68.2 7% 72.9 -17% 60.4 -22% 46.9 18% Total Liabilities 1045.9 24% 1292.6 23% 1595.0 -13% 1393.5 Redeemable NonControlling Inte 0.0 0% 0.0 0% 0.0 0% 0.0 Preferred Stock 0.0 0% 0.0 0% 0.0 0% 0.0 do do do do 55.3 2.4% 7.2% 1408.8 62.3% 58.7% 0.0% 0.0% Common Stock 0.0 0.0 0.0 0.0% Additional Paid-In Capital 4.6 257% 16.4 73% 28.4 -56% Retained Earnings 819.0 Accum. Other Comprehen. 8% (10.3) 359% Key Exec & Noncontrol Int Total Equity 0.0 813.3 Total Liabilities & Equity 1859.2 4% 15% 880.7 15% (47.3) 47% 0.0 #DIV/0! 849.8 14% 2142.4 1011.3 -2% (69.3) -42% 12.5 988.0 -9% (40.0) 27% -88% 1.5 0.1% 901.3 39.9% (50.6) -2.2% 0.0% 970.4 20% 2565.4 -1% 960.5 -11% -8% 2354.0 -4% 852.2 2261.0 37.7% 100.0% 100.0% 44.3%