NO.PZ201803130100000602
问题如下:
Construct the overall goals-based asset allocation for the Armstrongs given their three goals and Abbott’s suggestion for investing any excess capital. Show your calculations.
Show your calculations.
选项:
解释:
Guideline Answer:
■ The module that should be selected for each goal is the one that offers the highest return given the time horizon and required probability of success.
■ Approximately 16.4%, 12.7%, 50.4%, and 20.5% should be invested in Modules A, B, C, and D, respectively. The appropriate goals-based allocation for the Armstrongs is as follows:
Supporting calculations:
For Goal 1, which has a time horizon of five years and a required probability of success of 85%, Module C should be chosen because its 4.4% expected return is higher than the expected returns of all the other modules. The present value of Goal 1 is calculated as follows:
N = 5, FV = –5,000,000, I/Y = 4.4%; CPT PV = $4,031,508 (or $4.03 million)
So, approximately 50.4% of the total assets of $8 million (= $4.03 million/$8.00 million) should be allocated to Module C.
For Goal 2, which has a time horizon of 10 years and a required probability of success of 99%, Module B should be chosen because its 2.2% expected return is higher than the expected returns of all the other modules. The present value of Goal 2 is calculated as follows:
PV=$100,000/(1.022)1+$100,000(1.03)1/(1.022)2+$100,000(1.03)2/(1.022)3+...+$100,000(1.03)9/(1.022)10
PV = $1,013,670 (or $1.01 million)
So, approximately 12.7% of the total assets of $8 million (= $1.01 million/$8.00 million) should be allocated to Module B.
For Goal 3, which has a time horizon of 25 years and a required probability of success of 75%, Module D should be chosen because its 7.5% expected return is higher than the expected returns of all the other modules. The present value of
Goal 3 is calculated as follows:
N = 25, FV = –10,000,000, I/Y = 7.5%; CPT PV = $1,639,791 (or $1.64 million)
So, approximately 20.5% of the total assets of $8 million (= $1.64 million/$8.00 million) should be allocated to Module D.
Finally, the surplus of $1,315,032 (= $8,000,000 – $4,031,508 – $1,013,670 –$1,639,791), representing 16.4% (= $1.32 million/$8.00 million), should be invested in Module A following Abbott’s suggestion.
想到一个简便算法,辛苦老师帮忙看看是否可以适用其他情况
1.首先知道生活费需要是先付年金形式,调整计算器之后pmt=-100000,I/Y=-0.78,N=10,FV=0,算出pv=1036127.84
由于是从第二年末inflation才开始调整的,所以I/Y=-0.78对应的调整之后的数据,而本身还有一年2.2%未计算进去,所以还需要再多除一个(1+2.2%)
通过数据验证是没问题的,所以想看看这种取巧的方法能否在之后其他类似的题中推广,也就不存在理解起来比较费劲的问题了