All of the highlighter yellow cells and orange principal pre-payment cells will display values from the Adjustable Mortgage Schedule sheet. Every other cell with an excel formula will use the ...

Calculates monthly mortgage payments based on the loan amount, interest rate, and loan term. Generates an amortization schedule showing the breakdown of each payment. Visualizes the interest and ...