Question: I believe I input the correct numbers in the formula for Excel but it's wrong. Loan Amortization Assume that your aunt sold her house on

I believe I input the correct numbers in the formula for Excel but it's wrong. Loan Amortization
Assume that your aunt sold her house on December 31, and to help close the sale she took a second mortgage in the amount of $10,000 as part of the payment. The mortgage has a quoted (or nominal) interest rate of 8%; it calls for payments every 6 months, beginning on June 30, and is to be amortized over 5 years. Now, 1 year later, your aunt must inform the IRS and the person who bought the house about the interest that was included in the two payments made during the year. (This interest will be income to your aunt and a deduction to the buyer of the house.) To the closest cent, what is the total amount of interest that was paid during the first year? Do not round intermediate calculations. Round your answer to the nearest cent.

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!