Basic Loan Calculator with Conversion to Permanent Loan

Description
This is a simple, yet robust loan calculator that is ideal for modeling scenarios where an short-term loan/LOC exists that will convert to a "permanent loan" with new borrowing terms after a designated time period.  This is ideal for situations where a short term capital/construction loan exists initially during project development, but changes terms upon project completion.


Begin by choosing the start of the first loan in cell E4.  Input the borrowed amount and interest rate of the first loan in cells E7 and E8, respectively.


The first loan can end at any time by adjusting its length in months (cell E5), but payments can be amortized across any number of years.  There are options to pay "Interest only" during the first loan which is common in real world scenarios, or fully amortize.  Each loan has the option to include an origination/arrangement fee which is added to the initial balance if chosen.  Each loan can be assigned its own interest rate.


A full amortization schedule is available for both loans along with a graph at the top of the page showing the ending loan balance for each.


Only yellow cells should be adjusted by the user.
A similar version with a "cash out refi" option is in the works.