area. 5. Value Calculations: Show detail calculations of the intrinsic value of the company's stock price...

 

Transcribed Image Text:

area. 5. Value Calculations: Show detail calculations of the intrinsic value of the company's stock price using three different methods of valuations. Those are Dividend Discount Model, Free Cash Flow model and Relative Valuation models (such as, P/E ratio, price/sales ratio, price/book, etc.). Show these calculations in a separate excel spreadsheet. Attach the excel file in the assignment. Discuss the implications of those values in your mail paper by making references to the results in the excel file and if the values are different from market value, discuss the reasons. 1 UNDER ARMOUR: INCOME STATEMENT 2 Period Ending: 3 Total Revenue 4 Cost of Revenue 5 Gross Profit A Operating Expenses 7 Research and Development 8 Sales, General and Admin. 9 Non-Recurring Items 10 Other Operating Items 11 Operating Income 12 Add'l income/expense items 13 Earnings Before Interest and Tax 4 Interest Expense as Earnings Before Tax 26 Income Tax 7 Minority Interest Equity Earnings/Loss Unconsolidated Subsidiary 9 Net Income-Cont. Operations o Net Income Net Income Applicable to Common Shareholders 2 BALANCE SHEET Period Ending: Current Assets Cash and Cash Equivalents Short-Term Investments Net Receivables Inventory Other Current Assets Total Current Assets Long-Term Assets B 12/31/20 $4,474,667 $2,314,572 $2,160,095 $2,171,934 $601,599 ($613,438) $168,153 ($445,285) $47,259 ($492,544) $49,387 ($7,246) ($549,177) ($549,177) ($549,177) 12/31/20 $1,517,361 $527,340 $895,974 $282,300 $3,222,975 C 12/31/19 $5,267,132 $2,796,599 $2,470,533 $2,233,763 $236,770 ($5,688) $231,082 $21,240 $209,842 $70,024 ($47,679) $92,139 $92,139 $92,139 12/31/19 $788,072 $708,714 $892,258 $313,165 $2,702,209 D 12/31/18 $5,193,185 $2,852,714 $2,340,471 $2,182,339 $183,149 ($25,017) ($9,203) ($34,220) $33.568 ($67,788) ($20,552) $934- ($46,302) ($46,302) ($46,302) 12/31/18 $557,403 $652,546 $1,019,496 $364,183 $2,593,628 E 12/31/17 $4,989,244 $2.737,830 $2,251,414 $2.099,522 $124,049 $27,843 ($3.614) $24.229 $34,538 ($10.309) $37,951 ($48.260) ($48,260) ($48,260) 12/31/17 $312,483 $609,670 $1,150,548 $256,978 $2,337.679 (NI area. 5. Value Calculations: Show detail calculations of the intrinsic value of the company's stock price using three different methods of valuations. Those are Dividend Discount Model, Free Cash Flow model and Relative Valuation models (such as, P/E ratio, price/sales ratio, price/book, etc.). Show these calculations in a separate excel spreadsheet. Attach the excel file in the assignment. Discuss the implications of those values in your mail paper by making references to the results in the excel file and if the values are different from market value, discuss the reasons. 1 UNDER ARMOUR: INCOME STATEMENT 2 Period Ending: 3 Total Revenue 4 Cost of Revenue 5 Gross Profit A Operating Expenses 7 Research and Development 8 Sales, General and Admin. 9 Non-Recurring Items 10 Other Operating Items 11 Operating Income 12 Add'l income/expense items 13 Earnings Before Interest and Tax 4 Interest Expense as Earnings Before Tax 26 Income Tax 7 Minority Interest Equity Earnings/Loss Unconsolidated Subsidiary 9 Net Income-Cont. Operations o Net Income Net Income Applicable to Common Shareholders 2 BALANCE SHEET Period Ending: Current Assets Cash and Cash Equivalents Short-Term Investments Net Receivables Inventory Other Current Assets Total Current Assets Long-Term Assets B 12/31/20 $4,474,667 $2,314,572 $2,160,095 $2,171,934 $601,599 ($613,438) $168,153 ($445,285) $47,259 ($492,544) $49,387 ($7,246) ($549,177) ($549,177) ($549,177) 12/31/20 $1,517,361 $527,340 $895,974 $282,300 $3,222,975 C 12/31/19 $5,267,132 $2,796,599 $2,470,533 $2,233,763 $236,770 ($5,688) $231,082 $21,240 $209,842 $70,024 ($47,679) $92,139 $92,139 $92,139 12/31/19 $788,072 $708,714 $892,258 $313,165 $2,702,209 D 12/31/18 $5,193,185 $2,852,714 $2,340,471 $2,182,339 $183,149 ($25,017) ($9,203) ($34,220) $33.568 ($67,788) ($20,552) $934- ($46,302) ($46,302) ($46,302) 12/31/18 $557,403 $652,546 $1,019,496 $364,183 $2,593,628 E 12/31/17 $4,989,244 $2.737,830 $2,251,414 $2.099,522 $124,049 $27,843 ($3.614) $24.229 $34,538 ($10.309) $37,951 ($48.260) ($48,260) ($48,260) 12/31/17 $312,483 $609,670 $1,150,548 $256,978 $2,337.679 (NI

Answer rating: 100% (QA)

1 UNDER ARMOUR INCOME STATEMENT Period Ending Total Revenue The total revenue for Under Armour for the years 20172020 was as follows 123120 4474667 123119 5267132 123118 5193185 123117 4989244 Cost of ... View the full answer