Thank you Toby, Yes that is the exact amortization table(With Cummulatives)I want in Ms Access. The things I have to solve:
1. How to convert the results into a Access table which can be related to a particular borrower, 2. How can I accomodate if borrower returns a certain amount in between, keeping the regular payment(EMI Equal Monthly Installment) decided initially not disturbed. - Rajeev --- Toby Bierly <[EMAIL PROTECTED]> wrote: --------------------------------- Programming an amortization table with a final balloon payment caused by trimming off pennies from the monthly payment is quite tricky (i.e., a lot of math with fairly complicated summation formulas). Perhaps the following calculator will help http://ray.met.fsu.edu/cgi-bin/amortize or the author's explanation of the math http://ray.met.fsu.edu/~bret/am_derive/derivation.html Actually, now that I think about it, the following may work: 1. Use the PMT function and then round down to the nearest dollar to figure out monthly payment (for example =PMT(6.5%/12,360,-90000) ==> $568.86 2. Use the FV function with the payment calculated in step 1 to calculate the final balloon payment (for example =FV(6.5%/12,360,568,-90000) ==> $952.66 3. Then use the PPMT and IPMT functions to help create the table. HTH, Toby ----- Original Message ----- From: "rajeev vasu" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, September 23, 2005 6:36 PM Subject: Re: [AccessDevelopers] PMT and PPMT > Thank you Toby, > Actually I wanted to make a amortization table of > payments. For this i got the PPmt function example > from MSDN. Ref. Q256200-ACC2000. Srill I face > problem. I want to avoid decimels in monthly payment. > If the loan period is "n" then some amount will remain > to deduct at the end of the period,that will be paid > in "n+1" installment. I am trying to solve it. Tahnk > you. > > - Rajeev > > > > > > > > --- Toby Bierly <[EMAIL PROTECTED]> wrote: > > > --------------------------------- > I'm not sure how much clearer I can make it than is > already explained in > Access or Excel Help. There are examples as well in > both programs' Help. > > If you want to find the monthly payment for a 30 year > loan at 6.5% APR for > $50,000, then you enter > > PMT(.065/12, 360, -50000) > > If you want to find the principal payment for the 18th > month of the same > loan, you would enter > > PPMT(.065/12, 18, 360, -50000) > > HTH, > Toby > > ----- Original Message ----- > From: "rajeev vasu" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Thursday, September 22, 2005 10:49 AM > Subject: Re: [AccessDevelopers] PMT and PPMT > > > > Dear Johnson, > > > > I was also searching for the same. It is explained > in > > Access help. But I don't know how to use it. Will > you > > please elaborate ? > > > > - Rajeev > > > > > > > > --- Lonnie Johnson <[EMAIL PROTECTED]> wrote: > > > > > Sorry. I didn't know that these were Access > > > functions as well. Problem solved. > > > > > > Lonnie Johnson <[EMAIL PROTECTED]> wrote:Does > > > anyone know how to convert or duplicate Excel's > PMT > > > and PPMT loan functions in MS Access? > > > > > > > > > > > > May God bless you beyond your imagination! > > > Lonnie Johnson > > > ProDev, Professional Development of MS Access > > > Databases > > > Visit me at ==> http://www.prodev.us > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------- > > > Yahoo! for Good > > > Click here to donate to the Hurricane Katrina > relief > > > effort. > > > > > > > > > Please zip all files prior to uploading to Files > > > section. > > > > > > > > > > > > SPONSORED LINKS > > > Microsoft access developer Microsoft access help > > > Microsoft access database Microsoft access > training > > > Microsoft access training course Microsoft access > > > programming > > > > > > --------------------------------- > > > YAHOO! GROUPS LINKS > > > > > > > > > Visit your group "AccessDevelopers" on the > web. > > > > > > To unsubscribe from this group, send an email > > > to: > > > [EMAIL PROTECTED] > > > > > > Your use of Yahoo! Groups is subject to the > > > Yahoo! Terms of Service. > > > > > > > > > --------------------------------- > > > > > > > > > > > > > > > > > > > > > May God bless you beyond your imagination! > > > Lonnie Johnson > > > ProDev, Professional Development of MS Access > > > Databases > > > Visit me at ==> http://www.prodev.us > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------- > > > Yahoo! for Good > > > Click here to donate to the Hurricane Katrina > > > relief effort. > > > > > > > > > > > __________________________________________________________ > > Yahoo! India Matrimony: Find your partner now. Go to > http://yahoo.shaadi.com > > > > > > > > > > Please zip all files prior to uploading to Files > section. > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > Please zip all files prior to uploading to Files > section. > > > > --------------------------------- > YAHOO! GROUPS LINKS > > > Visit your group "AccessDevelopers" on the web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! > Terms of Service. > > > --------------------------------- > > > > > > > __________________________________________________________ > Yahoo! India Matrimony: Find your partner now. Go to http://yahoo.shaadi.com > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > Please zip all files prior to uploading to Files section. SPONSORED LINKS Microsoft access developer Microsoft access help Microsoft access database Microsoft access training Microsoft access training course Microsoft access programming --------------------------------- YAHOO! GROUPS LINKS Visit your group "AccessDevelopers" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- __________________________________________________________ Yahoo! India Matrimony: Find your partner now. Go to http://yahoo.shaadi.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
