Prepare a cash budget for december, january, and february

Assignment Help Finance Basics
Reference no: EM131103523

Dorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl's Doll Shop. Business has been good, but Koehl has frequently run out of cash. This has necessitated late payment on certain orders, which, in turn, is beginning to cause a problem with suppliers. Koehl plans to borrow from the bank to have cash ready as needed, but first she needs a forecast of just how much she must borrow. Accordingly, she has asked you to prepare a cash budget for the critical period around Christmas, when needs will be especially high. Sales are made on a cash basis only. Koehl's purchases must be paid for during the following month. Koehl pays herself a salary of $4,800 per month, and the rent is $2,000 per month. In addition, she must make a tax payment of $12,000 in December. The current cash on hand (on December 1) is $400, but Koehl has agreed to maintain an average bank balance of $6,000-this is her target cash balance. (Disregard till cash, which is insignificant because Koehl keeps only a small amount on hand in order to lessen the chances of robbery.) The estimated sales and purchases for December, January, and February are shown below. Purchases during November amounted to $140,000.

a. Prepare a cash budget for December, January, and February.
b. Now, suppose Koehl were to start selling on a credit basis on December 1, giving customers 30 days to pay. All customers accept these terms, and all other facts in the problem are unchanged. What would the company's loan requirements be at the end of December in this case? (Hint: The calculations required to answer this question are minimal.)

Reference no: EM131103523

Questions Cloud

Matching principle : List three criteria that can be used to determine whether such costs should appear as charges in the income statement for the current period.
Explain the rationale for recognizing costs as expenses : In what general circumstances would it be appropriate to treat a cost as an asset instead of as an expense? Explain.
Discuss the factors to be considered in determining : Discuss the factors to be considered in determining when revenue should be recognized for the purpose of accounting measurement of periodic income.
The publication of the magazine every month : Both events, by recognizing a portion of the revenue with cash sale of the magazine subscription and a portion of the revenue with the publication of the magazine every month.
Prepare a cash budget for december, january, and february : The estimated sales and purchases for December, January, and February are shown below. Purchases during November amounted to $140,000.a. Prepare a cash budget for December, January, and February.b. Now, suppose Koehl were to start selling on a credit..
The expected return on equity under each current asset level : What is the expected return on equity under each current asset level? (Assume a 40 percent effective federal-plus-state tax rate.) b. In this problem, we have assumed that the level of expected sales is independent of current asset policy. Is this a ..
Describe briefly the following characteristics : Describe briefly the following characteristics of useful accounting information.
Calculate christie''s cash conversion cycle : Calculate Christie's cash conversion cycle. Assuming Christie holds negligible amounts of cash and marketable securities, calculate its total assets turnover and ROA. Suppose Christie's managers believe that the inventory turnover can be raised to 7...
What is the length of the firm''s cash conversion cycle : The Zocco Corporation has an inventory conversion period of 75 days, a receivables collection period of 38 days, and a payables deferral period of 30 days.a. What is the length of the firm's cash conversion cycle?

Reviews

Write a Review

Finance Basics Questions & Answers

  Rno company''s market for the model 55

RNO Company's market for the Model 55 has changed significantly, and RNO has had to drop the price per unit from $285 to $200.  There are some units in the work in process inventory that have costs of $280 per unit associated with them.  RNO could se..

  Discuss the effect on stock market investor confidence

before you begin the unit 5 discussion you should have completed your assigned reading. please take this opportunity to

  Why are foreign currency futures contracts more popular

1 the authors state that empirical tests of purchasing power parity have for the most part not proved ppp to be

  The entertainment system vendor has offered to finance the

the adam limousine company wants to purchase a car entertainment system for one of its automobiles. the entertainment

  A particular securitys default risk premium is 3 percent

a particular securitys default risk premium is 3 percent. for all securities the inflation risk premium is 2.90 percent

  The current spot price of platinum is 1500 in us dollars

the current spot price of platinum is 1500 in us dollars per troy ounce. assume a continuously compounded risk-free

  Unbiased estimator of the error variance

This assignment will guide you through the derivations needed to determine what is a unbiased estimator of the error variance in the context of a univariate linear regression. This assignment may be quite challenging.

  Calculation of irr, npv and analysis in decision making

Calculation of IRR, NPV and analysis in decision making and how can the use of Net Present Value assist in the measurement and evaluation of corporate projects to ensure that stakeholder interests are being met

  What is pexi cost of dollar-denominated equity

U.S. corporate tax rate = 30% German corporate tax rate = 40% What is Pexi's cost of dollar-denominated equity? a. 12.0%. b. 11.2%. c. 10.0%. d. 7.2%.

  How does this affect output and the nominal interest rate

How does this affect output and the nominal interest rate? Could the nominal interest rate end up higher-not lower-than before the change in money growth? Why?

  Payable by the amount of profit on the sale

Is it true that when one firm sells to another on credit, the seller records the transaction as an account receivable while the buyer records it as an account payable and that, disregarding discounts, the receivable typically exceeds the payable by t..

  The leading competitors in the low-calorie frozen

The leading competitors in the low-calorie frozen

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