Adjustable Rate APR - Excel Help Forum

Does anyone have a formula to calculate an APR for an adjustable rate mortgage?

for example if I have a 200,000 - 30 year mortgage that has a fixed rate of

6% for 3 years and then adjusts to a rate of 7.75 every year after that

after that, with 1500 in finance charges.

So far I can figure out the APR without adjustment of

=rate(360,PMT(6%/12,360,200000),200000-1500)*12

> Does anyone have a...

Read more


Website: https://www.excelforum.com

Related topics : best mortgage rates canada 3 years fixed / 30 year fixed mortgage rates interest only / rates 30 year fixed mortgage / adjustable rate mortgage calculation formula / 5 year fixed mortgage rates interest only

[an error occurred while processing this directive]

Home Loan Mortgage and Refinance Rates Online

Guide to Lenders - 950 Tower Lane, 6th Floor - Foster City, CA 94404 - contact@guidetolenders.com

X

Ad Disclosure

QuinStreet Media, Inc. and QuinStreet Properties, Inc. are Marketing Lead Generators and Duly Licensed Mortgage Brokers, as required by law, with their main office located at 950 Tower Lane, 6th Floor, Foster City, CA 94404, Telephone Number (650) 578-7700. NMLS Unique Identifier for...

Read more


Website: guidetolenders.com

[an error occurred while processing this directive]

Home Loan Mortgage and Refinance Rates Online

Guide to Lenders - 950 Tower Lane, 6th Floor - Foster City, CA 94404 - contact@guidetolenders.com

X

Ad Disclosure

QuinStreet Media, Inc. and QuinStreet Properties, Inc. are Marketing Lead Generators and Duly Licensed Mortgage Brokers, as required by law, with their main office located at 950 Tower Lane, 6th Floor, Foster City, CA 94404, Telephone Number (650) 578-7700. NMLS Unique Identifier for...

Read more


Website: guidetolenders.com

[an error occurred while processing this directive]

tips on refinancing a mortgage - Guide to Lenders

Guide to Lenders - 950 Tower Lane, 6th Floor - Foster City, CA 94404 - contact@guidetolenders.com

X

Ad Disclosure

QuinStreet Media, Inc. and QuinStreet Properties, Inc. are Marketing Lead Generators and Duly Licensed Mortgage Brokers, as required by law, with their main office located at 950 Tower Lane, 6th Floor, Foster City, CA 94404, Telephone Number (650) 578-7700. NMLS Unique Identifier for...

Read more


Website: guidetolenders.com

Top 3 VA Home Loan Tips | Military.com

Top 3 VA Home Loan Tips

Home buying. Getty Images

Military.com

There are numerous advantages to having a VA mortgage. A VA mortgage loan can be guaranteed with no money down, in some cases up to $417,000. There is also no private mortgage insurance requirement with a VA guaranteed loan, which could offer you substantial savings on your monthly payment.� You can even use your VA Loan benefit to...

Read more

Date: 2018-03-30 03:19:36
Website: https://www.military.com

APR Calculation - Excel Tips & Solutions Since 1998

I am trying to calculate APR (Annual Percentage Rate) for a mortgage loan that has a balloon feature. I have tried to the the RATE function but it only gives me the APR for a loan that is ammortized over 30 yrs and paid in 30 years. I need the APR for a loan that is ammortized for 30 years with a baloon in 5 years. Can anyone help? Thanks Scott

Feb 13th, 2010, 03:10 PM

MickG

Re: APR...

Read more


Website: https://www.mrexcel.com