Explain how the organization can come up with a solution

Assignment Help Corporate Finance
Reference no: EM13853809

The goal is to figure out what the Cash Balance needed each month over a 3 month spread.

1st write down all the given information:

Sales for all three months will be $130,000

Raw Material Purchases is 70% of $130,000

Accounts Receivable is 40% of $130,000

Some customers will pay within the same month and take advantage of the 3% Discount.

Net the Accounts Receivable amount with the 3% Discount to get the Accounts Receivable paid within the month.

Then there are Cash Disbursements for Accounts Payable, Wages Payable, and Rent.

Accounts Payable and Wages Payable will be a % of Sales of $130,000 - percentages are given in the problem

Rent Expenses is fixed over the 3 months, $15,000 each month

The organization does not want its bank balance to be below $6,000

2nd use the Excel template attached to document your work:

The information in this spreadsheet may not be accurate. This is an example of the same problem, however, a different version of a Corporate Finance textbook, and the amounts and percentages are slightly different.

You should come out with a Shortfall rather than a Surplus. I say this because when calculating the figures you might think something is inaccurate. This company is trying to create its Cash Flow Forecast over a 3 month period with actual transaction activity the problem provided.

3rd since this organization already knows it is going to be short meeting its Cash Needs over the 3 month period, explain how the organization can come up with a solution to have positive cash flow. If this were your organization and you could not meet the bills/obligations, how would you remedy this situation?

Attachment:- Template.xlsx

Reference no: EM13853809

Questions Cloud

Why do you suppose so many fell into the given trap : Why do you suppose so many fell into this trap? Or was Jim Koch a poor executive in not bringing Boston Beer up to their expectations?
What are some of the causes of health care disparities : Summarize the article's major points - what are some (at least two) of the causes of health care disparities and
Comparative advantage in meatball production : Is the policy that is being advocated consistent with the preceding statements about the wages and productivities of American and Asian workers - What would shoppers see when they shopped in Walmart and the other "big box" stores that sell so many ..
How use descriptive statistics to summarize the data : Use descriptive statistics to summarize the data.
Explain how the organization can come up with a solution : Explain how the organization can come up with a solution to have positive cash flow. If this were your organization and you could not meet the bills/obligations, how would you remedy this situation?
Outline hunter safety lab business model : Outline Hunter Safety Lab's business model. Discuss the strengths and weaknesses of the market research
Define institutions in the context of business strategy : Define institutions in the context of business strategy
Calculate the payoff and the profits for investments : Use the data in the table to calculate the payoff and the profits for investments in each of the following July maturity options, assuming that the stock price on the expiration date is $420.
Type of dependency that exists between city and team : type of dependency that exists between CITY and TEAM.

Reviews

Write a Review

 

Corporate Finance Questions & Answers

  Pringle sock company determines its break-even point

pringle sock company determines its break-even point strictly on the basis of cash expenditures related to fixed

  Determine the growth rate

The PE ratio combined with forecasted receiving per share to predict stock value. So explain how would you find the growth rate is to work into your application of the formula?

  Determine the indifference level of ebit

Compute the indifference level of EBIT - Determine the indifference level of EBIT between these two alternatives.

  Projects expected net cash flows

Flower Engineering is considering two mutually exclusive investments - The projects expected net cash flows.

  Andrea corbridge is considering forming a portfolio

andrea corbridge is considering forming a portfolio consisting of kalama corp. and adelphia technologies.nbsp the two

  Determine the nations gross domestic product

Determine the nation's gross domestic product and how would your answer change if the dollar amounts of imports and exports were reversed?

  1 abilene corporation stock sells at a price of 80 a share

1. abilene corporation stock sells at a price of 80 a share and the riskless rate is 7. calculate the price of a

  Journal entries related to bonds

Journal entries related to bonds - What consolidation journal entry would have been recorded in connection?

  This case has been framed in order to test the skills in

this case has been framed in order to test the skills in evaluating a credit request and reaching a correct decision.

  Aunt sallys foods inc is a full line producer and

aunt sallys foods inc. is a full line producer and distributor of ready to use jarred food products such as gravies and

  The accompanying excel spreadsheet contains a template for

the accompanying excel spreadsheet contains a template for calculating your firms valuation using modeling techniques

  Determine the present value for the options

Assuming that a 11% interest rate properly reflects the time value of money in this situation and that all maintenance and insurance costs are paid at the end of each year, find the present value for the options.

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