10-Year, 20-Year, and 25-Year 504 Estimated Payment & Effective Rates Calculators (Excel spreadsheet). *Please note that these calculators are now contained in one spreadsheet, with each debenture increment contained on a separate labeled tab.
The page you are accessing is a downloadable Excel spreadsheet. You may retrieve this document by clicking the following link:
If this does not work, you may need to click and hold (Mac) or right click on the link (PC), then choose "Download to Disk," "Save Target As...," or the equivalent.
The results should be within a few basis points of the actual effective rates provided by the CSA, however, the information provided by the rate calculators has been obtained from sources that are believed to be reliable, but are not guaranteed for accuracy or completeness. Eagle Compliance, LLC, 2015.
Disclaimer: The official effective rates are provided only by the Central Servicing Agent prior to each funding date. These calculators provide only estimates of the Effective Loan Rate and are not guaranteed for accuracy because Excel does not properly compute the initial, abbreviated six-month calculation.