could u do the lasst 3 question in excel

I want you to complete a cash budget. The excel template has been included in the Financial planning module. Use the following assumptions: 1) Sales projection are provided 2) Assume that you purchase 100% ofthe sales that will occur in 2 months from now. In January we purchase enough to cover March sales. 3) Use the following assumptions for collections (20% one month after sales, 50% second month after sales, 30% third month after sales} 4)Tota| Cash receipts 5) Payments assume they are made one month after purchases 6) Assume wages are 10% of sales i') Assume rent is constant at $5,000 per month 8) Taxes Assume 5,000 is due on Apn'l, June and Sept 9) Interest Assume it is 6% APR (you will use 6%l12} of the prior months cummulatiye borrowing. 10} Assume you need to have $15,000 cash on hand at the end of each month. 11} Assume you start with a $30,000 cash balance on hand. You will be graded as follows. Completing budget for JANUARY through JUNE 4pts Correct Purchase numbers 1 pt Correct Total Cash receipts 1pt Correct Total Payments 1 pt Correct Wages and Salary 1 pt Correct Interest 1 pt Correct Cummulatiye Borrowing 1 pt A H October November December January February March April May June July August Worksheet Sales (forecast) 30,000 $ 45,000 $ 50,000 $ 55,000 $ 62,000 $ 70,000 $ 100,000 $ 125,000 $ 150,000 $ 100,000 $ 75,000 Purchase (100% of sales in 2 months) 50,000 55,000 62,000 70,000 100,000 125,000 150,000 100,000 75,000 Cash receipts Collections: First month after sale (20%) $6,000 $9,000 $10,000 $11,000 $12,400 $14,000 $20,000 $25,000 Second month after sale (50%) $15,000 $22,500 $25,000 $27,500 $31,000 $35,000 $50,000 Thrid month after sale (30%) $9,000 $13,500 $15,000 $16,500 $18,600 $21,000 Total cash receipts $41,500 $49,500 $54,900 $61,500 $73,600 $96,000 Cash Disbursements Payments (1-month lag of purchases made the previous month) S 62,000 S 70,000 $ 100,000 S 125,000 S 150,000 S 100,000 Wages and salaries 10% of sales for month S 5,500 $ 6,200 $ 7,000 $ 10,000 $ 12,500 $ 15,000 Rent $5,000 per month 5,000 5,000 5,000 $ 5,000 $ 5,000 5,000 Taxes ($5,000 Due April, June, Sept) 5,000 5,000 Total cash disbursements S 72,500 S 81,200 $ 112,000 140,000 S 167,500 120,000 Net change in cash for the period (31,000) $ (31,700) $ (57,100) $ (78,500) $ (93,900) $ (24,000) Plus: Beginning cash balance 30,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 15,000 Less: Interest on short-term borrowing 6% of prior months balance Equals: Ending cash balance before short-term borrowing 8 New financing needed Ending cash balance Always have $15,000 on hand $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 Cumulative borrowing