Question

draw a timeline, show the formula, and include your calculator inputs. What will the monthly payment...

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

Homework Answers

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

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Order these loans from highest monthly payment to lowest monthly payment. (Enter 1 as your answer...
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...
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...
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...
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,...
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...
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...
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...
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...
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...
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
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT