Monday, October 27, 2008

Analysis of investment projects

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.

Free Download: investment_analysis.xls

Unlocked template:

Friday, October 24, 2008

Loan repayment template

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.

Free Download: loan_repayment.xls

Unlocked template:

Thursday, October 23, 2008

Excel Economy

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.