Based on historical financial data, find FCF for Iron Mountain

1. In week 1 please choose a publicly traded company and submit its name for instructor's approval. Please do not choose a company which became public less than 3 years ago. It is also a good idea to choose a company that is already paying dividends on regular basis. Finally, please avoid financial service companies (banks etc.), because they have very specific structure.

2. Download annual financial data for the last 5 years from Edgar Website (forms 10-K). Attention: if your company became public less than 5 years ago, you will also have to download data from its IPO filing prospectus (form 424B4). Excel file template is approximate, you may modify it (change, delete, or add rows) to suit your company's statements.

3. Using approach similar to the one described in this module's Excel file you will have to calculate the FCF for the company of your choice. I suggest starting from the FS to FCF Practice Template and adjust it accordingly

If you have difficulty estimating company's tax rate you may assume statutory tax rate of 35% for years before 2018 and 21% thereafter.

For submission, Excel file is attached. Please provide excel formulas, etc.

Bensalida, FCF for the c Is ek low ed to charity ouche company and what is same for instructor's Dodatne w company ha s the power to download data from inte us ) Temple how is app you may editing, der add p Using up och similar to the one described in this module Excel file you will have to calculate the YCF for the company of your choice If you have any coming o u t of the years before Financial Data Cash Cashou valents Net Property. Plant & Louie Curre m olle dhe Tocal communities T h olders uit de Total Late & Shareholder's uity Income Statement Comfoods Sold General ministrative and other nestene Income taxe Dividends Pald Ne- a ted Income Find Changes in NWC Current Another than Chand Marketable Current Liabilities excluding the Net Working Capital (ACL) Change in NWC IWC Investment Find Captis t Net Property. Plant & Lo Depreciation and You can read more in the following link How Estimate FCF ERIT EBITIT-NOPAT Less Working Capital Trem Firma Free Cash Flow Bensalida, FCF for the c Is ek low ed to charity ouche company and what is same for instructor's Dodatne w company ha s the power to download data from inte us ) Temple how is app you may editing, der add p Using up och similar to the one described in this module Excel file you will have to calculate the YCF for the company of your choice If you have any coming o u t of the years before Financial Data Cash Cashou valents Net Property. Plant & Louie Curre m olle dhe Tocal communities T h olders uit de Total Late & Shareholder's uity Income Statement Comfoods Sold General ministrative and other nestene Income taxe Dividends Pald Ne- a ted Income Find Changes in NWC Current Another than Chand Marketable Current Liabilities excluding the Net Working Capital (ACL) Change in NWC IWC Investment Find Captis t Net Property. Plant & Lo Depreciation and You can read more in the following link How Estimate FCF ERIT EBITIT-NOPAT Less Working Capital Trem Firma Free Cash Flow