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

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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