Use the following information to answer question #12
ACC 1820 Project 4 (Ch 7) Name Use Question 11 from HW6 on CONNECT to complete the project requirements. represent check figures provided. items (5 points) Let's prepare a balance sheet for Garden Sales, Inc. at the BEGINNING of the quarter- March 31". The CONNECT problem provides beginning cash, Inventory and accounts payable balance as of March 31. To compicte the balance sheet, we will have to calculate a few balances I) Look at the Schedule of Expected Cash Collections that you completed on CONNECT CONNECT results) Remember the accounts receivable represents the sales that have already been made but payment is expected in the future. What would the accounts receivable balance be as of March 31? a) b) Complete the asset side of the balance sheet including total assets. Include the "total asset" amount in the "total liability & SH Equity" box. Include the accounts payable amount from CONNECT and calculate the amount of retained earnings such that the c) balance sheet will balance. Garden Sales, Inc Balance Sheet March 31 133ee0 Cash Accounts Receivable Inventory Accounts Payable 13000 Common Stock 100,000 c0 Retained Earnings 350,000 Total SH Equity Total current assets Plant Assets, net Total Assets Total liabilities & SH Equity he company's president is concerned about its ability to borrow money on its line of credit. The bank s indicated they will reduce the total loan balance limit to $100,000. Because of this, the president ants to know how increased collection efforts and reduced inventory levels will impact the cash budget e president suggests that sales continue to be 20% for cash and 80% on credit. However, credit sales April, May, and June will be collected over a three-month period with 25% collected in the month of e, 65% collected in the month following sale, and 10% in the second month following sale. This unge in policy will not affect collection of sales from February and March. (Assume those are hanged from your CONNECT problem)