Dahlia Colby, CFO of Charming Florist Ltd., has created thefirm’s pro forma balance sheet for the next fiscal year. Sales areprojected to grow by 10 percent to $330 million. Current assets,fixed assets, and short-term debt are 15 percent, 75 percent, and 5percent of sales, respectively. Charming Florist pays out 30percent of its net income in dividends. The company currently has$131 million of long-term debt and $59 million in common stock parvalue. The profit margin is 10 percent.

  

a.	Construct the current balance sheet for the firm using theprojected sales figure. (Do not round intermediatecalculations and enter your answers in dollars, not millions ofdollars, rounded to the nearest whole dollar amount, e.g.,1,234,567.)

  
   

b.	Based on Ms. Colby’s sales growth forecast, how much doesCharming Florist need in external funds for the upcoming fiscalyear? (Do not round intermediate calculations and enteryour answer in dollars, not millions of dollars, rounded to thenearest whole dollar amount, e.g., 1,234,567.)

  
   

c-1.	Construct the firm’s pro forma balance sheet for the next fiscalyear. (Do not round intermediate calculations and enteryour answers in dollars, not millions of dollars, rounded to thenearest whole dollar amount, e.g., 1,234,567.)

  
     

c-2.	Calculate the external funds needed. (Do not roundintermediate calculations and enter your answer in dollars, notmillions of dollars, rounded to the nearest whole dollar amount,e.g., 1,234,567.)