Need to calculate the ending cash balance for 4 quarters in the above spreadsheet.

Table 12 - Budgeted Statement of Cash Flows for Fiscal Year Beginning 12/1/2020 $ Quarter 1 $ 2,272,200 1,817,760 400,000 $ 2,217,760 Quarter 2 $ 2,272,200 1,817,760 454,440 $ 2,272,200 Quarter 3 $ 2,272,200 1,817,760 454,440 $ 2,272,200 Quarter 4 $ 2,272,200 1,817,760 454,440 $ 2,272,200 Annual 9,088,800 7,271,040 1,763,320 9,034,360 $ $ $ $ - $ Sales in the quarter 80% collected in this quarter 20% collected from last quarter Cash from sales Less: Almond purchases Direct labor Other ingredients Variable overheads Fixed factoy overhead Administrative costs Income taxes Total cash expenses before interest Cash flow from operations Beginning cash balance Less: minimum cash revenuews Cash available for operations New Short-term borrowings Repayment of loan and interest Outstanding loan balance Interest at 4% per quarter Capital expenditures Ending cash balance 188,030 449,350 473,600 544,667 100,000 175,000 128,660 2,059,307 158,453 2,000,000 200,000 1,800,000 188,030 449,350 473,600 544,667 100,000 175,000 128,660 2,059,307 212,893 200,000 200,000 188,030 449,350 473,600 544,667 100,000 175,000 128,660 2,059,307 212,893 200,000 200,000 - 564,090 1,348,050 1,420,800 1,634,000 400,000 700,000 514,639 6,581,579 2,452,781 1-09 S $ $ S S $ $ S $ 100,000 175,000 128,660 403,660 1,868,540 278,500 200,000 78,500 $ S $ S $ $ $ $ $ $ S 88,000 - 16,000 - $19,140 16,000 - S $ $