Question

In: Finance

Bilbo Baggins wants to save money to meet three objectives. First, he would like to be...

Bilbo Baggins wants to save money to meet three objectives. First, he would like to be able to retire 30 years from now with retirement income of $25,000 per month for 25 years, with the first payment received 30 years and 1 month from now. Second, he would like to purchase a cabin in Rivendell in 15 years at an estimated cost of $574,000. Third, after he passes on at the end of the 25 years of withdrawals, he would like to leave an inheritance of $700,000 to his nephew Frodo. He can afford to save $1,800 per month for the next 15 years. If he can earn a 10 percent EAR before he retires and a 6 percent EAR after he retires, how much will he have to save each month in years 16 through 30?

Solutions

Expert Solution

PV of annuity for making pthly payment
P = PMT x (((1-(1 + r) ^- n)) / i)
Where:
P = the present value of an annuity stream
PMT = the dollar amount of each annuity payment
r = the effective interest rate (also known as the discount rate)
i=nominal Interest rate
n = the number of periods in which payments will be made
Nominal Interest rate 6%
Frequency monthly
Effective Interest rate (1+6%/12)^12)-1)
Effective Interest rate 6.168%
Monthly payment 25000 Monthly
Annual payment 300000
PV of annuity P = PMT x (((1-(1 + r) ^- n)) / i)
PV of annuity = 300000* (((1-(1 + 6.18%) ^- 25)) / 6%)
PV of annuity 3,883,388.80
PV of inheritance= 700000/(1+6%)^25
PV of inheritance=      163,099.04
Total Corpus required= 4,046,487.84
FV of First 15 years investment @ 10%
Nominal Interest rate 10%
Frequency monthly
Effective Interest rate (1+10%/12)^12)-1)
Effective Interest rate 10.471%
Monthly payment 1800
Annual payment 21600
FV of this annuity
FV of annuity
The formula for the future value of an ordinary annuity, as opposed to an annuity due, is as follows:
P = PMT x ((((1 + r) ^ n) - 1) / i)
FV= 21600*((((1 + 10.471%) ^ 15) - 1) / 10%)
FV=      746,006.55
Cabin Cost 540000
Corpus remaining      206,006.55
Value of this corpus at the time of retirement i.e. after 15 years
Value of this remaining corpus= 206006*(1+10%)^15
Value of this remaining corpus=      860,538.19
Corpus to be built with annuity from year 16 to year 30
Required corpus= =4046487.85-860538.186
Required corpus= 3,185,949.66
                   3,185,949.66 =P*((((1 + 10.471%) ^ 15) - 1) / 10%)
                   3,185,949.66 =P*34.537
P=        92,247.44
Monthly depost from t 16-T30=          7,687.29

Related Solutions

Bilbo Baggins wants to save money to meet three objectives. First, he would like to be...
Bilbo Baggins wants to save money to meet three objectives. First, he would like to be able to retire 30 years from now with retirement income of $28,000 per month for 20 years, with the first payment received 30 years and 1 month from now. Second, he would like to purchase a cabin in Rivendell in 20 years at an estimated cost of $1,149,000. Third, after he passes on at the end of the 20 years of withdrawals, he would...
Bilbo Baggins wants to save money to meet three objectives. First, he would like to be...
Bilbo Baggins wants to save money to meet three objectives. First, he would like to be able to retire 30 years from now with a retirement income of $28,500 per month for 20 years, with the first payment received 30 years and 1 month from now. Second, he would like to purchase a cabin in Rivendell in 10 years at an estimated cost of $365,000. Third, after he passes on at the end of the 20 years of withdrawals, he...
Bilbo Baggins wants to save money to meet three objectives. First, he would like to be...
Bilbo Baggins wants to save money to meet three objectives. First, he would like to be able to retire 30 years from now with retirement income of $31,000 per month for 20 years, with the first payment received 30 years and 1 month from now. Second, he would like to purchase a cabin in Rivendell in 10 years at an estimated cost of $390,000. Third, after he passes on at the end of the 20 years of withdrawals, he would...
Bilbo Baggins wants to save money to meet three objectives. First, he would like to be...
Bilbo Baggins wants to save money to meet three objectives. First, he would like to be able to retire 30 years from now with a retirement income of $33,000 per month for 20 years, with the first payment received 30 years and 1 month from now. Second, he would like to purchase a cabin in Rivendell in 10 years at an estimated cost of $410,000. Third, after he passes on at the end of the 20 years of withdrawals, he...
Bilbo Baggins wants to save money to meet three objectives. First, he would like to be...
Bilbo Baggins wants to save money to meet three objectives. First, he would like to be able to retire 30 years from now with retirement income of $22,000 per month for 20 years, with the first payment received 30 years and 1 month from now. Second, he would like to purchase a cabin in Rivendell in 20 years at an estimated cost of $1,423,000. Third, after he passes on at the end of the 20 years of withdrawals, he would...
Bilbo Baggins wants to save money to meet three objectives. First, he would like to be...
Bilbo Baggins wants to save money to meet three objectives. First, he would like to be able to retire 30 years from now with retirement income of $29,000 per month for 15 years, with the first payment received 30 years and 1 month from now. Second, he would like to purchase a cabin in Rivendell in 15 years at an estimated cost of $603,000. Third, after he passes on at the end of the 15 years of withdrawals, he would...
Bilbo Baggins wants to save money to meet three objectives. First, he would like to be...
Bilbo Baggins wants to save money to meet three objectives. First, he would like to be able to retire 30 years from now with retirement income of $26,000 per month for 30 years, with the first payment received 30 years and 1 month from now. Second, he would like to purchase a cabin in Rivendell in 20 years at an estimated cost of $977,000. Third, after he passes on at the end of the 30 years of withdrawals, he would...
bilbo baggins wants to save money to meet three objectives. first, he would like to be...
bilbo baggins wants to save money to meet three objectives. first, he would like to be able to retire 30 years from now with retirement income of $23,000 per month for 20 years, with the first payment received 30 years and 1 month from now. second, he would like to purchase a cabin in rivendell in 20 years at an estimated cost of $1,034,000. third, after he passes on at the end of the 20 years of withdrawals, he would...
Bilbo Baggins wants to save money to meet three objectives. First, he would like to be...
Bilbo Baggins wants to save money to meet three objectives. First, he would like to be able to retire 30 years from now with a retirement income of $33,000 per month for 20 years, with the first payment received 30 years and 1 month from now. Second, he would like to purchase a cabin in Rivendell in 10 years at an estimated cost of $410,000. Third, after he passes on at the end of the 20 years of withdrawals, he...
‎‏Bilbo Baggins wants to save money to meet three objectives . First , he would like...
‎‏Bilbo Baggins wants to save money to meet three objectives . First , he would like to be able to retire 30 years from now with retirement income of $ 26,000 per month for 30 years , with the first payment received 30 years and 1 month from now . Second , he would like to purchase a cabin in Rivendell in 10 years at an estimated cost of $ 256,000 . Third , after he passes on at the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT