Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started