Q2. Complete the amortization schedule for the last three payments on a $500,000,15-year, monthly-pay, 4.2% APR home mortgage.End of Beginning MonthlyMonth BalancePaymentPrincipal InterestEndingBalance178$11,167.99 $3,748.75$39.09 $3,709.66 $7,458.32179$7,458.32 $3,748.75$26.10$3,722.65 $3,735.68180$3,735.68 $3,748.75$13.07$3,735.68$0.00

Here's the corrected amortization schedule for the last three payments:End of MonthBeginning…

Answered: Q2. Complete the amortization schedule…

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

6 % interest rate for 15 years is 8.43857
How do I get the beginning book value for the second year, third year and the fourth year??
Mortgage Information: Interest Only Payments Initial Loan Amount: $22,000 Fully Amortizing Term: 30 years Fixed rate interest rate: 3.25% Fees at origination: 3rd party fees: $750. What are the monthly payments? O.a $59.58 O.b $131.91 O.c $715.00
R2
Exercise 2: Directions: Analyze the given amortization procedures in the table below then fill in cach blank using the guide questions below the table. Problem: A salary loan amounting to P15,000 is to be paid annually for 4 years with an interest rate of 6% compounded annually. The annual amortization is P P4,328.87. PRINCIPAL Outstanding Balance Interest Regular Payment (R) Period Component of Component of Рауment Раyment P11,571.13 7,936.53 E 1. 2. 3. P4,328.87 P4,328.87 P4,328.87 P900 P694.27 P3,428.87 3,852.68 4,083.84 4 245.031 F Total G. H. Guide Questions: A. How much is the amount of the loan? (Outstanding balance at time 0) B. How much is the first regular annual payment? C. For the second payment, how much goes to pay the principal? D. For the third payment, how much goes to pay the interest? E. How much is the outstanding balance after the 3rd payment? F. How much should be the outstanding balance after the 4th or last payment? G. How much is the total amount of regular…
Using this table as needed, calculate the required information for the mortgage. Number Table Monthly Payment (in $) Term Total Amount Interest of $1,000s Financed of Loan Factor Interest Financed Rate (years) (in $) (in $) $74,500 8.00% 30 %24
Excel Questions 13-16. Complete the amortization table provided in the Excel document posted in IvyLearn in the homework area by setting the appropriate values for a $100,000, 30-year mortgage at 6% interest and using Excel's autofill (drag) feature to fill in the cells to the end of the mortgage period. Use this to answer the following: How much of the last payment goes towards the principal? Interest? (round to the hundredths place) Principal: $ Interest: $
James has a mortgage of $84,500 at 8% for 30 years. The property taxes are $3,700 per year, and the hazard insurance premium is $754.50 per year. Find the monthly PITI payment (in $). (Round your answer to the nearest cent. Use this table as needed.) $ LA Need Help? Read It Watch It Master It
Rahulbhaliya
Subject: Finance
31. Faith is taking out an $7,500, 1½-year loan with an APR of 8.75%. What isthe monthly payment for this loan?A. $441.17B. $485.14C. $519.34D. $446.12
Um

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

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