Required (MIND THE WEIGHT OF EACH REQUIREMENT):
1. Using an excel sheet that shows the relevant formulas; prepare a schedule of cash collections for A&A Corporation by month and in total only for the second quarter.
2. Using an excel sheet that shows the relevant formulas; prepare a schedule of cash payments for A&A Corporation by month and in total only for the second quarter.
3. Using an excel sheet that shows the relevant formulas; prepare a cash budget for A&A Corporation by month and in total only for the second quarter. Be sure that all receipts, disbursements and borrowing investing amounts are shown for each month.
4. Discuss why cash budgeting is particularly important for a rapidly expanding company such as A&A Corporation.