FINC721

Project 1: Analysis of Financial statements of your Company over the period 2017-2019

You are required to download the financial statements of, 2017, 2018 and 2019 of the company assigned to you in the file attached and to calculate the main ratios with the objective to highlight the areas of weaknesses and strength during the last 3 years.

A Good report will include 2 files: a word document and an excel spreadsheet.

the word document would first include an introduction about your company, products, markets, main competitors and a short paragraph on how well the stock price is doing.

The second part will focus on calculating and interpreting financial ratios learned in chapter 2.

The last part of the report will include recommendation to the management group or to potential investors.

note : please anaylize sony data sheet if possible (excel file is mandotory)

Annual Data 1 Millions of US $ except per share data 2019-03-31 2018-03-31 2017-03-31 $77,991.18 $46,356.75 $31,634.43 $76,895.84 $46,694.33 $30,201.5 $70,710.23 $44,202.99 $26,507.23 Revenue Cost Of Goods Sold Gross Profit Research And Development Expenses SG&A Expenses Other Operating Income Or Expenses Operating Expenses Operating Income Total Non-Operating Income/Expense $14,248.77 $14,191.42 $-9,394.889 $14,005.39 $-9,816.912 $-9,338.994 $69,943.06 $8,048.117 $1,056.717 $9,104.832 $405.882 $8,698.95 E E E E E EE E E E EE EE EEEE E $70,282.1 $6,613.734 $-322.299 $6,291.441 $1,365.93 $4,925.511 $68,025.3 $2,684.93 $-344.872 $2,340.057 $1,153.739 $1,186.317 Pre-Tax Income Income Taxes Income After Taxes Other Income Income From Continuous Operations Income From Discontinued Operations Net Income EBITDA $8,698.95 $4,925.511 $1,186.317 EBIT $8,246.439 $11,414.35 $8,048.117 1,267 1,295 $6.51 $6.37 $4,417.146 $9,866.73 $6,613.734 1,264 1,292 $3.49 $681.588 $5,726.476 $2,684.93 1,262 1,288 Basic Shares Outstanding Shares Outstanding Basic EPS EPS - Earnings Per Share $0.54 $3.42 $0.53 Annual Data 1 Millions of US $ except per share data 2019-03-31 2018-03-31 2017-03-31 $77,991.18 $46,356.75 $31,634.43 $76,895.84 $46,694.33 $30,201.5 $70,710.23 $44,202.99 $26,507.23 Revenue Cost Of Goods Sold Gross Profit Research And Development Expenses SG&A Expenses Other Operating Income Or Expenses Operating Expenses Operating Income Total Non-Operating Income/Expense $14,248.77 $14,191.42 $-9,394.889 $14,005.39 $-9,816.912 $-9,338.994 $69,943.06 $8,048.117 $1,056.717 $9,104.832 $405.882 $8,698.95 E E E E E EE E E E EE EE EEEE E $70,282.1 $6,613.734 $-322.299 $6,291.441 $1,365.93 $4,925.511 $68,025.3 $2,684.93 $-344.872 $2,340.057 $1,153.739 $1,186.317 Pre-Tax Income Income Taxes Income After Taxes Other Income Income From Continuous Operations Income From Discontinued Operations Net Income EBITDA $8,698.95 $4,925.511 $1,186.317 EBIT $8,246.439 $11,414.35 $8,048.117 1,267 1,295 $6.51 $6.37 $4,417.146 $9,866.73 $6,613.734 1,264 1,292 $3.49 $681.588 $5,726.476 $2,684.93 1,262 1,288 Basic Shares Outstanding Shares Outstanding Basic EPS EPS - Earnings Per Share $0.54 $3.42 $0.53