Saturday, June 4, 2011

Mod () function in Excel to "implement escalation" [financial modeling tutorial]

Posted on 24 May 2011 in financial modeling, learning to Excel-9 comments

Take the apartment for rent $ 1000 per month and puts the owner provided escalation increased 10% in every 3 years. How you can model this in excel? In this tutorial and see how that escalation in certain frequency using the mod function is implemented in excel.

Function calculates the lip, the Ministry of defence in the Division. For example,


Simple function, it calculates the remainder, but can check some of extremely complex tasks.

We want to create a form where user can change the frequency of escalation, for example, if you are able to negotiate escalate every 4 years, should be flexible enough to incorporate that sample.


First of all we create the search, if the year escalation. We use here the function mod (). For example, if the requirement of three years, then stepped up to take the Ministry of Defence No. 3 year. If the remainder is zero, it means increasing year (I know it can be confusing ... So my suggestion-playing with the mod function ()).


Once the escalation, we total up the escalation and find even one year total escalation.


Then we simply take the basic numbers, and the number of escalations at this point in time.


I have no doubt in my mind that a strong (and confusion). And confusion due to the nonlinear nature of the post (sometimes gives rise to consequences and results sometimes reduced)!.

If you plan to implement anything attribute for example, you want to color every fifth row of your excel, or you need to specify every day of the week, or anything like that, could be the function mod () function is very easy!

I know that the easiest way to do copy paste values in your form and update it manually. Easy to understand, but at the same time is not flexible. How implemented this functionality in your forms?

I have created a template for you, so give your subheadings and to bind the form to obtain cash numbers! You can download the same. from here you can go through and fill the yellow boxes. It also recommended trying to create this structure yourself (so you can get the hang of what information is logged).

Also you can download this template filled and check, if the information that you recorded, match mine or not!

For any queries regarding the impact of monetary or financial modelling, feel free to put comments in the blog or write an email to [email protected]

Modeling financial one repeated uses Excel. Please go through the below articles for more information,


This article is written in the Pristina madrasa has. The author can be contacted at [email protected].
Awesome try training institution pristine CFA, Olli, etc. They train people in HSBC, etc. of the Board of Auditors. Is partnering with the Pristina madrasa has to bring a training program on the Internet you excel financial modeling

Spread some love
It makes you fabulous!

& Navigation functions

Tags: downloads, finance, financial modeling, financial modelling school, Excel, Microsoft Excel formulas, MOD (), modeling, pristine, screencasts

RSS feed for comments on this post. TrackBack URI

View the original article here

No comments: