h*****x 发帖数: 47 | 1 大侠,这题对您是小菜一碟吧。给讲讲怎么做。多谢您了!
题目如下,请把您用的formula给写上。多谢!
Assume that on your 26th birthday, you have fully repaid your student loan,
and you start to put money into your Roth IRA account for retirement purpose
. You are able to deposit $5,000 into the account each year, and the first
deposit is made on your 26th birthday. Five years later, you are allowed
and are able to contribute an additional $1,000 per year (i.e., a deposit of
$6,000 per year). Assuming that from there on, every five years, the | d*********n 发帖数: 27 | 2 沾沾光,我的笨办法,请大侠一并改改
1200000
=5000 e^32r (e^4r + e^3r + e^2r + e^1r + 1)
+6000 e^27r (e^4r + e^3r + e^2r + e^1r + 1)
+7000 e^22r (e^4r + e^3r + e^2r + e^1r + 1)
+8000 e^17r (e^4r + e^3r + e^2r + e^1r + 1)
+9000 e^12r (e^4r + e^3r + e^2r + e^1r + 1)
+10000 e^7r (e^4r + e^3r + e^2r + e^1r + 1)
+11000 e^2r (e^4r + e^3r + e^2r + e^1r + 1)
+12000 (e^r + 1)
numerically, one gets r=0.07169 | h*****x 发帖数: 47 | 3 谁知道用excel怎么做这题?下面是一道例题,解法一模一样,只有future value不一
样,是$80000 ,所以用excel算得annual return是5.47%,请查看例题。
虽然有这个例题,可是老师把formula给删除了,所以,我不知道那个5.47%是怎么算出
来的。
例题:
Return on Investment 5.472432%
Post Retire Return 5.472432%
Cost of Living Adjustment 0.000000%
First Contirbution $5,000
First Withdrawal $0
Total Contribution $304,000
Age Beginning Balance Returns (%) Dollar Return Annual Contribution Ending
Balance
26 $0.00 5.47% $- $5,000 $5,000.00
27 $5,000.00 5.47% $273.6 | h*****x 发帖数: 47 | 4 二楼你的解法我看不懂,但还要谢谢你。
老师是要求用excel spreadsheet做这个题目。但谁要是能用计算器算出来annual
return 也行。 | d*********n 发帖数: 27 | 5 我是把每年的存款分开看, 第一个 5000 存 36 年, 所以到最后是 5000 e^36r
第二个5000 就是5000 e^35r, 别的依次类推。
r 是 continuous pound rate, 所以 annual rate 是 e^r-1
像你的例题里, final =800000 的时候 r=0.05328 , 所以 annual 是 e^r-1 = 0.0547 | a*z 发帖数: 294 | | v****e 发帖数: 19471 | 7 Financial Calculator:
CF = Cash Flow; F = Frequency
CF0=5K
CF1=5K, F1=4
CF2=6K, F2=5
CF3=7K, F3=5
CF4=8K, F4=5
CF5=9K, F5=5
CF6=10K, F6=5
CF7=11K, F7=5
CF8=12K, F8=1
CF9=-11.8K (-1,200,000 + 12,000 = -1,180,000), F9=1
Compute IRR => IRR=7.4322%
,
purpose
first
of
IRA
【在 h*****x 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 大侠,这题对您是小菜一碟吧。给讲讲怎么做。多谢您了! : 题目如下,请把您用的formula给写上。多谢! : Assume that on your 26th birthday, you have fully repaid your student loan, : and you start to put money into your Roth IRA account for retirement purpose : . You are able to deposit $5,000 into the account each year, and the first : deposit is made on your 26th birthday. Five years later, you are allowed : and are able to contribute an additional $1,000 per year (i.e., a deposit of : $6,000 per year). Assuming that from there on, every five years, the
| h*****x 发帖数: 47 | 8 二楼, and AZZ, and vankie, thanks you. | h*****x 发帖数: 47 | 9 dontbesocnn非常聪明,赞!
azz, 谢谢你的回应!
0547
【在 d*********n 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 我是把每年的存款分开看, 第一个 5000 存 36 年, 所以到最后是 5000 e^36r : 第二个5000 就是5000 e^35r, 别的依次类推。 : r 是 continuous pound rate, 所以 annual rate 是 e^r-1 : 像你的例题里, final =800000 的时候 r=0.05328 , 所以 annual 是 e^r-1 = 0.0547
| h*****x 发帖数: 47 | 10 vankie, 你是最聪明的!散花!散花!你的答案完全正确!!!!
用excel的what-if功能可以算出答案。 | v****e 发帖数: 19471 | 11 不需要聪明, 会用BAII plus就成, LOL
【在 h*****x 的大作中提到】![](/moin_static193/solenoid/img/up.png) : vankie, 你是最聪明的!散花!散花!你的答案完全正确!!!! : 用excel的what-if功能可以算出答案。
|
|