1 A 1 n 2 Period Interest Rate, i 3 Period 4 5 6 7 8...

 

Transcribed Image Text:

1 A 1 n 2 Period Interest Rate, i 3 Period 4 5 6 7 8 9 10 11 12 13 B C Select one: 10 6.00% Beginning-of- period Balance Interest 1 $ 100,000 $6,000.00 2 $ 3 $ 4 $ 5 $ 6 $ D E End-of- period Balance 7 $ 8 $ 9 $ 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: Repayment -$13,586.80 $ 92,413 92,413 $5,544.79 -$13,586.80 $ 84,371 84,371 $5,062.27 -$13,586.80 $ 75,847 75,847 $4,550.80-$13,586.80 $ 66,811 $4,008.64 -$13,586.80 $ 57,233 66,811 57,233 $3,433.95 -$13,586.80 $ 47,080 47,080 $2,824.78 -$13,586.80 $36,318 36,318 $2,179.06 -$13,586.80 $ 24,910 24,910 $ 1,494.60 -$13,586.80 $ 12,818 0 a. =-PPMT (rate,per,nper, pv,[fv],[type]) b. CUMINT (rate,nper, pv,start_period,end_period,type) c. =-CUMIPMT (rate,nper,pv,start_period,end_period, type) d. =RATE (rate,nper,pv,start_period,end_period,type) 1 A 1 n 2 Period Interest Rate, i 3 Period 4 5 6 7 8 9 10 11 12 13 B C Select one: 10 6.00% Beginning-of- period Balance Interest 1 $ 100,000 $6,000.00 2 $ 3 $ 4 $ 5 $ 6 $ D E End-of- period Balance 7 $ 8 $ 9 $ 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: Repayment -$13,586.80 $ 92,413 92,413 $5,544.79 -$13,586.80 $ 84,371 84,371 $5,062.27 -$13,586.80 $ 75,847 75,847 $4,550.80-$13,586.80 $ 66,811 $4,008.64 -$13,586.80 $ 57,233 66,811 57,233 $3,433.95 -$13,586.80 $ 47,080 47,080 $2,824.78 -$13,586.80 $36,318 36,318 $2,179.06 -$13,586.80 $ 24,910 24,910 $ 1,494.60 -$13,586.80 $ 12,818 0 a. =-PPMT (rate,per,nper, pv,[fv],[type]) b. CUMINT (rate,nper, pv,start_period,end_period,type) c. =-CUMIPMT (rate,nper,pv,start_period,end_period, type) d. =RATE (rate,nper,pv,start_period,end_period,type)

Answer rating: 100% (QA)

The detailed answer for the above question is provided below The correct an... View the full answer