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 Dec

Budgeted Sales $210,000$300,000$220,000

Budgeted Pmts (all paid in cash in month incurred)

Merchandise (all are on account) $80,750$75,0000$70,487

Shipping $18,500$15,000$18,000

A/R collection:

Collected in the month of sale65%

Collected one month after the sale35%

Balances for relevant accounts on September 2020

Cash $61,350

Accounts Receivable $84,000

Loan Payable $20,000

Monthly operating expenses paid in the month incurred

Sales Commission % of sales 20%

Office Salaries $100,000

Rent $15,000

Minumum required ending cash balance $25,000

Monthly interest rate on beginning of month loan balance 3%

A) Create a Cash Budget for each month October, November, and December

Lavender Box- Enter the appropriate line item in the order the information is provided in above instructions

Green Box- Formula and Sheet reference

Blue Box- Formula

Tangerine Box- Sheet Reference/Box Reference

SHOW ALL WORK

*you should combine merchandise payments into one group in cash budget

BEAUTIFULGARDENS 81 MORE Cash Budget For October, November, Er December October Beginning cash balance* Cash Receipts Total cash available Interest on bank loan Preliminary cash balance Additional loan from bank Repayment of loan to bank Ending cash balance Loan balance, end of month