Athena took out a home loan 4 years ago with a 30-year term, monthly payments of $1,600, and aninterest rate of 5%/year compounded monthly on the unpaid balance. She is looking to refinancewith a 3.25% per year interest rate and a 26-year loan term.a) Find the outstanding principal after 4 years of regular payments.b) What would the new monthly payment be?Use units and context for both answers. Round answers to two decimal places.

The given problem can be solved using FV and PMT function in excel. FV function will compute…

Answered: Athena took out a home loan 4 years ago…

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

Give typing answer with explanation and conclusion Assume you want to borrow $300,000 and have been presented with two options. The first option is a fully amortizing loan with an interest rate of 3% and $4000 of origination fees and points. The second option is an interest only loan with an interest rate of 4% and $5000 of origination fees and points. Both loans are for 30 years and have monthly payments. Further assume that if the borrower chooses the interest only loan, any money saved on the monthly payment can be invested with a projected return of 7%. Also assume that the proceeds from the investment will first be used to pay off any remaining balance on the loan. How much money will the investor have left at the end of 30 years after repaying the loan? Group of answer choices None, the investor will owe $12,373.42 $323,060.72 $22,063.08 $30,750.78
Problem: Please answer the following questions regarding a $300,000 Mortgage Loan with monthly amortization over 30 years and an annual interest rate of 6%. What is the loan payment for a (30 year loan (360 monthly payments) of $300,000 at 6%? Question Answer What is the monthly payment amount? Loan Monthly Payment: How much interest and how much is principle on the first payment? Interest: Principle: How much interest and how much is principle on the second payment? Interest: Principle: If after the second payment an addition $10,000 was paid on principle. How much would the interest be on the third payment? Interest:
Give complete solutions and draw a cashflow diagram. Provide an amortization schedule 1. You have a car loan of $15,000 with an annual interest rate of 8%. The loan term is 3 years. Calculate the outstanding balance after 2 years of making monthly payments.
Find the monthly payment and estimate the remaining balance. Assume interest is on the unpaid balance. 5-year computer loan for $2770 at 6.7%; remaining balance after 2 years. The monthly payment is (Round to the nearest cent as needed
Performance task No.2: SIMPLE INTERESTS Directions: Complete the table below. Show your solution on a separate sheet. 1. Find the simple interest on a loan of P65,000 if the loan is given at a rate of20% and is due in 3 years. 2. Amparo invested a certain amount at 10% simple interest per year. After 2years, the interest she received amounted to P3,000. How much did she invest? 3. Miko borrowed P25,000 at 10% annual simple interest rate. How much should he pay after 3 years and 6 months?
Suppose you secure a home improvement loan in the amount of $5,000 from a local bank. The loan officer gives you the following loan terms:• Contract amount = $5,000• Contract period = 24 months• Annual percentage rate = 12%• Monthly installment = $235 .37Shown is the cash flow diagram for this loan. Construct the loan payment schedule by showing the remaining balance, interest payment, and principal payment at the end of each period over the life of the loan.
Watch the video and then solve the problem given below. Click here to watch the video. You are considering a loan with an annual rate of 8%. The mortgage is $130,000 with 180 monthly payments of $1242.35 for 15 years. Complete the first two months of the amortization table. (Simplify your answers. Round to the nearest cent as needed.) Payment number Interest payment Principal payment Balance of loan 1
You borrow $207,000 to be repaid in monthly installments over the next 25 years. The first payment occurs one month from today. If the annualized interest rate for the loan is3.4%, how much principal is amortized in payment #52? Enter your answer as a positive number, and round to the nearest dollar. Note:- Don't use Excel and chatgpt
Your company is planning to borrow $1 million on a 5-year, 11%, annual payment, fully amortized term loan. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet What fraction of the payment made at the end of the second year will represent repayment of principal? Do not round intermediate calculations. Round your answer to two decimal places. %

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

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