I need part A. B. and C and D (please doc format). Maybe it's too much so I can add another question, mostly I need help with A and B I will add examples from the book (the book most of the times have more info than used in exercises)

Part 11 A. Projected Cash Receipts Maris Brothers Inc. needs a cash receipts schedule for the months of April, May, and June Actual Sales: February = $500,000, March = $500,000. Forecast Sales: April $560,000, May=$610,000, June= $650,000, July= $650,000 Assuming that sales are the only source of cash inflows and that 30% of them are for cash and the remainder are collected evenly over the following 2 months. Prepare a schedule of projected cash receipts for April, May and June. Use the format of Table 4.8 B. Projected Cash Disbursements Maris Brothers Inc needs a cash disbursement schedule for the months of April, May, and June. The following information was collected from financial records: Purchases: Purchases are calculated as 50% of the next month's sales, 15% of purchases are made in cash, 60% of purchases are paid for 1 month after purchase, and the remaining 25% of purchases are paid for 2 months after purchase. Rent: The firm pays rent of $9,000 per month Wages and salaries: Base wage and salary costs are fixed at $8,500 per month plus a variable cost of 5.5% of the current month's sales. Taxes: A tax payment of $45,600 is due in June. Fixed asset outlays: New equipment costing $61,000 will be bought and paid for in May. Principal payments: $35,000 due in June. Interest payments: $3,000 due in June. Cash dividends: $9,500 will be paid in April. Prepare a schedule of projected cash disbursements for April, May and June. Use the format of Table 4.9 C. Net Cash Flows Prepare a schedule to compute de Net Cash Flows for April, May and June of Maris Brothers Inc. ... A. Projected Cash Receipts Maris Brothers Inc. needs a cash receipts schedule for the months of April, May, and lune. Actual Sales: February = $500,000, March = $500,000. Forecast Sales: April =$560,000, May= $610,000, June= $650,000, July= $650,000 Assuming that sales are the only source of cash inflows and that 30% of them are for cash and the remainder are collected evenly over the following 2 months. Prepare a schedule of projected cash receipts for April, May and June. Use the format of Table 4.8 B. Projected Cash Disbursements Maris Brothers Inc. needs a cash disbursement schedule for the months of April, May, and June. The following information was collected from financial records: Purchases: Purchases are calculated as 50% of the next month's sales, 15% of purchases are made in cash, 60% of purchases are paid for 1 month after purchase, and the remaining 25% of purchases are paid for 2 months after purchase. Rent: The firm pays rent of $9,000 per month Wages and salaries: Base wage and salary costs are fixed at $8,500 per month plus a variable cost of 5.5% of the current month's sales. Taxes: A tax payment of $45,600 is due in June. Fixed asset outlays: New equipment costing $61,000 will be bought and paid for in May. Principal payments: $35,000 due in June. Interest payments: $3,000 due in June, Cash dividends: $9,500 will be paid in April. Prepare a schedule of projected cash disbursements for April, May and June. Use the format of Table 4.9 C. Net Cash Flows Cash dividends: $9,500 will be paid in April Prepare a schedule of projected cash disbursements for April, May and June. Use the format of Table 4.9 C. Net Cash Flows Prepare a schedule to compute de Net Cash Flows for April, May and June of Maris Brothers Inc. D. In the preparation of a quarterly cash budget, the following revenue and cost information have been compiled. Month August (actual) September (actual) October (forecast) November (forecast) December (forecast Sales $3,000,000 5,000,000 1,750,000 2,000,000 2,600,000 Purchase $3,500,000 2,500,000 800,000 950,000 1,300,000 The firm collects 60 percent of sales for cash and 40 percent of its sales one month later. Interest income of $50,000 on marketable securities will be received in December. The firm pays cash for 40 percent of its purchases. The firm pays for 60 percent of its purchases the following month. Salaries and wages amount to 15 percent of the preceding month's sales. Sales commissions amount to 2 percent of the preceding month's sales. Lease payments of $100,000 must be made each month. A principal and interest payment on an outstanding loan is due in December of $150,000 The firm pays dividends of $50,000 at the end of the quarter. Fixed assets costing $600,000 will be purchased in December Depreciation expense each month of $45,000. The firm has a beginning cash balance in October of $100,000 and maintains a minimum cash balance of $200,000, bilidad todo correcto Revisar Vista Ayuda Aa A - E 21 T P.A. A AaBbcod AaBbccDd AaBb C AaBbc AaBbc T Normal 1 Sin espa Titulo 1 Ttulo 2 Titulo Prrafo Estilos The firm pays cash for 40 percent of its purchases. The firm pays for 60 percent of its purchases the following month. Salaries and wages amount to 15 percent of the preceding month's sales. Sales commissions amount to 2 percent of the preceding month's sales. Lease payments of $100,000 must be made each month. A principal and interest payment on an outstanding loan is due in December of $150,000. The firm pays dividends of $50,000 at the end of the quarter. Fixed assets costing $600,000 will be purchased in December Depreciation expense each month of $45,000. The firm has a beginning cash balance in October of $100,000 and maintains a minimum cash balance of $200,000. Prepare and evaluate a cash budget for the months of October, November, and December based on the information shown above. CHAPTER 4 Cash Flow and Financial Planning 129 TABLE 4.8 A Schedule of Projected Cash Receipts for Coulson Industries ($000) Aug. $100 Sept. Oct. $200 $400 $40 $ 80 Nov. S300 Dec. $200 $20 $ 60 $ 40 Sales forecast Cash sales (0.20) Collections of A/R: Lagged 1 month (0.50) Lagged 2 months (0.30) Other cash receipts Total cash receipts 50 100 200 60 30 150 120 30 $340 $20 $90 $210 $320 www TE TABLE 4.9 A Schedule of Projected Cash Disbursements for Coulson Industries ($000) Aug. $70 Sept. $140 Oct. $280 Nov. $210 Dec. $140 $7 $14 $ 28 $ 21 $ 14 49 98 147 56 14 Purchases (0.70 X sales) Cash purchases (0.10) Payments of A/P: Lagged 1 month (0.70) Lagged 2 months (0.20) Rent payments Wages and salaries Tax payments Fixed-asset outlays Interest payments Cash dividend payments Principal payments Total cash disbursements 196 28 5 38 5 48 28 25 130 10 20 $7 $63 $213 20 $305 $418