Dahlla Colby, CFO of Charming Florist Ltd$.,$ has created the firm's pro forma balance sheet for the next fiscal year. Sales are projected to grow by $20$ percent to $$480$ million. Current assets, fixed assets, and short$-$term debt are $20$ percent, $70$ percent, and $10$ percent of sales, respectively. Charming Florist pays out $20$ percent of its net income in dividends. The company currently has $$125$ million of long$-$term debt and $$53$ million in common stock par value. The profit margin is $15$ 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 dollar amount, e$.$g$.,1,234,567.)$

$\backslash$table$[[$Assets$,$Balance Sheet,,$],[$Current assets,,Liabilities and equity,$],[$Fixed assets,,Long$-$term debt,$],[,,$Short$-$term debt,$],[,,,],[,,$Common stock,$],[,$Accumulated retained earnings,,$],[$Total assets,,Total 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 dollar amount, e$.$g$.,1,234,567.)$

Extemal 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 dollar amount, e$.$g$.,1,234,567.)$

$\backslash$table$[[$Assets$,$Balance Sheet,$],[$Current assets,,Liabilitios and equity,$],[$Fixed assets,Long$-$term debt,,$],[,$Short$-$term debt,,$],[,,,],[,$Common stock,,$],[,$Accumulated retained earnings,,$],[,,,],[$Total assets,Total 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 dollar amount, e$.$g$.,1,234,567.)$

External financing noeded