Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Garden Ltd. sells industrial lawn mowers for $2,000 each. The company needs a cash budget for the month of June. The following information is available:

Garden Ltd. sells industrial lawn mowers for $2,000 each. The company needs a cash budget
for the month of June. The following information is available:
a. Actual sales for May and expected sales for June are shown below. The company has both
cash sales, and sales on account. Of the sales on account, 25% are collected in the month of
sale, and 73% are collected in the month after sale. The remainder are uncollectible.
May June
Cash Sales $14,000 $24,000
Sales on account $60,000 $80,000
b. Purchases of their merchandise inventory (the lawn mowers that they sell) will total
$90,000 for June. Twenty percent of a month's inventory purchases are paid
for during the month of purchase. The remaining 80% is paid for in the following
month. Inventory purchases in May were $60,000.
c. Selling and administrative expenses are budgeted at $24,000 for June. Of this
amount $4,000 is for depreciation.
d. Equipment costing $38,000 will be purchased in June. Terms of the purchase
are 50% down payment and the balance due in 60 days.
e. Dividends of $3,000 and income tax installment payments of $4,000 are expected
to be paid in June.
f. The company must maintain a minimum cash balance of $8,000 at the end of
each month.
g. Any borrowings must be done at the beginning of the month and all borrowings
can only be in thousand dollar increments. (i.e. If they need $1,500, they must borrow $2,000.)
h. The annual interest rate is 6% on any of the borrowings and is calculated and paid
at the end of each month.
i. The cash balance at the beginning of June is $9,000.
REQUIRED: Prepare a cash budget for June.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Advanced Accounting And Auditing Theory And Practice

Authors: Prof. R.B. Patel

1st Edition

8188730882, 978-8188730889

More Books

Students also viewed these Accounting questions

Question

How is legality different from ethics?

Answered: 1 week ago