Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2 Period Interest Rate, 6.00% End of Beginning of period 3 Period period Balance Interest Repayment Balance 1 $ 100,000 $ 6,000.00 $13,586.80 $ 92,413
2 Period Interest Rate, 6.00% End of Beginning of period 3 Period period Balance Interest Repayment Balance 1 $ 100,000 $ 6,000.00 $13,586.80 $ 92,413 2 $ 92,413 $ 5,544.79 -$13,586.80 $ 84,371 31 $ 84,371 $ 5,062.27 -$13,586.80 $ 75,847 4 $ 75,847 $ 4,550.80 -$13,586.80 $ 66,811 5 $ 66,811 $ 4,008.64 $13,586.80 $ 57,233 6 $ 57,233 $ 3,433.95 -$13,586.80 $ 47,080 7 $ 47,080 $ 2,824.78 -$13,586.80 $ 36,318 8 $ 36,318 $ 2,179.06 -$13,586.80 $ 24,910 9 $ 24,910 $ 1,494.60 -$13,586.80 $ 12,818 10 $ 12,818 $ 769.06 -$13,586.80-$ Refer to the above loan amortisation schedule. To calculate the amount of the principal repaid within the $13,586.80 paid in period 8, we could use the formula: Select one: O a. E-PPMT(rate,per,nper, pv, [fv], [type]) O b. =CUMINT (rate, nper,pv,start_period,end_period, type) C. =-CUMIPMT(rate,nper,pv,start_period, end_period, type) O d. =RATE(rate, nper,pv,start_period, end_period, type)
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