4 (5) Assume a 30-year mortgage loan for $250,000 for 30 years at an annual rate of 6%. What would be your fixed annual and monthly payments? Enter the inputs into the appropriate cells 5 in column B and set this up so that your answers are displayed as positive values. Round all values to two places after the decimal point. 6 (6) For the loan in #5 , prepare the first two monthly payment rows of the amortization table. 7 8 LOAN AMOUNT 9 TERM OF LOAN N YEARS 10 ANNUAL INTEREST RATE 11 TERM OF LOAN IN MONTHS 12 MONTHLY INTEREST RATE 13 FIXED LOAN PAYMENT (ANNUAL) 14 FIXED LOAN PAYMENT (MONTHLY) 15 16 17 18 19 20 21 22 AMORTIZATION TABLE PAYMENT 1 2 BEGINNING BALANCE FIXED PAYMENT INTEREST PRINCIPAL ENDING BALANCE

4 (5) Assume a 30-year mortgage loan for $250,000 for 30 years at an annual rate of 6%. What would be your fixed annual and monthly payments? Enter the inputs into the appropriate cells 5 in column B and set this up so that your answers are displayed as positive values. Round all values to two places after the decimal point. 6 (6) For the loan in #5 , prepare the first two monthly payment rows of the amortization table. 7 8 LOAN AMOUNT 9 TERM OF LOAN N YEARS 10 ANNUAL INTEREST RATE 11 TERM OF LOAN IN MONTHS 12 MONTHLY INTEREST RATE 13 FIXED LOAN PAYMENT (ANNUAL) 14 FIXED LOAN PAYMENT (MONTHLY) 15 16 17 18 19 20 21 22 AMORTIZATION TABLE PAYMENT 1 2 BEGINNING BALANCE FIXED PAYMENT INTEREST PRINCIPAL ENDING 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

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.)
Prepare an amortization schedule for a three-year loan of $117,000. The interest rate is 8 percent per year, and the loan calls for equal annual payments. How much total interest is paid over the life of the loan? Note: Leave no cells blank. Enter '0' where necessary. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Year 1 2 3 $ Beginning Balance 117,000.00 Total Payment Total interest Interest Payment Principal Payment Ending Balance
Calculate the total amount of interest dollars you will pay the bank over the life of the loan. Round to the nearest dollar and assume end-of-month payments. Table 6.2 The Loan Amortization Schedule for a $5,000 Loan at 10% to Be Repaid in Four Years Year Amount Owed on the Principal at the Beginning of the Year (1) Interest Portion Annuity Payment (2) of the Annuity = (1) x 10% = (3) 1 $5,000.00 1577.35 500 2 (1) Amount Owed (ii) PMT (III) Interest on the Principal at the Beginning Portion of the 2nd year of the Year 2 3 4 Repayment of the Principal Portion of the Annuity = (2) (3) (4) 1077.35 (iv) Repayment of the Principal Portion of the 2nd year Outstanding Loan Balance at Year End, After the Annuity Payment = (1)-(4) = (5) 3922.65 (v) Outstanding Loan Balance at Year 2 End, after the Annuity Payment Select an answer and submit. For keyboard navigation, use the up/down arrow keys to select an answer. a 2000 b 6309 с 1309 d 500
Consider a home mortgage of $225,000 at a fixed APR of 6% for 30 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.) b. The total amount paid over the term of the loan is $ (Round to the nearest cent as needed.) c. Of the total amount paid,% is paid toward the principal, and % is paid for interest. (Round to one decimal place as needed.)
The loan below was paid in full before its due date. (a) Obtain the value of h from the annual percentage rate table. Then (b) use the actuarial method to find the amount of unearned interest, and (c) find the payoff amount. Regular Monthly Payment $445.22 Remaining Number of Scheduled Payments after Payoff 6 APR 11.0% Click the icon to view the annual percentage rate table. (a) h=$ (b) The unearned interest is $ (c) The payoff amount is $ (Round to the nearest cent as needed.) (Round to the nearest cent as needed.)
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
Consider a student loan of $10,000 at a fixed APR of 6% for 4 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.)
Suppose you take out a $185,500 mortgage for 30 years at 5.15% interest. (a) Find the monthly payment on this mortgage. S (b) Fill out the first two rows of the amortization schedule below. Round your answers to the nearest dollar. Payment Number Interest Payment Principal Payment Balance of Loan 1 2 Question Help: D Video M Message instructor D Post to forum
basic ARM is made for $220,000 at an initial interest rate of 6 percent for 30 years with an annual resetdate. The borrower believes that the interest rate at the beginning of year (BOY) 2 will increase to 7 percent. Required:a. Assuming that a fully amortizing loan is made, what will the monthly payments be during year 1? b. Based on (a) what will the loan balance be at the end of year (EOY) 1? c. Given that the interest rate is expected to be 7 percent at the beginning of year 2, what will the monthlypayments be during year 2? d. What will be the loan balance at the EOY 2 ? e. What would be the monthly payments in year 1 if they are to be interest only?
The loan below was paid in full before its due date: (a). Obtain the value of h from the annual percentage rate table. Then (b) use the actuarial method to find the amount of unearned interest, and (c) find the payoff amount. Regular Monthly Payment $494.14 APR 4.0% Remaining Number of Scheduled Payments after Payo!! 12 Click the icon to view the annual percentage rate table. (b) The unearned interest is (Round to the nearest cent as needed) (c) The payoff amount is $(Round to the nearest cent as needed)
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 $
Consider a 4-year amortizing loan. You borrow $2,400 initially and repay it in four equal annual year-end payments. a. If the interest rate is 10%, what is the annual payment? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Annual payment $ ✓Answer is complete and correct. Time b. Prepare an amortization schedule. Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required. 1 2 3 4 Loan Balance (S) 2,400.00 2,400.00 757.13 1,882.87 x 1,314.03 688 Answer is complete but not entirely correct. Year-End Interest Due on Loan Balance (5) 240.00 188.29 131.40 68.83 Total Year- End Payment ($) 10 757.13 757.13 757.13 757.13 Amortization of Loan (S) 0 517.13 568.84 625.73 688.30

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