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

❌❌❌❌❌❌✅✅✅
5 1/2 interest rate for 30 years is 5.67789
Consider a loan of $8,000 charging interest at j12-6% with monthly payments of $321.50 Calculate the missing amounts in the amortization table. Place the value for A in the first answer box, B in the second and C in the third. PMT Interest Principall Balance 8,000.00 1321.50 40.00 281.50 7,718.50 2 321.50 A C
Assume a 30 year fixed rate, fully amortizing mortgage for $260,000 at a stated rate of 5% with monthly payments (no fees, points or escrows). What is the loan balance (or "payoff amount) - after 4 years? Ch4 a. b. C. 230,530 d. 190,949 194,843 243,438
How much will you pay on a 25 year, $400,000 mortgage if you make monthly payment at the beginning of month? Interest is 3.5% compounded annually. O a. $1,968 O b. $1,973 OC. $1,979 O d. $1,997 O e. $1,991
A house sells for $317,000 and a 5% down payment is made. A mortgage is secured at 4% for 40 years. Compute an amortization schedule for the first 3 months. Round your answers to two decimal places, if necessary. The value of the mortgage is $301,150 and the monthly payment is $1258.81.
Find the mortgage balance after the first three payments on a 3030-year $170,000$⁢170,000 mortgage that was financed at an APR of 4.25%4.25% and has a monthly payment of $836.30$⁢836.30. Payment Number Interest Payment Principal Payment Mortgage Balance 11 $602.08$⁢602.08 $234.22$⁢234.22 Balance 1 22 $601.25$⁢601.25 $235.05$⁢235.05 Balance 2 33 $600.42$⁢600.42 $235.88$⁢235.88 Balance 3
A house sells for $309,500 and a 4% down payment is made. A mortgage is secured at 4% for 20 years. Compute an amortization schedule for the first 3 months. Round your answers to two decimal places, if necessary. The value of the mortgage is $297,120 and the monthly payment is $1800.55 . Part: 0 / 3 0 of 3 Parts Complete Part 1 of 3 Payment number Interest Payment on Principal Balance of Loan 1 $ $ $ Procedure for Computing an Amortization Schedule Step 1 Find the interest for the first month. Use =IPrt , where =t112 . Enter this value in a column labeled Interest. Step 2 Subtract the interest from the monthly payment to get the amount paid on the principal. Enter this amount in a column labeled Payment on Principal. Step 3 Subtract the amount of the payment on principal found in step 2 from the principal to…
Take a look at the chart pls..
Make an amortization table to show the first two payments for the mortgage. Amount of mortgage $401,995 Month 1 2 (Round to the Annual interest rate Years in mortgage Monthly payment 5.25% Monthly payment $2093.36 Interest $2093.36 est cent as needed.) $ 35 Principal $2093.36 End-of-month principal $
1.18q Determine the payment to amortize the debt. (Round your answer to the nearest cent.) Quarterly payments on $17,500 at 3.9% for 6 years.
Develop an amortization schedule for the loan described. (All answers should be entered in dollars. Round your answers to the nearest cent.) 1 $90,000 for 2 years at 12% compounded semiannually Period 1 2 3 4 5 $ $ $ $ $ Payment $ $ $ $ $ Interest Balance Reduction $ $ $ $ $ Unpaid Balance $90,000 $ $ $ $ $0.00

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