Ddded vfv - scdc wcew wecwefewd ewc34r4 45346 rtgtr PDF

Title	Ddded vfv - scdc wcew wecwefewd ewc34r4 45346 rtgtr
Author	kewen LaLAA
Course	Esl Placement
Institution	Kean University
Pages	1
File Size	97.4 KB
File Type	PDF
Total Downloads	34
Total Views	152

Preview

CLICK TO PREVIEW PDF

Summary

scdc wcew wecwefewd ewc34r4 45346 rtgtr...

Description

Click File > Make a copy.. to start using this spreadsheet Ticker

AAPL Company info Name Sector Market Cap (mil) Latest quarter column index Inputs Cash And Cash Equivalents Total debt Free cash flow (mil $) Shares outstanding (mil) Growth rate Margin of Safety Conservative growth rate Growth decline rate Discount rate Valuation last FCF

Intrinsic Value Analyze US listed companies by filling in their ticker symbol on the left

$237

Apple Inc. Technology $1.003.035

18 $39.771 $251.087 $63.970 $4.375 11,91% 25,00% 8,93% 5,00% 9,00% 12

Calculations Year FCF * Growth rate NPV FCF 1 $69.684,12 $63.930,39 2 $75.597,43 $63.628,84 3 $81.691,78 $63.081,04 4 $87.948,14 $62.304,68 5 $94.346,88 $61.319,00 6 $100.867,94 $60.144,26 7 $107.491,14 $58.801,34 8 $114.196,33 $57.311,29 9 $120.963,61 $55.695,01 10 $127.773,50 $53.972,91 Total NPV FCF Year 10 FCF value Cash on Hand Total Debt Company value:

$600.188,74 $647.674,88 $39.771,00 $251.087,00 $1.036.547,62...

Similar Free PDFs

Ddded vfv - scdc wcew wecwefewd ewc34r4 45346 rtgtr

1 Pages