In preparation for the quarterly cash budget, the following revenue and cost information have been...

70.2K

Verified Solution

Question

Finance

In preparation for the quarterly cash budget, the following revenue and cost information have been compiled. Prepare and evaluate a cash budget for the month of August based on the information shown below. Display formulas used.

Month

Sales

Purchases

June (actual)

$4,500,000

$3,500,000

July (actual)

$5,000,000

$4,000,000

August (forecast)

$2,000,000

$1,000,000

The firm collects 60 percent of sales for cash and 40 percent of its sales one month later.

The firm pays cash for 40 percent of its purchases.

The firm pays for 60 percent of its purchases the following month.

Salaries and wages amount to 15 percent of the preceding months sales.

Lease payments of $750,000 must be made each month.

Depreciation expense each month of $50,000.

The firm has a beginning cash balance in August of $150,000 and maintains a minimum cash balance of $100,000.

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students