I am having trouble figuring out how to calculate the 12 months of the balance sheet for a new business. Im estimating that every day the store gets 80 customers a day who have a transaction cost of $120. Which is how i got 9,600. How do I calculate the values for the upcoming months? Do i use the same 80 x 120 of cash for every month? The 24,600 in the cash box is from the owner's investment of $15,000 in cash plus the sales of 80 customers at a transaction cost of $120 which is $15,000 + $9,600 = 24,600 is this right?

	MONTH 1	MONTH 2	MONTH 3	MONTH 4	MONTH 5	MONTH 6	MONTH 7	MONTH 8	MONTH 9	MONTH 10	MONTH 11	MONTH 12
Current Assets
Cash & Cash Equivalents	$24,600.00
Accounts Receivable	$0.00
Inventory	$150,000.00
	$
Total Current Assets	$169,000.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Fixed Assets
Specialized Store Equipment	$175,000.00
Less accumulated depreciation (Negative Value)	$500.00
Delivery Van	$1,050.00
Total Assets	$175,500.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL ASSETS	$344,500.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
LIABILITIES AND OWNER'S EQUITY
Current Liabilities
Accounts payable	$6,250.00
Accrued wages and salaries	$11,667.00
Income taxes payable	$210,000.00
Total Current Liabilities	$227,917.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Long-Term Liabilities
Long-term debt	$27,777.00
Van car payment	$667.00
Lease	6,670
Total Long-Term Liabilities	$35,114.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Owner's Equity
Owner's investment	$15,000.00
Accumulated retained earnings
Other
Total Owner's Equity	$15,000.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL LIABILITIES AND OWNER'S EQUITY	$278,031.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00