Mortgage Interest Calculation
Exercise ID: tvm-real-011
Description
A $300,000 mortgage for 30 years at 4.5% (monthly compounding). Calculate the interest portion of the first monthly payment.
Given Values
Objective
Calculate INT
Steps
Total 19 stepsStep 1:Clear TVM Registers
💡 Always clear TVM before starting a new problem.
Key Sequence:
Before Key Press:
0.00
After Key Press:
0.00
⏱ 1500ms
Step 2:Input N = 360
Key Sequence:
Before Key Press:
0.00
After Key Press:
360
⏱ 1600ms
Step 3:Store in N
Key Sequence:
Before Key Press:
360
After Key Press:
N=360.00
⏱ 1000ms
Step 4:Input I/Y = 0.375
Key Sequence:
Before Key Press:
N=360.00
After Key Press:
0.375
⏱ 2000ms
Step 5:Store in I/Y
Key Sequence:
Before Key Press:
0.375
After Key Press:
I/Y=0.38
⏱ 1000ms
Step 6:Input PV = 300000
Key Sequence:
Before Key Press:
I/Y=0.38
After Key Press:
300000
⏱ 2200ms
Step 7:Store in PV
Key Sequence:
Before Key Press:
300000
After Key Press:
PV=300000.00
⏱ 1000ms
Step 8:Input PMT = 0
Key Sequence:
Before Key Press:
PV=300000.00
After Key Press:
0
⏱ 1200ms
Step 9:Store in PMT
Key Sequence:
Before Key Press:
0
After Key Press:
PMT=0.00
⏱ 1000ms
Step 10:Input FV = 0
Key Sequence:
Before Key Press:
PMT=0.00
After Key Press:
0
⏱ 1200ms
Step 11:Store in FV
Key Sequence:
Before Key Press:
0
After Key Press:
FV=0.00
⏱ 1000ms
Step 12:Compute PMT
Key Sequence:
Before Key Press:
FV=0.00
After Key Press:
PMT=-1520.06
⏱ 1500ms
Step 13:Open Amortization Worksheet
Key Sequence:
Before Key Press:
PMT=-1520.06
After Key Press:
P1= 1.00
⏱ 1000ms
Step 14:Accept P1 = 1
Key Sequence:
Before Key Press:
P1= 1.00
After Key Press:
P1= 1.00
⏱ 1000ms
Step 15:Move to P2
Key Sequence:
Before Key Press:
P1= 1.00
After Key Press:
P2= 1.00
⏱ 800ms
Step 16:Accept P2 = 1
Key Sequence:
Before Key Press:
P2= 1.00
After Key Press:
P2= 1.00
⏱ 1000ms
Step 17:Move to BAL
Key Sequence:
Before Key Press:
P2= 1.00
After Key Press:
BAL=299604.94
⏱ 800ms
Step 18:Move to PRN
Key Sequence:
Before Key Press:
BAL=299604.94
After Key Press:
PRN=-395.06
⏱ 800ms
Step 19:Move to INT
Key Sequence:
Before Key Press:
PRN=-395.06
After Key Press:
INT=-1125.00
⏱ 800ms
- 1.Calculating total payment instead of interest only
- 2.Using annual rate instead of monthly
- 3.Incorrect P1/P2 settings in AMORT worksheet
(Expand the sections to view answers and common mistakes before printing.)