Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help will give thumbs up area. 5. Value Calculations: Show detail calculations of the intrinsic value of the company's stock price using three different
please help will give thumbs up 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, NI 8 12/31/20 $4,474,667 $2,314 572 $2,160,095 12/31/19 $5,267,132 $2,796,599 $2,470,533 12/31/18 $5,193,185 $2.852,714 $2.340,471 12/31/17 $4.989 244 $2.737830 $2.251.414 $2,171,934 $601,599 $2.233.763 $2,182 339 $183,149 $2.090 522 $124049 1 UNDER ARMOUR: INCOME STATEMENT 2. Period Ending: 3 Total Revenue 4 Cost of Revenue 5 Gross Profit Operating Expenses * Research and Development 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 34 Interest Expense as Earnings Before Tax as Income Tax Minority Interest - Equity Earnings/Loss Unconsolidated Subsidiary Net Income-Cont. Operations o Net Income Net Income Applicable to Common Shareholders 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 (5613,438) $168,153 (5445 285) $47.259 (5492,544 $49,387 (57.246) $236,770 ($5,588) $231,082 $21240 $209,842 $70 024 (547,679) ($25,017 $9.203) (534.220) $33.560 $67.788) ($20 552 $934 $27, 843 $3.514 524229 $34558 ($10.309 $37.951 ($549,177) (5549,177) ($549,177) $92,139 $92,139 392,139 (546,302) ($46,302) (545.302) (548.250 ($48.240) (548.260) 12/31/20 12/31/19 12/31/18 12/31/17 $1,517,361 $788,072 $557 403 $312.483 5527,340 $895,974 $282,300 $3.222.975 $708,714 $892 258 $313.185 $2,702 209 $652546 $1.019.490 $354 183 $2,593,828 5609 670 $1.158,548 $256.978 $2.337.079 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, NI 8 12/31/20 $4,474,667 $2,314 572 $2,160,095 12/31/19 $5,267,132 $2,796,599 $2,470,533 12/31/18 $5,193,185 $2.852,714 $2.340,471 12/31/17 $4.989 244 $2.737830 $2.251.414 $2,171,934 $601,599 $2.233.763 $2,182 339 $183,149 $2.090 522 $124049 1 UNDER ARMOUR: INCOME STATEMENT 2. Period Ending: 3 Total Revenue 4 Cost of Revenue 5 Gross Profit Operating Expenses * Research and Development 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 34 Interest Expense as Earnings Before Tax as Income Tax Minority Interest - Equity Earnings/Loss Unconsolidated Subsidiary Net Income-Cont. Operations o Net Income Net Income Applicable to Common Shareholders 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 (5613,438) $168,153 (5445 285) $47.259 (5492,544 $49,387 (57.246) $236,770 ($5,588) $231,082 $21240 $209,842 $70 024 (547,679) ($25,017 $9.203) (534.220) $33.560 $67.788) ($20 552 $934 $27, 843 $3.514 524229 $34558 ($10.309 $37.951 ($549,177) (5549,177) ($549,177) $92,139 $92,139 392,139 (546,302) ($46,302) (545.302) (548.250 ($48.240) (548.260) 12/31/20 12/31/19 12/31/18 12/31/17 $1,517,361 $788,072 $557 403 $312.483 5527,340 $895,974 $282,300 $3.222.975 $708,714 $892 258 $313.185 $2,702 209 $652546 $1.019.490 $354 183 $2,593,828 5609 670 $1.158,548 $256.978 $2.337.079
please help will give thumbs up
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started