This assignment must be completed using the ExPrep platform. Instructions for registering and paying for the platform is available in Canvas as part of the syllabus. The instructions for this assignment are also provided in the instructions worksheet within the excel workbook in ExPrep. The purpose of this project is to give you experience creating a financing budgets, specifically the cash budgets using excel. Beautiful Gardens & More (BG&M) is a retailer that is preparing its cash budget for 4h 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. 65% of A/R are collected in the month of the sale and 35% in the month following the sale. Budgeted Sales Butonted Pints (all paid in cash in month incurred Merchandise Shipping Oct Nov Dec $ 210,000 $ 300,000 $ 220,000 $ 80,750 $ 75,000 $ 70,487 18,500 $ 15,000 S 18,000 Relevant account balances from September 2020 are: Cash $61,350 A/R $84,000 Loan/Payable $20,000 Monthly operating expenses paid in cash in the month incurred are: Sales commission that is 20% of sales Office salaries $100,000 Rent $15,000 Beautiful Gardens & More requires an ending cash balance of at least $25,000, if the preliminary a balance is below this amount BGM's will borrow from the bank to achieve this balance. The bank charges BGM 3% interest per month on loan balance. 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 the cash budget