Reference no: EM131410543
Cash flow exercise
BE SURE TO LABEL ALL POINTS!
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
50% of next month's sales
Cash Outlay
20% in month purchased
80% in the previous month
From the information provided:
1. 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
|
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
|
|
|
|
|
|
|
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
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? 10 points
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
|
Estimate the effective interest rate of the issuance
: At the beginning of 2002 Southwest Airlines issued ten-year notes with a face value of $385 million. The stated interest rate on the notes was 6.5 percent, and proceeds from the issuance approximated $380 million.
|
|
Maximum speed of the ball
: A 0.050kg ball at the end of a string rotates at constant speed in a vertical circle with a radius of 0.23m. What is the maximum speed of the ball so that the tension is not to exceed 11N?
|
|
What new challenges might given additional work create
: What other services besides traditional accounting can the firm offer to its clients? What new challenges might this additional work create?
|
|
Cash flows for a capital project
: Given the following cash flows for a capital project, calculate the Payback period, NPV, PI, IRR, and MIRR. The required rate of return is 8 percent.
|
|
Calculate the projected cash disbursements for same months
: 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 ..
|
|
At what amount should this building be capitalized
: Morrow Enterprises purchased a building on January 1, 2012, in exchange for a three-year, non-interest-bearing note with a face value of $693,000. Independent appraisers valued the building at $550,125.
|
|
What should you do in given condition
: You immediately notify the controller, whose response is, "Let it go, it happens often. It'll probably balance out on some future transaction." What should you do now?
|
|
What is the porosity of the core
: What is the porosity of the core? What would the porosity be if instead tge core had just barely floated in the water?
|
|
Compute the effective interest rate on the note payable
: Will the interest expense recognized in the third year be greater than, equal to, or less than the interest expense recognized in the second year?
|