In preparation for the quarterly cash budget, the following revenue and cost information have been...
70.2K
Verified Solution
Link Copied!
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!
