The Modern Elite Manufacturing Co has just completed the second draft of their master budget. The cash budget summary shows a negative cash balance in Quarter 1, 3 and 4. The company, however, is not considering new loans to address the deficits. They intend to complete repayment of the old loan and the final interest payment. The Cash budget summary, the budget Income statement and the budget Balance Sheet are shown below. Evaluate the cash budget situation and suggest actions that can be taken to prepare the company for the next period of operations. Prepare a new Cash Budget, Income Statement and Balance Sheet. Include a liquidity, profitability, and debt management analysis in your evaluation. Modern Elite Manufacturing Co for Budget Year 2024: Cash Budget Quarter 1 2 3 4 Cash Balance Beginning 32,500 -38,000 32,000 -18,000 ADD: Receipts 450,000 500,000 500,000 500,000 Total Cash Available 482,500 462,000 532,000 482,000 LESS: Disbursements 520,500 430,000 550,000 500,000 Excess (Deficits) of Cash -38,000 32,000 -18,000 -18,000 Modern Elite Manufacturing Co for Budget Year 2024: Income Statement Sales 2,000,000 Cost of Goods Sold 1,300,000 Gross Margin 700,000 Selling and Administration Expense 576,000 Net Operating Income 124,000 Interest Expense 1,200 Net Income 122,800 Previous Retain Earnings 449,900 Add: Net Income 122,800 Less: Dividends 20,000 New Retain Earnings 552,700 Accounting and Finance for Decision Making (GSFM7514) CONFIDENTIAL January 2023 Final Assessment 5 Modern Elite Manufacturing Co for Budget Year 2024: Balance Sheet Current Assets Cash -18,000 Account Receivables 150,000 Raw Materials 38,200 Inventories 34,000 Total Current Assets 204,200 Land 100,000 Plant and Machines 830,000 Less: Accumulated Depreciation 392,000 Plant and Machines Net 438,000 TOTAL ASSETS 742,200 Current Liabilities Accounts Payable 14,500 Total Current Liabilities 14,500 Stockholders Equity Common Stock 175,000 Retained Earnings 552,700 Total Equity 727,700 TOTAL LIABILITIES AND EQUITY 742,200