Question: 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

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 -$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 S 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 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 10 $ 12,818 $ 769.06 -$13,586.80 -$ To calculate the amount of the principal repaid from period 0 to period 5, we could use the formula: Select one: O A. =CUMINT (rate, nper, pv, start_period, end_period, type) O B. =-CUMIPMT(rate,nper,pv, start_period, end_period, type) O C. =RATE(rate,nper,pv,start_period, end_period, type) O D. =$B4-$E8 Clear my choice

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 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 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...

Dr.Ramsey Please assist me with my discussion post. Subject: Annuities Systematic risk evaluates the probability and extent of negative consequences to the larger body. For example, the government...

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 $...

can i get a solution to this question please. Value: Document (include your file name) 15% of final grade How to complete: 1. Read the following Anniversary Party scheduling problem: As the project...

Each section has excel with tabs at the bottom for assignments. P8-22A Correcting internal control weakness Each of the following situations has an internal control weakness. a. Upside-Down...

I have one more question on my unadjusted trial balance. My purchases are off and I am not sure how to fix this one. Final Project Peyton Approved Data You will prepare financial statements that will...

1) PREPARE the 2019 1040 TAX RETURN for Juan and Isabella Rodriguez. 2) Second Page: Attach WORKSHEETS listed in items 7, 8, 9, and 10 below. a. Third: Attach all Tax Return Forms in the following...

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...

On January 1, 2021, Gordon borrows $150,000 cash from a bank by signing a three-year installment note bearing 10% interest. The note requires equal payments of $60,316 each year on December 31....

Colonial Cookies, Inc., bakes cookies for retail stores. The companys best-selling cookie is chocolate nut supreme which is marketed as a gourmet cookie and regularly sells for $10.00 per pound. The...

The Tire Division of Trakker Company produces tires for off-road sport vehicles. One-third of Tire's output is sold to an internal division of Trakker; the remainder is sold to outside customers....

Simplify each of the following. (a) (2xy) (5xy) (10xy) (b) 8x*y (4x) 4xy X- (2xy) (3xy) (2xy)* (c) (d) 4xy8x*y (4xy)*(xy) (4xy)

The CS\&F quality team is investigating the composition of Uncle Jims fruit mixture. Each packet contains a mixture of four different flavoured sweets. The team examine four bags and count the numbers