In preparation for the quarterly cash budget, the following revenue and cost information have been compiled. Prepare and evaluate a cash budget for the months of October, November, and December based on the information shown below.       ∙     The firm collects 60 percent of sales for cash and 40 percent of its sales one month later. ∙     Interest income of $50,000 on marketable securities will be received in December. ∙     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 month's sales. ∙     Sales commissions amount to 2 percent of the preceding month's sales. ∙     Lease payments of $100,000 must be made each month. ∙     A principal and interest payment on an outstanding loan is due in December of $150,000. ∙     The firm pays dividends of $50,000 at the end of the quarter. ∙     Fixed assets costing $600,000 will be purchased in December. ∙     Depreciation expense each month of $45,000. ∙     The firm has a beginning cash balance in October of $100,000 and maintains a minimum cash balance of $200,000.

Entrepreneurial Finance
6th Edition
ISBN:9781337635653
Author:Leach
Publisher:Leach
Chapter6: Managing Cash Flow
Section: Chapter Questions
Problem 2EP
icon
Related questions
Topic Video
Question
100%

FIN 3004 Business Finance 

           Homework

In preparation for the quarterly cash budget, the following revenue and cost information have been compiled. Prepare and evaluate a cash budget for the months of October, November, and December based on the information shown below.

 

 

 

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

∙     Interest income of $50,000 on marketable securities will be received in December.

∙     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 month's sales.

∙     Sales commissions amount to 2 percent of the preceding month's sales.

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

∙     A principal and interest payment on an outstanding loan is due in December of $150,000.

∙     The firm pays dividends of $50,000 at the end of the quarter.

∙     Fixed assets costing $600,000 will be purchased in December.

∙     Depreciation expense each month of $45,000.

∙     The firm has a beginning cash balance in October of $100,000 and maintains a minimum cash balance of $200,000.

Month
Sales
$3,000,000
Purchases
August (actual)
September (actual)
October (forecast)
November (forecast)
December (forecast)
$3,500,000
$4,500,000
$2,000,000
$1,000,000
$1,500,000
$2,000,000
$ 500,000
$ 750,000
$1,000,000
Transcribed Image Text:Month Sales $3,000,000 Purchases August (actual) September (actual) October (forecast) November (forecast) December (forecast) $3,500,000 $4,500,000 $2,000,000 $1,000,000 $1,500,000 $2,000,000 $ 500,000 $ 750,000 $1,000,000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

The total cash receipts have to be put in the final part?

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Performance measurements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub