tag:blogger.com,1999:blog-2509167754737584590.post215177408654767143..comments2019-06-25T10:56:59.931+05:30Comments on Yogesh Gupta's Excel Tips: Excel Formula : PMT FunctionYogesh Guptahttp://www.blogger.com/profile/08246342663404873564noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-2509167754737584590.post-78992694629228030222019-04-09T10:11:47.626+05:302019-04-09T10:11:47.626+05:30Valuable Information!!Valuable Information!!Seyyonehttps://www.blogger.com/profile/17778803921170462346noreply@blogger.comtag:blogger.com,1999:blog-2509167754737584590.post-38439788003207115032016-11-24T19:59:06.121+05:302016-11-24T19:59:06.121+05:30why do you have taken principal as negative(-) .why do you have taken principal as negative(-) .lakshman bhatthttps://www.blogger.com/profile/13342837672667389287noreply@blogger.comtag:blogger.com,1999:blog-2509167754737584590.post-17525084972925101832016-05-06T07:38:40.770+05:302016-05-06T07:38:40.770+05:30What is formula for calculating EMI of a sim0le in...What is formula for calculating EMI of a sim0le interest loan.Unknownhttps://www.blogger.com/profile/09733726515880070534noreply@blogger.comtag:blogger.com,1999:blog-2509167754737584590.post-18552533429748242452016-05-06T07:38:40.056+05:302016-05-06T07:38:40.056+05:30What is formula for calculating EMI of a sim0le in...What is formula for calculating EMI of a sim0le interest loan.Unknownhttps://www.blogger.com/profile/09733726515880070534noreply@blogger.comtag:blogger.com,1999:blog-2509167754737584590.post-83443283764343115102013-12-16T12:32:58.369+05:302013-12-16T12:32:58.369+05:30Excellent! ThanksExcellent! ThanksBondhttps://www.blogger.com/profile/01198912147215269922noreply@blogger.comtag:blogger.com,1999:blog-2509167754737584590.post-31000072552632637532013-09-02T18:02:16.447+05:302013-09-02T18:02:16.447+05:30I am looking for a formula to calculate the PPF. E...I am looking for a formula to calculate the PPF. Each month separately and whole year accumulated interest.<br />ThanksGopuhttps://www.blogger.com/profile/10254009681835155187noreply@blogger.comtag:blogger.com,1999:blog-2509167754737584590.post-47051842880908003862013-05-22T12:37:57.782+05:302013-05-22T12:37:57.782+05:30Hi I used the same figure at same cells with 14 %...Hi I used the same figure at same cells with 14 % , instead of 14.25 as decimals were creating problem and exact same formula but i am getting value 233333.34 . WHy ? do i need to enable something in excel . i checked again the formula and values but i dont get EMI Value that you have got in the example . where i am making mistake ?ashishkgtmhttps://www.blogger.com/profile/01832669615377034201noreply@blogger.comtag:blogger.com,1999:blog-2509167754737584590.post-60486608569766560632013-03-03T00:12:54.015+05:302013-03-03T00:12:54.015+05:30Dear Yogesh, Thank you for explaining in very simp...Dear Yogesh, Thank you for explaining in very simple way the usage. It is indeed very helpful to all.<br />PareshParesh Jadiyahttps://www.blogger.com/profile/04130882770416604564noreply@blogger.comtag:blogger.com,1999:blog-2509167754737584590.post-1066580386659099002012-10-24T18:40:36.486+05:302012-10-24T18:40:36.486+05:30use pmt formula
=pmt(5%/12,60,-10000)
use pmt formula <br />=pmt(5%/12,60,-10000)<br />Hajahttps://www.blogger.com/profile/13635067796407002403noreply@blogger.comtag:blogger.com,1999:blog-2509167754737584590.post-32195317197511187272012-09-26T06:56:50.425+05:302012-09-26T06:56:50.425+05:30I am a banker. We charge interest rate on the outs...I am a banker. We charge interest rate on the outstanding balance every month end. This is known as interest with monthly rests. Could you calculate and send me a blank table wherein if I put the details, the program should calculate emi with monthly rests (ie interest will be charged on outstanding every month) what will be the emi? Could you send the same to me on my email id vinodhemdev@gmail.com This will be very helpful for our customers who wish to know how much emi will be there per lac on monthly rest basisVinod Hemdevhttps://www.blogger.com/profile/08996767934089284032noreply@blogger.comtag:blogger.com,1999:blog-2509167754737584590.post-71544351164037166102010-04-27T11:09:14.400+05:302010-04-27T11:09:14.400+05:30How to create Home loan EMI calculator with featur...How to create Home loan EMI calculator with features like staggered disbursement, variable interst rates amd moratorium periodsonahttps://www.blogger.com/profile/06778377170567350080noreply@blogger.com