Managerial Accounting Case Study: AccountingGenius

One Excel file submitted.
    Individual work.  All students are expected to prepare this case individually. File sharing on this assignment is not acceptable.

All calculations completed using Excel formula functions

Prepare a comprehensive cash budget:  Case Case 2 6100 Cash budget MgAcCam.pdf 

Use the format as your guide:  Cash budget set up.pdf 

Check figures:  Cash receipts (collections) balance Aug:  $20,500; Cash disbursements (all expenses) July $20,400

In addition to the preparation of the three month cash budget, provide the following descriptive analysis by addressing each of the following items fully:

1. Does the cash budget based on the given parameters provide the firm with the liquidity in needs in meeting operations for the quarter (and why)?
2. The CFO wants to know what is the impact of increasing the minimum monthly balance to $7,000.  Provide a short but detailed response to the CFO on the impact of this change.  Or course the CFO will expect to see the numerical values that support the response.
3. What is the impact of interest rate changes on the a) the budget as proposed, and b) the CFOs request for higher minimum cash balance?