Question

Amazon has the following balance sheet for years 2012 (incomplete) and 2011. Use the financial data information provided to construct the financial statements of the firm for year 2012, calculate, and analyze financial measures of the firm.

Balance sheet figures are in thousands of dollars:

*2012*
Cash - ?
Accounts receivable - 103,365
Inventories - 38,444
     Total current assets - $244,659
Net fixed assets - 67,165
Total assets - $311,824

Accounts payable - $311.824
Accruals - 30,477
Notes payable - 16,717
     Total current liabilities - 77,955
Long-term debt - 76,264
     Total liabilities - $154,219
Common stock - 100,000
Retained earnings - ?
Total common equity - $157,605
Total liabilities and equity - 311,824

2011
Cash - 89,725
Accounts receivable - 85,527
Inventories - 34,982
     Total current assets - $210,234
Net fixed assets - 42.436
Total assets - $252,670

Accounts payable - 23,109
Accruals - 22,656
Notes payable - 14,217
     Total current liabilities - 59,982
Long-term debt - 63,914
     Total liabilities - $123,896
Common stock - 90,000
Retained earnings - 38,774
     Total common equity - $128,774
Total liabilities and equity - $252670


a) Key input values to construct Income Statement are following.. Insert the key input data in the excel sheet and link the cells in calculations. Given this information, construct the firm's 2012 income statement (round the final answer to 000s).

• Sales for 2012 were $455,150,000
•EBITDA was 15% of sales.
•Depreciation and amortization were 11% of net fixed assets.
•Interest was $8,575,000.
•Corporate tax rate was 40%
•Amazon pays 40% of its net income in dividends.

b) Construct the statement of R/E for the year ending December 31, 2012.

c) Construct the statement of stockholder's equity for the year ending December 31, 2012

d) Construct the statement of cash flows for the year 2012.

e) Complete and construct the balance sheet as of December 31, 2012.

f) Calculate the following financial measures for the year 2012:
• NOPAT
•NOWC
•Total Operating Capital
•FCF
• MVA EVA

g) Interpret and analyze the above measures for the firm.


Additional information:
• Market stock price of Amazon share on •December 31, 2012 is $65.
•Cost of capital (WACC) is 10%.
•Par value per share is $10.
•New shares issued in 2012 @ a par value of $10 are 10 million.​

Answer 1

Answer:

$}okay \:dear \: friend \: please \: make \: me \: brainlylist$