Question
Please help with Excel and Balance sheet. I am not seeing the financial data on Edgar website for my company I chose which is IRON
Please help with Excel and Balance sheet. I am not seeing the financial data on Edgar website for my company I chose which is IRON MOUNTAIN
The instructions are below along with Excel information:
1. In week 1 please choose a publicly traded company (I CHOSE IRON MOUNTAIN) 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.
Assets
Cash & Cash Equivalent
Short-term Investments
Receivables
Inventories
Prepaid Expenses
Total Current Assets
Net Property, Plant & Equipment
Total Assets
Liabilities
Accounts payable
Current maturities of long-term debt
Income taxes payable
Total current liabilities
Long-term debt
Total Liabilities
Total stockholders' equity (deficit)
Total Liabilities & Shareholder's Equity
Income Statement
Revenue
Total revenues
Expenses
Cost of Goods Sold
General, administrative and other
Depreciation and amortization
Total expenses
Operating income
Interest expense
Income before income taxes
Income tax benefit (expense)
Net income
Dividends Paid
Non-distributed Income
Find Changes in NWC
Current Assets, other than Cash and Marketable Securities
Current Liabilities, excluding Debt
Net Working Capital (CA-CL)
Change in NWC (NWC Investment)
Find CapEx
Net Property, Plant & Equipment
Depreciation and amortization Capex
You can read more using the following link
Estimate FCF
Tax Rate
EBIT EBIT(1-T) = NOPAT
Plus: Depreciation Expense
Less: CAPEX Less: Working Capital Investment
Firm Free Cash Flow
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started