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
ABC Bank made a loan to XYZ, Inc. at a rate of 5.04%, compounded monthly, payable...
ABC Bank made a loan to XYZ, Inc. at a rate of 5.04%, compounded monthly, payable in equal monthly payments over a 15 year period. This resulted in a loan payment of $1,585.76, the first payment of which occurred one month after the loan was issued. XYZ, Inc. made payments over a period of 7 years and decided to refinance the loan because of lower interest rates. Assume the refinance was based on the remaining 8 years of the loan...
Using the Mortgage Payment Formula, calculate a monthly mortgage payment for a home with the price...
Using the Mortgage Payment Formula, calculate a monthly mortgage payment for a home with the price of $405,000 using pencil and paper. Your down payment is 10% of your own money apart from the loan. Calculate the total paid for your home after paying the monthly payment for 15 years factoring in the rate of 2.500% and APR of 2.556%. You can use arithmetic. How much money will you pay in interest over 15 years? All Calculations must be shown.
Be sure to show step by step explanation by using inputs ( NV, I,pmt,Fv,I/y) financial calculator...
Be sure to show step by step explanation by using inputs ( NV, I,pmt,Fv,I/y) financial calculator In a fixed-term, level-payment reverse mortgage, sometimes called a reverse annuity mortgage, or RAM, a lender agrees to pay the homeowner a monthly payment, or annuity, and expects to be repaid from the homeowner's equity when he or she sells the home or obtains other financing to pay off the RAM. Consider a household that owns a $150,000 home free and clear of mortgage...
Today, Malorie takes out a 20-year loan of $200,000, with a fixed interest rate of 5.0%...
Today, Malorie takes out a 20-year loan of $200,000, with a fixed interest rate of 5.0% per annum compounding monthly for the first 3 years. Afterwards, the loan will revert to the market interest rate. Malorie will make monthly repayments over the next 20 years, the first of which is exactly one month from today. The bank calculates her current monthly repayments assuming the fixed interest rate of 5.0% will stay the same over the coming 20 years. (c) Calculate...
Create a formula using the PMT function to calculate the monthly loan payment using interest rate...
Create a formula using the PMT function to calculate the monthly loan payment using interest rate and loan period values in cells C4:C8. Enter the formula with a - (negative) sign to return positive value. Do not specify values for the optional arguments fv or type. Loan amount: $1,000,000 Interest Rate APR- 5.0% Monthly Interest Rate- 0.4% Payment periods (years)- 5 Period (months)- 60
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...
Using the Mortgage Payment Formula, calculate a monthly mortgage payment for a home with the price...
Using the Mortgage Payment Formula, calculate a monthly mortgage payment for a home with the price of $405,000 using pencil and paper. Your down payment is 10% of your own money apart from the loan. Calculate the total paid for your home after paying the monthly payment for 30 years factoring in the rate of 2.990%. You can use arithmetic. How much money will you pay in interest over 30 years? All Calculations must be shown.