cash budget of your firm. You gathered the following information. The firm receives all income from sales Sales estimates (in millions) Q1 = 1,000; Q2 = 1,250; Q3 = 1,500; Q4 = 2,000; Q1 next year = 1,200 Accounts receivable Beginning receivables = $3000 Average collection period = 45 days Accounts payable Purchases = 60% of next quarter’s sales Beginning payables = 1,200 Accounts payable period is 45 days Other expenses Wages, taxes, and other expense are 25% of sales Interest and dividend payments are $100 A major capital expenditure of $500 is expected in the second quarter The initial cash balance is $100 and the company maintains a minimum balance of $50

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

(Short-Term Finance and Planning)

You are hired as a financial manager and your first task is to establish the cash budget of your firm.

You gathered the following information.

The firm receives all income from sales

  • Sales estimates (in millions)
    • Q1 = 1,000; Q2 = 1,250; Q3 = 1,500; Q4 = 2,000; Q1 next year = 1,200
  • Accounts receivable
    • Beginning receivables = $3000
    • Average collection period = 45 days
  • Accounts payable
    • Purchases = 60% of next quarter’s sales
    • Beginning payables = 1,200
    • Accounts payable period is 45 days
  • Other expenses
    • Wages, taxes, and other expense are 25% of sales
    • Interest and dividend payments are $100
    • A major capital expenditure of $500 is expected in the second quarter
  • The initial cash balance is $100 and the company maintains a minimum balance of $50
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Financial Planning
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance 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