I need help answering Finance Problem sets. Attached are the problems attached. Please show work. Please use excel to show work and For problems P4-9 and P4-10 please show in excel. Provided chapter4 excel resource if needed.

ACME Company Cash Budget July through December 2016 May June July AugustSeptemberOctoberNovember December Expected Gross Sales $300.00 $290.00 ### ### $600.00 $625.00 ### ### During month ### $34.92 $33.76 $49.47 $58.20 $69.84 $72.75 $75.66 $81.48 1 month lag 75% 225.00 217.50 318.75 375.00 450.00 468.75 487.50 2 month lag 13% 39.00 37.70 55.25 65.00 78.00 81.25 Total cash collections $34.92 $258.76 ### ### $500.09 $587.75 ### ### Purchases of Raw Material Expected Gros 60% $174.00 $255.00 Cash Payment 1 month lag $174.00 ### ### ### $375.00 $390.00 ### $360.00 $375.00 ### ### $0.00 ### Disbursements: Purchase of Raw Materials $174.00 ### ### $360.00 $375.00 ### ### Wages 6% $18.00 $17.40 $25.50 $30.00 $36.00 $37.50 $39.00 $42.00 Lease payment 2% $6.00 $5.80 $8.50 $10.00 $12.00 $12.50 $13.00 $14.00 Advertising Ex 3% $9.00 $8.70 $12.75 $15.00 $18.00 $18.75 $19.50 $21.00 R&D Expenditu 12% $60.00 $72.00 $75.00 Prepaid Insurance $24.00 Other expenses $15.00 $20.00 $25.00 $30.00 $35.00 $40.00 Taxes $40.00 $45.00 Total Disbursement Cash Budget: Beginning Balance Collections Disbursements Net Cash Balance Target Cash Balance (Deficit)/Surplus Cumulative Borrowing Surplus Cumulative Surplus $33.00 $205.90 ### $15.00 ### ### $4.22 $15.00 ($10.78) ($10.78) ### $563.00 $548.75 ### ### $15.00 $15.00 $15.00 $15.00 $15.00 ### $500.09 $587.75 ### ### ### $563.00 $548.75 ### ### ($5.35) ($47.91) $54.00 ### $59.23 $15.00 $15.00 $15.00 $15.00 $15.00 ($62.91) $39.00 ### $44.23 ($31.13) ($94.04) ($55.04) $70.87 ### ($20.35) P4-9 Cash Budget Basic Grenoble enterprises had sales of $50,000 in March and $60,000 in April. Forecast sales for Mayy=, June, and July are $70,000, $80,000, and $100,00 respectively. The firm has a cash balance of $5,000 on May 1 and wishes to maintain a minimum cash balance of $5,000. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. 1) The firm makes 20% of sales for cash, 60% are collected in the next month, and the remaining 30% are collected in the second month following sake. 2) The firm receives other income of $2,000 per month. 3) The firm's actual or expected purchases, all made for cash, are $50,000, $70,000, and $80,000 for the months of May through July, respectively. 4) Rent is $3,000 per month. 5) Wages and salaries are 10% of the previous month's sales. 6) Cash dividends of $3,000 will be paid in June. 7) Payment of principal and interest of $4,000 is due in June. 8) A cash purchase of equipment costing $6,000 is scheduled in July. 9) Taxes of $6,000 are due in June. P4-10 Preparation of cash budget Sam and Suzy Sizeman need to prepare a cash budget for the last quarter of 2016 to make sure they can cover their expenditures during the period. Sam and Suzy have been preparing budgets for the past several years and have been able to establish specific percentages for most of their cash outflows. These percentages are based on their take-home pay (that is, monthly utilities normally run 5% of monthly take-home pay). The information in the following table can be used to create their fourth-quarter budget for 2016. Income Monthly take home pay $4,900 Expenses Housing Utilities Food Transportation Medical/Dental Clothing for October and November Clothing for December Property Taxes (November only) Appliances Personal Care Entertainment for October and November 30% 5% 10% 7% .5% 3% $440 11.5% 1% 2% 6% Entertainment for December Savings Other Excess Cash $1,500 7.5% 5% 4.5% a) Prepare a quarterly cash budget for Sam and Suzy covering the months October through December 2016. b) Are there individual months that incur a deficit? c) What is the cumulative cash surplus or deficit by the end of December 2016