Need balance sheets for September and October please use a format like balance sheet given for august with formulas !!

Bobcat Beverage Company
Balance Sheets
As of
	August 31, 2021			September 30, 2021			October 31, 2021
ASSETS
CURRENT ASSETS
Cash	$ 25,800
Accounts Receivable	$ 595,000
Inventory	$ 50,688
Prepaid Insurance	$ 27,500
TOTAL CURRENT ASSETS		$ 698,988
PROPERTY PLANT & EQUIPMENT
Land	$ 100,000
Equipment	$ 300,000
Accumulated Depreciation	$ (100,000)
TOTAL PPE		$ 300,000
TOTAL ASSETS		$ 998,988
LIABILITIES & STOCKHOLDERS EQUITY
CURRENT LIABILITIES
Accounts Payable	$ 81,859
Commissions Payable	$ 59,500
Advertising Expense Payable	$ 121,250
Income Taxes Payable	$ 22,000
Dividends Payable	$ -
TOTAL CURRENT LIABILITIES		$ 284,609
LONG TERM DEBT		$ 220,000
STOCKHOLDERS EQUITY
Common Stock	$ 89,500
Retained Earnings	$ 404,879
TOTAL STOCKHOLDERS EQUITY		$ 494,379
TOTAL LIABILITIES & STOCKHOLDERS EQUITY		$ 998,988

Layout References Mailings Review View Grammarly Acrobat Table Design Layc Bobcat Beverage Company Balance Sheets As of August 31, 2021 ASSETS CURRENT ASSETS Cash $ 25,800 Accounts Receivable $ 595,000 Inventory 5 50,688 Prepaid Insurance $ 27.500 $ TOTAL CURRENT ASSETS 698,988 PROPERTY PLANT & EQUIPMENT Land Equipment $ 100,000 $ 300.000 $ (100,000) Accumulated Depreciation TOTAL PPE $ 300,000 TOTAL ASSETS 998,988 LIABILITIES & STOCKHOLDERS EQUITY CURRENT LIABILITIES Accounts Payable $ Commissions Payable $ Advertising Exponse Payable $ Income Tabes Payable $ Dividends Payablo $ 81,859 59.500 121.250 22.000 I $ 284,509 TOTAL CURRENT LIABILITIES LONG TERM DEBT 220.000 STOCKHOLDERS EQUITY Common Stock Rotained Earnings 89,500 404 879 TOTAL STOCKHOLDERS EQUITY $ 494.379 TOTAL LIABILITIES & STOCKHOLDERS EQUITY 998,988 8508 Document Mallings View an Review Acrobat Layout References Table Design Grammarly Layout Tell me September 5800,000 October $900,000 November $980,000 Expected sales (all sales are credit salen) Collections of Accounts Receivable Month of Sala Month following Sale 24% 76% 44% Cost of Goods Sold percentage of sales Inventory Purchase Information Purchases paid a current month Purchases paid in next month Purchases Mal on Credit Planned ending inventory as a percentage of next month's Cost Goods Sold 78% 22% 8% Sales Commission Information Sales commissions as a percentage of skies Sales commissions are paid the month after they are incurred 8.5% Advertising Expense Information Variable Rats 17.30X Food Cost $60,000 12 Insurance policy Information of months of insurance coverage paid for each year The policy period is from August 1 to July 31 each year The premom was peld on July 31, 2021 The premium will be charged to prepaid insurance $30.000 $55.000 15.00% General and Administrative Expense Information Fixed cost portion Variable rate as a percentage of ) Song and administrative expenses are paid in the month incurred Fixed Asset Information Purchase Land on September 15, 2021 Current Depreciation expenso per month 130,000 10,000 Long Term Loan Interest Information The interest rate on the long-term debt per months Interest is paid on the principle balance at the beginning of the month Minimum Cash Balance New borrowing must be in $1,000 increments 15 $25,000 Tax Information Income tax tato Taxes are pad in the month after they are incurred (exposed 25% Dvidend Information Cash dividend declared on September 20, 2021 Cash dividend paid on October 15, 2021 $25.000 riglish (United States Focus 29,620