TVM Calculate the required monthly payments for: 1) a 30-year mortgage loan at an annual rate of 3.75%; and 2) a 15-year mortgage loan at an annual rate of 3.25%. Assume both mortgage loans are $100,000. 3) Which loan will have the lowest loan balance in exactly 5 years (60 months), and what is the balance?

TVM Calculate the required monthly payments for: 1) a 30-year mortgage loan at an annual rate of 3.75%; and 2) a 15-year mortgage loan at an annual rate of 3.25%. Assume both mortgage loans are $100,000. 3) Which loan will have the lowest loan balance in exactly 5 years (60 months), and what is the balance?

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Need Detailed answer with steps please 30. Considering the following information, what is the NPV if the borrower refinances the loan? Expected holding period: 3 years, Current loan balance: $100,000; Current loan interest: 7%; Current loan mortgage payment: $898.33; Remaining term on current mortgage: 15 years; New loan interest: 5.5%; New loan mortgage payment: $817.08; New loan term: 15 years; Cost of refinancing: $5,000. Assume that the opportunity cost is the interest rate on the new loan (5.5%). A. -$5,000.00 B. -$1,155.27 C. $3,844.73 D. $8,844.73
Consider a student loan of $12,500 at a fixed APR of 12%for 25 years. What is the monthly payment?(Do not round until the final answer. Then round to the nearest cent as needed.) The total payment over the term of the loan is?(Round to the nearest cent as needed.) Of the total payment over the term of the loan %? is paid toward the principal and %? is paid toward interest.
A floating rate mortgage loan is made for $185,000 for a 30-year period at an initial rate of 12 percent interest. However, the borrower and lender have negotiated a monthly payment of $1,480. Required: a. What will be the loan balance at the end of year 1? b. If the interest rate increases to 13 percent at the end of year 2, how much is the payment plus negative amortization in year 2 and year 5 if the payment remains at $1,480?
Use PMT formula on the image uploaded to determine the regular payment amount, rounded to the nearest cent. The cost of a home is financed with a $150,000 20-year fixed-rate mortgage at 3.5%. a. Find the monthly payments and the total interest for the loan. b. Prepare a loan amortization schedule for the first three months of the mortgage. ______________________________________________________________ a. The monthly payment is $________.. (Do not round until the final answer. Then round to the nearest cent as needed.) - The total interest for the loan is $_______. (Use the answer from part a to find this answer. Round to the nearest cent as needed.) b. Fill out the loan amortization schedule for the first three months of the mortgage below. Payment Number Interest Principal Loan Balance 1 $ $ $ 2 $ $ $ 3 $ $ $ (Use the answer from part a to find these answers. Round to the…
What is the effective interest rate (APY) for a loan of $8,500 at 12% APR compounded monthly? use the formula method.
A floating rate mortgage loan is made for $170,000 for a 30-year period at an initial rate of 12 percent interest. However, the borrower and lender have negotiated a monthly payment of $1,360. Required: a. What will be the loan balance at the end of year 1? b. If the interest rate increases to 13 percent at the end of year 2, how much is the payment plus negative amortization in year 2 and year 5 if the payment remains at $1,360? Complete this question by entering your answers in the tabs below. Required A Required B What will be the loan balance at the end of year 1? Note: Do not round intermediate calculations. Round your final answer to 2 decimal places. Loan balance
Consider a 30-year, 6% loan for $240,000 with fixed monthly payments. a) What will be the remaining mortgage balance after the first 6 years? b) How much of interest is to be paid over the first 6 years? c) How much of principal reduction is to take place over the first 6 years?
What would be the sum of all the payments made (i.e., total $s paid over the 30 years, ignoring time value) on the following house mortgage? Loan amount is $175,000 with an interest rate of 6.4% per annum, term of 30 years, and monthly payments. (Round to nearest penny and enter, for example, as 123456.78) Answer:
You plan to borrow $40,100 at a 6.9% annual interest rate. The terms require you to amortize the loan with 7 equal end-of-year payments. How much interest would you be paying in Year 2? O a. $2,446.20 O b. $2,479.22 O c. $2,766.90 O d. $6,936.17 O e. $7,414.76
Consider a home mortgage of $125,000 at a fixed APR of 4.5% for 25 years. a. Calculate the monthly payment. b. Determine the total amount paid over the term of the loan. c. Of the total amount paid, what percentage is paid toward the principal and what percentage is paid for interest. ..... a. The monthly payment is $ (Do not round until the final answer. Then round to the nearest cent as needed.)
Please eolve this question on excell and show formulas please.
G. Find the interest rate (APR) on a 27-year mortgage with a initial loan amount of $358,000, if the monthly payment is $2229.45 Let's use references for input values; and be sure to annualize the rate! INPUTS: OUTPUT: Period Rate is APR Payment Loan amount

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS