COGS INV PURCHASES BUDGET % Mar-25 Apr-25 May-25 Jan-25 Jul-25 Aug-25 Sep-25 04-25 Nov-25 DESIRED ENDING INV 5% of Next Mos COGS 5% OF SALES COGS Base TOTAL MERCHADISE REQUIRED IN SS LESS: Beginning Inventory S BUDGETED PURCHASES IN S Mostly this would be calculated as a % of next period's sales and not just a given number. Cash Paid% AP% paid sest mos Base Ending Inventory per mos % of next period's COGS Total Ending Inventory 3 Mar-25 S $ Apr-25 May-25 Jun-25 S Jul-25 S $ S S Aug-25 Sep-25 04-25 Nov-25 Jun-25 Jul-25 Aug-25 Sep-25 Oct-25 Nov-25 Dec-25 Jan-26 Feb-26 Mar-26 Apr-26 5 Jun-25 Jul-25 Aug-25 Sep-25 On-25 Nov-25 Dec-25 Jan-26 Feb-26 Mar-26 Ape-26 Do not have May COGS WORK WITH GROUP TO COMPLETE A GROUP BUDGET YOUR COMPANY HAME has applied for a loan. Its bank has requested a 12-month budget and Pro Forma Financials from April 30, 2025 through March 31, 2026. YOUR COMPANY'S Balance Sheet for the Month Ended March 31, 2025 is: BUDGETED BALANCE SHEET Current Assets: Mar-25 Cash 30,000 Accounts Receivable 12,000 Merchandise Inventory 6,000 TOTAL CURRENT ASSETS 48,000 Property, Plant, & Equipment Equipment & Fixtures 48,000 Acc. Dep.-Equipment & Fixtures (8,000) TOTAL P,P,E 40,000 TOTAL ASSETS 88,000 BUDGETED BALANCE SHEET Current Liabilities Accounts Payable Salaries Payable (if needed) Line of Credit Notes Payable, Current Portion (if needed) TOTAL CURRENT LIABILITIES Long-Term Liabilities N/P-Long-Term Portion (if needed) TOTAL L/T LIABILITIES TOTAL LIABILITIES Stockholder's Equity Common Stock Retained Earnings TOTAL SE Mar-25 8,300 8,300 8,300 20,000 59.700 79,700 TOTAL LIABILITIES & SE 88,000 FOO TOTAL PURCHASES FOR COGS INV PURCH INVENTORY BUDGET: COGS will be 45% of Sales; the base amount for ending inventory each month is $10,000+ a Desired Ending Inventory at 10% of next periods COGS. Total Purchases Required each month will be 40% in cash during the month and 60% remaining on Account at the end of each month