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.) |
b. |
Based on Ms. Colby’s sales growth |
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff2690e4a-8615-4fb9-abf1-a8669cceab2a%2F4b604007-9c2d-47cb-9e48-345f87946f2e%2Fad797kk_processed.jpeg&w=3840&q=75)
![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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff2690e4a-8615-4fb9-abf1-a8669cceab2a%2F4b604007-9c2d-47cb-9e48-345f87946f2e%2F0h175nl_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 5 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Intermediate Financial Management (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781337395083/9781337395083_smallCoverImage.gif)
![Survey of Accounting (Accounting I)](https://www.bartleby.com/isbn_cover_images/9781305961883/9781305961883_smallCoverImage.gif)
![EBK CFIN](https://www.bartleby.com/isbn_cover_images/9781337671743/9781337671743_smallCoverImage.jpg)
![Intermediate Financial Management (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781337395083/9781337395083_smallCoverImage.gif)
![Survey of Accounting (Accounting I)](https://www.bartleby.com/isbn_cover_images/9781305961883/9781305961883_smallCoverImage.gif)
![EBK CFIN](https://www.bartleby.com/isbn_cover_images/9781337671743/9781337671743_smallCoverImage.jpg)