I am trying to compute the APR for Variable Rate Mortgages. The data I have
is the following:
Loan Type: 5/1 ARM
Amount:$100,000
Index: 4.3
Margin: 2.75%
Rate: 6.125%
Term: 30 Years

Is there any way using Excel formulas that I can calculate this?????
Thanks