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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!