complete the Cash Budget using the template provided, please include the excel formula thanm you

THE CASH BUDGET (in millions of pesos) You are the Financial Manager of FINMAN INC. and you are tasked to create a cash budget for the next 6 months. Complete the table below. Input Data Collections during month of sale Collections during 1st month after sale Collections during 2nd month after sale Percent bad debts Discount on first month collections Purchases as a % of next month's sales Lease payments Construction cost for new plant (Oct) Target cash balance Sales adjustment factor (change from base) THE CASH BUDGET Sales (gross) Collections During month of sale: During 1st month after sale: During 2nd month after sale: Total collections Purchases: Payments Payment for materials: Last month's purchases Wages and salaries Lease payments Other expenses Taxes Payment for plant construction Total payments Net cash flows: Net cash flow (NCF) for month: Cumulative NCF: Prior month's cum. NCF plus this month's NCF Cash surplus (or loan requirement) Target cash balance Surplus cash (or loan needed): Maximum required loan (shown as a negative) Maximum available for investment 30% 50% 20% 0% 3% 65% 20 150 30 10 May 310 June 160 July 290 40 20 August 460 40 20 Sept 330 40 20 40 Oct 280 40 20 Nov 440 40 20 Dec 310 40 20 30