Calculate all of the monthly ending cash balances $($through December $31$st$)$ for the below business based on the information provided. Show all computations within this spreadsheet tab.

Beginning cash balance, July $1=$$$3,000$

Sales Totals are as follows: July $=$$$4,000$; August $=$$$3,000$; September $=$$$4,000$; October $=$$$3,000$; November $=$$$4,000$; December $=$$$3,000$

$75$ percent of the sales are in cash. The other $25$ percent are accounts receivable collected in the next month.

The owner plans to invest another $$10,000$ in cash into the business in September.

Montthly Expenses are as follows: Rent $=$$$1,500$ Utilities $=$$$500$ Wages $=$$$2500$

A tax prepayment of $$2,500$ will be paid in September.

The business will buy $$3,500$ in equipment with cash in October.