Please help me find the External Funds Needed (EFN) for both questions. Thank yo
ID: 2328232 • Letter: P
Question
Please help me find the External Funds Needed (EFN) for both questions. Thank you.
Dahlia Colby, CFO of Charming Florist Ltd, has created the firm's pro forma balance sheet for the next fiscal year short-term debt are 25 percent, 70 percent, and 15 percent of sales, respectively. Charming Florist pays out 25 percent of its net income in dividends. The company currently has $121 million of long-term debt and 49 million in common stock par value. The proft margin is 9 percent. are projected to grow by 10 percent to $330 million. Current assets, foxed assets, and a. Prepare the current balance sheet for the firm using the projected sales figure. (Be sure to list the assets and liabilities in order of their liquidity. Enter your answers in dollars, not millions of dollars, e.g.1,234,567. Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.) Balance Sheet Assets Liabilities and equity Current assets 5000000 Short-tem debt 45,000.000 210,000,000 121,000,000 Fixed assets Long-term debt Common stock 49,000,000 70,000,000 Accumulated retained earnings Total equity 119000000 Total assets 285000000 Total liabilities and equity 285000000 b. Based on Ms. Colby's sales growth forecast, how much does Charming Florist need in external funds for the upcoming fiscal year? (Enter your answer in dollars, not millions of dollars, e.g., 1,234,567. Do not round intermediate calculations and round your answer to the nearest whole number, e.g 32.)Explanation / Answer
b. Computation of Eternal funds for the upcoming fiscal year EFN = [(Assets / sales)X change in sales] - [(Debt / sales)X change in sales] - (projected margin X projected sales)X (1 - payout ratio) = [(25% + (1.10)) X $300,00,000] - [(15%) X $300,00,000] - [($30,00,00,000 X 9 %) X ( 1 - 25%)] = $4,05,00,000 - $45,00,000 - $2,02,50,000 = $ 1,57,50,000 Workings: Current sales = Projected sales / (1 + g) = $3300,00,000 / (1.10) = $ 30,00,00,000 Change in sales = Projected sales - Current sales = $33,00,00,000 - $30,00,00,000 = $ 3,00,00,000 b2. EFN = Total Assets - Total Liabilities equity = $31,35,00,000 - $31,17,75,000 = $ 17,25,000
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.