| | Amazon.com Valuation & Terminal Value |
| | Given | | | | | | | Solution Legend |
| | Gross Margin | 40% | | | | | | Value given in problem |
| | Fixed Costs | $ 2,000 | | | | | | Formula/Calculation/Analysis required |
| | Revenue Growth Rate for Years 1 - 5 | 10% | | | | | | Crystal Ball Input |
| | FCF Steady Growth | 3% | | | | | | Crystal Ball Output |
| | Discount Rate | 12% |
| | Year 1 Revenue | $ 5,000 |
| | Tax Rate | 35% |
| | Terminal Year | 5 |
| | |
|
| | | | 1 | 2 | 3 | 4 | 5 |
| | Revenues |
| | Gross profits |
| | Fixed Costs |
| | Net Operating Income |
| | Taxes |
| | Free Cash Flow |
| | NPV for Years 1-5 Cash Flows |
| | Terminal Value (as of Year 5) |
| | PV of Terminal Value |
| | Enterprise Value |
| | PV of Terminal Value / Enterprise Value |
| This Assignment uses Amazon.com and here are the instructions: |
| 1. Choose peer companies for your company and download their relevant financial data. You don't have to download entire financial statements — only the items used in multiples valuation |
| 2. Using approach similar to the one described in this module's Excel file, find valuation multiples (ratios) of peer companies. |
| 3. Estimate your company's equity value and enterprise value |
| I suggest starting from the "Multiples Valuation Template" in Module 4 Excel file and adjust it accordingly |
skasikge
Module4-TVHomeworkTemplate.xlsx
