Question
As a group, your assignment is to: 1. Calculate financial ratios (liquidity, profitability, leverage, asset efficiency, returns) for the years included in the attached financial
As a group, your assignment is to: 1. Calculate financial ratios (liquidity, profitability, leverage, asset efficiency, returns) for the years included in the attached financial statements. 2. In each of five focus areas (liquidity, profitability, ), provide your view/thoughts for Waders consideration. 3. List, in order of priority (#1 being the highest), the three greatest concerns your group has about the historical performance and explain your thoughts. 4. List, in order of priority, the three greatest concerns your group has with the one-year financial forecast provided by Wader and explain your thoughts. 5. Use your answer in #4 (three greatest concerns about Waders forecast) to create your own forecast. In Excel, create a new, one-year forecast (balance sheet, income statement and statement of cash flow) that combines the companys forecast with your responses in #4 to reflect an adjusted forecast that you are more comfortable with.
($ in 000s) Actual 1 Actual Actual Plan 12/31/2017 12/31/2018 12/31/2019 12/30/2020 Net Sales 628,800 474,831 544,111 580,000 Cost of Sales 548,500 356,435 397,386 386,800 Gross Profit Margin 80,300 118,396 146,725 193,200 SG&A Expense 50,100 55,971 92,205 134,502 Depreciation Expense 13,600 7,687 12,654 13,100 Other expenses 14,400 5,280 3,000 Restructuring 19,764 9,431 2,598 Management Fees 3,976 1,591 5,000 Total Operating Expenses 78,100 87,398 121,161 158,200 Net Operating Profit 2,200 30,998 25,564 35,000 Interest Expense (2,100) (2,588) (4,620) (4,000) Interest Income 620 857 Dividend on Preferred Stock (1,099) FX Exchange Loss/Restructuring/Other 1,500 (4,772) (2,307) (1,500) Profit Before Tax 1,600 23,159 19,494 29,500 Income Tax Expense 10,200 9,468 7,902 7,375 Profit Before Extraordinary Item (8,600) 13,691 11,592 22,125 Bargain Purchase Gain (after tax) 147,220 Net Profit (8,600) 160,911 11,592 22,125 Dividends - Common (34,400) (45,000) (40,000) 1 Brakegen was owned by AfterM on 12/31/2017 . Balances from consolidating statements Midwest Shocks Consolidated Income Statement
($ in 000s) Actual 1 Actual Actual Plan Assets 12/31/2017 12/31/2018 12/31/2019 12/30/2020 Cash 25,480 38,349 24,224 27,913 A/R Net 92,497 75,654 69,829 72,703 Inventory 196,575 174,066 157,134 153,172 Other Curr. Assets 63,492 14,828 16,721 33,314 TOTAL CURRENT ASSETS 378,044 302,897 267,908 287,102 Land and Improvements 23,785 20,067 18,486 18,486 Buildings 52,078 43,842 37,805 37,805 Equipment 47,682 40,644 61,162 81,264 Accum. Depreciation 10,822 7,360 19,450 32,550 PP&E - Net 112,723 97,193 98,003 105,005 Intangibles 25,412 3,088 2,779 Other L/T Assets 20,396 6,527 7,541 1,307 Total Non-Current Assets 292,898 103,720 108,632 109,091 TOTAL ASSETS 670,942 406,617 376,540 396,193 Liabilities and Equity Accounts Payable 57,055 58,626 54,431 62,858 Accrued Compensation 29,976 15,593 15,333 18,941 Other Accrued Expenses 53,290 40,550 50,701 49,246 Taxes Payable 14,282 10,200 912 7,576 CMLTD TOTAL CURRENT LIABILITIES 154,603 124,969 121,377 138,621 ABL - Revolving Loan 81,000 50,000 43,000 67,247 Senior Debt (foreign) 11,928 11,928 11,928 11,928 Senior Debt (#1) 35,122 32,976 32,976 Senior Debt (#2) 20,981 20,981 Other Long-Term Liab's. 4,434 2,722 1,820 Deferred Income Taxes 16,521 2,537 4,831 3,589 TOTAL NON-CURRENT LIAB'S. 109,449 104,021 116,438 138,541 TOTAL LIABILITIES 264,052 228,990 237,815 277,162 EQUITY Common Stock 29 29 29 Additoninal Paid-In Capital 37,870 38,232 38,232 Retained Earnings 136,521 103,242 83,548 Accum. Other Comp. (Loss)/Income 3,207 (2,778) (2,778) Total Brakegen Shareholder's Equity 177,627 138,725 119,031 TOTAL LIABILITIES AND EQUITY #REF! 406,617 376,540 396,193 1 Brakegen was owned by AfterM on 12/31/2017 . Balance Sheet not available Midwest Shocks Consolidated Balance Sheets
($ in 000s) Actual Actual Plan 12/31/2018 12/31/2019 12/30/2020 CASH FLOWS FROM OPERATING ACTIVITIES Net Income 160,911 11,592 22,125 Depreciation 7,687 12,654 13,100 Loss On Sale of PP&E 143 Bargain Purchase Option (147,220) Other Non-Cash Items 1,453 692 (593) Deferred Income Tax (901) 2,294 (1,242) Changes In Assets/Liabilities Accounts Receivable 17,259 5,825 (2,874) Inventories 16,681 16,932 3,962 Prepaid Expenses and Other 7,105 (1,893) (16,593) Accounts Payable and accruals 18,938 5,956 6,972 Income Taxes Payable 3,180 (9,288) 6,664 Accrued Compensation 3,406 (260) 3,608 Other Current Other Long-Term Assets 2,509 (2,726) 6,234 Net Cash Provided by Operations 91,008 41,921 41,363 CASH FLOWS FROM INVESTING ACTIVITIES Capital Expenditures (11,451) (16,157) (20,102) Proceeds From Sales of PP&E 6,785 2,550 Other (37,602) (4,102) Net Cash Used In Investing Activities (42,268) (17,709) (20,102) CASH FLOWS FROM FINANCING ACTIVITIES ABL Revolver (31,000) (7,000) 24,247 Senior Debt (foreign) Senior Debt #1 35,122 (2,146) Senior Debt #2 20,981 Capital Contributions 37,602 Dividends (34,400) (45,000) (40,000) Repayment of Preferred Stock (31,099) Other (418) (3,433) Net Cash Used in Financing Activities (24,193) (36,598) (15,753) Effect of Foreign Currency Exchange Rate Changes (1,119) (1,739) (1,819) CHANGE IN CASH 23,428 (14,125) 3,689
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started