Question
caculate in excel, please An appraiser is looking for comparable sales and finds a property that recently sold for $200,000. She finds that the buyer
caculate in excel, please
An appraiser is looking for comparable sales and finds a property that recently sold for $200,000. She finds that the buyer was able to assume the seller's fully amortizing mortgage which had monthly payments based on a 7 percent interest rate. The balance of the loan at the time of sale was $140,000 with a remaining term of 15 years (monthly payments). The appraiser determines that if a $140,000 loan was obtained on the same property, monthly payments at the market rate for a 15-year fully amortizing loan would have been 8 percent with no points.
- Assume that the buyer expected to benefit from the interest savings on the assumable loan for the entire loan term. What is the cash equivalent value of the property?
- How would your answer to part (a) change if you assumed that the buyer only expected to benefit from interest savings for five years because he would probably sell or refinance after five years?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started