Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Bhical financial data, find FCF for the company of your choice. 1. YOUR CHOICE OF PULIC TRADE COMPANY WILL BE IRON MOUNTAI 2. Dfinancial

image text in transcribedimage text in transcribedimage text in transcribed

Bhical financial data, find FCF for the company of your choice. 1. YOUR CHOICE OF PULIC TRADE COMPANY WILL BE IRON MOUNTAI 2. Dfinancial data fo years from Edgar Website (forma 10-8). Amation: if your ou will also have to download IPO prospect (form 42404). Template below is approximate, you may modify it (changed, or add so 3. Using approach similar to the one described in this mod's Excel you will have to call FCF the company of your If you have difficulty eating company's tax rate you may try of 35% for before 2018 For bion, Excel fig Solution Legend Formula Calestation Analy Qualitative analysis h Financial Data 15 16 Year 1 Year: Year 3 Year 4 Year 5 A Cash & Cash Equivalents 29 Short-term Investment 20 Receivabl 21 22 Prepaid Exper 23 Total Cent 24 Net Property, Plant & Equipment 25 26 Total Assets Accounts payable 29 Current maturities of long-term del 30 Income tax payable FS to FCF Template 35 Tal Long- T Torality (decit) Tarcholder's Equity Re 43 Court of Goods Sold 43 atrative and other Operating 5 55 Find Change in NWC Year: T3 Your Year Year 51 Comment Assets, other than Cash and Marke New Working Capital (CA-CL) FS to FCF Template 173 Change CWCS Find CapEx Net Property Place & Eq Dean and meat Cape Year 3 Your You can read more wing the feltering Charite Us Confie calculation of PCE. Ta EDIT ENIT(1-T)-NOPAT Depreciation Exper CAPE Les: Working Capital Investment Cal " FS to FCF Template Year Year -

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Venture capital and the finance of innovation

Authors: Andrew Metrick

2nd Edition

9781118137888, 470454709, 1118137884, 978-0470454701

More Books

Students also viewed these Finance questions