Question: Please help me with my homework. Thanks! Please make an amortization schedule using the format I put in the image belowa minimum of 12 periods.

Please help me with my homework. Thanks!

Please make an amortization schedule using the format I put in the image belowa minimum of 12 periods. Note: I attached an example of the sample problem and its amortization schedule below. Please create one with the same format. Thanks!

Please help me with my homework. Thanks!Please make an amortization schedule usingthe format I put in the image belowa minimum of 12 periods.

Amortization Schedule Period Outstanding Interest due at end Payment (A) Principal repaid at principal (OP) of period (OP x i) end of period (A-l) 1 P 5000 P 300 P 1 0,1681 P 716.81 4,283.19 256. 99 1,016.81 759. 82 3523 37 1,016.81 2717.96 . 1,016.81 1,864.23 1,016 81 959. 27 57.55 1,.016 81 959.27 TOTALS P 1,100.87 P 0,100.80 P 5,000.00 Sample Problem 1. A debt of P5,000 with interest at 12% compounded semi-annually is to be amortized by equal semi-annual payments over the next 3 years. the rst due in 6 months. Find the semi-annual payment and construct an amortization schedule. Given: P=P5,000 r=12% m=2 n=3 Required: Amortization Schedule Solution: A[1 (1 + 0-H] PA = i A 2 PA 0) [1 (1 + i)'"] 500mg) )(3)(2) \"([1 _ 1 1 A: P1,016.81 \\

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 Economics Questions!