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 many months will it take to pay at least half of the principal?

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 many months will it take to pay at least half of the principal?

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

4. The cost of a home is financed with a $120,000 30-year fixed-rate mortgage at 4.5%. a. Find the monthly payments and the total interest for the loan. b. Prepare a loan amortization schedule for the first three months of the mortgage. Round entries to the nearest cent.
Complete the following amortization chart by using Table 15.1. Note: Round your "Payment per $1,000" answer to 5 decimal places and other answers to the nearest cent. Selling price of home Down payment Principal (loan) Rate of interest Years Payment per $1,000 Monthly mortgage payment 69 $ 82,000 $ 6,000 5.0 % 30 30
Complete the following table: (Use Table 15.1.) Note: Do not round intermediate calculations. Round your answers to the nearest cent. Selling price down payment amount mortgage rate years Monthly paymeny First payment broken down to interest first payment broken down to principal Balance at end of month $236,000 $47,200 7.00% 15 TABLE 15.1 Amortization table (mortgage principal and interest per $1,000) Rate Interest Only 10 Year 15 Year 20 Year 25 Year 30 Year 40 Year 2.000 0.16667 9.20135 6.43509 5.05883 4.23854 3.69619 3.02826 2.125 0.17708 9.25743 6.49281 5.11825 4.29966 3.75902 3.09444 2.250 0.18750 9.31374 6.55085 5.17808 4.36131 3.82246 3.16142 2.375 0.19792 9.37026 6.60921 5.23834 4.42348 3.88653 3.22921 2.500 0.20833 9.42699 6.66789 5.29903 4.48617 3.95121 3.29778 2.625 0.21875 9.48394 6.72689 5.36014 4.54938 4.01651 3.36714 2.750 0.22917 9.54110 6.78622 5.42166 4.61311 4.08241 3.43728 2.875 0.23958 9.59848 6.84586 5.48361 4.67735 4.14892…
2. Using Excel - Calculate using formulas (paste into a word document) the amortization schedule for a 5-year fixed-rate monthly payment mortgage that is fully amortizing. The interest rate on the loan is 6% and it is a $320,000 loan amount at origination with no points or fees.
A $178,000 mortgage loan is offered at an APR of 4%. Follow the instructions below the table. The loan payment formula was used to calculate the monthly payments for the loans and results are reported in the table below. You do NOT have to verify the given payment entries (you already used the formula for calculating payments in the first part Loan term in years Monthly Payment on $178,000 loan (in $) Total amount paid back over the full loan term (in $) Interest over the full loan term (in $) Difference in monthly payment from option above (in $) t = 15 years Pmt = $ 1316.64 F = I = No entry here t = 30 years Pmt = $ 849.80 F = I = Difference in MONTHLY payment t = 40 years Pmt = $ 743.93 F = I = Difference in MONTHLY payment t = 50 years Pmt = $ 686.56 F = I = Difference in MONTHLY payment For each loan term option, calculate the total amount paid back over the…
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 first payment goes towards the principal? Interest?
Can you please show the step-by-step solution. please do not skip steps. Explain how you got the answer you did
For the following loan, calculate the monthly payment and then complete the partial amortization schedule for the first three months. A home mortgage of $161,000 with a fixed APR of 3% for 30 years. Round all final answers to the nearest cent as needed. a) The monthly payment including principal and interest would be $ b) Complete the partial amortization table for the mortgage. End of.. Month 1 Month 2 Month 3 Interest Payment Toward Principal $ Outstanding Balance GA
Based on Exhibit 7-8, what would be the monthly mortgage payments for each of the following situations? (Round mortgage payment factors and final answers to 2 decimal places. Omit the "$" sign in your response.) a) A $123,000, 15-year loan at 6.0 percent APR compounded semi - annually b) A $165, 000, 25- year loan at 7.5 percent APR compounded semi- annually c) A $68, 000, 20-year loan at 7.5 percent APR compounded semi - annually.
A mortgage of $656,000 is amortized over 25 years by making end-of-month payments of $4,120. Your calculator must be set to 2 decimals before doing any calculations that are going to involve Amortization. a.) What is the annual rate of interest compounded semi-annually? (Correct to exactly 4 decimal places.) Once you have seen what this is, to 4 decimal places, set your calculator back to 2 decimal places before using the AMORT function. b.) What is the value of the final (partial) payment? The final payment required to make the outstanding balance equal exactly zero. (Use the BAII+: Do not calculate this by hand.) c.) What is the total interest cost for the debt over 25 years (300 payments)? (Use the BAII+: Do not calculate this by hand.)
Complete the following table: (Use Table 15.1.) (Do not round intermediate calculations. Round your answers to the nearest cent.) First Payment Broken Down Into— Selling price Down payment Amount mortgage Rate Years Monthly payment Interest Principal Balance at end of month $221,000 $44,200 7.00 % 15
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.)

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