Prepare a cash budget for December and February

Assignment Help Financial Accounting
Reference no: EM132464566

Problem - Dorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl's Doll Shop. Business has been good, but Koehl frequently run out of cash. This has necessitated late payment on certain orders, which 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 how much she should borrow. Accordingly, she has asked you to assist with the 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,700 per month, and the rent is $2,100 per month. In addition, she must make a tax payment of $14,000 in December. The current cash on hand (on December 1) is $350, but Koehl has agreed to maintain an average bank balance of $5,000 - this is her target cash balance. (Disregard the amount in the cash register, 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 $130,000.

 

Sales

Purchases

December

$170,000

$40,000

January

$46,000

$40,000

February

$52,000

$40,000

Required -

1. Prepare a cash budget for December, January, and February.

2. Suppose Koehl starts 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?

Reference no: EM132464566

Questions Cloud

Explain what semiotics is and its historic origins : Describe how semiotics functions in weather reporting, using an example from Brazil.Define metaphysics, recommending use of speculative metaphysics for TPHIL
What is probability that there are zero customers : A fast food restaurant has customers arrive at the checkout counter at a rate of 30 customers per hour. The average check out time at the till is 90 seconds.
Recipe costing : Recipe Costing - Search on woolworth and coles prices - And take the ingredients according to the recipe for 10 portions
Describe some ways that the emergency response guidebook : Describe how the chemical characteristics, production methods, uses, and associated unique hazards of hydrogen can affect the safety of an environmental
Prepare a cash budget for December and February : Koehl pays herself a salary of $4,700 per month, and the rent is $2,100 per month. Prepare a cash budget for December, January, and February
Discuss nuclear bombs rely upon : Discuss Nuclear bombs rely upon,In the last 50 years, the greatest progress in addressing worldwide hunger and malnutrition came from the:
At what amount should the patent be reported : Vandelay Industries Ltd. had one patent recorded on its books as at January 1, 2018. At what amount should the patent be reported on the December
Calculate the probability that exactly five customers : Use the binomial formula to calculate the probability that exactly five customers make a purchase. (Round your answer to 4 decimal places.)
Expected value of the estimated probability distribution : Find the expected value of the estimated probability distribution. (Round your answer to 2 decimal places.)

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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