LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default PMT function and 1st payment partway through a period

I am using the PMT function to calculate mortgage payments. payments are at
the end of each month and there will be 240 payments. how should i account
for the fact that the mortgage may start partway through the first month?

thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Starting payment when increase rate is known & total payment is kn Shailendra Harri Excel Worksheet Functions 12 September 22nd 07 09:04 PM
change the payment period of amortization schedule gcip Excel Worksheet Functions 2 March 14th 07 03:01 AM
Question on Payment function. Don New Users to Excel 4 August 6th 06 01:32 AM
need a function to calculate a mortgage payment bpeltzer Excel Worksheet Functions 0 November 7th 05 12:09 AM
Payment terms function Tina Excel Worksheet Functions 2 December 2nd 04 02:03 PM


All times are GMT +1. The time now is 12:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"