As the table above is related to the cash budget. Provide a brief analysis of it in detail and provide some suggestion if the companies have to work on it.

Cash Budget Proforma of XYZ company for the month of June and July Particulars June July Sales 50,000,000 60,000,000 Add: 1. Same Month (20%) (20 % * 50,000, 000) and ( 20% * 60,000,000) 10,000,000 12,000,000 2. Previous Month (60%) (60 % * 35,000,000) and (60 %* 50,000,000) 21,000,000 30,000,000 3. Two month (20%) (20% * 40,000,000) and (20 %* 35,000,000) 8,000,000 7,000,000 Total Cash In 39,000,000 49,000,000 Payments: 1. Expenses 30,000,000 35,000,000 2. Taxes (2%*50,000,000) and (2%*60,000,000) 1,000,000 1,200,000 3. Interest Rate on Cumulative loan Nill 60,000 Total Cash Out 31,000,000 36,260,000 Net Cash In / Out 8,000,000 12,470,000 Beginning Cash 6,000,000 14,000,000 Ending Cash 140,000,000 26,740,000 Minuimum Cash Required 20,000,000 20,000,000 Surplus / Deficit -6,000,000 6,740,000 Bank loan 6,000,000 Nill Cummulative borrowing 6,000,000 Nill Short term Investing Nill 6,740,000 Cash Budget Proforma of XYZ company for the month of June and July Particulars June July Sales 50,000,000 60,000,000 Add: 1. Same Month (20%) (20 % * 50,000, 000) and ( 20% * 60,000,000) 10,000,000 12,000,000 2. Previous Month (60%) (60 % * 35,000,000) and (60 %* 50,000,000) 21,000,000 30,000,000 3. Two month (20%) (20% * 40,000,000) and (20 %* 35,000,000) 8,000,000 7,000,000 Total Cash In 39,000,000 49,000,000 Payments: 1. Expenses 30,000,000 35,000,000 2. Taxes (2%*50,000,000) and (2%*60,000,000) 1,000,000 1,200,000 3. Interest Rate on Cumulative loan Nill 60,000 Total Cash Out 31,000,000 36,260,000 Net Cash In / Out 8,000,000 12,470,000 Beginning Cash 6,000,000 14,000,000 Ending Cash 140,000,000 26,740,000 Minuimum Cash Required 20,000,000 20,000,000 Surplus / Deficit -6,000,000 6,740,000 Bank loan 6,000,000 Nill Cummulative borrowing 6,000,000 Nill Short term Investing Nill 6,740,000