On the Cash Budget tab, enter 47200 as the beginning cash balance for the first quarter. Enter the data for the four quarters: SES 29 Quarter 14 $118,400 Quarter #3 $156,000 SES $33,200 Quarter #2 $126,400 Quarter #1 5172,000 Cash Receipts from In-Store Customer Sales Cash Receipts from Online $19,600 $21,200 $24,600 Sales 18871 ESKOL Cash Receipts from $8,000 $4,230 $3,800 Services Rendered Reduction in Notes $960 $1,550 $1,100 si 200 Receivable WWW IS Interest Received $730 $850 S420 $650 Sale of Automobile $2,350 $0 SO Cash Disbursements for 598,300 5 127 300895,300 S107,400 Merchandise Purchases Cash Disbursements for $73,600 $71,400 $69,100 $81,300 Operating Expenses Loan Payments (Principal) $2,600 $3,900 $3,900 $3,900 Create formulas in the appropriate locations to summarize cash receipts, cash available, and cash disbursements. Create formulas for the ending cash balances for Quarters 1-4 and for the beginning cash balances for Quarters 2-4. Quarter #4 Quarter #3 Quarter #2 Quarter #1 $ 47,200 Beginning Cash Balance Add: Cash Receipts from In-Store Customer Sales Cash Receipts from Online Sales Cash Receipts from Services Rendered Reduction in Notes Receivable Interest Received Sale of Automobile Total Cash Receipts: $ 118,400 $ 19,600 $ 8,000 $ 960 $ 730 $ - $ 156,000 $ 33,200 $ 4,230 $ 1,550 $ 850 $ 2,350 $ 126,400 $ 21,200 $ 3,800 $ 1,100 $ 420 $ - $ 172,000 $ 24,600 $ 9,700 $ 1,400 $ 650 $ . Total Cash Available Less: Cash Disbursements for Merchandise Purchases Cash Disbursements for Operating Expenses Loan Payments (Principal) Total Cash Disbursements: $ 98,300 $ 73,600 $ 2,600 $ 174,500 $ 127,300 $ 71,400 $ 3,900 $ 202,600 $ 95,300 $ 69,100 $ 3,900 $ 168,300 $ 107,400 $ 81,300 $ 3,900 $ 192,600 Ending Cash Balance