FINANCIAL MANAGEMENT

Using the financial data information provided to construct all the financial statements (i.e. income statement, statement of retained earnings, statement of cash flows, and balance sheet) of the firm for year 2012 using excel.

Using the information from the financial statements to calculate and analyze business financial perfpormance measures.

IMPORTANT:

FOR THE FOLLOWING QUESTION CONSTRUCT THE FINANCIAL STATEMENTS ON EXCEL (ONE FINANCIAL STATEMENT PER WORKSHEET) AND THEN CALUCLATE THE REQUIRED FINANCIAL MEASURES IN A NEW EXCEL SHEET OF THE SAME WORKBOOK.

NOTE : CONSTRUCT THE STATEMENTS USING EQUATIONS/ FORMULAS. ALSO, LINK CELLS (ACROSS SHEETS AND WITHIN SHEETS) WHERE REQUIRED. FINANCIAL STATEMENTS ARE COVERED IN DETAIL IN CLASS. YOU CAN REFER TO LECTURE VIDEOS ON LSE PORTAL.

SUBMIT ANALYSIS OF FINANCIAL PERFORMACE MEASURES IN A SEPARATE WORD FILE.

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 .

?

?

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 firms 2012 income statement

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 at 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.

QUESTION: Amazon has the following balance sheet for years 2012 (incomplete) and 2011. Use th financial data information provided to construct the financial statements of the firm for yes 2012, calculate, and analyze financial measures of the firm. 2012 2011 2 Cash Accounts receivable Inventories Total current assets Net fixed assets Total assets 103.365 38,444 $244,659 67,165 $311 824 $ 89,725 85,527 34.982 $210,234 42,436 $252670 Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total abilities Common stock Retained earnings Total common equity Total liabilities and equity $ 30,761 30,477 16,717 $ 77,955 76,264 $154219 100.000 $ 23,109 22656 14,217 $ 59,982 63.914 $123.896 90 000 5157605 5311 824 38.774 5128,774 $252570 a) Key input values to construct Income Statement are following. Insert the key input dat in the excel sheet and link the cells in calculations. Given this information, constru the firu's 2012 income statement Sales for 2012 were $455.150.000