LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Calculation of Interest / How to find Monthly Payment w/ Offset First Payment More options

I am attempting to find the monthly payment of a loan, for example a
car loan. I have found the formula P=(C*r*((1+r)^N))/(((1+r)^N)-1)
* ,
where C- Loan Amount; N-# of Payments ; r = ARP/ compounding
frequency ; and P-Payment.

[*Source:http://www.efunda.com/formulae/finan...alculator.cfm]


Now this formula works find with the following assumptions. That our
first payment will always be 1 cyle into the loan. For example if we
are compounding monthly, then ths payment (P) will be the monthly
payment, which will be due one month after the start of the loan.


Now my question is, if I would like to change the date of first
payment, how would I go about doing this? Is there a formula
developed
for this type of situation?

 
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
Calculate total interest earned on a loan and monthly payment Matt Stanley Excel Worksheet Functions 4 May 4th 23 03:42 AM
PMT: Daily interest compounding; monthly payment rkhughes Excel Worksheet Functions 10 April 3rd 23 07:44 PM
Interest payment da Excel Discussion (Misc queries) 5 August 26th 08 09:21 PM
Payment calculation w/ back interest Keeb Excel Discussion (Misc queries) 8 February 24th 06 05:27 AM
Interest only payment origin8r Excel Worksheet Functions 3 July 14th 05 03:53 AM


All times are GMT +1. The time now is 06:11 AM.

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

About Us

"It's about Microsoft Excel"