Define cash inflows and cash outflows

Assignment Help Other Subject
Reference no: EM131434641

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

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

 

 

 

 

 

 

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? 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 .

Reference no: EM131434641

Questions Cloud

What is the average annual growth rate of the economy : What is the average annual growth rate of this economy? Explain all the factors that are causing the per-worker production function, as applied to U.S. manufacturing, to shift up. HTML EditorKeyboard Shortcuts
Perform an initial search to learn about green initiatives : Local government leaders have asked you to provide information and recommendations for increasing sustainability in the community. Perform an initial search to learn about green initiatives for a city in your area. (Houston, TX).A summary of green..
Ratios equal to the industry averages : 1. If a company strives hard, any gets all of its ratios equal to the industry averages, what type of company would it be? 2. Other than industry averages, what else can we use?
Information pertaining to the two projects : The company is obligated to make a $3,500 payment to bondholders at the end of the year. The projects have the same systematic risk but different volatilities. Consider the following information pertaining to the two projects:
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) . Calculate the projected Cash Disbursements for the same months. What is a cash budget, a flexible budget, CAP..
Default risk premium for aaa rated corporate bonds : Assume that the real risk-free rate of interest is 1.0%; inflation is expected to be 1.5%; the maturity risk premium is 2.5%; and, the default risk premium for AAA rated corporate bonds is 3.5%. What rate of interest should the U.S. Treasury bond ..
Equity before the announcement of the debt issue : a. What is the expected return on the company's equity before the announcement of the debt issue? b. Construct the company's market value balance sheet before the announcement of the debt issue. What is the price per share of the firm's equity?
How will you create a learning environment for your students : ECE 430- Using the case study as an example, how will you create a learning environment for your students that will allow them to feel as successful as you did in school?
What the production level for the year : In tracking some of its costs, Kohler's controller discovered one cost that was $10 per pound no matter what the production level for the year. This is an example of a

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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