EFN, CR and SGR Worksheet.xisx 100% ; Home Layout Tables Charts SmartArt Formula

Question

EFN, CR and SGR Worksheet.xisx 100% ; Home Layout Tables Charts SmartArt Formulas Data Review Font Alignment Number | Fill : Calibri (Body) IEW Wrap Text Percentage 0 00 .00 .0 Condit Forma B6 1 2 3 EFN, IGR and SGR Worksheet FIN 3301/ECO 3331 Spring 2016 5 Percentage Increase in Sales Plowback Ratio 7 Dividend Payout Ratip 8 Internal Growth Rate 9 Sustainable Growth Rate 10 10.61947% 23.76238% Income Statement and Balance Acutal 12/31/15 Projected 12/31/16 11 Sheet Information 12 13 Total Revenues 14 Net Income 15 Dividends Paid 16 Addition to Retained Earnings 17 Total Assets 18 Debt 19 Equity 20 Return on Assets 21 Return on Equity 22 External Financing Needed 23 24 Balance Sheet Changes at SGR: 25 New Total Assets 26 EFN 27 Old Equity Add to R/E 28 Old Debt EFN 29 Beginning D/E Ratio 30 Ending D/E Ratio 31 25,000,000 S 4,000,000 S 1,600,000 $ 2,400,000 S 25,000,000 S 512,500,000$ 25,000,000 4,000,000 1,600,000 2,400,000 25,000,000 12,500,000 14,900,000 12,500,000 $ 16% 32% (2,400,000) 25,000,000 (2,400,000) 14,900,000 10,100,000 1.00 0.68 Sheet+ Normal View Ready Sum-60 0 12 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 1 1 1 1 1 1 1 1 1 2222222222333

Explanation / Answer

I am not able to understand the question clearly.It is not possible to answer this question with out knowing the formulaes used in preparing the excel you added

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.