Remember Me?

 sts111 Posts: n/a Annual Percentage Rate

I am trying to calculate annual percentage rate for a mortgage estimate. The
Formula works as long as I don't use a rate above 5.5% and term in months
above 310. I need to calculate using 360 month term.
Also I need to combine 1st and 2nd lien loan info into a single APR. Anyone
know how to creat this;

Here is the formula I Have been using:
=RATE(B4,PMT(ROUND(B2/12,6),B4,B1,0,0),B1-B3,0,0,0)*12
Data is as follows:
B1 = 110410 (Loan Amt)
B2 = 6.5% (Interest Rate)
B3 = 3360 (Estimated Closing Costs)
B4 = 360 (Term)
 Bernie Deitrick Posts: n/a sts,

It would help the function converge if you offer it an initial guess:

=RATE(B4,PMT(ROUND(B2/12,6),B4,B1,0,0),B1-B3,0,0,B2)*12

HTH,
Bernie
MS Excel MVP

"sts111" wrote in message
...
I am trying to calculate annual percentage rate for a mortgage estimate.

The
Formula works as long as I don't use a rate above 5.5% and term in months
above 310. I need to calculate using 360 month term.
Also I need to combine 1st and 2nd lien loan info into a single APR.

Anyone
know how to creat this;

Here is the formula I Have been using:
=RATE(B4,PMT(ROUND(B2/12,6),B4,B1,0,0),B1-B3,0,0,0)*12
Data is as follows:
B1 = 110410 (Loan Amt)
B2 = 6.5% (Interest Rate)
B3 = 3360 (Estimated Closing Costs)
B4 = 360 (Term)

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post LD Excel Worksheet Functions 5 January 13th 05 06:17 PM Kay LJ Excel Worksheet Functions 2 January 11th 05 01:38 AM fpbuckland Excel Worksheet Functions 1 January 6th 05 02:07 AM marlia Excel Worksheet Functions 2 December 9th 04 09:05 PM MayBee Excel Worksheet Functions 5 November 15th 04 06:10 PM

All times are GMT +1. The time now is 09:45 AM. Copyright ©2004-2023 ExcelBanter.