area. 5. Value Calculations: Show detail calculations of the intrinsic value of the company's stock price...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Related Book For
Fundamentals of Analytical Chemistry
ISBN: 978-0495558286
9th edition
Authors: Douglas A. Skoog,Donald M. West, F. James Holler, Stanley R. Crouch
Posted Date:
Students also viewed these accounting questions
-
a) You are provided with the following information relating to V ltd Equity and liabilities 12% debentures (shs1000 at par) 16,000 10% preferences shares 6,250 Ordinary shares (Sh. 10 par) 12,500...
-
If a parent and its subsidiary file separate income tax returns, why will the parent frequently have to recognize deferred income taxes? Why might the subsidiary have to recognize deferred income...
-
Discuss the reasons companies such as Under Armour or Calvin Klein might use an in-house agency rather than an external agency. Why might a company change from us9ng an in-house agency and hire an...
-
3. Questions A venture capitalist (VC) is willing to invest 100m for 20% ownership of a start-up that is looking to achieve scale. All existing shares are common shares, and this deal would result in...
-
Alanzary Co. has the following estimated 2010 information for its two departments: Production and Assembly. The production department is highly automated, and the assembly department is highly labor...
-
A 6.0 m 8.0 m 3.0 m room contains air at 20C. What is the rooms thermal energy?
-
Which of the following measures the potential amount of data that might be lost due to a system disaster? a. checkpoint c. RTO b. restoration d. RPO
-
1. Which of the two basic reporting approaches for the cash flows from operating activities did Lowes use? Is this the same as what The Home Depot used? 2. What amount of cash did Lowes receive from...
-
You have just received a windfall from an investment you made in a friend's business. She will be paying you $30,000 at the end of this year, $60,000 at the end of next year, and $90,000 at the end...
-
Perform the vertical and horizontal analysis and calculate the ratios as instructed (40 points) Fill the grey cells by using Excel formulas or cells referencing NOT hardcoding. You will not earn...
-
Given two vectors A = 3 . 8 0 i ^ + 6 . 9 0 j ^ and B = 4 . 8 0 i ^ 2 . 3 0 j ^ find the scalar product of the two vectors A and B .
-
Why is business management referred to as a profession rather than a discipline?
-
how data redundancy is handled in the relational database model?
-
Consider the following program: (Note: more about Arrays.toString on the cover page of the exam.) public class Probl ( public static void foo (int[] nums) { } nums [1] 17; nums = new int[6]; nums [2]...
-
The following figure shows a homogeneous cylinder of radius R and mass m that is free to rotate about its axis of rotation and that is connected to the wall through a spring. Assuming that the...
-
What ethical considerations arise in the implementation of stress management programs within organizational contexts, particularly concerning issues of confidentiality, privacy, and the stigma...
-
Consider the following simple assembly process: A Raw Material 3 min/unit B C 5 min/unit 2 min/unit Finished Goods The numbers below each step refer to the time necessary to process one unit of the...
-
Using the theoretical sampling strategy, how many samples of size 4 (n = 4) can be drawn from a population of size: (a) N = 5? (b) N = 8? (c) N = 16? (d) N = 50?
-
Estimate the absolute standard deviation and the coefficient of variation for the results of the following calculations. Round each result to include only significant figures the numbers in...
-
A 0.5000-g sample containing NaHCO3, Na2CO3, and H2O was dissolved and diluted to 250.0 mL. A 25.00-mL aliquot was then boiled with 50.00 mL of 0.01255 M HCl. After cooling, the excess acid in the...
-
Describe the preparation of (a) 1.00 L of 0.150 M KMnO4 from the solid reagent.
-
In which section of the balance sheet are the three inventory accounts of a manufacturing business listed?
-
How is underapplied overhead accounted for on an income statement?
-
A materials purchases journal, a cash payments journal, and a general journal for Vanyo, Inc., a manufacturer of cardboard boxes, are provided in the Working Papers. Your instructor will guide you...
Study smarter with the SolutionInn App