Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a. Green Spaces Ltd. sells industrial lawn mowers for $2,500 each. The company needs a cash budget for the month of May. The following information

image text in transcribed
a. Green Spaces Ltd. sells industrial lawn mowers for $2,500 each. The company needs a cash budget for the month of May. The following information is available: Actual sales for April and expected sales for Miy 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. April May Cash $12,500 $27,500 Sales Sales on $57,500 $82,500 account b. Purchases of their merchandise Inventory (the lawn mowers that they sell) will total $95,000 for May. 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 April were $50,000. Selling and administrative expenses are budgeted at $18,000 for May. Of this amount $3,000 is for depreciation. Equipment costing $44,000 will be purchased in May. Terms of the purchase are 50% down payment and the balance due in 60 days. Dividends of $4,000 and income tax installment payments of $3,000 are expected to be paid in May. The company must maintain a minimum cash balance of $5,000 at the end of c. d f. each month. 9. Any borrowings must be done at the beginning of the month and all borrowings can only be in increments of $1,000. ().e. If they need $1,500, they must borrow $2,000.) There was no financing outstanding at the beginning of the month. The annual interest rate is 6% on any of the borrowings and is calculated and paid at the end of each month. The cash balance at the beginning of May is $7,200. h. 1. REQUIRED: Prepare a cash budget for May

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_2

Step: 3

blur-text-image_3

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

Auditing The Food And Beverage Operation An Operational Audit Approach Volume 1

Authors: Hans L. Steiniger Certified Public Accountant Certified Internal Auditor

1st Edition

1424167698, 978-1424167692

More Books

Students also viewed these Accounting questions