Mortgage Interest Calculation

Exercise ID: tvm-real-011

Exam TrapsAmortization

Description

A $300,000 mortgage for 30 years at 4.5% (monthly compounding). Calculate the interest portion of the first monthly payment.

Given Values

N
360
I/Y
0.375%
PV
300000
PMT
0
FV
0
P1
1
P2
1

Objective

Calculate INT


Steps

Total 19 steps

Step 1:Clear TVM Registers

💡 Always clear TVM before starting a new problem.

Key Sequence:

2ndFV

Before Key Press:

0.00

After Key Press:

0.00

1500ms

Step 2:Input N = 360

Key Sequence:

360

Before Key Press:

0.00

After Key Press:

360

1600ms

Step 3:Store in N

Key Sequence:

N

Before Key Press:

360

After Key Press:

N=360.00

1000ms

Step 4:Input I/Y = 0.375

Key Sequence:

0DECIMAL375

Before Key Press:

N=360.00

After Key Press:

0.375

2000ms

Step 5:Store in I/Y

Key Sequence:

I/Y

Before Key Press:

0.375

After Key Press:

I/Y=0.38

1000ms

Step 6:Input PV = 300000

Key Sequence:

300000

Before Key Press:

I/Y=0.38

After Key Press:

300000

2200ms

Step 7:Store in PV

Key Sequence:

PV

Before Key Press:

300000

After Key Press:

PV=300000.00

1000ms

Step 8:Input PMT = 0

Key Sequence:

0

Before Key Press:

PV=300000.00

After Key Press:

0

1200ms

Step 9:Store in PMT

Key Sequence:

PMT

Before Key Press:

0

After Key Press:

PMT=0.00

1000ms

Step 10:Input FV = 0

Key Sequence:

0

Before Key Press:

PMT=0.00

After Key Press:

0

1200ms

Step 11:Store in FV

Key Sequence:

FV

Before Key Press:

0

After Key Press:

FV=0.00

1000ms

Step 12:Compute PMT

Key Sequence:

CPTPMT

Before Key Press:

FV=0.00

After Key Press:

PMT=-1520.06

1500ms

Step 13:Open Amortization Worksheet

Key Sequence:

2ndPV

Before Key Press:

PMT=-1520.06

After Key Press:

P1= 1.00

1000ms

Step 14:Accept P1 = 1

Key Sequence:

ENTER

Before Key Press:

P1= 1.00

After Key Press:

P1= 1.00

1000ms

Step 15:Move to P2

Key Sequence:

DOWN

Before Key Press:

P1= 1.00

After Key Press:

P2= 1.00

800ms

Step 16:Accept P2 = 1

Key Sequence:

ENTER

Before Key Press:

P2= 1.00

After Key Press:

P2= 1.00

1000ms

Step 17:Move to BAL

Key Sequence:

DOWN

Before Key Press:

P2= 1.00

After Key Press:

BAL=299604.94

800ms

Step 18:Move to PRN

Key Sequence:

DOWN

Before Key Press:

BAL=299604.94

After Key Press:

PRN=-395.06

800ms

Step 19:Move to INT

Key Sequence:

DOWN

Before Key Press:

PRN=-395.06

After Key Press:

INT=-1125.00

800ms

Calculator Display
0.00
Speed:← →
💡 Press Space to quickly pause/play
⚠️ Common Mistakes and Traps
  • 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.)

💡 Tip: Use your browser's print function (Ctrl+P or Cmd+P) to export this exercise as a PDF or print it on paper.