Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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?

image text in transcribed

image text in transcribed

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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Encyclopedia Of Money

Authors: Larry Allen

2nd Edition

159884251X,1598842528

More Books

Students also viewed these Finance questions

Question

What are three key elements of a successful business plan pitch?

Answered: 1 week ago

Question

Explain the market segmentation.

Answered: 1 week ago

Question

Mention the bases on which consumer market can be segmented.

Answered: 1 week ago

Question

Explain consumer behaviour.

Answered: 1 week ago

Question

Queues can help to equitably reduce moral hazard.

Answered: 1 week ago