Question: QUESTION 1 Construct an amortization schedule for a $100, 12% nominal rate loan with 8 quarter equal payments. a. Find quarterly payment: b. Find periodic
QUESTION 1 Construct an amortization schedule for a $100, 12% nominal rate loan with 8 quarter equal payments. a. Find quarterly payment: b. Find periodic rate c.Find interest payment for first quarter. d. Find principal payment for first month. e. Find ending balance for first month. f.Find Total monthly payment Note: Total monthly payment = monthly payment x number of payments = 8. Total interest payment total monthly payment - total principal payment h. Construct an amortization schedule. (.e. fill blank cells.) example: (1) = $100 Quarter Beginning Quarterly Interest Principal Balance Payment Payment Payment Ending Balance (1) (2) (3) (4) (5) 2 (6) (2) (7) (8) (9) ... (11) (10) 8 . ... ... (13) (12) Total (14)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
