Growth Capacity Calculator by SmallBusinessForum

VIEWS: 244 PAGES: 2

Growth Capacity Calculator is a Microsoft Excel model that can be downloaded immediately and used by putting your numbers in the appropriate cells. Calculations are automatic. Can be customized to fit your needs.|n||n|Click to a href="http

More Info
									Growth Capacity Calculator (GCC)
Instructions Goto A50 Contents Goto A63

--------------- --------------- --------------- --------------- --------------- --------------- --------------- --------------Capitalization Year 1 Year 2 Year 3 Year 4 Year 5 --------------- ---------------------------------------Accepted Debt/Equity Ratio * Equity * Total Debt Total Capitalization 80% 5,000 4,000 9,000 80% 5,717 4,574 10,291 80% 6,495 5,196 11,691 100% 7,411 7,411 14,821 100% 8,551 8,551 17,103

* Interest Rate

13.00%

14.50%

13.00%

12.00%

11.00%

Profitability --------------- --------------* Profit before Interest and Taxes Interest Expense Profit before Tax Tax Rate * Tax Expense Profit after Tax

Year 1 -----1,700 520 1,180 35% 414 766

Year 2 -----1,944 663 1,281 35% 449 831

Year 3 -----2,208 675 1,533 35% 538 995

Year 4 -----2,800 889 1,910 35% 670 1,240

Year 5 -----3,231 
								
To top