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.

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter4: Time Value Of Money

Section4.17: Amortized Loans

Problem 1ST

See similar textbooks

Similar questions

Calculating interest and APR of installment loan. Assuming that interest is the only finance charge, how much interest would be paid on a 5,000 installment loan to be repaid in 36 monthly installments of 166.10? What is the APR on this loan?
Give typing answer with explanation and conclusion to all parts A mortgage balance of $30000 is to be repaid over a 10-year term by equal payments at 4.6 compounded semiannually At the request of the mortgagor, the payments were set at 425 (a) How many payments will the mortgagor have to make? (b) What is the size of the last payment? (c) Determine the difference between the total amount required to amortize the mortgage with the contractual monthly payments rounded to the nearest cent and the total actual amount paid.
NEED FULLY CORRECT HANDWRITTEN SOLUTION FOR THIS...ASAP!!! A $180,000 mortgage amortized by monthly payments over 20 years is renewable after five years. (a) If interest is 5.02% compounded semi-annually, what is the size of each monthly payment? (b) Find the total interest paid during the first year. (c) Compute the interest included in the 35th payment. (d) If the mortgage is renewed after five years at 5.80% compounded semi-annually, what is the size of the monthly payment for the renewal period? (e) Construct a partial amortization schedule showing details of the first three payments for each of the two terms.
1.) Consider a 15-year, 9% mortgage for $200,000 with annual payments that are structured in the following way: for the first five years the payment is equal to just one third of the accrued interest for the respective year, for the remaining 10 years the payment assumes full amortization of the outstanding mortgage balance over the remaining term of the loan. Develop an amortization table for this loan.
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.
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
show steps to calculation with screenshots of excel !! Consider a $ 5,000,000, 8.5% APR, 30-year mortgage with monthly payments. What is the yield to maturity (YTM) of this loan under the following circumstances: (a) No points, fully - amortizing (b) Three points, fully amortizing. Three points means that the present value is 3% lower than the loan amount in the YTM calculation. ( c) Three points, 7 - year maturity with balloon.
1. You have just obtained a commercial mortgage for $6.25M with a 5-year term, 25-year amortization period and 6.50% mortgage interest rate. (a) Construct an amortization table for the term of the loan assuming annual payments. What is the annual payment? What is the balance at maturity? (b) What is the e¤ective cost of borrowing if the borrower pays an origination fee of $30,000? (c) The borrower can repay the balance of the loan at any time prior to its maturity, but must pay a penalty of 5% of the outstanding balance. What is the cost of borrowing if the borrower pays an origination fee of $30,000 and pays off the remaining balance of the loan after making payments for 4 years?
For each of the mortgages described in problems 6 through 12, create a partial amortization schedule with the rows for the first four payments completed. Assume monthly payments for all problems. 6. P=S 350,000, 30 years, 6.95% interest
Given the following information of the mortgage pool that backs a MPT, what is the regular scheduled payment in month 1 of the security? Use WAC as the mortgage rate and WAM as the number of periods for your calculations. Round your final answer to two decimals. • 30 year FRM, fully amortizing, monthly payments • Loans seasoned for 3 months before entering pool • WAM: 357 • WAC: 4% • Servicer/Guaran • Prepayment assumption: 75% PSA
Given the following information of the mortgage pool that backs a MPT, what is the regular scheduled payment in month 1 of the security? Use WAC as the mortgage rate and WAM as the number of periods for your calculations. Round your final answer to two decimals. • 30 year FRM, fully amortizing, monthly payments • Loans seasoned for 3 months before entering pool • WAM: 357 • WAC: 4% • Servicer/Guarantee fee: 0.55% • Starting pool balance: 250,342,967 • Prepayment assumption: 75% PSA
A mortgage of P 90 000 is to be paid by annual payment over a period of 10 years. If the interest rate is 15.8% effective. a) calculate the annual payment; b) construct an amortization schedule; c) find the total payment made; d) find the total interest paid