First, we calculate the nominal annual interest rates, given the EAR.
EAR = (1 + (r / 12))12 - 1 , where r = nominal annual interest rate.
8% EAR
EAR = (1 + (r / 12))12 - 1
8% = (1 + (r / 12))12 - 1
r = ((1 + 0.08)1/12 - 1) * 12
r = 9.57%
10% EAR
EAR = (1 + (r / 12))12 - 1
10% = (1 + (r / 12))12 - 1
r = ((1 + 0.10)1/12 - 1) * 12
r = 7.72%
Next, we calculate the amount of money required 30 years from now to fund the two goals of retirement income, and leaving inheritance to Frodo.
The amount of money required 30 years from now is calculated using PV function in Excel :
rate = 7.72% / 12 (nominal rate of return during retirement. Monthly rate = annual rate / 12)
nper = 15 * 12 (total number of monthly payments during retirement = number of years in retirement * 12 = 15 * 12)
pmt = -28000 (Monthly payment required during retirement. This is entered with a negative sign because it is a payment from the retirement fund)
fv = 600000 (Inheritance amount required to be left at the end of retirement. This is entered with a negative sign because it is a payment from the retirement fund)
PV is calculated to be $3,169,117.44
Now, we calculate the amount in the retirement fund 10 years from now, before the cabin in Rivendell is purchased. The amount in the retirement fund 10 years from now is calculated using FV function in Excel :
rate = 9.57%/12 (nominal rate of return before retirement. Monthly rate = annual rate / 12)
nper = 10 * 12 (total number of monthly savings upto 10 years = 10 * 12)
pmt = -2000 (Monthly saving amount. This is entered with a negative sign because it is a payment into the retirement fund)
FV is calculated to be $399,727.71
Out of this accumulated amount of $399,727.71, an amount of $320,000 is used to purchase the cabin in Rivendell. Amount remaining after cabin purchase = $399,727.71 - $320,000 = $79,727.71.
Lastly, we calculate the monthly saving required during Years 11 to 30 to accumulate the required amount in 30 years from now. The monthly saving required during Years 11 to 30 is calculated using PMT function in Excel :
rate = 9.57%/12 (nominal rate of return before retirement. Monthly rate = annual rate / 12)
nper = 20 * 12 (total number of monthly savings from Year 11 to Year 30 = 20 * 12)
pv = -79727.71 (Amount remaining after cabin purchase. This is entered with a negative sign because it is like a payment into the retirement fund)
fv = 3169117.44 (The amount of money required 30 years from now)
PMT is calculated to be $3,665.46
The monthly saving required during Years 11 to 30 is $3,665.46
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 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 $288,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 able to retire 30 years from now with a retirement income of $32,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 $405,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 able to retire 30 years from now with a retirement income of $25,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 $330,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 able to retire 30 years from now with retirement income of $28,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 $1,239,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 able to retire 30 years from now with retirement income of $31,500 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 10 years at an estimated cost of $415,000. Third, after he passes on at the end of 30 years, he would like to leave...
Problem 4-59 Calculating Annuity Values 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 $29,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 $370,000. Third, after he passes on at the end of the...
Problem 4-59 Calculating Annuity Values 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 $26,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 $340,000. Third, after he passes on at the end of the...
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,500 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 10 years at an estimated cost of $385,000. Third, after he passes on at the end of the 25 years of withdrawals, he would...
Please show work. Thank you Return to question Problem 4-59 Calculating Annuity Values points 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 $29,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 $370,000. Third,...
David Cooper wants to save money to meet three objectives. First, he would like to retire 30 years from now with retirement income of $21,000 per month for 20 years, with first payment received 30 years and 1 month from now. Second, he would like to purchase a cabin in Boise in 10 years at an estimated cost of $330,000. Third, after he passes on the end of the 20 years of withdrawals, he would like to leave an inheritance...