*Please provide complete correct answers with detailed work shown *
1. Calculate next year's estimated cost of goods sold. Current sales: $100,000 Cost of goods sold: $72,000 COGS percent of sales: 72% Forecasted sales: $110,000 Forecasted COGS :( 10,000 72% 79,200 Next year's estimated cost of goods sold is 79,200. 2.) Calculate the net financing required in the coming year. a. Beginning stockholder equity b. Additions to equity net income x retention ratio 45,000 300,000 50,000 x (1-0.10)-45,000 c. Ending stockholder equity 345,000 d. Beginning total liabilities e. Increase in non-debt liabilities f. Ending total liabilities 120,000 10,000 130,000 g. Ending total liabilities and equity h. Ending assets i. Therefore, Net financing required 475,000 500,000 25,000 Therefore, $25,000 in net financing is required. 3., Calculate the amounts of debt and equity financing that would be needed in Problem 2 to keep the capital structure constant. Beginning debt: Beginning equity: Beginning non-debt liabilities: Debt/Equity ratio: 100,000.00 300,000.00 20,000.00 0.33 New assets 500,000.00 30,000.00 470,000.00 . New non-debt liabilities New debt + equity: Amount of equity needed to maintain ratio: Amount of debt needed to maintain ratio 352,500 117,500 Amount of debt to issue (117,500-100,000): Amount of equity to issue (352,500-345,000): 17,500 7,500 With equity growing to $345,000 through retained earnings, the firm would need to issue an additional $7,500 in new equity and $17,500 in new debt to raise the needed net S25.000 and keep the capital structure constant at 33% debt. 1. Calculate next year's estimated cost of goods sold. Current sales: $100,000 Cost of goods sold: $72,000 COGS percent of sales: 72% Forecasted sales: $110,000 Forecasted COGS :( 10,000 72% 79,200 Next year's estimated cost of goods sold is 79,200. 2.) Calculate the net financing required in the coming year. a. Beginning stockholder equity b. Additions to equity net income x retention ratio 45,000 300,000 50,000 x (1-0.10)-45,000 c. Ending stockholder equity 345,000 d. Beginning total liabilities e. Increase in non-debt liabilities f. Ending total liabilities 120,000 10,000 130,000 g. Ending total liabilities and equity h. Ending assets i. Therefore, Net financing required 475,000 500,000 25,000 Therefore, $25,000 in net financing is required. 3., Calculate the amounts of debt and equity financing that would be needed in Problem 2 to keep the capital structure constant. Beginning debt: Beginning equity: Beginning non-debt liabilities: Debt/Equity ratio: 100,000.00 300,000.00 20,000.00 0.33 New assets 500,000.00 30,000.00 470,000.00 . New non-debt liabilities New debt + equity: Amount of equity needed to maintain ratio: Amount of debt needed to maintain ratio 352,500 117,500 Amount of debt to issue (117,500-100,000): Amount of equity to issue (352,500-345,000): 17,500 7,500 With equity growing to $345,000 through retained earnings, the firm would need to issue an additional $7,500 in new equity and $17,500 in new debt to raise the needed net S25.000 and keep the capital structure constant at 33% debt
