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

A B D E 1 n 10 2 Period interest Rate,

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 -$13,586.80 $ 84,371 6 31 $ 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 10 $ 12,818$ 769.06 -$13,586.801-$ 0 Refer to the above loan amortisation schedule. To calculate the amount of the principal repaid between end of period 4 and end of period 5, we could use the formula: Select one: a. =CUMINT (rate,nper,pv,start_period, end_period, type) b. --CUMIPMT(rate,nper,pv,start_period,end_period, type) C. =E7-E8 d. = $B4-$E8

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

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

n Refer to the below amortisation schedule. B D E 1 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...

************** Please help if you could somehow do this i will definitely rate, Thank you ****************** Hampton Machine Tool Company The questions for the Hampton Machine Tool Company are given...

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

Could someone please help me with the time value of money? I don't know how to fill out the form below with the financial statements. B D E M N 0 P Month Interest Investment Value 1 $0 $0 9 $0 $0 10...

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

On January 1, 20X4, CharmsCorporation sold 10% bonds having a maturity value of $700,000. The market determined that 12% was the appropriate rate of interest, given the risks that...

An electron is accelerated so that is kinetic energy is greater than its rest energy moc2 factor of (a) 5.00, (b) 999. What is the speed of the electron in each case?

Given the initial amounts listed, what is the limiting reagent, and what is the mass of the leftover reagent? MgO(s) + H2S(g) Mg S(s) + H,0(f) 227g 17.9

The audit risk model includes the four risks listed below. Match the type of risk with the related definition. A . Detection risk B . Control risk C . Inherent risk D . Audit risk Risk Definition: _...

After 30 years of service you have decided to retire from your current position as a manager of a well-known retail chain store. One of your last assignment is to mentor one of the departmental...

The Goals of Persuasive Speaking Developing a Persuasive Topic and Thesis

Explain three forms of rhetorical proof: ethos, logos, and pathos Identify the logical fallacies, deceptive forms of reasoning Choose an appropriate organizational strategy for your speech?

5. Have you stressed the topics relevance to your audience?