XS FILE Paste A1 5 Clipboard C 6 7 8 9 10 11 12 1. Calculate the additional funds needed. a A B V HOME INSERT B Calibri BIU- E Font X Sales last year Profit margin Sheet1 11 -A- Retention ratio Sales next year Assets Current liabilities PAGE LAYOUT C Current assets $2,124,000 Fixed assets 4,200,000 A G + Additional Funds Needed - Excel FORMULAS DATA Epic % Suppose that Gyp Sum Industries currently has the balance sheet shown below, and that sales for the year just ended were $10.2 million. The firm also has a profit margin of 30 percent, a retention ratio of 20 percent, and expects sales of $8.2 million next year. Assets Liabilities and Equity Current liabilities Long-term debt Equity Total assets $ 6,324,000 Total liabilities and equity $ 6,324,000 If all assets and current liabilities are expected to shrink with sales, what amount of additional funds will Gyp Sum need from external sources to fund the expected growth? (Enter your answer in dollars not in millions Negative amount should be indicated by a minus sign.) REVIEW Alignment Number Conditional Format as Cell Formatting Table Styles Styles $ $ $ $ VIEW $ 1,707,480 1,600,000 3,016,520 10,200,000 30% 20% ? 8,200,000 6,324,000 1,707,480 3 Cells Editing < Prev Sign In 8 of 9 C Next > FILE Paste A1 769 Clipboard F 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 1. Calculate the additional funds needed. 25 26 - A B HOME Calibri INSERT BIU- H Font B X Sales last year Profit margin Retention ratio Sales next year Assets Current liabilities PAGE LAYOUT 11 -A- Sheet1 C fx Additional Funds Needed - Excel FORMULAS DATA % Alignment Number Necessary increase in assets Spontaneous increase in liabilities Projected increase in retained earnings Additional Funds Needed $ $ $ $ REVIEW D Cell Conditional Format as Formatting Table Styles Styles 10,200,000 30% 20% 8,200,000 6,324,000 1,707,480 VIEW E Cells ? Complete the following analysis. Do not hard code values in your calculations, and do not round intermediate calculations. Editing H < Prev Sign In 8 of 9 H X 4 Next >