Hello. I need someone to look over my case study to make sure it is correct and to put the calculations in it as well. I have attached the case study details and the excel sheet I have completed. My tutor on here will not answer messages and I am running out of time.
65800 26850 62649.999999999993 22500 92650 85150 117000 54000 81000 25200 171000 106200 20000 24500 92650 85150 33000 50000 75000 57000 200650 192150 220650 216650 171000 106200 15000 15000 10150 10150 19000 20000 196150 170350 24500 46300 24500 46300 Cash balance Borrowings Repayments SCHEDULE OF EXPECTED CASH COLLECTIONS FROM CUSTOMERS: Credit Sales SCHEDULE FOR EXPECTED PAYMENTS FOR PURCHASE OF INVENTORY Inventory purchases Total Cash Collections Total Payments for Inventory Purchases Cash Budget Add: Receipts Total receipts Total Available Cash Less: Disbursements Total disbursements Excess (deficiency of available cash over disbursements) Financing Ending cash balance Collections from customers Sale of plant assets Sale of new common stock Cash sales Operating expenses Selling and administrative expenses Dividends CASE STUDY 3 – Cash Budget Template Equipment purchase Purchases of inventory What are the three sections of a Cash Budget, and what is included in each section? 1) 2) 3) Why is a Cash Budget so vital to a company? What are the five basic principles of cash management that a company can follow in order to improve its chances of having adequate cash? May June April For the Two Months of May and June LBJ Company Please answer the 3 qualitative questions on the next tab called Qualitative Questions. Cash is a vital life line for many businesses and therefore contributes to more effective cash management. A cash budget shows anticipated cash flows, usually over a one or-year period. It can show when a company will need additional financing, well before the actual need arises. On the hand, it can indicate when the company will have excess cash available for investments or other purposes. The alternative to a cash budget is one that is based on the availability of credit, or money that will have to be repaid down the line with interest. A cash budget therefor places limits on your purchasing and…
Attachments: