Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Pro-Forma: Assumption: Debt is the Plug Sales Growth: 24.00% Tax Rate: 43.00% L-T Interest: 7.00% COGS/SGA per Sales: 60.00% Current Assets per Sales: 10.00% Current
Pro-Forma: | ||||||
Assumption: | ||||||
Debt is the Plug | ||||||
Sales Growth: | 24.00% | |||||
Tax Rate: | 43.00% | |||||
L-T Interest: | 7.00% | |||||
COGS/SGA per Sales: | 60.00% | |||||
Current Assets per Sales: | 10.00% | |||||
Current Liabilities per Sales: | 80.00% | |||||
Fixed Assets per Sales: | 70.00% | |||||
Dividend Payout: | 50.00% | |||||
Depreciation Periods: | 0 | years | ||||
Number of Years in Analysis: | 5 | years | ||||
Income Statement: | ||||||
YEAR: | 0 | 1 | 2 | 3 | 4 | 5 |
Sales: | $ 3,100.00 | |||||
COGS and SGA: | $ 2,340.50 | |||||
Depreciation Expense: | $ 186.00 | |||||
EBIT: | $ 573.50 | |||||
Interest Expense: | $ 69.06 | |||||
EBT: | $ 504.44 | |||||
Taxes: | $ 216.91 | |||||
Net Income: | $ 287.53 | |||||
Dividend: | $ 112.14 | |||||
Paid to Retained Earnings: | $ 175.39 | |||||
Assets: | ||||||
Current Assets: | $ 403.00 | |||||
Fixed Assets: | $ 3,348.00 | |||||
Acc Depreciation: | $ 372.00 | |||||
Net Fixed Assets: | $ 2,976.00 | |||||
Total Assets: | $ 3,379.00 | |||||
Liabilities and Equity: | ||||||
Current Liabilities: | $ 356.50 | |||||
L-T Debt: | $ 812.50 | |||||
Total Liabilities: | $ 1,169.00 | |||||
Stock: | $ 1,105.00 | |||||
Retained Earnings: | $ 1,105.00 | |||||
Total Equity: | $ 2,210.00 | |||||
Total L and E: | $ 3,379.00 | |||||
Cash Flow from Operations: | ||||||
Change in NWC: | ||||||
Change in Fixed Assets: | ||||||
Cash Flow from Assets: | ||||||
Free Cash Flow: | ||||||
Cash Flow to Creditors: | ||||||
Cash Flow to Shareholders: |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started