Skip to main content

Microsoft Excel -- Quick Reckoner for Financial Calculations

Microsoft Excel -- Quick Reckoner for Financial Calculations

Most of us would have encountered piquant situations while planning to avail personal loans from financial institutions. While the bank gives a full details of the loan, the amortization schedules etc, it would be better that we also have hand-calculate and cross verify the details. The calculation process is not simple and particularly assumes mammoth complexities in the case of long term loans.

Fortunately, there is a simple but generic tool that lies very much within Microsoft Excel to help ease out this situation and greatly help us.

  1. Amotization Schedule
    1. Launch Microsoft Excel.
    2. Right click on the bottom tab 'Sheet 1'.
    3. Click on the tab 'Spreadsheet Solutions'.
    4. You can now select 'Amortization Schedule'.
    5. Fill out the steps and Microsoft Excel would calculate the rest.
  2. Principal Component in EMI
    1. Launch Microsoft Excel and from Insert -> Function, choose the category 'Financial'
    2. Choose 'PPMT' as the function name.
    3. Fill out the fields.
    4. Instead of PPMT, if you can choose IPMT, you can get the Interest component of the loan.

I hope this would be of tremendous significance to any user before availing a loan from any financial institution.

Comments

Popular posts from this blog

Google NCR

Google NCRMost of you would be knowing about this trick in navigating to Google generic website. But I just came to know only a few days before and hence thought I would share the information with others too.
Whenever you type http://www.google.com/, Google automatically tries to redirect you to your country-specific website. For me, it always redirects to http://www.google.co.in/ (Google India). But when we specifically want to navigate to Google Generic website for some reason, there are two ways to accomplish the same.Click the 'Go to Google.com' link at the bottom of the webpage that is displayed from http://www.google.co.in/To prevent this redundant click, you can opt to type http://www.google.com/ncr/ which would prevent the redirect from happening. The NCR stands for No Country Redirect. There is a brief discussion about this NCR over this forum.You may also like to check out Google help documentation regarding the country redirections from here.

Elegant 'MailTo' Replacement

Elegant 'MailTo' Replacement

MailTo tags have become a bane to all websites since spammers run spam robots which crawl the web to capture the email addresses, add to their catalogs and send spams to them. I just thought of sharing with others a simple JavaScript function which would trigger open the default email client instead of having mailto: embedded in the HTML Page.

Just have the following function included in your webpage

<script language='Javascript'>
function WriteMailTo(user,domain)
{
location.replace ('mailto:'+user+'@'+domain);
}
</script>

And whereever you want to invoke the mailto, just called WriteMailTo('user','example.com') and the user's default email client should be launching (if configured) without any hassles.

Contacts import utility from Web2Project to Addressbook

I have been using Web2Project for planning my personal and professional tasks for a few years now. Now I have bifurcated the tools into the following:

Project PierAddress Book The only issue I had was to import my addressbook from Web2Project to AB. PP is a different animal. It does not serve as a comprehensive candidate for addressbook and hence I needed this bifurcation. 
I wrote up a following simple script to import the contacts to AB. The pre-requisite for this script is to hop on to PhpMyAdmin, export the contacts as a PHP array and then  modify the path in our import script to whatever you downloaded from PhpMyAdmin.
Our import script would explode the entries as SQL scripts into the browser window. Copy them and execute into PhpMyAdmin AB database to have the contacts imported.

Script URL: https://gist.github.com/lavanyadeepak/5177500#file-import-php