Excel DCF Models | Discounted Cash Flow
Free Personal Finance Calculators
Personal Finance Calculators for Everyday Life
A discounted cash flow or DCF model is a style of calculation that links streams of future money flows to lump sum amounts. Discounted cash flow models have a range of practical applications, and are commonly used by economists, accountants, actuaries, engineers, business valuators, finance professionals, and others.
For example, a company may wish to finance a project if (and only if) the Internal Rate of Return exceeds 10% per year. The anticipated development costs for the project may be large for the initial year. On the other hand, significant revenues are anticipated for Year 2 onward. The company directors rely on a DCF model to help determine whether or not the project's Internal Rate of Return exceeds their 10% threshold.
Discounted cash flow models also have applications in everyday life that are often overlooked. For example, consider automobile dealers who advertise low finance rates to prospective clients. From a car buyer's perspective, low finance rates are understood to be good, since they mean lower monthly payments. By using a DCF model, a buyer can determine the monetary value on the low finance rate offer.
Discounted cash flow models therefore allow us to make better decisions, both in business and in everyday life.
This site provides free personal finance templates based on Discounted Cash Flow principles. I encourage readers to evaluate the templates, recommend changes, and share ideas on how DCF models can lead to better decisions.
Personal Finance Calculators | Excel Templates
| Mortgage Refinancing Calculator Financial benefit from mortgage refinancing. 
|
Loan Amortization Spreadsheet Amortization schedule for any finance loan. 
|
| Vehicle Finance and Lease Comparison Costs of buying or leasing. 
|
Housing Purchase Analysis Model Renting versus owning a home. 
|
| Reverse Dutch Auction Internal return on selling a car by Reverse Dutch Auction. 
|
Business Valuation Model Net present value of Net Income stream. 
|
| Mortgage-Free Calculator Period to Achieving Mortgage-Free Status. 
|
Enjoy the free excel templates, and please contact me with any comments.
(
)
DCF-models.com respects your right to personal privacy. For details on how
personal information is collected and used, please visit our Privacy
Policy.