a financial scenario using a 17/19BII  Printable Version + HP Forums (https://archived.hpcalc.org/museumforum) + Forum: HP Museum Forums (https://archived.hpcalc.org/museumforum/forum1.html) + Forum: Old HP Forum Archives (https://archived.hpcalc.org/museumforum/forum2.html) + Thread: a financial scenario using a 17/19BII (/thread36944.html) 
a financial scenario using a 17/19BII  Justin  06222003 Hi there. I came up with a scenario that I'm not sure how to solve with my 17BII: John is retiring in 20 years. He wants to be able to withdraw the inflation adjusted equivalent of $50,000 a year for 10 years after retirement. How much does he need to deposit annually up until retirement for his needs to be met, if he can get 8% on his money and inflation is assumed to be 3.5%? To tackle this I worked out the inflation adjusted payment for each of the ten years after retirement, but as the cash flow isn't a normal annuity (equal payments for each period) I don't know how to work out what the savings schedule should be because I can't figure out the lump sum that gets John his payments while still taking advantage of interest over the 10 years. Any gurus out there know the way to solve one of these using a 17BII? ********************************************************** EDIT: Actually, I think I've got it.... I would do a CFLO list of the ten payments and use the NPV at an I of 8% for the lump sum target amount. Can someone confirm this is correct?
Thanks in advance! Edited: 22 June 2003, 7:14 p.m.
Re: a financial scenario using a 17/19BII  Stephan (Germany)  06232003 Dear Justin, before trying to solve the actual problem, I'd like to know if you assume the yield of 8 % as constant over the whole 30 years. It might be reasonable to set the yield rate to 8 % for the saving period (until retirement), but a lower rate should be considered for the time after, e.g. 5 % as John will shift his investment from long term highyield type to short term safe havens. In general, if inflation rate is set to a constant figure, you could do all calculations in "today's value" by just considering the real interest rate (after deduction of constant inflation). First step would be to calculate the demand for ten years at the beginning of retirement. Second to calculate the annual saving rate from today until retirement. Meaning two separate calculations.
Best regards,
Stephan
Re: a financial scenario using a 17/19BII  Werner Huysegoms  06232003 I did this once before (albeit a bit differently), so here goes: Re: a financial scenario using a 17/19BII  Justin  06232003 Werner: Thanks for your brilliantly detailed answer. I am going through it, and may have some questions later if that's OK with you. Once again, thanks! ********************************************************** EDIT: Werner:
Am I right in assuming that if you didn't want to adapt the payments in for inflation but instead keep them the same throughout the build up period to give a lump sum of 793,155.34 that that annual figure would be a payment of
Thanks in advance Edited: 24 June 2003, 2:20 a.m.
Re: a financial scenario using a 17/19BII  Justin  06232003 Stephan: Yes, the decreased return is more realistic. I was more trying to get my thinking around the calculations. Below, Werner has provided a great working example elaborating the scenario.
I'm going through it now to make sure I fully understand it.
Re: a financial scenario using a 17/19BII  Werner Huysegoms  06242003 Yes, that's 'conventional' TVM. Re: a financial scenario using a 17/19BII  Justin  06242003 Thanks Werner! Your explanation has lifted a cloud of confusion.
Much obliged.
