Question

In: Finance

Construct the amortization schedule for a $15000 debt that is to be amortized in 10 quarterly...

Construct the amortization schedule for a $15000 debt that is to be amortized in 10 quarterly payments at 3% interest per quarter on the unpaid balance.

Solutions

Expert Solution

Quarterly Loan Payment

Loan Amount (P) = $15,000

Quarterly Interest Rate (n) = 3.00% per Quarter

Number of period (n) = 10 Quarters

Quarterly Loan Payment = [P x {r (1+r)n} ] / [( 1+r)n – 1]

= [$15,000 x {0.03 x (1 + 0.03)10}] / [(1 + 0.03)10 – 1]

= [$15,000 x {0.03 x 1.343916}] / [1.343916 – 1]

= [$15,000 x 0.040317] / 0.343916

= $1,758.46 per Quarter

Quarter

Beginning Loan Amount

Quarterly Payment

Interest Paid at 3%

Repayment of Principal

Ending Loan Balance

1

15,000.00

1,758.46

450.00

1,308.46

13,691.54

2

13,691.54

1,758.46

410.75

1,347.71

12,343.83

3

12,343.83

1,758.46

370.31

1,388.15

10,955.68

4

10,955.68

1,758.46

328.67

1,429.79

9,525.89

5

9,525.89

1,758.46

285.78

1,472.68

8,053.21

6

8,053.21

1,758.46

241.60

1,516.86

6,536.34

7

6,536.34

1,758.46

196.09

1,562.37

4,973.97

8

4,973.97

1,758.46

149.22

1,609.24

3,364.73

9

3,364.73

1,758.46

100.94

1,657.52

1,707.22

10

1,707.22

1,758.46

51.22

1,707.22

0.00


Related Solutions

complete an amortization schedule for the following loan. the loan is $100,000 at 3.5% interest, amortized...
complete an amortization schedule for the following loan. the loan is $100,000 at 3.5% interest, amortized on a YEARLY basis over five (5) years.
Set up an amortization schedule that amortizes $500,000 with 5 years of cyclical quarterly payments. The...
Set up an amortization schedule that amortizes $500,000 with 5 years of cyclical quarterly payments. The annual interest rate is 6%. The Payment Schedule is:one-third normal payments at the end of quarter 1, normal payments at the end of quarters 2 and 3, and 50% of a normal payment at the end of quarter 4
Set up an amortization schedule that amortizes $500,000 with 5 years of cyclical quarterly payments. The...
Set up an amortization schedule that amortizes $500,000 with 5 years of cyclical quarterly payments. The annual interest rate is 6%. The payment schedule is: " one-third a normal payment" at the end of quarter 1, "normal payments" at the end of quarters 2 and 3, and "50% of a normal payment" at the end of quarter 4. please solve in excel and list equations that go in the cells. Thank you :)
Amortization Schedule You will be creating an amortization schedule for a house on the market. To...
Amortization Schedule You will be creating an amortization schedule for a house on the market. To do so, you will need the principal amount, the interest rate, and the amount of years you will borrow the loan. The amount you put as a down payment is up to you, but it can range from a minimum of 3.5% for an FHA loan or 5% for a traditional loan to a maximum of whatever. Traditionally you only need to go as...
Construct an amortization schedule that includes all the required information and illustrate the relationship between the...
Construct an amortization schedule that includes all the required information and illustrate the relationship between the elements in this schedule.
5. Construct an amortization schedule for the mortgage. If the Halls would pay extra payment of...
5. Construct an amortization schedule for the mortgage. If the Halls would pay extra payment of $150 a month starting 49th month, how quickly will they able to payoff the mortgage? Be sure to have a zero balance at the end of amortization. Loan Amount 180,576 Loan Length in months 240 Interest (APR) 4.250% Total interest payment Hint: Be sure to compute the total interest payments using "Sum()" function. Prepayment $150 Total # of pmts with prepay With the prepayments,...
Construct an amortization schedule for a loan with the following characteristics. Loan amount = $10,000; term...
Construct an amortization schedule for a loan with the following characteristics. Loan amount = $10,000; term = 5 years; interest rate = 8 percent; annual payments.
AMORTIZATION SCHEDULE a. Complete an amortization schedule for a $25,000 loan to be repaid in equal...
AMORTIZATION SCHEDULE a. Complete an amortization schedule for a $25,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 8% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $ $ $ $ $ 2 3 b. What percentage of the payment represents interest and what percentage represents principal for each of the three years? Round all...
1A) Construct a loan amortization schedule for a 15 year, 7.75% loan of $10,000,000. The loan...
1A) Construct a loan amortization schedule for a 15 year, 7.75% loan of $10,000,000. The loan requires equal, end-of-year paymens, and interest compounded monthly. b) what is the total amount of interest paid over the life of the loan? c) Assume that there is a balloon payment requirment after 10 years. What is the balloon payment in section a?
Construct an amortization schedule for a four-year, RM10,000 loan at 6% interest compounded annually.
Construct an amortization schedule for a four-year, RM10,000 loan at 6% interest compounded annually.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT