Hello Maya
There are more questions in the problem.
I will type the question again. The problem is:
Create a 12-month cash Budget:
==> Initial sales of $5,000,000 with forecasted monthly growth of 1%.
==>40% of each month's sales for cash; 30% collected the following month; 20% collected 2 months later, 8% collected 3 months later; and 2% never collected.
==> Initial cash balance of $350,000.
==> Add Expected Cash outflows equal to 77% of the current month's sales.
==> Also add a row to calculate the amount of cash that needs to be borrowed in order to maintian a minimum cash balance of %50,000 at the end of each month.
==> Add another row to show the cash inflow from borrowing.
==> Add another to show the cumulative amount borrowed.
==> add another row to show amount of the loan that can be repaid, being sure to maintain a minimum ending balance of $50,000 each month.
==> Add appropriate data validation controls to ensure spreadsheet accuracy.
Here is the following format I suppose to follow:
Begining Balance XXXXXX
Add: Cash Receipts:
Cash Sales XXXXXX
Collections on Account XXXXXX
Total Cash Available (A) XXXXXX
Less:Cash Disbursement (B) (XXXXX)
Ending Cash Balance (C= A-B) XXXXXX
Desired Minimum Balance (D) XXXXXX
Amount needed to borrow XXXXXX
Ending Balance XXXXXX
Please help me to solve this problem until May. Then I can solve the rests.
Thank you
