1. Excel: Complete the amortization table provided in the Excel document posted in Ivylearn in the homework area by setting the appropriate values for a $165,000, 30-year mortgage at 4.5% 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: a. How much of the first payment goes towards the principal? How much goes toward the interest? b. How much of the last payment goes towards the principal? How much goes toward the interest? c. Find the total interest paid by the end of the mortgage.

1. Excel: Complete the amortization table provided in the Excel document posted in Ivylearn in the homework area by setting the appropriate values for a $165,000, 30-year mortgage at 4.5% 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: a. How much of the first payment goes towards the principal? How much goes toward the interest? b. How much of the last payment goes towards the principal? How much goes toward the interest? c. Find the total interest paid by the end of the mortgage.

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

Please include the excel formula If the following is a loan, identify a) the principal amount, b) the monthly interest rate, and c) the length of the loan in months. Determine if the following situation is an investment or a loan. If the following is an investment, identify a) if it is a one-time or recurring investment, b) the number of compounding periods per year and c) the total number of compounding periods. If the following is a loan, identify a) the principal amount, b) the monthly interest rate, and c) the length of the loan in months. Ashtyn purchased new appliances for her house for a total of $5,744. The store she buys the appliances from offers an annual simple interest rate of 8.5% with no down payment and monthly payments for 3 years. This situation represents a(n) . a) b) c) What will be your monthly payments? Use Excel to calculate the value.
(c) Use the graph to estimate the amount of the mortgage.
Pls help on this question. pls do all of the question pls i beg. Pls do all three parts.
Please make sure the answers are clear n easy to read. Please do it on white paper. Again make sure the answer is clear. do it on white paper
Find the monthly payment needed to amortize principle and interest for the fixed rate mortgage. Use eithr the regular monthly payment formula or the given table.
We will now verify your results using an online Amortization Calculator. Return to www.bankrate.com (Links to an external site.), scroll down the home page and select Amortization Calculator (Links to an external site.) under the Mortgages heading. Enter the amount, time, and rate for the original loan to begin with and click CALCULATE. Your monthly payments will appear on the side. Click Show Amortization Schedule to see the month-to-month breakdown of your loan payments over the entire term of the loan.
Make an amortization table to show the first two payments for the mortgage. Amount of mortgage Annual interest rate Years in mortgage Monthly payment $407,550 5.25% 35 $2122.29 Month Monthly payment Interest Principal End-of-month principal 1 $2122.29 $enter your response here $enter your response here $enter your response here 2 $2122.29 $enter your response here $enter your response here $enter your response here
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…
a) Based on your prepared amortization schedule for Concert Time Again, Inc term loan, what is the remaining loan balance after the 4th payment AND which financial statement would that amount appear on? Type the financial statement in the text box below and write the Dollar Amount on your PDF upload Financial Statement b) Based on your prepared amortization schedule, what is the interest expense for this loan after the 4th payment AND which financial statement would this appear on? Assume the first 4 payments are in the same accounting period that is presented on the financial statement. Type the financial statement in the text box below and write the Dollar Amount on your PDF upload Financial Statement c) What will the loan balance be after the 60th payment? $
Using this table as needed, calculate the required information for the mortgage. Amount Interest Financed Rate $88,500 8.00% Need Help? Read It Submit Answer Term of Loan (years) 30 Number of $1,000s Financed 88.5 Table Factor (in $) 7.34 Monthly Payment (in $) X LA Total Interest (in $) X
2. Using tab 2 in the template, create the amortization spreadsheet and answer the following questions for a $700,000 10-year adjustable-rate mortgage (ARM) loan that is fully-amortizing and has monthly payments. A teaser rate of 4.4% applies to the mortgage payments and amortization during the first 2 years of the loan. After the second , the annual interest rate on the loan is equal to the going rate on an index + a margin of 2.7%, subject to an annual interest rate cap of 2.5% and a lifetime interest rate cap of 5.8% over the initial teaser rate. Expectations for the beginning-of-year values for the appropriate index are as follows: year, Year Index 3451 3.1% 4.7% 6.5% 6 2.5% 7 2.9% 8 5.1% 9 6.6% 10 6.0% a) Based on these expectations and conditions, what would be the actual (contract) interest rates applied to the mortgage payment during years 1 through 10? b) What would be the APR on this loan, if held until maturity – assuming up-front points of 2.0%? c) What is the outstanding…

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