dahlia 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 $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. construct the current balance sheet for the firm using the projected sales figure. based on ms$.$colby's sales growth forecast, how much does charming florist need in external funds for the upcoming fiscal year? construct the firms's pro forma balance sheet for the next fiscal year.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.)$

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.)$