I will create a multi function mortgage loan amortization saver

[1] Generate simultaneously monthly and fortnightly repayment schedules, using fixed or adjustable rates

[2] Add optional extra payments ***

[3] Input one-off payment on principal ***

[4] Evaluate the feasibility of refinancing an existing loan with another loan (at a fixed or adjustable rate) ***

[5] Access the spreadsheet to change the fixed rate and/or input extra payments of varying amounts. In this mode, with every input, the comparative repayment schedules dynamically update since they are formula-driven ***

[6] Compute the LVR, to see if LMI is required

***End Notes

(a) Comparative monthly and fortnightly repayment timetables are juxtaposed with the existing monthly and fortnightly schedules

(b) The column headings of the original schedules are colored yellow while those of the subsequent ones are green

(c) The Loan Summary section of the app provides a synopsis of the savings in interest expense and years for any change in servicing the mortgage loan

(d) 4 colorful graphs automatically mirror the changes at (c) above

(e) A 25-page PDF doc't with 50 diagrams, clear and detailed instructions comes with the app to ensure easy usage