tag:blogger.com,1999:blog-75125417296118676972024-03-06T21:01:48.654+01:00Excel EconomyExcel templates for economic and business analysis<br>
Official translation of the original blog "Economia Excel"Unknownnoreply@blogger.comBlogger8125tag:blogger.com,1999:blog-7512541729611867697.post-83650320422443868162010-09-27T06:56:00.018+02:002010-10-01T12:06:34.376+02:00Analysis of two economic variables<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMQ5-l9ZvEmqGn0hMZbmGc5DrzzUcWBXz9ZJpqqMImkXX9DCZSmzHA8T3rxoiC6pWof0ZaezFuzRDDkJ_4si8uAMjIh8EEt1O_DZ6eYAg4SwdtW7YwLjN67QNwLwYBY35kS_nQr18r8Tg/s1600/08analysis_two_variables.jpg"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 320px; height: 200px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMQ5-l9ZvEmqGn0hMZbmGc5DrzzUcWBXz9ZJpqqMImkXX9DCZSmzHA8T3rxoiC6pWof0ZaezFuzRDDkJ_4si8uAMjIh8EEt1O_DZ6eYAg4SwdtW7YwLjN67QNwLwYBY35kS_nQr18r8Tg/s320/08analysis_two_variables.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5521461627789433586" /></a><br /><span title="" style="background-color: rgb(255, 255, 255); "><span class="Apple-style-span" style="font-family:georgia;"><span class="Apple-style-span" style="font-size:small;">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; </span></span></span><span title="" style="background-color: rgb(255, 255, 255); "><span class="Apple-style-span" style="font-family:georgia;"><span class="Apple-style-span" style="font-size:small;">demand-price and demand-rent, ...<br /></span></span></span><span title="" style="background-color: rgb(255, 255, 255); "><span class="Apple-style-span" style="font-family:georgia;"><span class="Apple-style-span" style="font-size:small;">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.</span></span></span><div><br /></div><div><br /></div><div><span title="" style="background-color: rgb(255, 255, 255); "><span class="Apple-style-span" style="font-size:small;"></span></span><br /><div style="text-align: center;"><span class="Apple-style-span" style="font-family:georgia;"></span><span class="Apple-style-span" style="font-size:small;">Free Download</span><span class="Apple-style-span" style="font-size:small;">:</span><span class="Apple-style-span" style="font-size:small;"> <a href="http://dstats.net/download/http://econometra.es/en/analysis_two_variables.xls"><b><span class="Apple-style-span" style="font-size:x-large;"><span class="Apple-style-span" > analysis_two_variables.xls</span></span></b></a><br /><script type="text/javascript" src="http://dstats.net/dstatsjs.php?file=http://econometra.es/en/analysis_two_variables.xls"></script> <script type="text/javascript">document.write(dsdlcounter(dsCounter+" downloads"));</script><br />Unlocked template: <a href="mailto:exceleconomy@gmail.com?subject=EE07">exceleconomy@gmail.com</a><br /><br /><br /></span></div></div>Unknownnoreply@blogger.com10tag:blogger.com,1999:blog-7512541729611867697.post-63269593642963468282010-09-16T18:00:00.026+02:002010-10-01T12:07:49.710+02:00Economic trends forecast<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhk_IbtdZgnlY6k6jhMi5GRys_1cZLFWbu51JUHIV0iAddSw1CnkR9CNPoA6W4D-ZuhCXJaqXbhBO8wyYQ89Us88UShEaVyMc29Du-nri5YL4jOnnrZSuxbCkI6yX74N20E_RY9UNuua7E/s1600/07economic_trends_forecast.jpg"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 200px; height: 125px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhk_IbtdZgnlY6k6jhMi5GRys_1cZLFWbu51JUHIV0iAddSw1CnkR9CNPoA6W4D-ZuhCXJaqXbhBO8wyYQ89Us88UShEaVyMc29Du-nri5YL4jOnnrZSuxbCkI6yX74N20E_RY9UNuua7E/s200/07economic_trends_forecast.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5517554443908019474" /></a><br /><span class="Apple-style-span" style="font-family:georgia;"><span class="Apple-style-span" style="font-size:small;">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.</span></span><div style="text-align: center;"><span class="Apple-style-span" style="font-size:small;">Free Download</span><span class="Apple-style-span" style="font-size:small;">:</span><span class="Apple-style-span" style="font-size:small;"> <a href="http://dstats.net/download/http://econometra.es/en/economic_trends_forecast.xls"><b><span class="Apple-style-span" style="font-size:x-large;"> economic_trends_forecast.xls</span></b></a><br /><script type="text/javascript" src="http://dstats.net/dstatsjs.php?file=http://econometra.es/en/economic_trends_forecast.xls">+" "+ </script><script type="text/javascript">document.write(dsdlcounter(dsCounter+" downloads"));</script><br />Unlocked template: <a href="mailto:exceleconomy@gmail.com?subject=EE06">exceleconomy@gmail.com</a><br /><br /></span></div>Unknownnoreply@blogger.com3tag:blogger.com,1999:blog-7512541729611867697.post-32675965933517990122010-05-04T01:35:00.027+02:002010-10-01T12:08:07.042+02:00Brown's double exponential smoothing prediction<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxpg_mIh84Nqb4QSQG49nrYO-Vc_2xY4bRh7aBXubOcmbtM6i-7o6GIIGRM6vorxyf4zFJzoHt8_jn8TanYXGfzrjqegEV02NLp-muE05fHHoozO2vKqcqHiQHw2mUags9w51ZYiH57OA/s1600/06Browns_double_exponential.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 200px; height: 157px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxpg_mIh84Nqb4QSQG49nrYO-Vc_2xY4bRh7aBXubOcmbtM6i-7o6GIIGRM6vorxyf4zFJzoHt8_jn8TanYXGfzrjqegEV02NLp-muE05fHHoozO2vKqcqHiQHw2mUags9w51ZYiH57OA/s200/06Browns_double_exponential.JPG" border="0" alt="" id="BLOGGER_PHOTO_ID_5517537526514198914" /></a><br /><span class="Apple-style-span" style="font-family:Georgia, Times, serif;"><span class="Apple-style-span" style="font-family:georgia;"><span class="Apple-style-span" style="font-family:Georgia, serif;"><span class="Apple-style-span" style="font-family:georgia;"><span class="Apple-style-span" style="font-size:small;">Exponential smoothing is obtained by a moving average with weights declining in geometric progression. Brown's </span></span><span class="Apple-style-span" style="font-family:georgia;"><span class="Apple-style-span" style="font-size:small;">double exponential smoothing, includes a trend component which is useful for forecasting series with or without trend but no seasonality. </span></span><span onmouseover="_tipon(this)" onmouseout="_tipoff()"><span class="Apple-style-span" style="font-family:georgia;"><span class="Apple-style-span" style="font-size:small;">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.<br /></span></span></span></span><span class="Apple-style-span" style="font-size:small;">This technique is used to forecast economic series such as: sales, revenues, costs, expenses, production, wages, economic indicators...</span></span></span><div style="text-align: center;"><span class="Apple-style-span" style="font-family:georgia, Times, serif;"><br /></span></div><div style="text-align: center;"><span class="Apple-style-span" style=" ;font-family:Georgia, Times, serif;"><span class="Apple-style-span" style="font-family:georgia;"><span class="Apple-style-span" style="font-size:small;">Free Download</span></span><span class="Apple-style-span" style="font-size:small;">:</span><a href="http://dstats.net/download/http://econometra.es/en/browns_double.xls"> <b><span class="Apple-style-span" style="font-size:x-large;">browns_double.xl</span></b><span class="Apple-style-span" style="font-size:x-large;">s</span></a><br /><script type="text/javascript" src="http://dstats.net/dstatsjs.php?file=http://econometra.es/en/browns_double.xls">+" "+ </script><script type="text/javascript">document.write(dsdlcounter(" "+dsCounter+" downloads "));</script><br />Unlocked template: <a href="mailto:exceleconomy@gmail.com?subject=EE05">exceleconomy@gmail.com</a><br /></span></div>Unknownnoreply@blogger.com4tag:blogger.com,1999:blog-7512541729611867697.post-14165899108933969292008-11-16T14:52:00.021+01:002010-10-01T12:08:28.842+02:00Interest-only loan<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_ZhS-F_g4CvfQbN22ajXNoINgJHo8mN-3UzrQLvZQU-1pu3oKAn0cNcJxGpHDmo2fxiBqsGqxUPdpNyBPfH8hHnLVKdePwzRbRfoxgLcJPc_S38k-WMLDvkS-HkT7dOGpo3hKPAhK1Ao/s1600/05interest-only_loan.jpg"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 297px; height: 320px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_ZhS-F_g4CvfQbN22ajXNoINgJHo8mN-3UzrQLvZQU-1pu3oKAn0cNcJxGpHDmo2fxiBqsGqxUPdpNyBPfH8hHnLVKdePwzRbRfoxgLcJPc_S38k-WMLDvkS-HkT7dOGpo3hKPAhK1Ao/s320/05interest-only_loan.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5518912215779050114" /></a><br /><span><span class="Apple-style-span" style="font-size: small;">Making an investment, because of delay of income, we should apply for an interest-only loan.<br />This way, during a short period we pay only the interests while our business begin to look starts running.<br />Also can be used with personal situations, such as building a house.<br />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.</span></span><div><span><span class="Apple-style-span" style="font-size: small;"><br /></span></span><div style="text-align: center;"><span><span class="Apple-style-span" style="font-size: small;">Free Download</span></span><span style="font-size:100%;">: <a href="http://dstats.net/download/http://econometra.es/en/interest-only_loan.xls"><span class="Apple-style-span" style="font-size:x-large;"><b> interest-only_loan.xls</b></span></a><br /><script type="text/javascript" src="http://dstats.net/dstatsjs.php?file=http://econometra.es/en/interest-only_loan.xls">+" "+ </script><script type="text/javascript">document.write(dsdlcounter(dsCounter+" downloads"));</script></span><br />Unlocked template: <a href="mailto:exceleconomy@gmail.com?subject=EE04">exceleconomy@gmail.com</a><br /><br /></div></div>Unknownnoreply@blogger.com3tag:blogger.com,1999:blog-7512541729611867697.post-37676601251527199812008-11-11T23:00:00.023+01:002010-10-01T12:08:45.009+02:00Business viability analysis<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIsygMBtWRuz08N-M34iLWTb6RKk4eztOBwmPwZkCxpqa65qu3LqFXRy1iiaeDN4VTNSL6yA4zamt1AtZoutE7bYP_xfFlIcmmm5n6OgUf7QOX9RLeQkaKL8GtCmAZAUTbT3fgkGMzqLQ/s1600/04business+viability.jpg"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 313px; height: 320px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIsygMBtWRuz08N-M34iLWTb6RKk4eztOBwmPwZkCxpqa65qu3LqFXRy1iiaeDN4VTNSL6yA4zamt1AtZoutE7bYP_xfFlIcmmm5n6OgUf7QOX9RLeQkaKL8GtCmAZAUTbT3fgkGMzqLQ/s320/04business+viability.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5518912443178931986" /></a><br /><span><span class="Apple-style-span" style="font-size: small;">Before starting a business, such as a shop or similar, there should be a preliminary sudy of financial viability.<br />This Excel template that can be used to get </span></span><span><span class="Apple-style-span" style="font-size: small;">the income report and the financial situation of the company at the year-end</span></span><span><span class="Apple-style-span" style="font-size: small;">, filling out the investmen, incomes and expenditures, and operating margin.<br />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.</span></span><div><span><span class="Apple-style-span" style="font-size: small;"><br /></span></span><div style="text-align: center;"><span><span class="Apple-style-span" style="font-size: small;">Free Download:</span></span><span style="font-size:100%;"> <a href="http://dstats.net/download/http://econometra.es/en/business_viability.xls"><span class="Apple-style-span" style="font-size:x-large;"><b> business_viability.xls</b></span></a><br /><script type="text/javascript" src="http://dstats.net/dstatsjs.php?file=http://econometra.es/en/business_viability.xls">+ </script><script type="text/javascript">document.write(dsdlcounter(dsCounter+" downloads"));</script></span><br />Unlocked template: <a href="mailto:exceleconomy@gmail.com?subject=EE03">exceleconomy@gmail.com</a><br /><br /></div></div>Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-7512541729611867697.post-28326663814737815812008-10-27T01:35:00.018+01:002010-10-01T12:09:01.576+02:00Analysis of investment projects<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgX-R1dms03L_O62_WgiuxQrZga9FXeUHiKvlsDDwkMTNA9Ps96g5Sqz6_AXCrKp6T6PhqzvfesX-9AZemn3vveQV-H9Y1w2FUm42r84J-dFJ16tuWuQdxCwWIeJReEBKgrdtkR64n5beE/s1600/03investment_analysis.jpg"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 320px; height: 310px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgX-R1dms03L_O62_WgiuxQrZga9FXeUHiKvlsDDwkMTNA9Ps96g5Sqz6_AXCrKp6T6PhqzvfesX-9AZemn3vveQV-H9Y1w2FUm42r84J-dFJ16tuWuQdxCwWIeJReEBKgrdtkR64n5beE/s320/03investment_analysis.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5518912613316250066" /></a><br /><span class="Apple-style-span" style="font-size: small;">Excel template for analyzing and comparing several investment projects, using dynamic methods: NPV (Net Present Value) and IRR (Internal Rate of Return).<br />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.</span><div><span class="Apple-style-span" style="font-size: small;"><br /></span><div style="text-align: center;"><span class="Apple-style-span" style="font-size: small;">Free Download:</span> <a href="http://dstats.net/download/http://econometra.es/en/investment_analysis.xls"><span class="Apple-style-span" style="font-size:x-large;"><b> investment_analysis.xls</b></span></a><br /><script type="text/javascript" src="http://dstats.net/dstatsjs.php?file=http://econometra.es/en/investment_analysis.xls">+</script><script type="text/javascript">document.write(dsdlcounter(dsCounter+" downloads"));</script><br />Unlocked template: <a href="mailto:exceleconomy@gmail.com?subject=EE02">exceleconomy@gmail.com</a><br /></div></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7512541729611867697.post-47339021144576616782008-10-24T15:31:00.025+02:002010-10-01T12:09:47.703+02:00Loan repayment template<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjedFqgqJ906J302U1KzsP1myK626xfR6ijh_5g3wh_p4foass3j_XlP64_6abPBgFTuVjkILu5vyqdBpaAT8ohQvtgzlwjpZFGwOrPOOlc6n3Yj2CaWe88MX1DhM7wl4raucmriYiWAkY/s1600/02Loan_repayment.jpg"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 144px; height: 200px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjedFqgqJ906J302U1KzsP1myK626xfR6ijh_5g3wh_p4foass3j_XlP64_6abPBgFTuVjkILu5vyqdBpaAT8ohQvtgzlwjpZFGwOrPOOlc6n3Yj2CaWe88MX1DhM7wl4raucmriYiWAkY/s200/02Loan_repayment.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5518912771492752594" /></a><br /><span class="Apple-style-span" style="font-size: small;">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).<br />The model is useful for calculating business loans, mortgages or personal loans, etc.</span><div><span class="Apple-style-span" style="font-size: small;"><br /></span></div><div><span class="Apple-style-span" style="font-size: small;"><br /></span><div style="text-align: center;"><span class="Apple-style-span" style="font-size: small;">Free Download:</span> <a href="http://dstats.net/download/http://econometra.es/en/Loan_repayment.xls"><span class="Apple-style-span" style="font-size:x-large;"><b><span class="Apple-style-span" > loan_repayment.xls</span></b></span></a><br /><script type="text/javascript" src="http://dstats.net/dstatsjs.php?file=http://econometra.es/en/Loan_repayment.xls">+</script><script type="text/javascript">document.write(dsdlcounter(dsCounter+" downloads"));</script><br />Unlocked template: <a href="mailto:exceleconomy@gmail.com?subject=EE01">exceleconomy@gmail.com</a><br /><br /></div></div>Unknownnoreply@blogger.com5tag:blogger.com,1999:blog-7512541729611867697.post-87970678646679168402008-10-23T22:41:00.010+02:002010-10-01T02:20:30.110+02:00Excel Economy<span><span class="Apple-style-span" style="font-size: small;">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.<br />They will help you about several subjects like: loan estimation, leasing operations, business valuation, elasticity estimations, balance analysis, sales forecasts, feasibility studies, etc.<br />The author allows free distribution of the models, while maintaining its integrity and quoting this site.</span></span>Unknownnoreply@blogger.com0