The ""simple ranking"" method for evaluating RFPs assigns an additional value to the rating scale to take into account the relat
1 answer:
You might be interested in
Answer:
$1,247.12
Explanation:
For computing the asked price we need to apply the present value formula i.e to be shown in the attachment below
Given that,
Future value = $1,000
Rate of interest = 4.151% ÷ 2 = 2.076%
NPER = 17 years × 2 = 34 years
The 20 years come from May 2019 to May 2036
PMT = $1,000 × 6.193% ÷ 2 = $30.965
The formula is shown below:
= -PV(Rate;NPER;PMT;FV;type)
So, after applying the above formula, the present value or the ask price is $1,247.12
Answer:
- 3.21%
Explanation:
In this question, we use the PV formula which is shown in the spreadsheet.
The NPER represents the time period.
Given that,
Future value = $1,000
PMT = 1,000 × 5% = 50
NPER = 34 years - 1 year = 33 year
Rate of interest = 9%
The formula is shown below:
= -PV(Rate;NPER;PMT;FV;type)
So, after solving this, the present value would be $581.42
Now the return would be
= Sale price + interest - purchase price
= $581.42 + $50 - $652.39
= -$20.97
And, the total return would be
= Return ÷ purchase price
= -$20.97 ÷ $652.39
= - 3.21%
