Time value of money and financial calculator tutorials
Tutorials by Brand:
Time value of money and financial calculator tutorials
In the original amortization schedule tutorial I left out a feature that is of interest to a lot of people: adding extra principal payments in order to pay off the loan earlier than the loan contract calls for. In this tutorial we will add this feature. Before we get started let me mention one important thing: You can almost always…
This is the first of a two-part tutorial on amortization schedules. In this tutorial we will see how to create an amortization schedule for a fixed-rate loan using Microsoft Excel and other spreadsheets (the next part shows how to handle extra principal payments and also includes a sample spreadsheet using this same example data). Almost all of this tutorial also…
This tutorial explains how to amortize a fixed-rate loan using the HP 17BII financial calculator. It guides users on calculating the principal and interest for individual payments or a range of payments. The article demonstrates using the calculator’s built-in functions to break down loan payments into principal and interest components and how to determine the remaining balance after each payment. Additionally, it briefly compares this method with using a spreadsheet for creating a full amortization schedule, highlighting the limitations and practical applications of the HP 17BII calculator's amortization functions.
This tutorial explains how to create an amortization schedule for a fixed-rate loan using a TI 83 Plus calculator. The tutorial covers entering loan details into the TVM Solver, calculating monthly payments, and breaking down each payment into interest and principal. It also demonstrates using built-in functions (ΣInt, ΣPrn, and Bal) to automate calculations and create a complete amortization table. The tutorial includes tips for adjusting loan terms and efficiently navigating the amortization schedule. For those preferring spreadsheets, a separate tutorial is recommended.
This tutorial explains how to amortize a fixed-rate loan using the HP 19BII financial calculator. It guides users on calculating the principal and interest for individual payments or a range of payments. The article demonstrates using the calculator’s built-in functions to break down loan payments into principal and interest components and how to determine the remaining balance after each payment. Additionally, it briefly compares this method with using a spreadsheet for creating a full amortization schedule, highlighting the limitations and practical applications of the HP 19BII calculator's amortization functions.
In this tutorial we will see how to amortize a fixed-rate loan using the HP 10BII+ calculator from Hewlett Packard. Specifically, we will see how to calculate the amount of principal and interest for any particular payment, or range of payments. For example, you may wish to know how much your principal or interest payments will be for the first…
This tutorial explains how to amortize a fixed-rate loan using the HP 20b financial calculator. It guides users on calculating the principal and interest for individual payments or a range of payments. The article demonstrates using the calculator’s built-in functions to break down loan payments into principal and interest components and how to determine the remaining balance after each payment. Additionally, it briefly compares this method with using a spreadsheet for creating a full amortization schedule, highlighting the limitations and practical applications of the HP 20b calculator's amortization functions.
This tutorial explains how to create an amortization schedule for a fixed-rate loan using a TI 84 Plus calculator. The tutorial covers entering loan details into the TVM Solver, calculating monthly payments, and breaking down each payment into interest and principal. It also demonstrates using built-in functions (ΣInt, ΣPrn, and Bal) to automate calculations and create a complete amortization table. The tutorial includes tips for adjusting loan terms and efficiently navigating the amortization schedule. For those preferring spreadsheets, a separate tutorial is recommended.
In this tutorial we will see how to amortize a fixed-rate loan using the TI BAII Plus Professional calculator from Texas Instruments. Specifically, we will see how to calculate the amount of principal and interest for any particular payment, or range of payments. For example, you may wish to know how much your principal or interest payments will be for…
In this tutorial we will see how to amortize a fixed-rate loan using the TI BAII Plus calculator from Texas Instruments. Specifically, we will see how to calculate the amount of principal and interest for any particular payment, or range of payments. For example, you may wish to know how much your principal or interest payments will be for the…