Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Cash Budgeting Donuthy Koeht recently leased space in the Southside Mall and opened a new business, Koehl's Doll Shop Business has been good, but
Cash Budgeting Donuthy Koeht recently leased space in the Southside Mall and opened a new business, Koehl's Doll Shop Business has been good, but Koehl frequently runs 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 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,500 per month, and the rent in $1,000) per month. In addition, she must make a tax payment of $10,000 in December. The current cash on hand (on December 1) is $500, 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 $100,000 December January February Sales $130,000 30,000 66,000 Purchases $45,000 45,000 45,000 a. Prepare a cash budget for December, January, and February. Do not round intermediate calculations. Round your answers to the nearest dollar. Negative values, if any should be indicated by a minus sign Collections and Purchases Sales (Collections) December $ January February $ Purchases $ $ $ Payments for purchases $ $ $ Salaries S $ $ Rent $ $ $ Taxes $ Total payments
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started