Create the amortization schedule for a loan of $11,000, paid
monthly over three years using an...
Create the amortization schedule for a loan of $11,000, paid
monthly over three years using an APR of 9 percent. Enter the data
for the first three months. (Round your answers to 2
decimal places.)
Create the amortization schedule for a loan of $11,000, paid
monthly over three years using an APR of 9 percent. Enter the data
for the first three months. (Round your answers to 2
decimal places.)
Month
Beginning Balance
Total Payment
Interest Paid
Principal Paid
Ending Balance
1
2
3
Create the amortization schedule for a loan of $4,300, paid
monthly over two years using an 9 percent APR. (Round your
answers to 2 decimal places.)
Month
Beginning
Balance
Total
Payment
Interest
Paid
Principal
Paid
Ending
Balance
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Create the amortization schedule for a loan of $5,400, paid
monthly over two years using an APR of 10 percent. Enter the data
for the first three months.
Month
Beginning Balance
Total Payment
Interest Paid
Principal Paid
Ending Balance
1
2
3
Problem 5-50 Amortization Schedule (LG9)
Create the amortization schedule for a loan of $4,300, paid
monthly over two years using an 9 percent APR. (Round your
answers to 2 decimal places.)
Month Beginning
Balance Total
Payment Interest
Paid Principal
Paid Ending
Balance
1
2
3
4
5
6
7 ...
Problem 5-49 Amortization Schedule (LG9)
Create the amortization schedule for a loan of $14,000, paid
monthly over three years using a 9 percent APR. (Round your
answers to 2 decimal places.)
Month
Beginning
Balance
Total
Payment
Interest
Paid
Principal
Paid
Ending
Balance
1
2
3
4
5
6
7...
Create a loan amortization schedule in Excell for a $275,000
mortgage that will be repaid over 20 years with
monthlypayments. The annual interest
rate is 5.5 %.
What is your monthly payment? $
What is the total dollar amount of payments made over the life
of this loan? $__
What is the total dollar amount of interest paid over the life
of this loan? $_
How many months will it take to pay off the loan if you pay an
extra $100...
Loan Amortization:
A loan of $14 100.00 is amortized over 11 years by equal monthly
payments at
5.4% compounded monthly.
a) Find the outstanding balances after the payment 39 is
done.
b) Find the outstanding balances after the payment 129 is
done.
c) Find the amount of Final Payment and fill out the last
row.
Create a loan amortization schedule in excell for a $27,000 car
loan that will be repaid over 48 months at an
annual interest rate of 6%.
What is your monthly payment? _$_
What is the total dollar amount of payments made over the life
of this loan? $____
What is the total dollar amount of interest paid over the life
of this loan? $___________
How many months will it take to pay off the loan if you pay an
extra...
Prepare an amortization schedule for a three-year loan
of $24,000. The interest rate is 16 percent per year, and the loan
calls for equal principal payments.