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!


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
Get step-by-step solutions from verified subject matter experts
