Question

In: Finance

For a 30-year loan with a face value of $150,000, 5 percent annual interest, and monthly...

For a 30-year loan with a face value of $150,000, 5 percent

annual interest, and monthly payments, find the monthly

payment and remaining mortgage balance at the end of

years 5, 20, and 30

Solutions

Expert Solution

Remaining Mortgage balance at the end of

5years = $137,743.10

20years = $75,918.40

30Years = $0.

normal formula to calculate interest i.e. Opening balance*interest rate/12

Closing balance is net of Opening balance+Interest-Repayment.


Related Solutions

Find the monthly payment for a 25-year fixed-rate loan of $200,000 at 5% annual interest.
Find the monthly payment for a 25-year fixed-rate loan of $200,000 at 5% annual interest.
5. (a) What are the monthly payments on a 20-year, $200,000 loan having 6% annual interest,...
5. (a) What are the monthly payments on a 20-year, $200,000 loan having 6% annual interest, compounded monthly? Interest is computed based on the balance at the beginning of each month, and payments are made at the end of eachmonth. (b) How much must be deposited each month to achieve a balance of $200,000 at the end of 25 years, at 6% annual interest compounded monthly? Deposits are made at the beginning of each month, and interest is paid on...
A) For a loan of $160,000 at 7% annual interest, monthly payments, for 30 years, how...
A) For a loan of $160,000 at 7% annual interest, monthly payments, for 30 years, how much total interest will be paid over the life of the loan? Group of answer choices $279,785.00 $81,002.00 $223,214.00 $265,778.00 B) For a loan of $250,000 at 6% annual interest, with monthly payments over 15 years, if you pay an additional $100 in principle per month, how much total interest will you pay over the life of the loan? Group of answer choices $218,090.00...
The loan is for $150,000 with a rate of 6% for 30 years payable monthly. Calculate...
The loan is for $150,000 with a rate of 6% for 30 years payable monthly. Calculate the Monthly Payment (MP): Do a monthly Amortization Table for 4 months using the MP: Calculate the Loan Balance (LB) using the formula approach at the end of 4 months.
      4. Calculate the new monthly payment given a $150,000 loan for 6%, 30 years (monthly)...
      4. Calculate the new monthly payment given a $150,000 loan for 6%, 30 years (monthly) with a lump-sum pay down of $20,000 made after 12 years have lapsed. New MP: Calculate the upfront fees that needs to be charged by the lender given a loan for $150,000 with terms 6%, 30 years (monthly compounding). The lender wants to earn a 6.6% yield. Assume a holding period of 12 years. Calculate the total payments and total interest expense for a...
Consider a CPM loan in the amount of $150,000 with an interest rate of 4 percent...
Consider a CPM loan in the amount of $150,000 with an interest rate of 4 percent with a 15 year maturity. What will be the monthly payment on the loan? If this loan had a maturity of 25 years, what would be the monthly payment?
26.)What would be the monthly payment on a 5 year loan of $24,000 if the interest...
26.)What would be the monthly payment on a 5 year loan of $24,000 if the interest rate is 5.0% compounded montly? A. $452.91 B. $492.75 C. $377.42 D. $500.00 true or false: 27.)When doing a comparison of ratios for your company, the comparison probably should be with the industry average. 28.)When taking out a loan you would rather get an interest rate of 7% compounded monthly, instead of one compounded daily. 29.)Which of the following financial ratios are market-based ratios?...
With a 12-year loan of 13% annual interest rate compoundedmonthly, how much is the monthly...
With a 12-year loan of 13% annual interest rate compounded monthly, how much is the monthly loan payment of $841,590
Refinance decision: The original loan is for $150,000 with terms 6%, 30 years payable monthly. The...
Refinance decision: The original loan is for $150,000 with terms 6%, 30 years payable monthly. The elapsed time on the original loan is 5 years. The new loan rate is 3.6% which will be held 7 years. The cost of refinancing is $3,000. The opportunity cost is 9%. A. Prepare a table that calculates the change in monthly payment and change in Loan Balance numbers: B. Do the Present Value Analysis:
You take out a 30-year $450,000 mortgage loan with an APR of 7.75 percent and monthly...
You take out a 30-year $450,000 mortgage loan with an APR of 7.75 percent and monthly payments. In 16 years, you decide to sell your house and payoff the mortgage. What is your monthly payment? What is the principal balance on the loan? What is your total payment? What is your principal payment? What is your interest payment?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT