Reference no: EM131383285
CASE STUDY: Cash flow exercise
All written cases in this class require a introduction and a conclusion. APA style 3 references!
Will file dispute once paid and everything is not addressed!!!!
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) and submit in APA format. Title page, introduction and conclusion apply here.
• 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 the previous 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)
A Schedule of Projected Cash Receipts for Joseph Pharmacy
|
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 month's sales)
Current month (.20)
Lagged 1 month (.80)
|
|
|
|
|
|
|
Rent payments
|
|
|
|
|
|
|
Wages/Salaries
|
|
|
|
|
|
|
Total
|
|
|
|
|
|
3. 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.
|
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 10 points
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? How would you attempt to explain the variance?
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?
9. Title page, introduction, conclusion, APA format, grammar, and sentence structure.
|
Show boat will eventually come to rest
: If the water offers a resistance to the motion of the boat proportional to the velocity of the boat, show that the boat will eventually come to rest at its orginal position.
|
|
Risk manager for orlando radiology
: You are the risk manager for Orlando Radiology. Your organization operates 10 medical imaging facilities throughout the Orlando, FL region. As the risk manager, you are responsible for safety, risk management, insurance programs, and workers' comp..
|
|
Find the rms voltage of the carrier without modulation
: Find the RMS voltage of the carrier without modulation
|
|
Find the height to which the chain will first rise
: When all the chain has landed on the table, the loose end is pulled upwards with the constant force 1/3 Mg. Find the height to which the chain will first rise.
|
|
What is a cash budget a flexible budget capex and opex
: What is a cash budget, a flexible budget, CAPEX, and OPEX? How often do you use some form of budgeting? Why? If the business world is allowed to explain away their variances to budget, why is budgeting so important?
|
|
Furniture builders five manufacturing plants
: You are the new safety manager for one of Furniture Builders' five manufacturing plants. The company specializes in making wood bedroom furniture including beds and dressers. The plant where you work is located in High Point, North Carolina. You r..
|
|
How do unethical accounting practices affect stakeholders
: How do unethical accounting practices affect internal and external stakeholders? Cite at least one regulation to present the legal perspective.The Sarbanes-Oxley Act contains ten titles or sections.Summarize the major reform principles of any three..
|
|
Find the speed of the centre g of the ball
: Initially the ball is at rest at the highest point of the sphere when it is slightly disturbed.- Find the speed of the centre G of the ball in terms of the variable θ, the angle between the line OG and the upward vertical.
|
|
What is the effective modulation index
: An AM transmitter is modulated by two sine waves, at 1 kHz and 2.5 kHz, with a modulation due to each of 25% and 50% respectively. What is the effective modulation index?
|