Define cash inflows and cash outflows

Assignment Help Finance Basics
Reference no: EM131577903

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

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

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

Reference no: EM131577903

Questions Cloud

Compute the ending inventory at retail : Problem - Presented below is information related to Sarasota Company. Compute the ending inventory at retail
Is harper contact liable to britania under the contract : Britania ships the order to Harper Contact. Is Harper Contact liable to Britania under the contract?
Describe what makes someone a professional in your field : Describe what makes someone a professional in your field. Use research and/or reflect on your personal experiences and what you know about your profession.
Comparative advantage and specialization : How much time would it take the two to complete the project if they use comparative advantage and specialization in calculating or writing?
Define cash inflows and cash outflows : Calculate the projected Cash Receipts for the three months of February, March, and April (Tables have been set up for you)
Purpose of a unit root test in financial modeling : Explain the concept of Nonstationarity and show clearly the purpose of a Unit root test in Financial modeling
Review the preview of your final project criteria sheet : Review the "Preview of Your Final Project" criteria sheet to help you focus your work this week.
What is the profitability index of an investment in machine : Hunter Corporation uses a hurdle rate of 15%. What is the profitability index of an investment in Machine B?
What is invoice price of the bond : If the last interest payment was made one month ago and the coupon rate is 7%, what is the invoice price of the bond?

Reviews

Write a Review

Finance Basics Questions & Answers

  Explain maximum price that can be paid for the bond

Explain Maximum price that can be paid for the bond and what is the maximum price you should be willing to pay for the bond

  What is the convertible bonds conversion premium

A $1000 per value convertible bond has a conversion price of $50. It is currently selling for $1,120 despite the fact that the bond's coupon rate and the market rate are equal. The common stock obtained upon conversion is selling for $54 per share. W..

  Falon cost of common equity capital

(Cost of common equity) Falon Corporation is issuing new common stock at a market price of $27.32. Dividends last year were $1.39 and are expected to grow at an annual rate of 8.4 percent forever. What is Falon's cost of common equity capital?

  What would have been the inventories in 2012

The robinson company had a cost of goods sold of 1,000,000 in 2011 and 1,200,000 in 2012. b. what would have been the inventories in 2012 if the 2011 turnover ratio had been maintained?

  Find yield to maturity

Boston Common Community Hospital's tax-exempt bond is selling for dollar 626.53/bond and has a remaining maturity of 20-years. If the par value is $1,000 & coupon value is 7 percent, what is the yield to maturity?

  Determine the present value of the bonds payable

Determine the present value of the bonds payable, using the present value tables in Chapter 10 of your text. Round to the nearest dollar. b. Illustrate the General Journal entry that would be made to record the issuance of the bonds. Prepare an amort..

  What does the term current liabilities mean

What does the term current liabilities mean? What assets are usually used to settle current liabilities? Give examples.

  Ebay has never been profitable

eBay has never been profitable

  Why is notional principal often exchanged in a currency swap

Why is notional principal often exchanged in a currency swap but not in an interest rate or equity swap? Why would the parties to a currency swap choose not to exchange the notional principal ?

  Employment law case brief

Summarize the issue of the case, and then explain the employment law that was violated.

  Direct relationship with public finances

What are the clauses of the Constitution of PR and USA that have a direct relationship with public finances and why?

  You are an accountant at a local cpa firm that is auditing

you are an accountant at a local cpa firm that is auditing the accounting records of abc company. you have been asked

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd