Question: Using an Excel spreadsheet , please complete the calculations for this home mortgage loan problem. Initial home mortgage amount borrowed: $245,000 . Annual mortgage loan

Using an Excel spreadsheet, please complete the calculations for this home mortgage loan problem.

Initial home mortgage amount borrowed: $245,000.

Annual mortgage loan rate: 5.15%.

Term of the home mortgage loan: 20 years.

Mortgage Payment: To be made on December 31 (i.e., once per year) during each of the 20 years that the mortgage loan is outstanding.

Step One: Calculate the value of the annual mortgage payment and enter that amount here:

$ ______________________

Step Two: Prepare a mortgage loan amortization table in Excel. Your loan amortization table should break each home mortgage payment into its “principal” and “interest” components.

Step Three: Over the 20-year life of the home mortgage loan, list the following values that are paid:

Total interest over the 20-year life of the loan: $_______________.

Total principal over the 20-year life of the loan: $ ______________.

Step by Step Solution

★★★★★

3.28 Rating (148 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To calculate the annual mortgage payment we can use the PMT function in Excel The formula for this i... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

1. Suppose that a pair of dice is rolled. Given that the two numbers are different, what is the probability that one die shows a three? 2. Consider Table 1, with figures in millions, pertaining to...

Start of Payroll Project 7-3a October 9, 20-- No. 1 The first payroll in October covered the two workweeks that ended on September 26 and October 3. This payroll transaction has been entered for you...

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

Build a spreadsheet to find the EAW of each lawn- mower in Problem 8-29. Use the GOAL SEEK tool of Excel to find the IRR of the incremental investment. Data from 8-29 Don Garlits is a landscaper. He...

Presented below is the unaudited balance sheet as of December 31, 2007, prepared by the bookkeeper of Zues Manufacturing Corporation. Your firm has been engaged to perform an audit, during which the...

A few years back, Dave and Jana bought a new home. They borrowed $230,415 at a fixed rate of 5.49% (15-year term) with monthly payments of $1,881.46. They just made their twenty-fifth payment and the...

On December 31, 2012, Mercantile Corp. had a $10,000,000, 8% fixed-rate note outstanding, payable in 2 years. It decides to enter into a 2-year swap with Chicago FirstBank to convert the fixed-rate...

Pic Corporation acquired an 80 percent interest in Sic Company on January 1, 2011, for $136,000, when Sic's capital stock and retained earnings were $100,000 and $70,000, respectively. At the...

Equity method entries. Weber Corporation acquired significant influence over Albee Computer Company on January 2 by purchasing 20% of its outstanding stock for $100 million. Weber Corporation...

Kelly Realty loaned money and received the following notes during 2012. Requirements For each note, compute interest using a 360-day year. Explanations are not required. 1. Determine the due date and...

Q1) The U.S. Department of Agriculture records data on farm acreage and the number of farms by county for every county in the country. This takes considerable time and energy, and the results for...

Global supply chain partners can experience various problems, such as managing the long-range logistics involved during the end-to-end process. Various issues contribute to such operational problems,...

Select the best option from the list of options provided to identify the impact on the total sample size based on each of the below facts. Each choice may be used once, more than once, or not at all....

7. How Did Boeing Corporate Strategy Impact Design and Production of the 737 Max, and How Did Airbus Influence Boeing's Strategy and Product Quality (Starting in 2011)

In your organization, are the majority of physicians employed by the hospital or private practice? Do you think that being employed by a hospital or health service organization has a more positive...

Should there be continued support for the funding of primary care physician (Internists, Family Physicians, Psychiatrists, Geriatricians) education or shift resources to "associated healthcare...

A substantial portion of inventory owned by Prentiss Sporting Goods was recently destroyed when the roof collapsed during a rainstorm. Prentiss also lost some of its accounting records. Prentiss must...

The liquidliquid extractor in Figure 8.1 operates at 100F and a nominal pressure of 15 psia. For the feed and solvent flows shown, determine the number of equilibrium stages to extract 99.5% of the...

Ray and Maria Gomez have been married 3 years. They live at 1610 Quince Ave., McAllen, TX 78701. Ray works for Palm Oil Corporation and Maria works for the City of McAllen. Maria's Social Security...

Phil and Linda are 25-year-old newlyweds and file a joint tax return. Linda is covered by a retirement plan at work, but Phil is not. a. Assuming Phil's wages were $27,000 and Linda's wages were...

Brian and Kim have a 12-year-old child, Stan. For 2012, Brian and Kim have taxable income of $52,000, and Stan has nonqualifying dividend income of $4,500 and investment expenses of $250. No election...

4. How can stress lead to damage in the hippocampus?

3. Recall LeVays study of brain anatomy in heterosexual and homosexual men (p. 348). Certain critics have suggested that one or more of the men classified as heterosexual might actually have been...

2. What evidence suggests that criminal behavior depends on a combination of biological predisposition and family environment?