Question

A bank just approved your small business loan for $20,000. The loan has an interest rate of 9.0% and will be repaid with 10 end-of-year payments. What is the required annual loan payment?

a. $2,980.59

b. $3,116.40

c. $3,981.65

d. $4,271.33

e. $3,254.91

Halfway through the loan's life, what is the loan’s remaining balance?

a. $17,513

b. $13,339

c. $15,288

d. $12,122

e. $11,901

What percentage of the total payments made during the first five years will be made toward interest?

a. 45.66%

b. 51.22%

c. 49.44%

d. 52.93%

e. 41.53%

Answer #1

**1]**

Required annual loan payment is calculated using PMT function in Excel

rate = 9%

nper = 10

pv = 20,000

PMT is calculated to be $3116.40

**2]**

The cumulative principal repaid after 5 payments are completed is calculated using CUMPRINC function in Excel

rate = 9%

nper = 10

pv = 20000

start period = 1

end period = 5

type = 0 (since payments are made at the end of each year)

CUMPRINC is calculated to be $7878.28.

balance remaining on loan = $20,000 - $7,878.28 = $12,121.72

**3]**

The total interest paid after 5 payments are completed is calculated using CUMIPMT function in Excel

rate = 9%

nper = 10

pv = 20000

start period = 1

end period = 5

type = 0 (since payments are made at the end of each year)

CUMIPMT is calculated to be $7,703.73

% paid towards interest = $7,703.73 / ($3,116.40 * 5) = 49.44%

A bank makes a loan of 20,000 at an interest rate of
i.
The loan will be repaid with level payments at the end of each
year for 20 years.
When the bank receives each payment, it reinvests at a rate of
5%.
At the end of the 20 year period, the bank calculates the annual
effective return over the loan period to be 6.5%.
What is i, the original interest rate on the loan?

A business that owns a chain of restaurants needs to borrow
$20,000 to remodel one of it's establishments. A loan of $20,000
was offered for a term of 24 months. The business must make
payments of $1118 per month.
Please format percentage rate as decimals. Format to five
decimal places. 0.00000 VERY IMPORTANT TO FORMAT CORRECTLY, DO NOT
ROUND
a. Determine the loan's monthly interest rate. _____________
b. Determine the loan's annual effective interest rate.
______________

You borrowed $20,000 from a bank at an
interest rate of 12%, compounded monthly.
This loan will be repaid in 60 equal monthly
installments over 5 years. Immediately after
your 30th payment if you want to pay the
remainder of the loan in a single payment, the
amount is close to:

You have just arranged for an eight-year bank loan for
$350,000 at an interest rate of 12% p.a.
with interest compounded semi-annually. The loan will be
repaid in 16 equal semi-annual
installments and the first payment will be due six months from
today. Assuming end-of-theperiod
cash flows, the interest paid in period 2 will be closest
to:
a) $13,633.
b) $14,451.
c) $20,182.
d) $21,000.

A borrower is approved for a $80,000 mortgage loan at
12% interest with monthly payments over 30 years. The borrower is
required to pay 3.5 points.
PART A- Assume that monthly payments begin in one month.
What will each payment be?
a $822.89
b. $800.00
c. $794.09
d. $842.58
e. $876.85
PART B- What will the outstanding balance of the loan be
after five years assuming you make the first 60 payments exactly on
time?
a $75,396
b. $75,957
c....

Today you borrow $25,000 from your local bank. The stated
interest rate is 10%, compounded annually. It will be a 5 year
loan. You will pay back the loan at the end of each of the next
five years.
A) What will be your annual payment be for the next five years.
B) How much of your first payment is going toward interest?
C) What is the outstanding principle balance after you make the
first payment?
D) How much...

Diane d' Meetcha just closed a $50,000 business loan that is to
be repaid in 5 years with equal, annual, end-of-year payments. The
annual interest rate on the loan is 8%. Determine the annual
payment amount.

7. You just find your dream car and get an auto loan of $20,000
from a local bank. It requires fixed monthly payments over 5
consecutive years. The first monthly payment is due in one month.
If the interest rate on the auto loan is 8%, calculate your monthly
payment. (assume no down payment)
a. $326
b. $346
c. $366
d. $386
e. $406
8. Your local bank offers you a CD that if you deposit $1,000
today, you will...

Assume that today you borrow $25,000 from your local bank. The
stated interest rate is 10%, compounded annually. It will be a 5
year loan. You will pay back the loan at the end of each of the
next five years. Part A) What will be your annual payment be for
the next five years. Part B) How much of your first payment is
going toward interest? Part C) What is the outstanding principle
balance after you make the first...

You have just arranged a three-year bank loan for $200,000 at an
interest rate of 8% p.a. with interest compounded monthly. The loan
will be repaid in equal monthly instalments and the first payment
will be due one month from today. Assuming end-of-the-month cash
flows, the total interest paid in the second month will be closest
to:
$1,300.
$1,333.
$4,967.
$6,267.

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 2 minutes ago

asked 13 minutes ago

asked 31 minutes ago

asked 33 minutes ago

asked 37 minutes ago

asked 40 minutes ago

asked 43 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago