Financial forecasting—percent of sales) Next year’s sales for Cumberland Mfg. are expected to be $22 million. Current sales are $18 million, based on current assets of $5  million and fixed assets of $5 million. The firm’s net profit margin is 5 percent after taxes. Cumberland estimates that current assets will rise in direct proportion to the increase in sales but that its fixed assets will increase by only $150,000. Currently, Cumberland has $2 million in accounts payable (which vary directly with sales), $1  million in long-term debt (due in 10 years), and common equity (including $4 million in retained earnings) totaling $6.5 million. Cumberland plans to pay $750,000 in common stock dividends next year. a. What are Cumberland’s total financing needs (that is, total assets) for the coming year? b. Given the firm’s projections and dividend payment plans, what are its discretionary financing needs? c. Based on your projections, and assuming that the $150,000 expansion in fixed assets will occur, what is the largest increase in sales the firm can support without having to resort to the use of discretionary sources of financing? (Please show working in excel)

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter9: Capital Budgeting And Cash Flow Analysis
Section: Chapter Questions
Problem 20P
icon
Related questions
Question

14-4. (Financial forecasting—percent of sales) Next year’s sales for Cumberland Mfg.
are expected to be $22 million. Current sales are $18 million, based on current assets of
$5  million and fixed assets of $5 million. The firm’s net profit margin is 5 percent after taxes.
Cumberland estimates that current assets will rise in direct proportion to the increase in
sales but that its fixed assets will increase by only $150,000. Currently, Cumberland has
$2 million in accounts payable (which vary directly with sales), $1  million in long-term
debt (due in 10 years), and common equity (including $4 million in retained earnings) totaling $6.5 million. Cumberland plans to pay $750,000 in common stock dividends next year.
a. What are Cumberland’s total financing needs (that is, total assets) for the coming year?
b. Given the firm’s projections and dividend payment plans, what are its discretionary financing needs?
c. Based on your projections, and assuming that the $150,000 expansion in fixed
assets will occur, what is the largest increase in sales the firm can support
without having to resort to the use of discretionary sources of financing?

(Please show working in excel)

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
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
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning