Please login here to save this document to a list.
If you don't have an account, you can register for free here.
ALL FEES INCLUDED
|Add to Cart|
This is a detailed and user-friendly financial model with the three financial statements i.e. Income Statement, Balance Sheet, and Cash Flow Statement, and detailed calculation around DCF based valuation and financial analysis.
The model captures 5 years of Historical + 5 Years of forecast period. Valuation is based on the 5-year forecast using Discounted Cash Flow methodology and Comparable Company Analysis (Relative valuation).
The Control Sheet tab allows for the inputting of various financial data for your business. These inputs cover a wide range of financial data:
1. Revenue Assumption (Capacity, Production, Sales, Unit Price)
2. Costs Assumptions (Operating Cost, Distribution & more)
3. Working Capital Assumptions (Receivables, Payable, Inventory)
5. Capital Expenditure and Depreciation/Amortization (Tangle and In Tangible Assets)
6. Debt Addition and Repayment
7. Dividend Calculation
8. Interest Income and Expense calculations
The model runs comprehensive calculations based on the inputs provided by the user generate very accurate outputs which include:
1. Income Statement: Includes Historical and Forecasted Profit and Loss statement
2. Balance Sheet: Includes Historical and Forecasted Balance sheet
3. Cash Flow Statement: Includes Historical and Forecasted cash flows
4. Valuation: DCF based valuation based on the Forecasted cash flows and discount rate assumptions
5. Valuation Ratio: A very detailed financial analysis covering:
• Price and EV based valuation ratios
• Per Share Data like EPS, DPS, FCFF per share & more
• Margin ratios
• Return ratios
• Dupont Analysis
• Gearing Ratios
• Liquidity ratios
• Coverage Ratios
• Activity Ratios
• Investment rations
• Enterprise value
This is a very detailed and user-friendly model that can be used by the user to perform cash flow valuation for companies in the mining sector.
Got a question about the product? Email us at [email protected] or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Valuation Model Example, Mining Industry Excel: Mining - Discounted Cash Flow DCF Valuation Model Excel (XLSM) Spreadsheet, Fin-Wiser Advisory
ABOUT THE AUTHOR: FIN-WISER ADVISORY
Fin-wiser is a specialist advisory boutique focused on providing financial modelling, financial analysis, business transformation and business research services.
Our mission is to deliver high-quality Financial Models, Financial Analysis, Operational Transformation and Data Analytics which are custom made as per the business requirements. [read more] These solutions can integrate elements of business, accounting, finance, economics, operations and corporate psychology to summarize particular events for the end user and provide direction regarding possible actions or alternatives.
Our Vision - Fin-Wiser is committed to become the world's leading Financial and Transformation Advisory Company with the knack of providing excellent Training and Advisory services.
Our values depict our DNA. We imbibe these values and live for them. We are passionate about making a positive impact and deliver customize solutions. We treat our client's businesses as our businesses and act like supporting partners not just outside consultants. Your aspirations are ours. Fin-Wiser works hard to understand your reality and align itself with your objectives so you know we're together in this endeavor.
Fin-wiser Advisory's core services are as follows:-
1) Financial Advisory
2) Operations Advisory
3) Data Analytics
4) Process Mapping and Documentation
Fin-Wiser Advisory has published 59 additional documents on Flevy.
This business document is categorized under the function(s): Corporate Finance Operations
It applies to Mining
File Size: 128.7 KB
Related Topic(s): Valuation Model Example Mining Industry
Purchase includes lifetime product updates. After your purchase, you will receive an email to download this document.
Initial upload date (first version): Oct 24, 2020
Most recent version published: Oct 28, 2020
|Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S Strategy Model, Balanced Scorecard, Disruptive Innovation, BCG Experience Curve, and many more. To receive this free download, enter your email address below and click the "Email Me" button.|
"As a consultant requiring up to date and professional material that will be of value and use to my clients, I find Flevy a very reliable resource.
The variety and quality of material available through Flevy offers a very useful and commanding source for information. Using Flevy saves me time, enhances my expertise and ends up being a good decision."
– Dennis Gershowitz, Principal at DG Associates
"As a young consulting firm, requests for input from clients vary and it's sometimes impossible to provide expert solutions across a broad spectrum of requirements. That was before I discovered Flevy.com.
Through subscription to this invaluable site of a plethora of topics that are key and crucial to consulting, I have been able to exceed expectations and deliver quality advice and solutions to my clients. The quality and expertise of the authors are exemplary and gives me great confidence to use as part of my service offerings.
I highly recommend this company for any consultant wanting to apply international best practice standards in their service offerings. "
– Nishi Singh, Strategist and MD at NSP Consultants
"I have used FlevyPro for several business applications. It is a great complement to working with expensive consultants. The quality and effectiveness of the tools are of the highest standards."
– Moritz Bernhoerster, Global Sourcing Director at Fortune 500
"I have found Flevy to be an amazing resource and library of useful presentations for lean sigma, change management and so many other topics. This has reduced the time I need to spend on preparing for my performance consultation. The library is easily accessible and updates are regularly provided. A wealth of great information."
– Cynthia Howard RN, PhD, Executive Coach at Ei Leadership
"One of the great discoveries that I have made for my business is the Flevy library of training materials.
As a Lean Transformation Expert, I am always making presentations to clients on a variety of topics: Training, Transformation, Total Productive Maintenance, Culture, Coaching, Tools, Leadership Behavior, etc. Flevy usually has just what I need to make my point.
It is well worth the money to purchase these presentations. Sure, I have the knowledge and information to make my point. It is another thing to create a presentation that captures what I want to say. Flevy has saved me countless hours of preparation time that is much better spent with implementation that will actually save money for my clients."
– Ed Kemmerling, Senior Lean Transformation Expert at PMG
"Flevy is our 'go to' resource for management material, at an affordable cost. The Flevy library is comprehensive and the content deep, and typically provides a great foundation for us to further develop and tailor our own service offer."
– Chris McCann, Founder at Resilient.World
"As a consulting firm, we had been creating subject matter training materials for our people and found the excellent materials on Flevy, which saved us 100's of hours of re-creating what already exists on the Flevy materials we purchased."
– Michael Evans, Managing Director at Newport LLC
"I have used Flevy services for a number of years and have never, ever been disappointed. As a matter of fact, David and his team continue, time after time, to impress me with their willingness to assist and in the real sense of the word. I have concluded in fact that it is not at all just a repository of documents/resources but, in the way that David and his team manage the firm, it is like dealing with consultants always ready to assist, advise and direct you to what you really need, and they always get it right.
I am an international hospitality accomplished senior executive who has worked and lived during the past 35 years in 23 countries in 5 continents and I can humbly say that I know what customer service is, trust me.
Aside from the great and professional service that Flevy's team provide, their wide variety of material is of utmost great quality, professionally put together and most current.
Well done Flevy, keep up the great work and I look forward to continue working with you in the future and to recommend you to a variety of colleagues around the world."
– Roberto Pelliccia, Senior Executive in International Hospitality
Do You Want to Get Lean?We've assembled 40 Lean Six Sigma guides: Lean Management, Six Sigma, Strategy Planning, Process, and Change Management.
Waste Too Much Time on PowerPoint?Get our FREE PowerPoint Plugin (Flevy Tools) for creating common business diagrams, from Gantt Charts to Harvey Balls.
Do You Run a Consulting Firm?Learn how to level the playing field with global consulting firms, like McKinsey, BCG, Bain, E&Y, and Accenture.
Need Help with PowerPoint or Excel?Have our highly trained staff create the exact documents you need. We offer PowerPoint and Excel document creation services.
FlevyPro (Subscription Service)
Flevy Executive Learning (FEL)
LinkedIn Influencer Marketing
Contact / FAQ / Terms / Privacy
flevyblog (Business Magazine)
Strategy, Marketing, & Sales
Organization, Change, & HR
Health & Safety
Governance, Risk, & Compliance
Customer-centric Design (CCD)
Human Resource Management
Blue Ocean Strategy
COVID-19 Trend Data
Consulting Training Guides
Organizational Culture (OC)
Organizational Design (OD)
Organizational Leadership (OL)
Financial Advising Services (FAS)
Flevy Tools (PowerPoint Plugin)
Lean Six Sigma Training Guides
Post-merger Integration (PMI)
Supply Chain Management (SCM)
Small Business Owner
© 2012-2023 Copyright. Flevy LLC. All Rights Reserved.