Attached please find the question and the supporting balance sheet information in an excel spreasdsheet. Can you please help me by tomorrow morning?

Document Preview:

2011
2011
2010

48230

-31729
261
130

-11176
1566
1647

-1539
7209
6611

3786
215
298

-1422.079030810532
9251
8686

2363.920969189468
24261

1539
22722
21361

3902.920969189468
253
509

-211
460
313

-2900
56947
30869

791.920969189468

1021
1104

2011
2012
2013
2014
2015
2016
2017
4109
3713

791.920969189468
831.51701764894142
873.09286853138849
916.74751195795795
962.58488755585586
1010.7141319336487
1025.8748439126532
2892
2934

18652.269889320964
8022
7751

5039
5576

0.05
1570
1444

1.4999999999999999E-2
18055
16098

7.0000000000000007E-2
32686
30869

4534.9484590665015
2011
2010

13298.81064708522
48230
48283

17833.759106151723
31729
31556

-7630
11176
10656

10203.759106151723
1539
1366

3786
4705

40
45

3826
4750

320
239

3506
4511

1311
1702

2195
2809

0.37393040501996577
0.37729993349589891

0.37561516925793237

EMBA 602 – Problem Set 2
#4: Individual Assignment
Jason Hover
Question A
Balance Sheet
Year Ending Dec 31
Revenue
ASSETS
COGS
Cash and cash equivalents
SG&A
Accounts receivables
Depreciation
Inventories
Taxable operating income
Other current assets
Tax on operating income
Total current assets
Net oper proft after tax (NOPAT)
(+) Depreciation
Net PP&E
Operating cash flow
Long-term investments
Change in working capital
Other assets
Capital Expenditure
Total assets
Free cash flow
LIABILITIES AND EQUITY
Question B
Short-term debt
Accounts payable
FCF
Accrued expenses
Terminal Value
Total current liabilities
Assumptions:
Long-term debt
FCF Growth Rate (5 years)
Other long-term liabilities
Growth in Perpetuity
Shareholders’ equity
WACC
Total liabilities and equity
Calculation of Equity Value:
Income statement
PV of FCF through 2016
PV of Terminal Value
Net sales
Enterprise Value
Cost of goods sold
Less: Debt
Equity Value
Income from operations
Interest income
Total Income
Interest expense
Profit before taxes
Income taxes
Net Income
Implied Tax Rate
Average Tax Rate

Attachments:

"Get 15% discount on your first 3 orders with us"
Use the following coupon
"FIRST15"

Order Now