Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please complete problem 3- and 4 (there is no additional information) . 3. Calculate the current ratio, the quick ratio/acid-test ratio, and the amount of

please complete problem 3- and 4 (there is no additional information) .

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

3. Calculate the current ratio, the quick ratio/acid-test ratio, and the amount of working capital. Based on your calculations and some benchmark, can the company meet its short-term obligations? 4. Calculate the Debt to Equity Ratio. Based on your calculations and some benchmark, can the company meet its long-term obligations? han Fiscal 2021 Highlights Fiscal 2021 net sales decreased $167 million, or 8 percent, from the prior year, primarily due to lower sales in our CIS, HDE, and Automotive segments, partially offset by higher sales in our BHVAC segment. Foreign currency exchange rate changes favorably impacted sales in fiscal 2021 by $28 million. Cost of sales decreased $153 million, or 9 percent, from last year, primarily due to lower sales volume. Gross profit decreased $14 million and gross margin improved 60 basis points to 16.2 percent. SG&A expenses decreased $39 million, primarily due to lower costs associated with our review of strategic alternatives for our Automotive segment businesses and preparing the liquid-and air-cooled automotive businesses for sale. In addition, SG&A expenses decreased due to cost-reduction initiatives implemented early in the fiscal year in response to the negative impacts of COVID-19. The operating loss of $98 million during fiscal 2021 represents a $136 million decline from the prior-year operating income of $38 million and was primarily due to $167 million of impairment charges recorded primarily for assets of the liquid- and air-cooled automotive businesses, partially offset by lower SG&A expenses. Fiscal 2020 Highlights Fiscal 2020 net sales decreased $237 million, or 11 percent, from the prior year, primarily due to lower sales in our HDE, CIS, and Automotive segments, partially offset by higher sales in our BHVAC segment. Foreign currency exchange rate changes negatively impacted sales in fiscal 2020 by $46 million. Cost of sales decreased $179 million, or 10 percent, from the prior year, primarily due to lower sales volume. Gross profit decreased $58 million and gross margin declined 90 basis points to 15.6 percent. SG&A expenses increased $6 million, primarily due to higher costs associated with the review of strategic alternatives for our Automotive segment businesses, partially offset by lower-compensation related expenses. Operating income during fiscal 2020 decreased $72 million to $38 million, primarily due to lower gross profit and higher SG&A expenses. The following table presents our consolidated financial results on a comparative basis for fiscal years 2021, 2020 and 2019. Years ended March 31, 2021 2020 2019 (in millions) $'s % of sales S's % of sales S's We of sales Net sales 1,805 100.0% S 1,976 100.0% 2.213 100.00 Cost of sales 1.515 83.8% 1,668 84.4% 1.847 83.5% Gross profit 293 16.2% 308 15.6% 366 16.5% Selling, general and administrative expenses 211 11.7% 250 12.6% 244 11.0% Restructuring expenses 13 0.7% 12 0.6% 10 0.4% Impairment charges 167 9.2% 9 0.4% (Gain) loss on sale of assets (1) 0.1 Operating (loss) income 198) -5.4% 38 1.9% 5.0M Interest expense (19) -1.1% (23) -1.1% (25 -1.1% Other expense - net (2) -0.1% (5) -0.2% -0.2% (Loss) earnings before income taxes (119) -6.6% 10 0.5% 81 3.7% (Provision) benefit for income taxes (90) -5.0% (12 -0.6% 0.2% Net (Loss) earnings (209) - 11.6% $ (2) -0.1% 86 3.9% 110 141 Year Ended March 31, 2021 Compared with Year Ended March 31, 2020 Fiscal 2021 net sales of $1,808 million were $167 million, or 8 percent, lower than the prior year, primarily due to lower sales volume in the CIS, HDE, and Automotive segments, partially offset by a $28 million favorable impact of foreign currency exchange rate changes and higher sales volume in the BHVAC segment. Sales in the CIS, HDE and Automotive segments decreased $92 million, $64 million and $47 million, respectively, and were significantly impacted by market-driven volume declines and temporary plant closures early in the fiscal year due to the COVID-19 pandemic. Sales increased $20 million in our BHVAC segment. Fiscal 2021 cost of sales of $1,515 million decreased $153 million, or 9 percent, primarily due to lower sales volume. Fiscal 2021 cost of sales was negatively impacted by $24 million from foreign currency exchange rate changes. As a percentage of sales, cost of sales decreased 60 basis points to 83.8 percent. The unfavorable impacts of lower sales volume and, to a lesser extent, higher material costs, which negatively impacted cost of sales as a percentage of sales by approximately 50 basis points were more than offset by benefits from procurement and other cost-reduction initiatives and an $8 million decrease in depreciation expense in the Automotive segment. We ceased depreciating the long-lived assets within the liquid- and air- cooled automotive businesses once they were classified as held for sale during fiscal 2021. In addition, program and equipment transfer costs to prepare the liquid-cooled automotive business for sale decreased approximately $3 million compared with the prior year. III $ Search Facts a Y Facts 1,980 28 Table of contents Fiscal 2020 SG&A expenses increased $6 million. The increase in SG&A was primarily due to separation and project costs recorded at Corporate associated with our review of strategic alternatives for the Automotive segment businesses, which increased approximately $29 million. This increase was partially offset by lower compensation-related expenses, which decreased approximately $13 million, lower environmental charges related to previously-owned manufacturing facilities in the U.S., which decreased approximately $3 million, and a $4 million favorable impact from foreign currency exchange rate changes. Restructuring expenses totaled $12 million during fiscal 2020 and increased $2 million compared with the prior year. The fiscal 2020 restructuring expenses primarily consisted of severance expenses related to targeted headcount reductions in the HDE and Automotive segments and equipment transfer and plant consolidation costs in the CIS segment. During fiscal 2020, we recorded impairment charges totaling $9 million, primarily related to two manufacturing facilities in the Automotive segment. Operating income of $38 million during fiscal 2020 decreased $72 million compared with the prior year. This decrease was primarily due to an increase of $32 million of separation and project costs associated with our review of strategic alternatives for our automotive businesses and lower earnings in our HDE, CIS, and Automotive segments, which decreased $27 million, $20 million, and $10 million respectively, partially offset by higher earnings in our BHVAC segment, which increased $9 million. The provision for income taxes was $12 million in fiscal 2020, compared with a benefit for income taxes of $5 million in fiscal 2019. The $17 million change was primarily due to the absence of income tax benefits totaling $25 million recorded in fiscal 2019 and income tax charges totaling $10 million in fiscal 2020 partially offset by lower operating earnings in fiscal 2020. The $25 million of income tax benefits recorded in fiscal 2019 related to the recognition of tax assets for foreign tax credits and a manufacturing deduction in the U.S. and our accounting for the Tax Act. The $10 million of income tax charges in fiscal 2020 were comprised of net charges totaling $7 million resulting from adjustments of valuation allowances on certain deferred tax assets in the U.S. and in a foreign jurisdiction and $3 million associated with legal entity restructuring in preparation for a potential sale of the liquid-cooled automotive business. Segment Results of Operations Effective April 1, 2020, we began managing our global automotive business separate from the other businesses within the previously-reported VTS segment. We have been managing the automotive business as the Automotive segment as we work towards the sale or eventual exit of its underlying automotive business operations. We are managing the other businesses of the VTS segment, including the commercial vehicle and off-highway businesses, as the HDE segment. We began reporting financial results for our new segment structure beginning for fiscal 2021. Segment financial information for fiscal 2020 and 2019 has been recast to conform to the fiscal 2021 presentation. The segment realignment had no impact on the CIS and BHVAC segments. BHVAC Years ended March 31, 2021 2020 2019 (in millions) $'s We of sales S's W of sales S's W of sales Net sales 241 100.0% 3 221 100.0% 212 100.0% Cost of sales 158 65.5% 150 67.7% 149 70.1% Gross profit 83 34.5% 72 32.3% 29.9% Selling, general and administrative expenses 36 14.9% 35 15.8% 16.4% Loss on sale of assets 0.8% Operating income 19.6 36 12.6 Year Ended March 31, 2021 Compared with Year Ended March 31, 2020 BHVAC net sales increased $20 million, or 9 percent in fiscal 2021 compared with the prior year, primarily due to higher sales in the U.K. and the U.S., which increased $14 million and $5 million, respectively. The higher sales in the U.K. were primarily due to higher sales of data center cooling products. The higher sales in the U.S. were primarily due to higher sales of heating products, partially offset by lower sales of ventilation products. IA R 16.5% Table of contents CIS cost of sales decreased $66 million, or 12 percent, primarily due to lower sales volume, partially offset by an $11 million unfavorable impact of foreign currency exchange rate changes. As a percentage of sales, cost of sales increased 240 basis points to 87.5 percent, primarily due to the impact of lower sales volume and unfavorable sales mix, partially offset by cost-reduction and procurement initiatives. As a result of the lower sales and higher cost of sales as a percentage of sales, gross profit decreased $26 million and gross margin declined 240 basis points to 12.5 percent. CIS SG&A expenses decreased S4 million compared with the prior year. The decrease in SG&A expenses was primarily due to lower compensation- related expenses, which decreased approximately $5 million, partially offset by a $1 million unfavorable impact of foreign currency exchange rate changes Restructuring expenses during fiscal 2021 increased $3 million, and primarily consisted of severance expenses and equipment transfer costs related to plant consolidation activities in China and targeted headcount reductions in North America. Operating income in fiscal 2021 decreased $25 million to $8 million, primarily due to lower gross profit and higher restructuring expenses, partially offset by lower SG&A expenses. Year Ended March 31, 2020 Compared with Year Ended March 31, 2019 CIS net sales decreased $84 million, or 12 percent, in fiscal 2020 compared with the prior year, primarily due to lower sales volume and a $12 million a unfavorable impact of foreign currency exchange rate changes. Sales to commercial HVAC&R and data center cooling customers decreased $43 million and $38 million, respectively CIS cost of sales decreased of sales, cost of sales increased 130 basis points to 85.1 percent, primarily due to the unfavorable impact of lower sales CIS cost of sales decreased $62 million, or 10 percent, primarily due to lower sales volume and an $11 million favorable foreign currency exchange rate . As , volume and unfavorable sales mix. As a result of the lower sales and higher cost of sales as a percentage of sales, gross profit decreased $22 million and gross margin declined 130 basis points to 14.9 percent. CIS SG&A expenses decreased S4 million compared with the prior year, primarily due to lower compensation-related expenses, which decreased approximately $2 million, and the favorable impact of cost-control initiatives. Restructuring expenses during fiscal 2020 increased $2 million, primarily due to higher equipment transfer and plant consolidation costs. During fiscal 2020, we recorded a $1 million asset impairment charge related to a previously-closed manufacturing facility in Austria. Operating income in fiscal 2020 decreased $20 million to $33 million, primarily due to lower gross profit, partially offset by lower SG&A expenses. 31 Tuhle of contents HDE 2021 3's $'s 682 Years ended March 31, 2020 3's % of sales 746 100.0% $ 649 87.0% 97 13,0% (in millions) Net sales Cost of sales Gross profit Selling, general and administrative expenses Restructuring expenses Operating income % 6 of sales 100.0% 87.0% 13.0% 594 2019 W V of sales 872 100.0% 744 85.3% 128 14.7% 88 49 3 37 7.1% 0.4% 5.4% 56 3 38 7.4% 0.4% 5.1% 62 1 65 7.1% 0.1% 7.5% Year Ended March 31, 2021 Compared with Year Ended March 31, 2020 HDE net sales decreased $64 million, or 9 percent, in fiscal 2021 compared with the prior year, primarily due to lower sales volume resulting from the impacts of the COVID-19 pandemic, which were most severe in the Americas and Europe during the first half of the fiscal year. Sales to off-highway, customers increased $20 million and were offset by lower sales to commercial vehicle and automotive and light vehicle customers, which decreased $52 million and $11 million, respectively. HDE cost of sales decreased $55 million, or 8 percent, primarily due to lower sales volume. As a percentage of sales, cost of sales was consistent at 87.0 percent. Beyond the unfavorable impacts of the lower sales volume, higher material costs impacted cost of sales as a percentage of sales by approximately 100 basis points. The unfavorable materials costs primarily resulted from higher commodity pricing and tariffs on imported materials. These negative impacts were largely offset by favorable impacts from improved operating efficiencies and cost savings from procurement and other cost-reduction initiatives. As a result of the lower sales, gross profit decreased $9 million. Gross margin of 13.0 percent was consistent with the prior year. HDE SG&A expenses decreased $7 million compared with the prior year. The decrease in SG&A expenses was primarily due to lower compensation- &7 & related expenses, which decreased approximately $6 million, and cost-reduction initiatives, including lower travel expenses. Restructuring expenses during fiscal 2021 totaled $3 million, consistent with the prior year. Fiscal 2021 restructuring expenses primarily consisted of severance expenses resulting from targeted headcount reductions in North America. Operating income in fiscal 2021 decreased $1 million to $37 million, primarily due to lower gross profit, partially offset by lower SG&A expenses. Year Ended March 31, 2020 Compared with Year Ended March 31, 2019 HDE net sales decreased $126 million, or 14 percent, in fiscal 2020 compared with the prior year, primarily due to lower sales volume, a $15 million unfavorable impact of foreign currency exchange rate changes, and, to a lesser extent, unfavorable customer pricing largely resulting from contractually-scheduled price-downs. Sales to off-highway and commercial vehicle customers decreased $57 million and $$1 million, respectively. These sales declines largely resulted from weakness in global vehicular markets and the planned wind-down of certain commercial vehicle programs. HDE cost of sales decreased $95 million, or 13 percent, primarily due to lower sales volume and a $13 million favorable impact of foreign currency exchange rate changes. As a percentage of sales, cost of sales increased 170 basis points to 87.0 percent. Beyond the unfavorable impact of the lower sales volume, higher labor and inflationary costs and unfavorable customer pricing negatively impacted cost of sales as a percentage of sales by approximately 110 basis points and 80 basis points, respectively. These negative impacts were partially offset by improved operating efficiencies and cost savings from procurement initiatives. As a result of the lower sales and higher cost of sales as a percentage of sales, gross profit decreased $31 million and gross margin declined 170 basis points to 13.0 percent. HDE SG&A expenses decreased $6 million compared with the prior year, primarily due to lower compensation-related expenses and environmental charges related to previously-owned manufacturing facilities in the US, which each decreased approximately $3 million. Restructuring expenses during fiscal 2020 increased $2 million, primarily due to higher severance expenses resulting from targeted headcount reductions in the Americas. Operating income in fiscal 2020 decreased $27 million to $38 million, primarily due to lower gross profit, partially offset by lower SG&A expenses. 32 Table of Contents ITEM 8. FINANCIAL STATEMENTS AND SUPPLEMENTARY DATA. MODINE MANUFACTURING COMPANY CONSOLIDATED STATEMENTS OF OPERATIONS For the years ended March 31, 2021, 2020 and 2019 (In millions, except per share amounts) $ S 2021 1.808.4 1,515.0 293.4 210.9 13.4 166.8 Net sales Cost of sales Gross profit Selling, general and administrative expenses Restructuring expenses Impairment charges (Gain) loss on sale of assets Operating (loss) income Interest experise Other expense - net (Loss) earnings before income taxes (Provision) benefit for income taxes Net (loss) earnings Net earnings attributable to noncontrolling interest Net (loss) earnings attributable to Modine Net (loss) earnings per share attributable to Madine shareholders: Basic Diluted Weighted average shares outstanding: Basic Diluted 2020 1.975.5 1.668.0 307.5 249.6 12.2 8,6 (0.8 37.9 (22.7 4.8 10.4 (12.4) (2.0) (0.2 2019 2,212.7 1,847.2 365.5 244.1 9.6 0.4 1.7 109.7 (24.8) (4.1 80.8 5.1 85.9 (1.1 84.8 (97.7 (19.4) (2.2) (1193) (90.2) (209.5) (1.2 (210.7) $ TII (2.2 (4.11) $ (4.11) $ (0.04) (0.04) S S 1.67 1.65 $ 51.3 51.3 50.8 50.8 50.5 51.3 The notes to consolidated financial statements are an integral part of these statements. 44 Table of Contents MODINE MANUFACTURING COMPANY CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME For the years ended March 31, 2021, 2020 and 2019 (In millions) 2021 (209.5) $ 2020 (2.0) 2019 85.9 S Net (loss) earnings Other comprehensive income (loss): Foreign currency translation Defined benefit plans, net of income taxes of $10.4. ($8.3) and ($0.3) million Cash flow hedges, net of income taxes of $0.6, (30.5) and $0.1 million Total other comprehensive income (Loss) 30.9 30.1 1.6 (19.2) (246) (1.5 (45.3) (37.6 (1.4) 0.4 (38.6) 62.6 (146.9) Comprehensive income (loss) Comprehensive (income) loss attributable to noncontrolling interest Comprehensive income (loss) attributable to Modine (1.7) (47.3 0.2 (471) S 47.3 (0.6 46.7 (148.6) $ The notes to consolidated financial statements are an integral part of these statements. 2021 2020 2019 $ (2.0) S 85.9 67.9 6.3 (5.0) 44.0 15.7 27.5 (21.7 149.8 Cash flows from operating activities: Net (loss) earnings Adjustments to reconcile net (loss) earnings to net cash provided by operating activities: Depreciation and amortization Impairment charges (Gain) loss on sale of assets Stock-based compensation expense Deferred income taxes Othernet Changes in operating assets and liabilities: Trade accounts receivable Inventories Accounts payable Accrued compensation and employee benefits Other assets Other liabilities Net cash provided by operating activities Cash flows from investing activities: Expenditures for property, plant and equipment Proceeds from dispositions of assets Proceeds from sale of investment in affiliate Proceeds from maturities of short-term investments Purchases of short-term investments Othernet Net cash used for investing activities Cash flows from financing activities: Borrowings of debt Repayments of debt Borrowings on bank overdraft facilities -net Dividend paid to noncontrolling interest Purchase of treasury stock under share repurchase program Financing fees paid Othernet Net cash (used for) provided by financing activities Effect of exchange rate changes on cash Net (decrease) increase in cash, cash equivalents, restricted cash and cash held for sale Cash, cash equivalents, restricted cash and cash held for sale - beginning of year Cash, cash equivalents, restricted cash and cash held for sale - end of year The notes to consolidated financial statements are an integral part of these statements. Le... blague a la El | EI:18:31: ABISEI SAHIS Hazlo bla. Bez blaga, el RECECE 18@2017 (60.5 32.7 (183,6) 672.0 (630,3) 1.2 (1.3 (2.4 (2.8 (3.1 33.3 ( ) (1.6 29.1 42.2 71.3 46.1 $ 47 Table of Contents MODINE MANUFACTURING COMPANY CONSOLIDATED BALANCE SHEETS March 31, 2021 and 2020 (In millions, except per share amounts) 2021 2020 S 70.9 292.5 207.4 ASSETS Cash and cash equivalents Trade accounts receivable-net Inventories Assets held for sale Other current assets Total current assets Property, plant and equipment - net Intangible assets-net Goodwill Deferred income taxes Other noncurrent assets Total assets 1 37.8 267,9 195.6 107.6 35.9 644.8 269.9 100.6 170.7 24.5 66.2 1.276.7 62.5 633.3 448.0 106.3 166.1 104.8 77.6 1,536.1 $ S S 14.8 15.6 227.4 65.0 LIABILITIES AND SHAREHOLDERS' EQUITY Short-term debt Long-term debt -current portion Accounts payable Accrued compensation and employee benefits Liabilities held for sale Other current liabilities Total current liabilities Long-term debt Deferred income taxes Pensions Other noncurrent liabilities Total liabilities Commitments and contingencies (see Note 20) Shareholders' equitya Preferred stock $0.025 par value, authorized 16.0 million shares, issued - none Common stock, $0.625 par value, authorized 80.0 million shares, issued 54.3 million and 53.4 million shares Additional paid-in capital Retained earnings Accumulated other comprehensive loss Treasury stock, at cost, 2.7 million and 2.5 million shares Total Modine shareholders' equity Noncontrolling interest Total equity Total liabilities and equity 1.4 21.9 233.9 66.5 103.3 42.2 469.2 311.2 5.9 58.6 75.7 920.6 49.2 372.0 452.0 8.1 130.9 79.5 1,042.5 33.9 255.0 259.2 (161.2 (38.2 348.7 7.4 356.1 1,276.7 33.3 245.1 469.9 (223.3 (37.1 487.9 5.7 493.6 1,536.1 $ S The notes to consolidated financial statements are an integral part of these statements. 46 Table of Contents

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Bev Vickerstaff, Parminder Johal

1st Edition

1444170414, 978-1444170412

More Books

Students also viewed these Accounting questions

Question

Was the Hawthorne effect operating?

Answered: 1 week ago