A spreadsheet to assist in calculating Yield Maintenance
Financial Calculations
Yield Maintenance
Yield Maintenance
Input fields in the sheet below are shaded in yellow and the results from the calculations are in shaded in black
This sheet calculates the approximate yield maintenance. Some documents will require calculation to maturity. Some will require that the reinvestment rate is adjusted to a mortgage equivalent.
These models are provided for educational purposes only and are not intended to provide investment advice.
Copyright © 2013 MERCCREM, LLC. All rights reserved. PO Box 1663, Livingston, NJ 07039 973-714-8550, info@merccrem.com. Nothing contained in
this site is to be used to make investment decisions. All information contained herein is for discussion purposes only. Photo credits: From Top Left moving
clockwise 1) lower Manhattan at dusk, 2) Summit Medical Group, 3) Stuyvesant Town Alec Jordan; cropped by Beyond My Ken (talk) 00:03, 2 March 2012 (UTC) This
file is licensed under the Creative Commons Attribution-Share Alike 3.0 Unported license, 4) Short Hills Mall, 5) Freedom Tower under construction, 6) King Kong
on Empire State Building approx. 1982, 7) Willis Tower (Formerly Sears Tower) Sears tower photo 1998 by Wikipedia user Soakologist. No rights claimed or reserved.
8)1500 Broadway by Thomas Craven This file is licensed under the Creative Commons Attribution-Share Alike 3.0 Unported license. 9) Stikshift (talk). Original uploader
was Stikshift at en.wikipedia This work has been released into the public domain by its author, Stikshift at the wikipedia project.