Please complete a 12 month Sales Budget:

BUDGETED BALANCE SHEET December 31, 2022 ASSETS: Current Assets: Cash 38,000 Accounts Receivable 16,000 Merchandise Inventory 5,500 TOTAL CURRENT ASSETS 59,500 Property, Plant, & Equipment: Equipment & Fixtures 88,000 Acc. Dep. - Equipment & Fixtures -16,000 TOTAL P,P,E 72,000 TOTAL ASSETS 131,500 LIABILITIES/OWNERS' EQUITY Current Liabilities: Accounts Payable 15,500 Salaries Payable (if needed) - Line of Credit - Notes Payable, Current Portion (if needed) - TOTAL CURRENT LIABILITIES 15,500 Long-Term Liabilities: N/P- Long-Term Portion (if needed) 0 TOTAL L/T LIABILITIES 0 TOTAL LIABILITIES 15,500 Owner's Equity: Capital 116,000 TOTAL OE 116,000 TOTAL LIABILITIES & SE 131,500

After first month of sales units, you will calculate sales units based on the below increases(decreases) % from the previous months sales (must use Excel formulas and cell locators for this.) JANUARY SALES BUDGET: 400 UNITS @ AVG. SELL AVG. SELLING $ PER FOR THE YEAR: $35..

FUTURE MONTHS SALES (Increases/(Decreases)) % from the Previous Months Sales: February 0% increase from previous month, March 1% increase previous month, April 2% increase previous month, May 2% increase previous month, June 1% increase previous month, July -1% decrease previous month, August 2% increase previous month, September 2% increase previous month, October 1% increase previous month, November 0% increase previous month, December -1% decrease previous month, January 2026 0% previous month: Sales Collections: 60% CASH SALE AND 40% SALES ON ACCOUNT paid off next month.