Question

In: Finance

The following loan is fully amortizing. The loan is for $13,000 at 9% interest to be...

The following loan is fully amortizing. The loan is for $13,000 at 9% interest to be repaid over three (3) years. Amortize this loan on a monthly basis. Calculate the interest portion of the fourth (4th) payment considering that an additional payment of $2,000 was made with the second payment.

Solutions

Expert Solution


First calculate monthly payment:

Using financial calculator BA II Plus - Input details:

#

I/Y = Rate = 9/12 =

0.750000

FV = Future value =

$0

N = Total payment term = 12 x 3 Years =

                          36

PV = Present value of loan =

-$13,000

CPT > PMT = Monthly Payment =

$413.40

Amortization schedule:

Year

Beginning Balance

Payment

Interest

Repayment of principal

Additional payment

Ending balance

Y

OP

PMT

I = OP x 9%/12

AM = PMT - I

AP

CB = OP-AM-AP

1

$13,000.00

$413.40

97.50

$315.90

$12,684.10

2

12,684.10

$413.40

95.13

$318.27

$2,000.00

$10,365.84

3

10,365.84

$413.40

77.74

$335.65

$10,030.18

4

10,030.18

$413.40

75.23

338.17

$9,692.01

Interest portion of the fourth payment = $75.23


Related Solutions

The following loan is fully amortizing. The loan is for $13,000 at 10% interest to be...
The following loan is fully amortizing. The loan is for $13,000 at 10% interest to be repaid over three (3) years. Amortize this loan on a monthly basis. Calculate the interest portion of the fourth (4th) payment considering that an additional payment of $2,000 was made with the second payment.
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 $270,000 fully amortizing mortgage loan, which accrues interest at a 7.5% interest rate, and...
Assume a $270,000 fully amortizing mortgage loan, which accrues interest at a 7.5% interest rate, and has a maturity of 25 years. Payments are monthly. What is the payoff of the loan in 12 years?
A fully amortizing mortgage loan is made for $200,000 at 6 percent interest for 30 years....
A fully amortizing mortgage loan is made for $200,000 at 6 percent interest for 30 years. Payments are to be made monthly. (Ignore origination fee and other fees). a.      Using Excel, construct fully amortizing mortgage loan table including beginning balance, payment, interest, principal, and ending balance. (Please check your ending balance by using PV function in Excel) b.      Interest and principal payments during month 1. c.       Total Principal and total interest paid over 30 years. d.      The outstanding loan balance...
4. A $600,000 CPM fully amortizing loan is made, at a 4% interest rate compounded monthly,...
4. A $600,000 CPM fully amortizing loan is made, at a 4% interest rate compounded monthly, for a 30 year term. Loan comes with a charge of 5 points. What is the effective annual rate on the loan? *do work in EXCEL please*
16 years ago, a homeowner obtained a fully amortizing loan $120,000 at eight percent interest for...
16 years ago, a homeowner obtained a fully amortizing loan $120,000 at eight percent interest for 30 years. Mortgage rates have dropped, so that a fully amortizing 14-year loan can be obtained today at six percent interest. There is a two-percent prepayment penalty on the mortgage balance of the original loan. In addition, the new loan will charge 3 points, and other closing costs on the new loan will add an additional $125.00. All payments and compounding are monthly. What...
To finance the purchase of a new home, a homebuyer takes-out a fully amortizing loan in...
To finance the purchase of a new home, a homebuyer takes-out a fully amortizing loan in the amount of $500,000 at 9% interest per year, compounded monthly, for a term of 20 years. 1. What is the outstanding balance of the loan at the end of 5 years? 2. At the end of year 5, the market rate of interest is 6%. What is the market value of the loan at the end of 5 years? 3. If this loan...
A fully amortizing mortgage loan is made for $100,000 at 4.5% for 30 years. Payments will...
A fully amortizing mortgage loan is made for $100,000 at 4.5% for 30 years. Payments will be made monthly. Calculate the following: a. Monthly payments b. Interest and principal payments during month 1. c. Total interest and principal payments made over the life of the loan (30 years). d. If the property were sold at the end of year 15, how much is still owed on the mortgage? e. At the end of year 15, how much has been paid...
Given the following information on a 30-year fixed-payment fully amortizing loan, determine the owner’s equity in...
Given the following information on a 30-year fixed-payment fully amortizing loan, determine the owner’s equity in the property after seven years if the market value of the property is $240,000 at the end of year 7: rate: 7%; monthly payment: $1,200.
What are the major differences between the four CPM loans: Fully Amortizing: Partially Amortizing: Interest Only:...
What are the major differences between the four CPM loans: Fully Amortizing: Partially Amortizing: Interest Only: Negative Amortizing:
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT