Please register (it's free!) or login to view the remaining preview.

If you are logged in, your referral link [?] is automatically included below.

EMBED CODE (Copy and Paste)

DOCUMENT DESCRIPTION

This is a very detailed and user-friendly financial model with 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 3 years of Historical + 5 Years of the forecast period. Valuation is based on the 5-year forecast using Discounted Cash Flow methodology.

The assumptions tab allows for the input of a huge amount of financial data for your business. These inputs cover a wide range of financial data:

1. Revenue Assumption (Sales Volume by Production type, Unit Price)
2. Costs Assumptions (Production Cost, Transportation & more)
3. Income tax
4. Working Capital Assumptions (Receivables, Payable, Inventory)
5. Capital Expenditure and Depreciation/Amortization (Tangle and In Tangible Assets)
6. Long Term and Short Term Debt
7. Share Capital (Issue of New shares, Reserve Accounts)
8. Dividend Calculation (Interim and Final Dividend along with Tax impact)
9. 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 users can use to perform cash flow valuation for Battery Manufacturing and Sales Business companies.

Got a question about the product? Email us at [email protected] or ask the author directly by using the form to the right. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Battery Manufacturing & Sales - Discounted Cash Flow (DCF) Excel document

Battery Manufacturing & Sales - Discounted Cash Flow (DCF)

Sold by Fin-Wiser Advisory (this author has 43 documents)

$99.00

ALL FEES INCLUDED

Add to Cart

This business document is categorized under the function(s):

Corporate Finance

It applies to Retail, Consumer Products, & Distribution

File Type: Excel (xlsb)

File Size: 204.1 KB

Related Topic(s): Integrated Financial Model Manufacturing

Purchase includes lifetime product updates. After your purchase, you will receive an email to download this document.

Initial upload date (first version): Aug 19, 2021
Most recent version published: Aug 23, 2021

Ask the Author a Question

Must be logged in Click here to log in

CUSTOMER TESTIMONIALS

"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 like your product. I'm frequently designing PowerPoint presentations for my company and your product has given me so many great ideas on the use of charts, layouts, tools, and frameworks. I really think the templates are a valuable asset to the job."

– Roberto Fuentes Martinez, Manager at Technology Transformation Advisory

"FlevyPro provides business frameworks from many of the global giants in management consulting that allow you to provide best in class solutions for your clients."

– David Harris, Managing Director at Futures Strategy

"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

"If you are looking for great resources to save time with your business presentations, Flevy is truly a value-added resource. Flevy has done all the work for you and we will continue to utilize Flevy as a source to extract up-to-date information and data for our virtual and onsite presentations!"

– Debbi Saffo, President at The NiKhar Group

"Flevy is now a part of my business routine. I visit Flevy at least 3 times each month.

Flevy has become my preferred learning source, because what it provides is practical, current, and useful in this era where the business world is being rewritten.

In today's environment where there are so many challenges and there is the need to make the right decisions in a short time, with so much scattered information, we are fortunate to have Flevy. Flevy investigates, selects, and puts at our disposal the best of the best to help us be successful in our work."

– Omar Hernán Montes Parra, CEO at Quantum SFE

"My FlevyPro subscription provides me with the most popular frameworks and decks in demand in today’s market. They not only augment my existing consulting and coaching offerings and delivery, but also keep me abreast of the latest trends, inspire new products and service offerings for my practice, and educate me in a fraction of the time and money of other solutions. I strongly recommend FlevyPro to any consultant serious about success."

– Bill Branson, Founder at Strategic Business Architects

"[Flevy] produces some great work that has been/continues to be of immense help not only to myself, but as I seek to provide professional services to my clients, it give me a large "tool box" of resources that are critical to provide them with the quality of service and outcomes they are expecting."

– Royston Knowles, Executive with 50+ Years of Board Level Experience

"As a niche strategic consulting firm, Flevy and FlevyPro frameworks and documents are an on-going reference to help us structure our findings and recommendations to our clients as well as improve their clarity, strength, and visual power. For us, it is an invaluable resource to increase our impact and value."

– David Coloma, Consulting Area Manager at Cynertia Consulting

"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

SELECT CUSTOMERS

Since 2012, we have provided best practices to over 5,000 businesses and organizations of all sizes across the world—in over 130 countries. Below is just a very small sample of our customer base.

Did you know?

The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.

CUSTOMERS ALSO BOUGHT THESE DOCUMENTS

Advanced Financial Model - 1- to 10-Year Business Plan Excel workbook $109.00 Author: GL Consulting Integrated Financial Model	Lean Manufacturing 177-slide PowerPoint deck and supporting ZIP $79.00 Author: Operational Excellence Consulting Lean Management/Enterprise Operational Excellence Manufacturing	Business Plan Template (Financial Model) Excel workbook $109.99 Author: Documents & Files Integrated Financial Model	GMP (Good Manufacturing Practices) Training 183-slide PowerPoint deck and supporting ZIP $59.00 Author: Vishnu Rayapeddi Manufacturing
All-Day Bar & Restaurant Financial Model Excel workbook $109.00 Author: GL Consulting Integrated Financial Model Restaurant Industry	Integrated Financial Model - Auto Generate Projected Financial Statements Excel workbook $39.00 Author: Ganesh Rajagopalan Integrated Financial Model Profit and Loss	Continuous Flow - 1 Piece Flow 86-slide PowerPoint deck and supporting ZIP $44.00 Author: Vishnu Rayapeddi Manufacturing Continuous Flow	Financial Model for Manufacturing Valuation Excel workbook $25.00 Author: investmentbanker Valuation Model Example Manufacturing
Quick Response Quality Control Problem Solving Tool 37-slide PowerPoint deck and supporting Excel workbook $99.00 Author: Youssef AIT AKKI Problem Solving Manufacturing	Site Review Checklist Excel workbook and supporting ZIP $29.00 Author: Vishnu Rayapeddi Manufacturing	Three Statement Financial Model with Scenarios Excel workbook $49.00 Author: GL Consulting Integrated Financial Model	Biogas Plant (Waste to Energy) Financial Model Excel workbook and supporting Word $140.00 Author: Fin-Wiser Advisory Integrated Financial Model Oil & Gas Energy Industry