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

Previous Q& A

  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.

  Anticipate particular size or model requests

He says he rarely ever gets complaints if the exact model is not available, as long as he has a vehicle available, so he does not try to anticipate particular size or model requests and lets randomness take care of that. Weekly demand is as follow..

  Journalize the entries in good form on the general journal

Journalize the entries in good form on the general journal tab in the template. Post the journal entries to the appropriate T-accounts on the ledger tab in the template.

  Calculate the amount of cash dividends paid

Calculate the amount of cash dividends paid during 2012. Calculate the depreciation expense incurred during 2012. Prepare a statement of retained earnings for the year ended December 31, 2012.

  How much do you set aside each year

You plan to set aside equal annual payments (at the end of) each year for the next 4 years to provide for your needs. If the interest rate is 6%, how much do you set aside each year?

  Determine which markets to target short versus long term

Apply SWOT, Porter's Five Forces, or the BCG Matrix to analyze Kraft's strategic plan to expand into international markets. How would you determine which markets to target short versus long term?

  What are zara global strategies

What are Zara's global strategies? How does the global legal landscape alter, if any, the execution of Zara's global strategies

Reviews

Write a Review

 

Similar Q& A

  Exponential discounter

Sue is an exponential discounter. Her discount function which illustrates her preference for money at various points in time is characterized as follows:

  The question on problem number 5 seems to stem from a

the question on problem number 5 seems to stem from a question on the number of years but only given 10 periods and the

  Find the amount invested in each of the two companies

Find the amount invested in each of the two companies and find the standard deviation of this portfolio's returns

  Compute the expected return on the market portfolio

Compute the expected return on the market portfolio and Is it possible for a stock to have a negative standard deviation in returns?

  Explain why the issuing corporation charged

On March 31, 2011, Gardner Corporation received authorization to issue $50,000 of 9 percent, 30-year bonds payable. The bonds pay interest on March 31 and September 30. The entire issue was dated March 31, 2011, but the bonds were not issued until..

  Describe the components of the current ratio

Describe the components of the current ratio and what does the current ratio measure also what are the reasons for using the current ratio for analysis?

  The specific objective of this graded written research

the specific objective of this graded written research exercise is to prepare an executive level financial report to

  Selecting the correct option for expected return

Given the following data for 3 stocks, A,B,& C, and portfolios of these stocks. The stocks' returns are positively but not perfectly positively correlated with othe,

  Prepare a statement of cash flows for the company

Prepare a statement of cash flows for the company for 2012 together with a reconciliation of operating profit and cash from operations.

  Part ayou have been directed to develop a cost of capital

part ayou have been directed to develop a cost of capital for the firm to use in evaluating 2013 capital investment

  Bridgeports revolving credit agreement

Calculate the charges associated with Bridgeports revolving credit agreement for the month of April - revolving Credit Agreements

  Describe the sample selection process

Ignore those IPO without issue price in the spreadsheet downloaded from DatAnalysis. Also, make sure you select the adjusted price for the closing price. Describe the sample selection process.

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