Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Ariel's Caf provides the following budgets for cash receipts and cash disbursements for the year 2021 on a quarterly basis. The ending cash balance
Ariel's Caf provides the following budgets for cash receipts and cash disbursements for the year 2021 on a quarterly basis. The ending cash balance on Englis December 31, 2020 was $18,500. Q1 Q2 Q3 Q4 Total Receipts $29,000 $16,000 $22,000 $59,000 $126,000) Disbursements $12,000 $31,000 $16,000 $28,000 $87,000 Do not enter dollar signs.or.commas in the input boxes. Use the negative sign for negative values. a) Calculate the net cash flow for each quarter. Q1 Receipts $ 28000 Q2 $ 18000 Q3 Q4 $ 14000 $ 44000 Disbursements $ 19000 $ 30000 $16000 $ 32000 Net Cash Flow $16000 $ 17000 $ 1000 $ 28000 b) Calculate the ending cash balance for each quarter. Q1 Q2 Q3 Q4 Opening Balance $18500 $ 34500 17500 $ 16500 Net Cash Flow $16000 $17000 $ 1000 $ 28000 Ending Balance $ 34500 $17500 $16500 $ 44500
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started