with this information i need this question answered ----> prepare a schedule to compute the net cash flows for april,may and june
 
 

Part II (60 points) A. Projected Cash Receipts Ramis 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 Cash Budget April 2 3 Cash inflows: 4 Cash Sales 5 Collection from Debtors: 6 February Sales 7 March sales 8 Aril Sales 9 May Sales 10 Total Cash flow -168000 175000 175000 182000 may 183000 175000 0.41 358000.41 June 195000 -560000.15 213500 -151500.15