Sunday, November 16, 2008

Interest-only loan

Making an investment, because of delay of income, we should apply for an interest-only loan.
This way, during a short period we pay only the interests while our business begin to look starts running.
Also can be used with personal situations, such as building a house.
This template, from the amount, interest periods and rate, calculates the payments for the interest-only period and the amortization period, and the loan table.

Free Download: interest-only_loan.xls

Unlocked template:

Tuesday, November 11, 2008

Business viability analysis

Before starting a business, such as a shop or similar, there should be a preliminary sudy of financial viability.
This Excel template that can be used to get
the income report and the financial situation of the company at the year-end, filling out the investmen, incomes and expenditures, and operating margin.
The aim is to provide a first sight of the threshold of the profitability and financial results, to choose between several alternative enterprises or different situations for only one.

Free Download: business_viability.xls

Unlocked template:

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.