Discussion Board
Watch this board

Total 51 messages Pages | 1 | 2 | 3 | 4 | 5   Older >
Views
by shubhi mathur on Aug 22, 2008 05:26 PM  Permalink 

How many times will you publish the same article?

    Forward  |  Report abuse
rent v/s buy
by ashish on Aug 19, 2008 03:45 PM  Permalink  | Hide replies

Assumption: House cost 20,00000 which can be rented at 5000 per month rent
Rent increasing 5% per annum house appreciating 5% pa EMI 20000/-
My point is that rent and home prices will increase same rate,as it can not happen that one is steady or slow and other is increasing very high,
Saving denotes what amount will be saved if living in rented house instead of buying and paying EMI Saving =EMI-Rent
Of these saving 1 lacs will be invested lon term in equity/mutual fund that can fetch 15% return (though it can be higher but i m taking a conservative view)
for eg. in first year i will save 1,87,716 of which i will invest 1 lac and rest 87,716 i will spend on my lifestyle
i have negated tax benifit because HRA component is not taxed which accounts for 1,20,000 (10K pm) in my salary component.

Rent per annum      EMI per annum      Saving (Annual)       Amount invested each year from saving
1 60000            247716             187716            100000
2 63000            247716             184716            100000
3 66150            247716             181566            100000
4 69458            247716             178258            100000
5 72930            247716             174786            100000
6 76577            247716             171139            100000
7 80406            247716             167310            100000
8 84426            247716             163290            100000
9 88647            247716             159069            100000
10 93080            247716             154636            100000
11 97734            247716             149982            100000
12 107751            247716        ;     139965            100000
13 102620            247716        ;     145096            100000
14 113139            247716        ;     134577            100000
15 118796            247716        ;     128920            100000
16 124736            247716        ;     122980            100000
17 130972            247716        ;     116744            100000
18 137521            

    Forward  |  Report abuse
RE:rent v/s buy
by R.K. Singh on Aug 19, 2008 04:47 PM  Permalink
Mutual fund guy ........... :D


Gud analyis and example though....i agree with it.

   Forward   |   Report abuse
Message deleted by moderator. | Hide replies
Message deleted by moderator
XIRR formula
by amit on Aug 18, 2008 08:46 PM  Permalink 

XIRR might not work in some excel pages.
Go to - TOOLS, CLICK ON ADDINS AND THEN CLICK ON ANALYSIS TOOLPAK..then xirr works.

    Forward  |  Report abuse
Nice One. Very Useful!
by jayaprakash narayan on Aug 15, 2008 12:30 PM  Permalink 

Nice One. Very Useful!

    Forward  |  Report abuse
XIRR FORMULA
by sagarpk on Aug 04, 2008 12:49 AM  Permalink  | Hide replies

SIR,
XIRR FORMULA DOES NOT WORKING IN MSEXCEL 2003. PLS HELP ME.IS THERE ANY OTHER FORMULAS OF THIS TYPE TO CALCULATE THE INCOME FROM SHARES
SAGAR

    Forward  |  Report abuse
RE:XIRR FORMULA
by Sagar Chandak on Aug 09, 2008 05:29 PM  Permalink
Insert * after 100000. Enter formula as

=100000*(1 8%)^4

   Forward   |   'Report abuse' disabled by moderator
RE:XIRR FORMULA
by Sagar Chandak on Aug 09, 2008 05:28 PM  Permalink
Type * after 100000 enter formula as

=100000*(1 8%)^4

   Forward   |   'Report abuse' disabled by moderator
XIRR does not work in excel
by RAJESH PARMAR on Aug 03, 2008 05:34 PM  Permalink  | Hide replies

Please help!
XIRR formula does not work in excel
how to go about?
rajparmar2@rediffmail.com

    Forward  |  Report abuse
Message deleted by moderator
calculatio
by Surendra Kumar on Aug 02, 2008 06:11 PM  Permalink 

It will be very helpfull for us , if such calculation is provided for calculation of principle & interest on the EMI of housing loan.

    Forward  |  Report abuse
Total 51 messages Pages: | 1 | 2 | 3 | 4 | 5   Older >
Write a message