While we don’t have a dedicated yield maintenance calculator, you might find our Commercial Mortgage Loan Analysis Tool helpful. This tool includes features that can assist in analyzing various loan scenarios, including pre-payment penalties. You can access it here: https://www.adventuresincre.com/commercial-mortgage-loan-analysis-model/
Additionally, our Yield Maintenance glossary term provides a detailed explanation of how yield maintenance works, offering valuable insights. You can check it out here: https://www.adventuresincre.com/glossary/yield-maintenance/
For more advanced calculations, Chatham’s yield maintenance calculator is an excellent resource. Although it’s not Excel-based, it’s highly reliable: https://www.chathamfinancial.com/expertise/defeasance-prepayment-expertise/yield-maintenance-calculator/
Finally, in the A.CRE Accelerator program, Spencer and Michael use Chatham’s forward yield curve forecasts to teach floating rate modeling, which may also enhance your understanding of yield maintenance and loan structuring.