Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Howe Ltd. is trying to decide whether it is going to need to take a loan in coming January to buy a new microcomputer system.

Howe Ltd. is trying to decide whether it is going to need to take a loan in coming January to buy a new microcomputer system. The microcomputer will cost $8,800. The president, Joan Howe, has collected the following information about her operations as at December 31: 1. Balance of selected ledger accounts:

Howe Ltd. is trying to decide whether it is going to need to take a loan in coming January to buy a new microcomputer system. The microcomputer will cost $8,800. The president, Joan Howe, has collected the following information about her operations as at December 31: 1. Balance of selected ledger accounts:
Cash $2,500
Accounts payable 6,667
2. Sales history and forecast (unit selling price, $10):
October (actual) $45,000
November (actual) 33,000
December (actual) 45,000
January (forecast) 60,000
3. All sales are on credit and are due 30 days after the sale.
4. Cash payments for purchases are as follows: two-thirds in the month of purchase; one-third in the month after that.
5. Howe Ltd. collects 50% of a months sales one month after the sale and 45% two months after the sale; 5% are uncollectible.
6. The company purchases inventory as required under terms of 2/10, net 30. It always takes the 2% discount, but records purchases at gross cost.
7. Inventory costs $5 per unit, gross.
8. Other expenses, all paid in cash as incurred, average about 30% of the sales dollar amount. Depreciation is part of these expenses and costs $3,000 per month.
9. Howe Ltd. keeps a minimum cash balance of $4,000.

Prepare a cash budget for January, indicating whether Howe Ltd. will need a loan to finance its computer acquisition. (Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45). Round answers to 0 decimal places, e.g. 5,275. Do not leave any answer field blank. Enter 0 for amounts.)

image text in transcribed

HOWE LTD. Cash Budget For the Month Ended January 31

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Governmental and Nonprofit Accounting

Authors: Robert Freeman, Craig Shoulders, Gregory Allison, Robert Smi

10th edition

132751267, 978-0132751261

Students also viewed these Accounting questions