Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)
7th Edition
ISBN: 9780357033609
Author: Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 5, Problem 7FPE
a.
Summary Introduction
To calculate: The monthly mortgage payment.
b.
Summary Introduction
To calculate: The monthly mortgage payment.
c.
Summary Introduction
To calculate: The monthly mortgage payment.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Consider a traditional 30-year fixed rate mortgage, borrowing $400,000 (present value) at an annual interest rate of 3.25%, payable in monthly payments. Create an Excel spreadsheet and use basic math functions to develop a schedule for the entire life of the loan. Your table should include columns for Payment #, Principle Remaining, Interest Paid, Principal Paid, Cumulative Interest Paid, and Cumulative Principal Paid. Then use this table to answer the following questions:
c. How much did the borrower pay in total to pay off this loan, if they paid just the minimum payment for the entire 30 years? And how much of that total is just interest?
d. Create a graph of the interest and principal amounts paid each month, for just the first two years of the loan. (Hint: use an “X Y Scatter” chart type)
e. Bonus question: How much sooner (in months) would the borrower pay off this loan, if they paid an extra $100 per month? Your Excel spreadsheet must show this calculation
The following formula is used for figuring out a monthly home mortgage payment: 7(12t) r Lr1+ 12 M = 12t 12 1+ 12 -1 Where: L = the loan amount in dollars the annual interest rate expressed as decimal t = the number of years of the loan M= the monthly payment in dollars r = You are looking to buy a $275,599.00 home in Haverhill. If Bank of America will give them a 30-year mortgage at 6.75% annual interest rate for the cost of the house after they receive a 10% down payment. A. Determine the loan amount? B. How much their monthly payment will be? C. At the end of the 30-years, how much total money will you have paid to Bank of America for your home? In another word how much did the $275,599.00 house really cost the couple? D. How much interest will they have paid? E. How many of her monthly payment go toward the interest? F. What percent increase over the cost of the home does this interest represent? G. Redo and re-answer all questions, but this time for 15 years? Do analysis…
Solve the problem. If necessary, use the accompanying table of monthly payments. Round your answer to the nearest cent.
Find the monthly payment needed to amortize principal and interest for the following fixed-rate mortgage.
Mortgage amount: $73,500
Term of mortgage: 20 years
Interest rate: 10.5%
Chapter 5 Solutions
Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.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?arrow_forwardCalculating and comparing add-on and simple interest loans. Eli Nelson is borrowing 10,000 for five years at 7 percent. Payments, which are made on a monthly basis, are determined using the add-on method. a. How much total interest will Eli pay on the loan if it is held for the full five-year term? b. What are Elis monthly payments? c. How much higher are the monthly payments under the add-on method than under the simple interest method?arrow_forwardCalculating single-payment loan amount due at maturity. Stanley Price plans to borrow 8,000 for five years. The loan will be repaid with a single payment after five years, and the interest on the loan will be computed using the simple interest method at an annual rate of 6 percent. How much will Stanley have to pay in five years? How much will he have to pay at maturity if hes required to make annual interest payments at the end of each year?arrow_forward
- Use Excel to calculate the total interest on a mortgage paid monthly given the following values: Amount of loan = 499,256 Annual interest rate = 6% Length of loan = 20 years Round your answer to the nearest hundredth. Enter your answer as a positive number.arrow_forwardSolve the problem. If necessary, use the table of monthly payments below. Round your answer to the nearest cent. Find the monthly payment needed to amortize principal and interest for the following fixed-rate mortgage. Mortgage amount: $177,000 Term of mortgage: 10 years Interest rate: 9%arrow_forwardInvestigate the effect of the interest rate on home loans by finding the monthly payment and the total interest for a forty-year simple interest amortized loan of $150,000 at the following rates. (Round your answers to the nearest cent.) (a) 6% 1) payment 2) total interest (b) 7% 1) payment 2) total interest (c) 8% 1) payment 2) total interest (d) 9% 1) payment 2) total interest (e) 10% 1) payment 2) total interest (f) 11% 1) payment 2) total interestarrow_forward
- Find the monthly payment (in $) and the total interest (in $) for a mortgage of $48,000 at 5 1/4% for 20 years. Use this table and give the total interest as your answer. (Round your answers to the nearest cent.) Monthly payment$ Total interest$ Table 14-1: Monthly Payments to Amortize Principal and Interest per $1,000 Financed Monthly Payments(Necessary to amortize a loan of $1,000) InterestRate (%) 5Years 10Years 15Years 20Years 25Years 30Years 35Years 40Years 3.50 18.19 9.89 7.15 5.80 5.01 4.49 4.13 3.87 3.75 18.30 10.01 7.27 5.93 5.14 4.63 4.28 4.03 4.00 18.42 10.12 7.40 6.06 5.28 4.77 4.43 4.18 4.25 18.53 10.24 7.52 6.19 5.42 4.92 4.58 4.34 4.50 18.64 10.36 7.65 6.33 5.56 5.07 4.73 4.50 4.75 18.76 10.48 7.78 6.46 5.70 5.22 4.89 4.66 5.00 18.87 10.61 7.91 6.60 5.85 5.37 5.05 4.82 5.25 18.99 10.73 8.04 6.74 5.99 5.52 5.21 4.99 5.50 19.10 10.85 8.17 6.88 6.14 5.68 5.37 5.16 5.75 19.22 10.98 8.30 7.02 6.29 5.84 5.54 5.33 6.00 19.33 11.10 8.44 7.16…arrow_forwardShow the first two lines of the amortization table for your new home mortgage, assuming a sellingprice of $118,500, a down payment of 6%, annual interest rate 5.3% compounded monthly, andmonthly payments on a 30-year mortgage. (Please help by solving through calculator)arrow_forwardPlease show how to solve this using an Excel spreadsheet and please show the formulas. The maturity of the balloon loan is 5 years, amortization period is 30 years, loan amount is $85,000 with annual interest rate 4.5% and monthly payments. What is the monthly payment for this balloon mortgage? What is the balloon payment at the end of five years for this balloon mortgage?arrow_forward
- Please show all steps and formulas in an excel spreadsheet to answer a. through g. using the information below! You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?arrow_forwardExplain on excel spread sheet....Your local bank has offered you a mortgage of 100,000). The mortgage is to be paid back over 10 years in annual payments, and the bank charges 12% annual interest. Calculate the annual mortgage payments What is the mortgage EAIR?arrow_forwardPlease show how to solve a. b. and c. using the information below and Excel. Interest-only mortgage with monthly payments and loan amount: $56,000; Term: 15 years; Annual interest rate: 7.5% a. What is the total payment in the 180th month? b. What is the outstanding balance at the end of 10 years (120 months)? c. What is the total interest payment during the entire loan term (180 months)?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Pfin (with Mindtap, 1 Term Printed Access Card) (...FinanceISBN:9780357033609Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning