Question

draw a timeline, show the formula, and include your calculator inputs.

What will the monthly payment be on a $250,000 loan, assuming the nominal rate of interest is 6% and the loan will be repaid over a period of 15 years? Assume the first payment will be made one month from today

Answer #1

**EMI = $**2109.64

**_________________________________________________________________**

If the loan amount is P, rate on interest (monthly is r, and loan term is n the EMI will be

EMI = P*r[(1 +r)^n]/ [(1+ r)^n- 1]

Where,

Loan amount (P) = $250000

Time (n) = 180 Period

Interest rate [r] = 0.5% /Period

Let's put all the values in the formula to calculate EMI

EMI = 250000*0.005[(1+0.005)^180]/ [(1+ 0.005)^180- 1]

= 1250[(1.005)^180]/ [(1.005)^180- 1]

= 1250[2.4540935622]/ [2.4540935622- 1]

= 1250[2.4540935622]/ [1.4540935622]

= 1250[1.68771365611923]

= 2109.64

Order these loans from highest monthly payment to lowest monthly
payment. (Enter 1 as your answer to designate loan with highest
payment, 2 as loan with second highest payment, and so on up to 5
to designate loan with lowest payment.) Each of the following loans
is for $300,000 and is a fixed rate mortgage with a 3.5% interest
rate. Assume 30 years.
Balloon payment of $500,000 is due at maturity
Balloon payment of $250,000 is due at maturity
The...

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

I need the EXCEL formula for the following questions,
please.
What is the formula to calculate how much a savings account
would be worth if the initial balance is $1,000 with monthly
deposits of $75 for 10 years at 4.3% annual interest compounded
monthly? What is the formula result?
You want a savings account to grow from $1,000 to $5,000 within
two years. Assume the bank provides a 3.2% annual interest rate
compounded monthly. What is the formula to calculate...

Tom has taken out a 9-year mortgage for $450,000.00 that
requires you to make a payment every month with the first payment
being made exactly one month from now. The interest rate is fixed
at 3.2 percent for the first three years if compounded monthly.
a. What is the initial monthly
payment?
b. Immediately after the fixed-rate
period expires, the loan interest rate increases to 4.65%. What is
the new monthly payment (assume that the loan fully amortizes over
the...

Please show your steps for each part of the
problem, and if a calculator was used, list the
button combination pressed in order to arrive at
your answer!
a. Jack and Jill are twins and at 20 years of
age they both opened separate investment accounts with an on online
broker. Jack started investing $50 a month starting from today.
Jill will save $55 a month starting at the end of the month. if
this investment account gives them 8%...

You obtain a $95.000 home loan for 15 years at 5.1% interest
compounded monthly. If you made the first payment was made on
August 15, 2009, how much interest will be paid in the year 2014?
DO NOT USE EXCEL TO RESPOND TO THIS QUESTION. USE THE FORMULA FOR
EACH STEP AND SHOW WORK.

A loan of $100,000 is made today. The borrower will make equal
repayments of $1231 per month with the first payment being exactly
one month from today. The interest being charged on this loan is
constant (but unknown). For the following two scenarios, calculate
the interest rate being charged on this loan, expressed as a
nominal annual rate compounding monthly. Give your answer as a
percentage to 2 decimal places.
(a) The loan is fully repaid exactly after 180 monthly...

On 1st January 2020, a loan was issued and it was
amortized over 20 years with monthly payments at a nominal interest
rate of 8.4% compounded monthly. The first payment was paid on 1st
February 2020. The loan is structured in such a way that the first
120 installments will be paid in equal installments of N$6000 and
the next 120 installments will be paid in such a way that each
succeeding monthly payment will be 3% lower than the...

Car Payment related
Loan Amount: 80000 (Cell A3)
Interest Rate: 4.5% per
year (Cell B3)
Years of the loan: 6 years (Cell
B5)
What is the formula to figure out the monthly payment? (Show
formula first, then when you hit enter, you should see the monthly
payment amount.) (2 points)
What is the first pay periodâ€™s Principle and Interest
payment? (Show formula first, then when you hit enter,
you should see the Principle and Interest amounts. (4
points)

Question 1
Jack took a $ 5,000 loan, which he repaid in
monthly installments over seven
months. Payments were always made at the end of
the month (each payment month was 1/12 part of the year)
so that the first repayment was made 4 months after the loan was
drawn down. Each equal installment consisted of an installment of
the loan amount of $ 5,000 / 7 and an interest component of $ 30
and an account management fee of...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 28 seconds ago

asked 1 minute ago

asked 3 minutes ago

asked 8 minutes ago

asked 8 minutes ago

asked 10 minutes ago

asked 11 minutes ago

asked 14 minutes ago

asked 14 minutes ago

asked 14 minutes ago

asked 22 minutes ago

asked 22 minutes ago