skip to main |
skip to sidebar
Excel template for analyzing and comparing several investment projects, using dynamic methods: NPV (Net Present Value) and IRR (Internal Rate of Return).
From the data: initial outlay, net cash flow, discount rate and inflation (for NPV), gives the results to choose the select the most profitable project.
This template allows drawing up loan tables after filling out the loan amount, term in years, eh fee, interest rate, payment period (annual, semi-annual, quarterly or monthly) and the amortization method (French, constant shares, or American).
The model is useful for calculating business loans, mortgages or personal loans, etc.
A new blog is born, with objective of publishing Excel models and templates, applied to economic and business analysis, made in a simple, practical way.
They will help you about several subjects like: loan estimation, leasing operations, business valuation, elasticity estimations, balance analysis, sales forecasts, feasibility studies, etc.
The author allows free distribution of the models, while maintaining its integrity and quoting this site.
