Answered step by step
Verified Expert Solution
Link Copied!

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

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

Elements Of Structured Finance

Authors: Ann Rutledge, Sylvain Raynes

1st Edition

0195179986, 978-0195179989

More Books

Students also viewed these Finance questions

Question

DO NOT SOLVE PROBLEM 1. IT IS SOLVED HERE:...

Answered: 1 week ago