Use the pro forma balance sheet to calculate the external financing needs.

Based on the assumptions of the SGR, what is the total growth in assets and the external financing needed? (EFN will be around $X)

What is the internal equity financing and spontaneous (A/P) financing? NOTE: EFN plus the internal/spontaneous financing in this step should sum to the growth in assets.

Based on the assumptions of the SGR, what is the external debt financing?

Display all answers and formulas in the Excel sheet. This question has to be completed in Excel with the correct formulas.

CurrentYearSalesTotalCosts(COGS&Admin.)Commonstock&Paid-inCapitalRetainedearningsDividendsPaidAccountspayableNotespayableLong-termdebtNetincomeCashAccountsreceivableInventoryNetplantandequipmentTaxrate71,00055,0006,000200,0004,2002,6005,70028,00012,6403,1404,2006,500150,00021% Growth in assets External financing needed Internal equity financing Spontaneous debt (A/P) External debt (excludes A/P) CurrentYearSalesTotalCosts(COGS&Admin.)Commonstock&Paid-inCapitalRetainedearningsDividendsPaidAccountspayableNotespayableLong-termdebtNetincomeCashAccountsreceivableInventoryNetplantandequipmentTaxrate71,00055,0006,000200,0004,2002,6005,70028,00012,6403,1404,2006,500150,00021% Growth in assets External financing needed Internal equity financing Spontaneous debt (A/P) External debt (excludes A/P)