Question
1. Calculate the projected Cash Receipts for the three months of February, March, and April (Tables have been set up for you) (30 pts) Sales
1. Calculate the projected Cash Receipts for the three months of February, March, and April (Tables have been set up for you) (30 pts)
Sales forecast | December | January | February | March | April |
Cash Sales |
|
|
|
|
|
Collection of AR: Lagged 1 Month Lagged 2 Months |
|
|
|
|
|
Other Cash Receipts |
|
|
|
|
|
Total Cash Receipts |
|
|
|
|
|
2. Calculate the projected Cash Disbursements for the same months
A Schedule of Projected Cash Disbursements for Joseph Pharmacy (30 points)
Sales | December
| January
| February
| March
| April
|
|
Purchases (50% of next months sales)
|
|
|
|
|
|
|
Rent payments |
|
|
|
|
|
|
Wages/Salaries |
|
|
|
|
|
|
Total |
|
|
|
|
|
|
Indicate what the total cash balance would be at the end of these three months if the cash balance at the beginning of February was $1,500. (40 points)
February Cash balance |
|
|
|
|
|
|
Total Cash Receipts | December
| January
| February
| March
| April
|
|
Cash Disbursements |
|
|
|
|
|
|
Balance |
|
|
|
|
|
|
Balance from Feb - April |
|
|
|
|
|
|
****To keep it fair to all, I am going to provide you with the ending cash balance for Feb. You should have $-9,250.****
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