Problem 3-9 External Funds Needed Dahlia Colby, CFO of Charming Florist Limited, has created the firm’s pro forma balance sheet for the next fiscal year. Sales are projected to grow by 10 percent to $330 million. Current assets, fixed assets, and short-term debt are 25 percent, 80 percent, and 15 percent of sales, respectively. Charming Florist pays out 30 percent of its net income in dividends. The company currently has $135 million of long-term debt and $63 million in common stock par value. The profit margin is 10 percent.    a. Construct the current balance sheet for the firm using the projected sales figure. (Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, rounded to the nearest whole number, e.g., 1,234,567.)              b. Based on Ms. Colby’s sales growth forecast, how much does Charming Florist need in external funds for the upcoming fiscal year? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to the nearest whole number, e.g., 1,234,567.)            c-1. Construct the firm’s pro forma balance sheet for the next fiscal year. (Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, rounded to the nearest whole numbert, e.g., 1,234,567.)              c-2. Calculate the external funds needed. (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to the nearest whole number, e.g., 1,234,567.)

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter4: Financial Planning And Forecasting
Section: Chapter Questions
Problem 10P
icon
Related questions
Question

Problem 3-9 External Funds Needed

Dahlia Colby, CFO of Charming Florist Limited, has created the firm’s pro forma balance sheet for the next fiscal year. Sales are projected to grow by 10 percent to $330 million. Current assets, fixed assets, and short-term debt are 25 percent, 80 percent, and 15 percent of sales, respectively. Charming Florist pays out 30 percent of its net income in dividends. The company currently has $135 million of long-term debt and $63 million in common stock par value. The profit margin is 10 percent.

  

a.

Construct the current balance sheet for the firm using the projected sales figure. (Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, rounded to the nearest whole number, e.g., 1,234,567.)

  
   

 


   

b.

Based on Ms. Colby’s sales growth forecast, how much does Charming Florist need in external funds for the upcoming fiscal year? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to the nearest whole number, e.g., 1,234,567.)

  
   

 


 

c-1.

Construct the firm’s pro forma balance sheet for the next fiscal year. (Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, rounded to the nearest whole numbert, e.g., 1,234,567.)

  
     

 


 

c-2.

Calculate the external funds needed. (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to the nearest whole number, e.g., 1,234,567.)

  
     

 
Problem 3-9 External Funds Needed
Dahlia Colby, CFO of Charming Florist Limited, has created the firm's pro forma balance
sheet for the next fiscal year. Sales are projected to grow by 10 percent to $330 million.
Current assets, fixed assets, and short-term debt are 25 percent, 80 percent, and 15
percent of sales, respectively. Charming Florist pays out 30 percent of its net income in
dividends. The company currently has $135 million of long-term debt and $63 million in
common stock par value. The profit margin is 10 percent.
a. Construct the current balance sheet for the firm using the projected sales figure. (Do
not round intermediate calculations and enter your answers in dollars, not millions
of dollars, rounded to the nearest whole number, e.g., 1,234,567.)
Total assets
Assets
Balance Sheet
Liabilities and equity
Total equity
Total liabilities and equity
Transcribed Image Text:Problem 3-9 External Funds Needed Dahlia Colby, CFO of Charming Florist Limited, has created the firm's pro forma balance sheet for the next fiscal year. Sales are projected to grow by 10 percent to $330 million. Current assets, fixed assets, and short-term debt are 25 percent, 80 percent, and 15 percent of sales, respectively. Charming Florist pays out 30 percent of its net income in dividends. The company currently has $135 million of long-term debt and $63 million in common stock par value. The profit margin is 10 percent. a. Construct the current balance sheet for the firm using the projected sales figure. (Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, rounded to the nearest whole number, e.g., 1,234,567.) Total assets Assets Balance Sheet Liabilities and equity Total equity Total liabilities and equity
b. Based on Ms. Colby's sales growth forecast, how much does Charming Florist need in
external funds for the upcoming fiscal year? (Do not round intermediate calculations
and enter your answer in dollars, not millions of dollars, rounded to the nearest
whole number, e.g., 1,234,567.)
External financing needed
c-1. Construct the firm's pro forma balance sheet for the next fiscal year. (Do not round
intermediate calculations and enter your answers in dollars, not millions of
dollars, rounded to the nearest whole numbert, e.g., 1,234,567.)
Total assets
Assets
Balance Sheet
Total equity
Total liabilities and equity
Liabilities and equity
c-2. Calculate the external funds needed. (Do not round intermediate calculations and
enter your answer in dollars, not millions of dollars, rounded to the nearest whole
Transcribed Image Text:b. Based on Ms. Colby's sales growth forecast, how much does Charming Florist need in external funds for the upcoming fiscal year? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to the nearest whole number, e.g., 1,234,567.) External financing needed c-1. Construct the firm's pro forma balance sheet for the next fiscal year. (Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, rounded to the nearest whole numbert, e.g., 1,234,567.) Total assets Assets Balance Sheet Total equity Total liabilities and equity Liabilities and equity c-2. Calculate the external funds needed. (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to the nearest whole
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps

Blurred answer
Knowledge Booster
Balance Sheet Analysis
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
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
International Financial Management
International Financial Management
Finance
ISBN:
9780357130698
Author:
Madura
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