OBJECTIVE: 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. 2012 2011 ? 103,365 $ 89,725 85,527 Cash Accounts receivable Inventories Total current assets Net fixed assets Total assets 38,444 $244,659 34,982 $210,234 42,436 $252,670 67,165 $311,824 $ 23,109 22,656 14,217 $ 59,982 63,914 Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained earnings Total common equity Total liabilities and equity $ 30,761 30,477 16,717 $ 77,955 76,264 $154,219 100,000 ? $157,605 5311,824 $123,896 90,000 38,774 $128,774 $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 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. OBJECTIVE: 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. 2012 2011 ? 103,365 $ 89,725 85,527 Cash Accounts receivable Inventories Total current assets Net fixed assets Total assets 38,444 $244,659 34,982 $210,234 42,436 $252,670 67,165 $311,824 $ 23,109 22,656 14,217 $ 59,982 63,914 Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained earnings Total common equity Total liabilities and equity $ 30,761 30,477 16,717 $ 77,955 76,264 $154,219 100,000 ? $157,605 5311,824 $123,896 90,000 38,774 $128,774 $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 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