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

  What have you mastered about strategy in business ?

What have you mastered about Strategy in business ?

  At what price will kim be faced with her first margin call

Kim want to separate on the declining value of RST Inc. If the price of RST is currently $60 and has decided to Short-Sell 800 shares; What will her A/C shares look like?

  All of general hospitals debt is at an inerest rate of 75

all of general hospitals debt is at an inerest rate of 7.5 on its debt. it is in the 35 tax bracket. 30 of its funding

  Calculate the monthly mortgage payment

Calculate the monthly mortgage payment of principal and interest for the a loan with an initial balance of 150,000, an annual stated interest rate of 6%, and 30 years to maturity. Use Excel to develop this response and present your result within a..

  What will happen to the value of the indian rupee today

If the indian government unexpectedly announces taht it will be imposing higher tariffs on foreign goods one year from now, what will happen to the value of the indian rupee today?

  Objective type questions on bond valuation

Objective type questions on bond valuation and Asymmetric information occurs when

  Compare the performance of a given set of portfolios

Lets extend the discussion by examining the practical implications of these concepts. Under what circumstances would it make sense to use the Treynor measure to compare the performance of a given set of portfolios?

  Revealed in half concealing

It was her sister Josephine who told her, in broken sentences; veiled hints that revealed in half concealing. Her husband's friend Richards was there, too, near her. It was he who had been in the newspaper office when intelligence of the railro..

  What is the rate of return from this investment

An investor purchases a mutual fund share for $100. the fund pays dividends of $3, distributes a capital gain of $4, and charges a fee of $2 when the mutual fund is sold one year later for $105. What is the rate of return from this investment?

  Required rate return and risk analysis

Stocks coefficient of variation, required rate return and risk analysis - Calculate each stock's coefficient of variation. and Which stock is riskier for a diversified investor?

  Question 1- corporate debt has been expanding very

question 1- corporate debt has been expanding very dramatically in the last three decades. what has been the impact on

  Various techniques of inventory management

An investor is thinking of investing in a recurring deposit scheme that offers an interest rate of 12% per annum

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