ALL Questions
Assignments:
Your paper must be submitted as a Microsoft Word .doc document. If you are using Microsoft 2007 software you must save (“save as”) your work in an earlier version of Word to ensure you turn in the .doc format. Try this early to make sure you are able to save your work as a .doc file. Questions? Use the “Help Desk Forum”.
Week Four Case #2: (Show ALL work)
Cash flow exercise
Joseph Pharmacy had sales of $25,000 in December and $30,000 in January. The company expects sales of $20,000 in February and $40,000 in both March and April, and $30,000 in May. The company has no other source of cash inflows. Half of the sales are paid for with cash. Twenty-five percent are paid for in each of the two months following the sale.
Joseph Pharmacy has the following expenses: (show all of your work)
· Monthly rent of $1,500
· Wages of $5,000 each month
· Purchases
o 50% of next month’s sales
o Cash Outlay
§ 20% in month purchased
§ 80% in following month
From the information provided:
1. Calculate the projected Cash Receipts for the three months of February, March, and April (Tables have been set up for you)
|
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
|
Sales |
December
|
January
|
February
|
March
|
April
|
|
|
Purchases (50% of last month’s sales)
|
|
|
|
|
|
|
|
Rent payments |
|
|
|
|
|
|
|
Wages/Salaries |
|
|
|
|
|
|
|
Total |
|
|
|
|
|
|
|
February Cash balance |
|
|
|
|
|
|
|
Total Cash Receipts |
December
|
January
|
February
|
March
|
April
|
|
|
Cash Disbursements |
|
|
|
|
|
|
|
Balance |
|
|
|
|
|
|
|
Balance from Feb – April |
|
|
|
|
|
|
4. Define cash inflows and cash outflows
5. If I have a budget where expected gross receipts are what is obtained in #1 and my expected cash disbursements are what is obtained in #2. What can you tell me about the cash balance (obtained in #3) if you were doing a variance analysis?
6. What is a cash budget, a flexible budget, CAPEX, and OPEX?
7. How often do you use some form of budgeting? Why?
8. If the business world is allowed to explain away their variances to budget, why is budgeting so important?
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more