Question 13.Prepare a Balance Sheet in good format as of 3/31/18.
$ $ Accounts R=1 400 000 1 395000=1 10. In addition to the info in problem #1, and based on past experience, the company expects to collect 90% of the month's sales in the current month, and 10% in the month folowing the sale. The accounts receivable balance at 12/31/17 was $100.000 and is deemed fully colectible. 10 000 $ 13000 25 $ 25 1 100 000 300 000 100 000 110 000 990 000 1 170 000 1 090 000 $ 200 000 14000 25 1 400 000 130 000 260 000 1390 000 1 $ Prepare the Cash Receipts Budget for Jan. Feb. & March Also calculate the Accounts Receivable balance on 3/31/16. 11. In addition to the infa from previous problems, the folowing cash disbursements were made each month: - Equipment purchases $85,000 in Jan, $60,000 in Feb, & $75,000 in March. - Dividends paid of $200.000 in Jan, $300,000 in Feb and $400.000 in March, Materials purchases are paid for 100% in the month of purchase. Operating expenses include $6.000 of Depreciation each month, which is a non-cash expense. 147 600 $ 213 750 $ 101 300 $ 462 659 $ 6 000 $ 85 000 S 200 000 $ 148 000 $ 901 650 $ 170 400 $ 181 200 447 500 $ 285 000 109 400 $ 118 400 527 300 $ 584 600 6000 S 6000 60 000 $ 75 000 300 000 400.000 172 000 $ 184000 1065 300 1 249 600 Prepare the Cash Disbursements Budget for Jan Feb. & March, which should also include the cash payments for materials, labor, MOH, and operating expenses. 285 000 $ 500 000 1 090 000 $ 280 000 1 375 000 $ 780 000 901 650 $ 1065 300 473 350 $ 714 700 26 650 26, 650 500 000 684 852 S 684 852 $ 1 390 000 $ 2074 852 $ 825 252 12. The bank requires a minimum cash balance at the end of each month of $500,000. The company has a $500,000 line of credit with $0 outstanding balance as of 1/1/18. Interest on the line of credit is 12% annualy, and is paid at the end of each month. Ending cash balance on 12/31/17 was $285.000 In addition to the info in problems #10 and #11. prepare a Comprehensive Cash Budget for Jan, Feb, and March. 13. In addition to the info from problems #10 & #12, the following balances are as of 3/31/18: Equipment, net of Accum, Deprec. - $389,560 Bonds Payable = $250,000 (one annual payment in July Interest Payable = $15.000 (due in July) Beginning Retained Eamings Bal 1/1/18 = $290.743 Common Stock - $170.000 $ $ Accounts R=1 400 000 1 395000=1 10. In addition to the info in problem #1, and based on past experience, the company expects to collect 90% of the month's sales in the current month, and 10% in the month folowing the sale. The accounts receivable balance at 12/31/17 was $100.000 and is deemed fully colectible. 10 000 $ 13000 25 $ 25 1 100 000 300 000 100 000 110 000 990 000 1 170 000 1 090 000 $ 200 000 14000 25 1 400 000 130 000 260 000 1390 000 1 $ Prepare the Cash Receipts Budget for Jan. Feb. & March Also calculate the Accounts Receivable balance on 3/31/16. 11. In addition to the infa from previous problems, the folowing cash disbursements were made each month: - Equipment purchases $85,000 in Jan, $60,000 in Feb, & $75,000 in March. - Dividends paid of $200.000 in Jan, $300,000 in Feb and $400.000 in March, Materials purchases are paid for 100% in the month of purchase. Operating expenses include $6.000 of Depreciation each month, which is a non-cash expense. 147 600 $ 213 750 $ 101 300 $ 462 659 $ 6 000 $ 85 000 S 200 000 $ 148 000 $ 901 650 $ 170 400 $ 181 200 447 500 $ 285 000 109 400 $ 118 400 527 300 $ 584 600 6000 S 6000 60 000 $ 75 000 300 000 400.000 172 000 $ 184000 1065 300 1 249 600 Prepare the Cash Disbursements Budget for Jan Feb. & March, which should also include the cash payments for materials, labor, MOH, and operating expenses. 285 000 $ 500 000 1 090 000 $ 280 000 1 375 000 $ 780 000 901 650 $ 1065 300 473 350 $ 714 700 26 650 26, 650 500 000 684 852 S 684 852 $ 1 390 000 $ 2074 852 $ 825 252 12. The bank requires a minimum cash balance at the end of each month of $500,000. The company has a $500,000 line of credit with $0 outstanding balance as of 1/1/18. Interest on the line of credit is 12% annualy, and is paid at the end of each month. Ending cash balance on 12/31/17 was $285.000 In addition to the info in problems #10 and #11. prepare a Comprehensive Cash Budget for Jan, Feb, and March. 13. In addition to the info from problems #10 & #12, the following balances are as of 3/31/18: Equipment, net of Accum, Deprec. - $389,560 Bonds Payable = $250,000 (one annual payment in July Interest Payable = $15.000 (due in July) Beginning Retained Eamings Bal 1/1/18 = $290.743 Common Stock - $170.000
