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 with a minimum of 12 periods. 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!