In the final part of this series we discuss how to insert charts to illustrate how our interest and principal changes over time and also add Section 3 which allows us to compare different mortgage options. Section 3 will consist of the mortgage inputs, intermediary calculations and outputs. The main difference between the three mortgage options will be the amount paid upfront as a deposit which ultimately determines the total cost. To identify which mortgage option is most cost effective we have used the RANK function. We have also added a bar chart to show a detailed cost breakdown.
See Part 1 of the Mortgage Repayment Calculator Series:
https://youtu.be/v6n4wWXy5Us
See Part 2 of the Mortgage Repayment Calculator Series:
https://youtu.be/fUZU5VWNMDk
Subscribe for weekly Excel tutorials, techniques and examples:
https://www.youtube.com/channel/UCgdRm6hepAn6Y0FqMZPLiAw?sub_confirmation1
Please share this video with others that may find it useful:
https://youtu.be/cQdoyomsrIw
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
The Excel Hub website: https://theexcelhub.com/
Instagram: https://www.instagram.com/theexcelhub/
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]Overview: (0:00)
Create Charts: (0:28)
Section 3 Inputs (3:02)
Section 3 Intermediary Calculations (4:05)
Section 3 Outputs (4:38)
Section 3 Bar Chart (6:10)
Concluding Remarks (7:40)