Monday, September 27, 2010

Analysis of two economic variables

This model is useful to study the relationships between two variables (explanatory and explained), for example: amount depending on the price, sales in terms of advertising, production as a function of the number of hours worked; demand-price and demand-rent, ...
Once you have chosen the functional relationship with the best fit (linear, potential, exponential, logarithmic or parabolic) , this template can be used for simulations and future estimations.

Free Download: analysis_two_variables.xls

Unlocked template:

Thursday, September 16, 2010

Economic trends forecast

This Excel template predicts trends, creating a mathematical function of time by simple regression techniques. In other words, trying to explain a dependent variable (also called endogenous) according to the dependent variable time (exogenous or explanatory). After entering data we can see the graph and trends calculated, choosing the model with a greater degree of fit (coefficient of determination higher). The selected function can be used to make predictions of the variable under study (y), assigning values in function to the time variable (x). It can also be seen in the graph, where there is the trend by adding more data of time (years, months, ...) in the DATE column. The estimation is useful for time series forecasting (economic or otherwise) when all you know is the data series over time.
Free Download: economic_trends_forecast.xls

Unlocked template:

Tuesday, May 4, 2010

Brown's double exponential smoothing prediction

Exponential smoothing is obtained by a moving average with weights declining in geometric progression. Brown's double exponential smoothing, includes a trend component which is useful for forecasting series with or without trend but no seasonality. To achieve optimal prediction we need an ALFA coefficient that minimizes squared error, which is achieved by trying different values between zero and one in the following Excel model.
This technique is used to forecast economic series such as: sales, revenues, costs, expenses, production, wages, economic indicators...

Free Download: browns_double.xls

Unlocked template:

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.