Instructions :

Cash Receipts Budget:

Cash Budget:

Grading Cell Reference:

Beautiful Gardens & More (BG&M) is a retailer that is preparing its cash budget for 4th quarter. Provided below is information pertaining to BG&M's expected sales,merchandise payments and expense information for 4th quarter 2020. All sales are made on account. Oct Nov $ 300,000 Dec 220,000 $ 210,000 $ Budgeted Sales Budgeted Pmts (all paid in cash in month incurred) Merchandise (all are on account) Shipping $ $ 80,750 18,500 $ 75,000 $ 15,000 $ $ 70,487 18,000 A/R collection: Collected in the month of sale Collected one month after the sale 65% 35% Balances for relevant accounts on September 2020 Cash $ Accounts Receivable $ Loan Payable $ 61,350 84,000 20,000 Monthly operating expenses paid in the month incurred Sales commission % of sales Office Salaries $ Rent $ 20% 100,000 15,000 Minimum required ending cash balance $ Montly interest rate on beginning of month loan balance 25,000 3% Required: Prepare a cash receipts budget for October, November, & December Lavender cell-enter the appropriate line item Green cells- formula & sheet reference Blue cells- Formula Tangerine cells- sheet reference or cell reference Prepare a Cash budget for each month October-December Lavender cell-enter the appropriate line item in the order the information is provided in above instructions Green cells- formula & sheet reference Blue cells- Formula Tangerine cells- sheet reference/cell reference * you should combine merchandise payments into one group in cash budget BEAUTIFUL GARDENS & MORE Cash Receipts Budget For October, November, & December October November December Total cash receipts BEAUTIFUL GARDENS & MORE Cash Budget For October, November, & December October November December $ Beginning cash balance* Cash Receipts Total cash available Payments for Merchandise $ $ $ $ Interest on bank loan $ $ $ ili $ $ Preliminary cash balance Additional loan from bank Repayment of loan to bank Ending cash balance $ $ Loan balance, end of month Grade 3 0.5 2 2. 3 0.5 1 2.5 2.5 6 Problem Type WorksheetName Range Cell Cash Receipts Budget C7:E7 Cell Cash Receipts Budget C8 Cell Cash Receipts Budget D8:E8 Cell Cash Receipts Budget C9:19 Cell Cash Budget C5 Cell Cash Budget D5:E5 Cell Cash Budget C6:16 Cell Cash Budget 07:E7 Cell Cash Budget 08:E9 Cell Cash Budget C10:E11 Cell Cash Budget C13 Cell Cash Budget D14 Cell Cash Budget E15 Cell Cash Budget C16:E16 Cell Cash Budget C18:E18 Cell Cash Budget D18 Cell Cash Budget C19 Cell Cash Budget C20 Cell Cash Budget D20 Comparison Reference();Value Reference();Value Reference();Value Formula(sum);Value Value Reference();Value Reference();Value Formula(sum);Value Reference();Value Reference();Value Reference();Value Reference();Value Reference();Value Reference();Value Reference();Value Reference();Value Formula(sum);Value Reference();Value Reference();Value 3 1 1 1 3 3 3 0.5 0.5 0.5 0.5