Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Distressed Investment Banking To The Abyss And Back

Authors: Peter S Kaufman, Henry F Owsley

2nd Edition

1587983044, 978-1587983047

More Books

Students also viewed these Finance questions