Excel Applications for Accounting Principles

Business

Quiz 21 :
Cash Budgeting Cashbud

bookmark
Unbookmark

Quiz 21 :
Cash Budgeting Cashbud

The cash budget will be prepared to evaluate repayment of loan. The required worksheet is given below: img

The formulas are entered by using the cell reference. The required worksheet is given below: img

Company S has a note payable for $10,000 that needs to be paid in May. According to the cash budget, Company S is not having enough cash on hand at the beginning of May to make payment for the note payable due. They only have $7,772 cash on hand at the end of April. The required worksheet is given below: img