Originally published: 11/12/2017 13:46
Publication number: ELQ-23474-1
View all versions & Certificate
Publication number: ELQ-23474-1
View all versions & Certificate
Quarterly DCF (Discounted Cash Flow) Discounting Formula Excel Model
Illustration of annual vs. quarterly DCF and discounting properly using the '=NPV' function in one cell
by Wall Street TrainingThe Leading Provider of Training and Advisory Services
Wall Street Training offers you this business tool for free!
download for free
Add to bookmarks
Reviews
People using this tool also downloaded
Quick valuation: Net present value (NPV) Calculator
A calculator for a quick net present value (NPV) calculation for valuing a business232 remove_red_eyeDiscuss$15.00by ModellingGuyDiscounted Cash Flow (DCF) Analysis with IRR and NPV
Several spreadsheets that can be used for the analysis of a real estate investment from various perspectives11,804 remove_red_eye2 chat_bubbleDiscounted Cash Flow Analysis
This pdf contains all you need to know when calculating a company's value by using the DCF method.32 remove_red_eyeDiscussSensitivity Analysis Using Excel
In this video you will learn how to carry out sensitivity analysis using Excel.635 remove_red_eyeDiscussfreeby Finance WalkWACC (Weighted Average Cost of Capital) Excel Calculator
WACC calculation template to help the user think about all of the components of their WACC calculation150 remove_red_eyeDiscuss$15.00by ModellingGuyDiscount Cash Flow Template in Excel
This is a discounted cash flow (DCF) template with income statement, balance sheet, FCF calculation & FV calculation.120 remove_red_eyeDiscussfreeby Andrew HanDCF Model with Bear and Bull Scenarios in Excel
A DCF model built for public equity valuations, with a bull and bear scenario analysis to evaluate upside/downside risk1,069 remove_red_eyeDiscuss$20.00by Colin FerrianBusiness Valuation Excel Model with Economic Value Added
Business and investment valuation model with economic value added (EVA) calculations.1,002 remove_red_eyeDiscussDiscounted Cash Flow (DCF) Model
A step by step Discounted Cash Flow Analysis Tutorial (DCF model)28,121 remove_red_eye23 chat_bubbleDCF (Discounted Cash Flow) Excel Monte Carlo Simulation Model
A simplified DCF (Discounted Cash Flow) Monte Carlo Simulation model in Excel451 remove_red_eyeDiscussfreeby Hans Ensing
More tools from Wall Street Training
Weighted Average Cost of Capital (WACC) Cheat Sheet
This PDF file contains all you need to know about WACC including formulas and descriptions167 remove_red_eyeDiscussCash Flow Metrics Comparison Cheat Sheet
This comparison chart includes the common cash flow metrics and how to use them.54 remove_red_eyeDiscussPayback Period Example Model
Calculation of discounted and undiscounted payback period (both intuitive and with arrays)48 remove_red_eyeDiscussDCF (Discounted Cash Flow) Stub Period Discounting Excel Model
Illustration of how to discount full year and stub periods for DCF analyses417 remove_red_eyeDiscussCorporate Valuation Methodologies
Summary of valuation methodologies, including overview discussion of trading comps, deal comps, DCF and LBO analysis.21 remove_red_eyeDiscussCover Letter Tips
A comprehensive guide on how to write a good cover letter that will attract the attention of your future employers.19 remove_red_eyeDiscussResume Tips
Tips on how to write an effective resume, as well as how to develop, design and structure it.14 remove_red_eyeDiscussInterviewing Tips for Interviewees
Tips on how to prepare and conduct yourself before, during and after an interview as well as sample questions.13 remove_red_eyeDiscuss
Any questions on Quarterly DCF (Discounted Cash Flow) Discounting Formula Excel Model?
The user community and author are here to help. Go ahead!
