(Related to Checkpoint 6.3) (Determining the outstanding balance of a loan) Ten years ago you took out a $250,000, 25-year mortgage with an annual interestrate of 10 percent and monthly payments of $2,271.75. What is the outstanding balance on your current loan if you just make the 120th payment?scrIf you just make the 120th payment, the outstanding balance on your current loan is $ (Round to the nearest cent)CU INKY GenMadison-MadisonHealtInsuranportNextcorearchCOUOO 67°FIMGCoursOMathChapt99.CHOFBPriscF7FOF10F11F12341678VEIRTYUDFGKMAltCtriAlt

Data given :: Loan = $250,000 n= 25 years i= 10% PMT= $ 2271.75 Required: Outstanding balance on…

(Related to Checkpoint 6.3) (Determining the outstanding balance of a loan) Ten years ago you took out a $250,00, 25-year mortgage with an annual interest rate of 10 percent and monthly payments of $2,271.75. What is the outstanding balance on your current loan if you just make the 120th payment? If you just make the 120th payment, the outstanding balance on your current loan is S (Round to the nearest cent) sen

(Related to Checkpoint 6.3) (Determining the outstanding balance of a loan) Ten years ago you took out a $250,00, 25-year mortgage with an annual interest rate of 10 percent and monthly payments of $2,271.75. What is the outstanding balance on your current loan if you just make the 120th payment? If you just make the 120th payment, the outstanding balance on your current loan is S (Round to the nearest cent) sen

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

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.)
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:
(Related to Checkpoint 6.3) (Determining the outstanding balance of a loan) Five years ago you took out a $250,000, 25-year mortgage with an annual interest rate of 11 percent and monthly payments of $2,450.28. What is the outstanding balance on your current loan if you just make the 60th payment? CTT If you just make the 60th payment, the outstanding balance on your current loan is $ (Round to the nearest cent.)
Investigate the effect of the term on simple interest amortized auto loans by finding the monthly payment and the total interest for a loan of $13,000 at 8 and 7/8% interest if the term is the following. (Round all answers to the nearest cent.) (a) 3 years. Payment $ Total interest $ (b) 4 years. Payment $ Total interest $ 4615 (c) 5 years. Payment Total interest Enter a number. XX XX XX
If a lender makes a simple loan of $500 for 5 years and charges 3%, then the amount that the lender receive at maturity is $ (Round your response to the nearest two decimal place) If a lender makes a simple loan of $2000 for one year and charges $90 interest, then the simple interest rate on that loan is %. (Round your response to the nearest whole number) If a borrower must repay $106.50 one year from today in order to receive a simple loan of $100 today, the simple interest on this loan is OA. 6.0% OB. 6.5% OC. 65% OD. 5.0%
Investigate the effect of the term on simple interest amortized auto loans by finding the monthly payment and the total interest for a loan of $10,000 at 7 and 7/8% interest if the term is the following. (Round all answers to the nearest cent.) (a) 3 years. Payment $312.79 Total interest $ 1260.34 (b) 4 years. Payment $ 243.54 Total interest $ (c) 5 years. Payment Total interest $ $ 202.17 X
QUESTIONS 1,2,3 ARE CONNECTED. I SOLVED QUESTIONS 1 and 2 and need help solving QUESTION 3 ONLY 1. A bank customer obtains a $150,000 mortgage with a term of 15 years and a nominal interest rate of 4.20%. The monthly debt service/payment for the mortgage : Answer - $1,124.63 2) If the homeowner makes the minimum monthly required payments on the mortgage, what is the balance on the mortgage after 5 years – i.e. after the 60th payment is made: Answer - $110,043.38 3) Assume the homeowner has made the minimum required monthly payments on the mortgage and 5 years have passed. If the homeowner’s income has increased and he/she decides to increase the monthly payments to $1500, how many months and years will it take to retire the mortgage? Months Years? *PLEASE SOLVE #3 USING EXCEL ONLY AND SHOW THE FUNCTIONS/FORMULAS USED*
Investigate the effect of the term on simple interest amortized auto loans by finding the monthly payment and the total interest for a loan of $16,000 at 9 7/8% interest if the term is the following. (Round your answers to the nearest cent.) (a) three years payment total interest (b) four years payment $ total interest $ (c) five years payment $ total interest $
Mortgage, part 1 (The Loan)5 years ago you purchased a home for $215,000. You made a 10% down payment and paid for the rest with a 30 year mortgage with a rate of 4.65%. How much was the down payment? How much of the purchase price did you finance with the loan? What is your monthly payment? Use solver. Clearly write the formula you will use as well as all values used in the formula. How much of the loan is left to pay after the first 5 years? Use solver. Clearly write the formula you will use as well as all values used in the formula. How much did you pay to the lender (total) over the first 5 years? How much of what you paid to the lender in the first 5 years was interest? If you paid this loan for all 30 years, how much interest would you pay?
A 20-year mortgage has an annual interest rate of 5.5 percent and a loan amount of $210,000. (Hint: Use the "CUMPRINC" function in Excel.) What is the remaining balance at the 72th payment? Note: Round your answer to 2 decimal places. Answer is complete but not entirely correct. Balance $ 41,010.77x

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