Question

In: Finance

For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly...

For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly payments per year, find the balance at the end of 4 years and 10 years?

Solutions

Expert Solution

Mortgage Loan $             300,000
Interest rate 2.0%
Number of payments in a year 12
Term of the loan in years 15
Monthly payment $            1,930.53
Principal paid till year 4 $          71,424.68
Balance after 4 years $       228,575.32
Principal paid till year 10 $       189,858.94
Balance after 10 years $       110,141.06

Excel formulas:


Related Solutions

For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly...
For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly payments per year, find the balance at the end of 4 years and 10 years.
Consider a mortgage loan of $300,000, to be amortized over thirty years with monthly payments. If...
Consider a mortgage loan of $300,000, to be amortized over thirty years with monthly payments. If the annual percentage rate on this mortgage is 4% : What is the monthly payment on this loan? What is the balance of this loan AFTER the 14th payment is made? How much of the 8th payment is allocated to interest? How much of the 19th payment is allocated to principal?
Assume a mortgage loan amount of $ 300,000, with annual interest rate 4% and 5 years...
Assume a mortgage loan amount of $ 300,000, with annual interest rate 4% and 5 years term 1. Calculate annual payment amount 2. Calculate monthly payment amount 3. Do you pay more annually or monthly? Why? 4. Prepare a 60 month loan amortization schedule. How much is your total interest payment?
A mortgage loan is made for $80,000 at 6 percent interest for 25 years. Payments are...
A mortgage loan is made for $80,000 at 6 percent interest for 25 years. Payments are to be made monthly. Calculate. 1. Total monthly interest and principal payments through year 10. 2. What would the breakdown of interest and principal be during month 50?
A fully amortizing mortgage loan is made for $90,000 for 15 years. The interest rate is...
A fully amortizing mortgage loan is made for $90,000 for 15 years. The interest rate is 6 percent per year compounding monthly. Payments are to be made monthly. What is the principal payment in the first monthly payment?
5)What is the monthly payment on a 15 year, $350,000 mortgage loan, where interest rate is...
5)What is the monthly payment on a 15 year, $350,000 mortgage loan, where interest rate is 3% per year, Compounded annually Compounded monthly Compounded daily What are effective annual rates for 1,2, and 3 above?
A loan is for $600,000 (mortgage), 30 years monthly, 4% fixed rate interest. What is the...
A loan is for $600,000 (mortgage), 30 years monthly, 4% fixed rate interest. What is the payment, 5-year payoff, 5-year principal paid, and 5-year interest paid?
A lender makes a 100,000 mortgage at 12% interest with monthly payments for 25 years. How...
A lender makes a 100,000 mortgage at 12% interest with monthly payments for 25 years. How much principal will be repaid during the 10th year of the loan? How much interest will be paid during the 10th year of the loan? Show Calculations using a financial calculator. (i.e. I=?, PMT=? etc)
A fully amortizing mortgage loan is made for $200,000 at 6 percent interest for 30 years....
A fully amortizing mortgage loan is made for $200,000 at 6 percent interest for 30 years. Payments are to be made monthly. (Ignore origination fee and other fees). a.      Using Excel, construct fully amortizing mortgage loan table including beginning balance, payment, interest, principal, and ending balance. (Please check your ending balance by using PV function in Excel) b.      Interest and principal payments during month 1. c.       Total Principal and total interest paid over 30 years. d.      The outstanding loan balance...
Assume a mortgage loan amount of $ 400,000, with annual interest rate 4% and 15 years...
Assume a mortgage loan amount of $ 400,000, with annual interest rate 4% and 15 years term 1. Calculate annual payment amount 2. Calculate monthly payment amount 3. Do you pay more annually or monthly? Why? 4. Prepare a 180 month loan amortization schedule. How much is your total interest payment?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT