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.

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.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 27M

See similar textbooks

Similar questions

Jamison is looking at the historical prepayment for a passthrough security. He finds the following: mortgage balance in month 42 = $260,000,000 scheduled principal payment in month 42 = $1,000,000 prepayment in month 42 = $2,450,000 What is the SMM for month 42? How should Mr. Jamison interpret the SMM computed? What is the CPR for month 42?
As one of the loan officers for Grove Gate Bank, calculate the monthly principal and interest, PI (in $), using this table and the monthly PITI (in $) for the mortgage. (Round dollars to the nearest cent.)
Calculate the amount financed, the finance charge, and the monthly payments (in $) for the add-on interest loan. (Round your answers to the nearest cent.)
Develop a general-purpose spreadsheet to calculate the balance due, principal payment, and interest payment for each period of a loan. The user inputs to the spreadsheet will be the loan amount, the number of payments per year, the number of years payments are made, and the nominal interest rate. Submit printouts of your analysis of a loan in the amount of $15,000 at 8.9% nominal rate for 36 months and for 60 months of payments
In the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000. It will be a 30-year mortgage. The interest your bank will charge will be 7.5%. In cell C5, create a function that determines what your monthly payment will be.
Based on Exhibit 9-9, or using a financial calculator, what would be the monthly mortgage payments for each of the following situations? How do I round time value factor and final answers to 2 decimal places? What relationship exists between the length of the loan and the monthly payment? How does the mortgage rate affect the monthly payment?
You may use your financial calculator or excel for calculations but be sure to show your work (i.e. rate, periods, payments, etc.). For the amortization schedule be sure to print the schedule so all columns fit on one page and only include the first and last pages of the schedule when you pass it in. Jack Casey is interested in buying a waterfront vacation home and has saved $300,000 for the down payment. His plans call for making additional monthly deposits into an investment account over the next 12 months. Casey wants to make the purchase 18 months from today and wants to have $400,000 saved up for the down payment. What is the amount of each of the additional payments he must make for his plan to work out? Assume Allen can earn 2% annual return in his investment account. If Casey takes out a 30-year, $1,200,000 mortgage at 5%, what will his mortgage payments be? Prepare an amortization schedule to prove that your answer is right and his mortgage will be paid off in 30 years.
Using this table as needed, calculate the required information for the mortgage. (Round dollars to the nearest cent.)
Show 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)
can you do a full solution to calculate the annuity and to build up a loan repayment repayment schedule thank you
You have just been hired as a loan officer at a national bank. Your first assignment is to calculate the amount of the periodic payment (in $) required to amortize (pay off) the following loan being considered by the bank (use Table 12-2). (Round your answer to the nearest cent.) LoanPayment PaymentPeriod Term ofLoan (years) NominalRate (%) Present Value(Amount of Loan) $ every month 1 3/4 6 $30,000
Use the formula or a calculator application to find the total interest paid for the home mortgage of $279,185 at 4.697% interest for 30 years given that the monthly payment is $1,446.62.