Question: Refer to the below amortisation schedule. A B D E 1 n 10 2 Period Interest Rate, i 6.00% End-of- Beginning-of- period 3 Period period

Refer to the below amortisation schedule. A B D E 1

Refer to the below amortisation schedule. A B D E 1 n 10 2 Period Interest Rate, i 6.00% End-of- Beginning-of- period 3 Period period Balance Interest Repayment Balance 4 1 $ 100,000 $ 6,000.00 -$13,586.801 $ 92,413 5 2 $ 92,413$ 5,544.79 -$13,586.80 $ 84,371 6 3 $ 84,371 $ 5,062.27 -$13,586.80 $ 75,847 7 4 $ 75,847 $ 4,550.80 -$13,586.80 $ 66,811 8 50 $ 66,811 $ 4,008.64 -$13,586.80 $ 57,233 9 6 $ 57,233 $ 3,433.95 -$13,586.80 $ 47,080 10 7 $ 47,080 $ 2,824.78 -$13,586.80 $ 36,318 11 8 $ 36,318 $ 2,179.06 -$13,586.80 $ 24,910 12 9 $ 24,910 $ 1,494.60 - $13,586.80 $ 12,818 13 100 $ 12,818$ 769.06 -$13,586.80|-$ 0 To enter the repayment amount in cell D4, before it is copied down to cells D5 to D13, we are best to input: Select one: O A. =PMT(C$2,C$1,B4) O B. =PMT(C$2,C$1,B$4) O C. EPMT(C1,C2,B4) O D. =IPMT(C2,C1,B4)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Refer to the below amortisation schedule. A B D E 1 n 10 2 Period Interest Rate, i 6.00% End-of- Beginning-of- period 3 Period period Balance Interest Repayment Balance 4 1 $ 100,000 $ 6,000.00...

A B D E 1 n 10 2 Period interest Rate, 6.00% End-of- Beginning of period 3 Period period Balance Interest Repayment Balance 4 11 $ 100,000 $ 6,000.00 - $13,586.80 $ 92,413 5 2 $ 92,413$ 5,544.79...

. Refer to the below amortisation schedule. A B C D E n 10 2 Period Interest Rate, i 6.00% End-of- Beginning-of- period 3 Period period Balance Interest Repayment Balance 4 1 $ 100,000 $ 6,000.00...

Refer to the below amortisation schedule. A B D E 2 1 n 10 2 Period interest Rate, i 6.00% End-of- Beginning-of- period 3 Period period Balance Interest Repayment Balance 4 1 $ 100,000 $ 6,000.00...

B 1 n 10 2 Period Interest Rate, 6.00% End of Beginning of period 3 Period period Balance Interest Repayment Balance 4 1 $ 100,000 $ 6,000.00 $13,586.80 $ 92,413 5 2 92,413 $ 5,544.79$13,586.80 $...

Could I please get some help with the forms below? B D E M N 0 P Month Interest Investment Value 1 $0 $0 9 $0 $0 10 $0 $0 11 $0 $0 12 $0 $0 Month 1 9 Interest Investment Value $0 $0 $0 $0 10 $0 $0 11...

use question 4 and data for question 4 to answer question 6 em #4: Create a table on a spreadsheet with columns labelled "Count", "Date". "Interest this period", and "Total". As depicted below A B D...

need help on part 2 ! which is cell 35 to 45 need to add the adjusted entries Journalize (in the order given above) and post the adjusting entries. A B TUI Tuias JCL UP III LIIC waianice CUIUIJ anu...

if you could please help me solve this excel exercise yes this is excel D3 B D E F G Personal Investments 1 Growth Rate 2 Investment Fund 3. Treasury Bond 4 Corporate Bond 5 Domestic Dividend 6. Mid...

A B D E w N 4 3 3 Shadow Box Photo Studio, Inc. went into business as a corporation in early 2018. For the first few years, the company provided photography services only (no merchandise). During...

What is aging of accounts receivable?

The following are working in JOHN company on weekly basis on claims code 2 basis in Ontario. Employee Hours Worked C. White J. Wozowski K. Hurt M. Khan 44 46 39 42 1. Gross pay of each worker 2. CPP...

? _ i s l i q u i d i t y r a t i o : i n g e n e r a l t h e i n t e n t o f l i q u i d i t y r a t i o s i s t o a s s e s s _ _ _

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...