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

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter12: The Cost Of Capital
Section: Chapter Questions
Problem 13P
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
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage