Attached please find the question and the supporting balance sheet information in an excel spreasdsh

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:

PLACE YOUR ORDER TO GET STARTEDThe post Attached please find the question and the supporting balance sheet information in an excel spreasdsh appeared first on Essay Gem.

"Order a Custom Paper on Similar Assignment! No Plagiarism! Enjoy 20% Discount"