Answer:
To Prepare an appraisal report
Explanation:
The steps which are involved in the appraisal process are:
1. Stating the purpose.
2. Listing the data needed and its source
3. Gathering, recording and verifying the data.
4. Gathering, recording and verifying the specific data.
5. Gathering, recording and verifying the data for each approach.
6. Analyzing and interpreting the data.
7. Reconciling the data for the final estimation.
8. Prepare an appraisal report.
3, 3.5, -2, 3.7, -1, 0, 2, -3, -2.7, -1.34
Answer:
$936.17
Explanation:
The current market price of the bond = present value of all coupon received + present value of face value on maturity date
The discount rate in all calculation is YTM (6.12%), and its semiannual rate is 3.06%
Coupon to received semiannual = 5.3%/2*$1000= $26.5
We can either calculate PV manually or use formula PV in excel to calculate present value:
<u>Manually:</u>
PV of all coupon received semiannual = 26.5/(1+3.06)^1 + 26.5/(1+3.06)^2....+ 26.5/(1+3.06)^24 = $445.9
PV of of face value on maturity date = 1000/(1+6.12%)^12 = $490.27
<u>In excel:</u>
PV of all coupon received semiannual = PV(3.06%,24,-$26.5) = $445.9
PV of of face value on maturity date = PV(6.12%,12,-$1000) = 1000/(1+6.12%)^12 = $490.27
The current market price of the bond = $445.9 + $490.27 = $936.17
Please excel calculation attached
The monthly mortgage payment including principal and interest is $1,936.25
Explanation:
PV = (1 - 0.20) × $325,000 = $260,000
r = 0.041 / 12
t = 15 * 12 = 180
![C = \frac{PV}{\frac{1- [\frac{1}{(1+r)^{t} } ] }{r}}](https://tex.z-dn.net/?f=C%20%3D%20%5Cfrac%7BPV%7D%7B%5Cfrac%7B1-%20%5B%5Cfrac%7B1%7D%7B%281%2Br%29%5E%7Bt%7D%20%7D%20%5D%20%7D%7Br%7D%7D)
C = $260,000 ÷ [1 - {1 / (1 + 0.041 / 12)∧180} / (0.041 / 12)]
C = $1,936.25
The monthly mortgage payment including principal and interest is $1,936.25