Question

A $10000 loan has an interest rate of 12% per year, compounded monthly, and 30 equal monthly payments are required.

a) If payments begin at the end of the first month, what is the value of each payment?

b) How much interest is in the 10th payment?

c) What would you enter into Excel to solve part b?

d) What is the unpaid balance immediately after the 10th payment?

e) If the 30 loan payments are deferred and begin at the end of month 6, how much interest is in the first payment?

Answer #1

Loan = $10000, interest rate = 12% per year, compounded monthly, (monthly rate = 1%) and number of monthly payments = 30

a) If payments begin at the end of the first month, what is the value of each payment?

A = 10000(A/P, 1%, 30) = 10000*0.038748 = $387.48

b) How much interest is in the 10th payment?

Interest in 10th payment = 387.48(P/A, 1%, 30 - 10 + 1)i% = 387.38*18.856983*1% = 73.05

c) What would you enter into Excel to solve part b?

= PV(1%,21,-387.48)*0.01

d) What is the unpaid balance immediately after the 10th payment?

Balance = A(P/A, i%, N – n) = 387.48*(P/A, 1%, 30 - 10) = 387.48*18.04555 = $6992.29

A loan of $ 10000 is to be repaid in 30 equal monthly
installments with the first one paid seven months after the loan is
made. The nominal annual interest rate is 6 % compounded quarterly.
Determine the amount of the monthly payment.
Please show detailed process

A young couple take out a 30-year home mortgage of $145,000.00
at 6.9% compounded monthly. They make their regular monthly payment
for 7 years, then decide to up their monthly payment to
$1,200.00.
a) What is the regular monthly payment? $
b) What is the unpaid balance when they begin paying the
accelerated monthly payment of $1,200.00? $
c) How many monthly payment of $1,200.00 will it take to pay off
the loan? payments d) How much interest will this...

3. You take a $500,000 mortgage to buy a vacation home. The
mortgage entails equal monthly payments for 10 years, 120 payments
in all, with the first payment in one month. The bank charges you
an interest rate of 9.6% (APR with monthly compounding).
a. How much of your first payment is interest, and how much is
repayment of principal?
b. What is the loan balance immediately after the 10th payment?
(Calculate the loan balance using the annuity formula.)
c....

Clark and Lana take a 30-year home mortgage of $129,000 at 7.8%,
compounded monthly. They make their regular monthly payments for 5
years, then decide to pay $1400 per month.
(a) Find their regular monthly payment. (Round your answer to
the nearest cent.) the answer is $ 928.63
(b) Find the unpaid balance when they begin paying the $1400.
(Round your answer to the nearest cent.) the answer is $
122,411.73
(c) How many payments of $1400 will it take...

A man borrows $120,000 to buy a home. The interest rate is 4.1%,
compounded monthly, and the loan period is 30 years. a) What will
be the monthly payment (360 equal payments) for the life of the
loan? b) What will be the effective annual interest rate, ieff ? c)
How much of the first payment will be interest? d) How much of the
fiftieth (50th) payment will be interest? [Try not to put problem
on a spreadsheet to find...

A manufacture borrows P2,843,737 with interest at 8%
compounded monthly, and agrees to discharge the loan by a sequence
of equal monthly payments for 5 years with the first payment at the
beginning of the 4th year. Find the periodic payment.
DEFERRED ANNUITY.

John borrowed $84,000 at 9.60% compounded monthly He agreed to
repay the loan in equal monthly payments over a 15 year
amortization term.
(a) What is the size of the monthly payment? Enter answer to 2
decimal places
For parts (b),(c) and (d) DO NOT round the monthly payments
but use exact results as found in your calculator. Nevertheless
enter answers you find in each answer box to 2 decimal
places.
(b) How much of the 22nd payment is interest?...

A business owner arranges for a start up loan for $163100 where
the first payment will be deferred for 2 years. After that he will
make equal payments for 2 more years until the loan is paid off.
The bank is charging him 7% per year compounded monthly.
a. How much will he owe at the end of two years?
$
b. How much of his ballance at the end of two years represents
unpaid interest? $
c. What are...

Consider a 30-year mortgage with an interest rate of 10%
compounded monthly and a monthly payment of $850. Cannot use excel
must be equation based . If principal is 96,858.20 than....How much
of the principal is paid the first, 5th, 20th and last year

Loan of $10000 with interest at j4 = 12%, is to be amortized by
equal payments at the end of each quarter over a period of 30
quarters. Using the Retrospective Method, Determine the outstanding
balance at the end of 12 quarters

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 11 minutes ago

asked 11 minutes ago

asked 17 minutes ago

asked 25 minutes ago

asked 28 minutes ago

asked 29 minutes ago

asked 29 minutes ago

asked 31 minutes ago

asked 32 minutes ago

asked 32 minutes ago

asked 35 minutes ago

asked 46 minutes ago