Question

In: Accounting

The interest rate for the first five years of a $27,000 mortgage loan was 3.25% compounded...

The interest rate for the first five years of a $27,000 mortgage loan was 3.25% compounded semiannually. The monthly payments computed for a 10-year amortization were rounded to the next higher $10. (Do not round intermediate calculations and round your final answers to 2 decimal places.)

a.

Calculate the principal balance at the end of the first term.

  Principal balance $   

    

b.

Upon renewal at 5.75% compounded semiannually, monthly payments were calculated for a five-year amortization and again rounded up to the next $10. What will be the amount of the last payment?

  Final payment $   

Solutions

Expert Solution

Dates

Replaced the values in

The pay montlhy is rounded to the next 10$ more nearest, so

R=260$

End of month

Interest charged

Payment made R

Payment toward principal

Oustanding principal

0

25000$

1

135

260

125

24875

Month 1

Calcule Interest charged

Calcule Payment toward l

Calculate Oustanding principal

Repeat the same calculations until reaching 5 years (60 months),and obtained the next table

End of month

Interest charged

R

Payment Towart

Oustanding principal

1

135

260

125

24875

2

134,325

260

125,675

24749,325

3

133,646355

260

126,353645

24622,97136

4

132,9640453

260

127,0359547

24495,9354

5

132,2780512

260

127,7219488

24368,21345

6

131,5883526

260

128,4116474

24239,8018

7

130,8949297

260

129,1050703

24110,69673

8

130,1977624

260

129,8022376

23980,8945

9

129,4968303

260

130,5031697

23850,39133

10

128,7921132

260

131,2078868

23719,18344

11

128,0835906

260

131,9164094

23587,26703

12

127,371242

260

132,628758

23454,63827

13

126,6550467

260

133,3449533

23321,29332

14

125,9349839

260

134,0650161

23187,2283

15

125,2110328

260

134,7889672

23052,43934

16

124,4831724

260

135,5168276

22916,92251

17

123,7513815

260

136,2486185

22780,67389

18

123,015639

260

136,984361

22643,68953

19

122,2759235

260

137,7240765

22505,96545

20

121,5322134

260

138,4677866

22367,49767

21

120,7844874

260

139,2155126

22228,28215

22

120,0327236

260

139,9672764

22088,31488

23

119,2769003

260

140,7230997

21947,59178

24

118,5169956

260

141,4830044

21806,10877

25

117,7529874

260

142,2470126

21663,86176

26

116,9848535

260

143,0151465

21520,84661

27

116,2125717

260

143,7874283

21377,05919

28

115,4361196

260

144,5638804

21232,4953

29

114,6554746

260

145,3445254

21087,15078

30

113,8706142

260

146,1293858

20941,02139

31

113,0815155

260

146,9184845

20794,10291

32

112,2881557

260

147,7118443

20646,39106

33

111,4905117

260

148,5094883

20497,88158

34

110,6885605

260

149,3114395

20348,57014

35

109,8822787

260

150,1177213

20198,45242

36

109,071643

260

150,928357

20047,52406

37

108,2566299

260

151,7433701

19895,78069

38

107,4372157

260

152,5627843

19743,2179

39

106,6133767

260

153,3866233

19589,83128

40

105,7850889

260

154,2149111

19435,61637

41

104,9523284

260

155,0476716

19280,5687

42

104,115071

260

155,884929

19124,68377

43

103,2732924

260

156,7267076

18967,95706

44

102,4269681

260

157,5730319

18810,38403

45

101,5760738

260

158,4239262

18651,9601

46

100,7205846

260

159,2794154

18492,68069

Related Solutions

The interest rate for the first three years of an $86,000 mortgage is 7.4% compounded semiannually....
The interest rate for the first three years of an $86,000 mortgage is 7.4% compounded semiannually. Monthly payments are based on a 20-year amortization. Suppose a $4500 prepayment is made at the end of the sixteenth month.    a. How much will the amortization period be shortened? The amortization period will be shortened by  months.     b. What will be the principal balance at the end of the three-year term? (Round your answer to the nearest cent.)
A fully amortizing mortgage loan is made for $90,000 for 15 years. The interest rate is...
A fully amortizing mortgage loan is made for $90,000 for 15 years. The interest rate is 6 percent per year compounding monthly. Payments are to be made monthly. What is the principal payment in the first monthly payment?
Assume a mortgage loan amount of $ 400,000, with annual interest rate 4% and 15 years...
Assume a mortgage loan amount of $ 400,000, with annual interest rate 4% and 15 years term 1. Calculate annual payment amount 2. Calculate monthly payment amount 3. Do you pay more annually or monthly? Why? 4. Prepare a 180 month loan amortization schedule. How much is your total interest payment?
Assume a mortgage loan amount of $ 300,000, with annual interest rate 4% and 5 years...
Assume a mortgage loan amount of $ 300,000, with annual interest rate 4% and 5 years term 1. Calculate annual payment amount 2. Calculate monthly payment amount 3. Do you pay more annually or monthly? Why? 4. Prepare a 60 month loan amortization schedule. How much is your total interest payment?
A loan is for $600,000 (mortgage), 30 years monthly, 4% fixed rate interest. What is the...
A loan is for $600,000 (mortgage), 30 years monthly, 4% fixed rate interest. What is the payment, 5-year payoff, 5-year principal paid, and 5-year interest paid?
Consider a 30-year fixed-rate home loan of $545,500 with an interest rate of 3.25%. What is...
Consider a 30-year fixed-rate home loan of $545,500 with an interest rate of 3.25%. What is the total amount of interest paid? (Round your answer to the nearest cent.)?
Yassine took a loan of $6,744.29. The rate of interest is 5% compounded annually. The loan...
Yassine took a loan of $6,744.29. The rate of interest is 5% compounded annually. The loan is to be repaid by annual payments of $500 at the end of each year for 23 years. What is the outstanding balance of the loan after the third payment? ​
John has a level-payment mortgage loan with 12 years remaining, at an interest rate of 7%...
John has a level-payment mortgage loan with 12 years remaining, at an interest rate of 7% with a payment of $1,000/monthly. John's mortgage balance is:
A loan is amortized over five years with monthly payments at an annual nominal interest rate...
A loan is amortized over five years with monthly payments at an annual nominal interest rate of 6% compounded monthly. The first payment is 1000 and is to be paid one month from the date of the loan. Each succeeding monthly payment will be 3% lower than the prior payment. Calculate the outstanding loan balance immediately after the 40th payment is made.
A loan of 11000 is made with interest at a nominal annual rate of 12% compounded...
A loan of 11000 is made with interest at a nominal annual rate of 12% compounded monthly. The loan is to be repaid by 36 monthly payments of 367.21 over 37 months, starting one month after the loan is made, there being a payment at the end of every month but one. At the end of which month is the missing payment? For your reference, the answer is at the 17th month.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT