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 > > > > > > ------------------------ 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/
