practice problem # 11.

Please show formulas and calculations. If using excel or tables, please show data.

*** I have seen this answered previously, but I do not believe the answers took into account COGS and the timing of payments corectly

Jupiter stores had a Quarter 2 beginning cash balance of $430. Sales for Quarters 1 through 3 are estimated at $600, $800, and $900, respectively. The cost of goods sold is equal to 70 percent of sales. Goods are purchased one quarter prior to the month of sale. The accounts payable period is 30 days and the accounts receivable period is 15 days. The firm had quarterly cash expenses of $180. What was the cash balance at the end of Quarter 2?