Need to make a cash budget based on the following information. Trying using excel and with formulas

\f-m,.. ~_ OAIW'W ' ' Doe, 6/6 AR '- 'ACC'I'. 111 Spring 2016 Extra Credit (20 max. piS-l arter of the upcoming year and wants tot bv u to prepare a cash budge ated in an Excel he budget 5 rge expenditures in the second qu d to borrow funds. Management has asked yo ssist in their planning. This budget should be are to pull information from. You should also design t l-B-'ar Co. is planning to make la determine whether they will nee month for the rst quarter of the year to a Spreadsheet. YOu should create a data section that it can be reused in subsequent accounting per cash payments and collections in your bUdEEt- Gra building, and spelling. IT IS NOT ACCEPTABLE TO W0 SHOULD BE A CULMINATION OF YOUR OWN EFFORTS. ding will be based on appearance, organization, RK ON THIS PROJECT WITH OTHER STUDENTS. THIS The following information is made available to you: dit. Applicable Budgeted Credit Sales by month for the current year W __ma_ mM lemming eived the month A. All of the company's sales are on cre and upcoming year are Credit Sales are collected as follows: 75% in the month of sale and the balance 'IS rec following the sale. B. Purchases of Materials are made on account. Applicable credit purchases by month for the current and upcoming year are $75,000 5125.000 m_ $43,000 $65900. $40,000 Credit Purchases are paid as follows: 65% in the month of purchase and 35% in the month following the purchase. . r C. Direct Labor Costs are expected to be $60,000 in January and increase 5% each month thereafter. D. Overhead is expected to be $55,000 each month during the first quarter and includes $10,000 of depreciation. T E. Selling and Administrative Expenses are to be $50,000 in January and are expected to increase 1% ea; month thereafter. F. The company plans to purchase land in February for $80,000. G. The company plans to receive $8,000 from security sales in March. H. l-Bar expects to have a $60,000 cash balance on January 1. l. The company desires a minimum cash balance of $50,000 and has a line of cred-i __ repayments are made on the line as excess cash becomes available.