ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Computing mortgage APR (https://www.excelbanter.com/excel-worksheet-functions/198217-computing-mortgage-apr.html)

NorCalHomeFinance

Computing mortgage APR
 
Hello,

I need to know how to compute the APR for a mortgage quote using the following data:

Rate: Say 6.75%
Term: 360 months
Loan Amount: Say $200,000
Closing Costs: Say $3,000

I'm a mortgage professional and even I get confused as to how to compute the APR, but it's always a bit higher than the interest rate and I believe it takes into account the closing costs.

Does anybody have the formula for this?

Thanks!

Barb Reinhardt

Computing mortgage APR
 
Found with a google search

http://banking.about.com/od/loans/a/calculateapr.htm
--
HTH,
Barb Reinhardt



"NorCalHomeFinance" wrote:


Hello,

I need to know how to compute the APR for a mortgage quote using the
following data:

Rate: Say 6.75%
Term: 360 months
Loan Amount: Say $200,000
Closing Costs: Say $3,000

I'm a mortgage professional and even I get confused as to how to
compute the APR, but it's always a bit higher than the interest rate
and I believe it takes into account the closing costs.

Does anybody have the formula for this?

Thanks!




--
NorCalHomeFinance


ryguy7272

Computing mortgage APR
 
Take a look at these samples; all free:
http://www.vertex42.com/ExcelTemplat...readsheet.html


Regards,
Ryan---

--
RyGuy


"Barb Reinhardt" wrote:

Found with a google search

http://banking.about.com/od/loans/a/calculateapr.htm
--
HTH,
Barb Reinhardt



"NorCalHomeFinance" wrote:


Hello,

I need to know how to compute the APR for a mortgage quote using the
following data:

Rate: Say 6.75%
Term: 360 months
Loan Amount: Say $200,000
Closing Costs: Say $3,000

I'm a mortgage professional and even I get confused as to how to
compute the APR, but it's always a bit higher than the interest rate
and I believe it takes into account the closing costs.

Does anybody have the formula for this?

Thanks!




--
NorCalHomeFinance



All times are GMT +1. The time now is 03:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com