Question: Create an Amortization Schedule for a home that cost $259,000 with 20% down for a down-payment. Do not use an online amortization schedule. Note the

Create an Amortization Schedule for a home that cost $259,000 with 20% down for a down-payment. Do not use an online amortization schedule. Note the textbook amortization schedule is using an annual payment. Please complete a schedule for both 180 months (15 years) and 360 months (30 years). The interest rate for the year is 2.75% according to Bankrate for the area the home is in. Remember to divide your interest by 12 to get a monthly rate. How much interest will you pay over the life of each loan? You can determine this by summing all the payments and subtracting the amount borrowed.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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!

Assume that the axial load P applied to the lap joint is distributed equally among the three 20-mm-diameter rivets. What is the maximum load P that can be applied if the allowable stresses are 40 MPa...

Create an Amortization Schedule for a home that cost $259,000 with 20% down for a down-payment. I expect the amortization schedule to be completed in Excel with all work shown in Excel. Thus, I...

Create an Amortization Schedule for a home costing $300,000 at 4% for 30 years and $300,000 at 3.5% for 15 years. The amortization schedule is to be completed in Excel with all work shown in Excel ....

The house I chose is $475000 please show answer in excel with formulas thank you interest rate-5.996 I want you to find a home that you would like to buy. Use Google, Zillow, Realtor.com, or another...

In atleast 200 words. I want you to find a home that you would like to buy. Any amount and at any rate. Use Google, Zillow, Realtor.com, or another real estate site to find a home. Make sure to...

I want you to find a home that you would like to buy. Use Google, Zillow, Realtor.com, or another real estate site to find a home. Make sure to include the link for the home in your discussion post....

want you to find a home that you would like to buy. Use Google, Zillow, Realtor.com, or another real estate site to find a home. Make sure to include the link for the home in your discussion post....

1. Bella is 23 years old and wants to invest money for her retirement. She wants to have $2,000,000 saved up when she retires at age 65. a) If she can earn 10% per year in an equity mutual fund,...

If you vigorously shake a can of chicken broth back and forth for more than a minute, will the temperature of the broth increase?

Write a report on Ubiquitous microbes?

c ) A medical administrator who works in a small private optometry practice is asked to answer a cultural sensitivity question that is listed below in her own perspective which may be asked to a...

Elburn Supply Co. has the following transactions related to notes receivable during the last 2 months of 2014. The company does not make entries to accrue interest except at December 31. Nov. 1...

Marvelettes Company provided the following information: Standard fixed overhead rate (SFOR) per direct labor hour .....$ 5.00 Actual fixed overhead rate (AFOR) per direct labor hour .......$ 5.03...

Calculate the after-tax return of a 4.65 percent, 20-year, A-rated corporate bond for an investor in the 15 percent marginal tax bracket. Compare this yield to that of a 3.25 percent, 20-year,...

Calculate the percentage return on a 1-year Treasury bill with a face value of $10,000 if you pay $9,800 to purchase it and receive its full face value at maturity.

Multiple Choice Questions 1. When the government imposes a binding price floor, it causes a. The supply curve to shift to the left. b. The demand curve to shift to the right. c. A shortage of the...

Cyberphone, a manufacturer of cell phone accessories, ended the current year with annual sales ( at cost ) of $ 5 6 5 6 million. During the year, the inventory of accessories turned over eighteight...

What styles do they use?

create a semiotic sign system to communicate an idea.

apply research strategies to writing.