Question

Earl obtained a loan for 15000 dollars. He will pay it back in 36 months with an interest rate of 14 yearly compounded monthly. Each payment will be $200 larger than the previous payment. Calculate the amount of the last payment.

Please show formulas and refrain from using excel. Thanks

Answer #1

**P = $15000**

**n = 36 months**

**i = 14/12 = 1.16**

**G = 200**

**P = (A' + 200(A/G,1.16,36)(P/A,1.16,36)**

15000 = [A' + 200(A/G,1.16,36)](P/A,1.16,36)

(A/G,1.16,36) = [(1/i) - [n / (1+i)^n - 1]] = [(1/0.0116) - [36 / (1+0.0116)^36 - 1]] = 1.2324

(P/A,1.16,36) = (1+i)^n - 1 / i * (1+i)^n = (1+0.0116)^36 - 1 / 0.0116 * (1+0.0116)^36 = 29.2922

15000 = [A' + 200(1.2324)](29.2922)

512.08 = A' + 246.48

A' = 265.6

The last payment = A' + 35G

The last payment = 265.6 + 35*200

**The last payment = $7265.6**

Sang just took out a loan from the bank for 67,668 dollars. He
plans to repay this loan by making a special payment to the bank of
29,855 dollars in 2 months and by also making equal, regular
monthly payments of X. If the interest rate on the loan is 1.35
percent per month, he makes his first regular monthly payment later
today, and he makes his last regular monthly payment made in 4
months from today, then what is...

Youssef just took out a loan from the bank for 78,090 dollars.
He plans to repay this loan by making a special payment to the bank
of 19,680 dollars in 2 months and by also making equal, regular
monthly payments of X. If the interest rate on the loan is 0.63
percent per month, he makes his first regular monthly payment later
today, and he makes his last regular monthly payment made in 4
months from today, then what is...

Jonathon takes out a cash loan of $12,000. He agrees to pay back
the loan with three payments as follows: $2,000 at the end of six
months, ($2,000 + Y) at the end of 10 months and ($2,000 +
2Y) at the end of 18 months. What is the value of
Y if
a) r = 6% and you use 8 months as the
focal date
b) d = 6% and you use 14 months as the
focal date
c) j4...

1) Jens just took out a loan from the bank for 79,702 dollars.
He plans to repay this loan by making a special payment to the bank
of 4,130 dollars in 4 years and by also making equal, regular
annual payments of X for 8 years. If the interest rate on the loan
is 12.57 percent per year and he makes his first regular annual
payment in 1 year, then what is X, Jens’s regular annual
payment?
2) Theo just...

If I borrow $80,000 in loans for college and have to pay back
the loan every month for 15 years after graduation. If the rate is
8%, what is the amount of my monthly loan payment?
Please explain to me how I would enter this information on Excel
and how I can solve it. Thank you!

Aftergraduation, you decide that you can pay $203.24 per month
extraon your student loan (standard monthly payment is 302.99),
which has a balance of $50,000 and 20 years of monthly payments
remaining. The annual interest rate on the loan is
4% How many yearsearly will you be able to pay off the
loan? Please show using excel formulas!!!!!!!

How long (in months) would it take to pay off a student loan
totaling $12,000 if a monthly payment of $300 is made each month
and the appropriate rate of interest is 4% annual rate
compound monthly?
Please show Step by step

Angelo Lemay borrowed $8000 from his credit union. He agreed to
repay the loan by making equal monthly payments for five years.
Interest is 9% compounded monthly.
(Please use financial BAII calculator method by showing
calculator inputs)
(a) What is the size of the monthly payments?
(b) How much will the loan cost him?
(c) How much will Angelo owe after 18 months?
(d) How much interest will he pay in his 36th payment?
(e) How much of the principal...

Amy Phillips needs to borrow $20,000 to purchase a new car. She
can get a 3 year loan from her bank with an interest rate of 7%
(compounded monthly). Calculate Amy's monthly payment.
Also how much interest (in dollars) will Amy pay over the life
of the loan?
Lastly, if Amy got a 5 year loan instead of a 3 year loan, how
much interest (in dollars) would she pay over the life of the
loan?
Answer using formulas -...

You are planning to purchase a house for $180,000. You will pay
20% down payment and take a mortgage loan for the remaining 80%.
You could get a 3/1 ARM amortized over 15 years at 3.9 % or a fixed
15 year FRM loan at 5.3%. The expected interest rate of the ARM
from years 4 to 5 is 7.5%. You will live in the house for five
years, and after that you expect to sell the house for $200,000...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 1 minute ago

asked 11 minutes ago

asked 11 minutes ago

asked 14 minutes ago

asked 29 minutes ago

asked 30 minutes ago

asked 32 minutes ago

asked 56 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago