Please show me in Excel!

N O P Midgely Inc. is planning to request a line of credit from the bank. Midgely has estimated the following sales forecasts for the firm for parts of 2016 and 2017 May 2016 180,000 June 185,000 July 380,000 August 540,000 September 750,000 October 360,000 November 360,000 December 190,000 January 2017 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 20%; collected the month following the sale, 65, collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus row materials: May 2016 $ 94,000 June 99,000 July 146,000 August 782,000 September 326,000 October 204,000 November 142,000 December 80,000 P H M N 0 General and administrative salaries are approximately $28,000 a month. Lease payments under long-term leases are $9,500 a month. Depreciation charges are $36,000 a month Miscellaneous expenses are $2,900 a month. Income tax payments of $68,000 are due in September and December. A progress payment of $190,000 on a new design studio must be paid in October. Cash on hand on July 1 will be $110,000, and a minimum cash balance of $90,000 should be maintained throughout the cash budget period. Problem 16:Prepare a monthly cash budget for the last 6 months of 2016. Problem 17: Prepare monthly estimates of the required financing or excess funds -- that is, the amount of money Midgely will need to borrow or will have available to invest. Problem 18: What is the maximum the firm would have to borrow during the last 6 months of 2016? Input Data Collections during month of sale Collections during 1st month after sale Collections during 2nd month after sale 20% Assumed constant. Don't change 65% Assumed constant. Don't change. 15% May June July August Sept Oct Nov Dec Sales (gross Collections During month of sales During 1st month after sale: During 2nd month after sale: Totallentine Total collections Purchases Payments Payment for materials Wages and salaries Lease payments Other expenses axes Payment for plant construction Total payments Wer cash flows: Het cash flow (NCF) for month: $110 Beginning cash balance Cumulative NCF: Prior month's cum. NCF plus this month's NCF arget cash balance Surplus cash (or loan needed): Maximum required loan (shown as a negative) Maximum available for investment