Future Value

I'm sick and tired of looking at canned Financial Calculators differing
results.
I want to calculate how long a fixed value of money will last based on a
"Current Value", "Interest rate", "withdrawl". I also want to do a month by
month table of the above can someone tell me if this is possible?

Paul

Paul,

Use
=NPER(0.07/12,-200,11731.39,0)

Think about it in terms of you holding a 7.0% mortgage note with a balance
of $11,731.39 and the borrower having to pay you $200 a month until the
mortgage was paid off. You would receive $200 each month for 72 months or 6
years.

Don



"Paul Ilacqua" <[email protected]> wrote in message
news:[email protected]...
> I'm sick and tired of looking at canned Financial Calculators differing
> results.
> I want to calculate how long a fixed value of money will last based on a
> "Current Value", "Interest rate", "withdrawl". I also want to do a month
> by month table of the above can someone tell me if this is possible?
>
> Paul
>

To do the month by month analysis, you need to prepare an amortization
table. While many templates exist for this, I always do my own.

You need five columns: Month, Opening Balance, Payment, Interest, Closing
Balance
Opening Balance = initial value of loan/investment on row 1or Closing
Balance from previous row
Interest = Opening Balance * Rate / #periodsperyear (12 in your case)
Closing Balance = Opening Balance - Payment + Interest

Copy down until Closing Balance gets to zero.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Paul Ilacqua" <[email protected]> wrote in message
news:[email protected]...
> I'm sick and tired of looking at canned Financial Calculators differing
> results.
> I want to calculate how long a fixed value of money will last based on a
> "Current Value", "Interest rate", "withdrawl". I also want to do a month
> by month table of the above can someone tell me if this is possible?
>
> Paul
>

Fred,
Thanks so much... taht's just what I needed.
Paul
"Fred Smith" <[email protected]> wrote in message
news:[email protected]...
> To do the month by month analysis, you need to prepare an amortization
> table. While many templates exist for this, I always do my own.
>
> You need five columns: Month, Opening Balance, Payment, Interest, Closing
> Balance
> Opening Balance = initial value of loan/investment on row 1or Closing
> Balance from previous row
> Interest = Opening Balance * Rate / #periodsperyear (12 in your case)
> Closing Balance = Opening Balance - Payment + Interest
>
> Copy down until Closing Balance gets to zero.
>
> --
> Regards,
> Fred
> Please reply to newsgroup, not e-mail
>
>
> "Paul Ilacqua" <[email protected]> wrote in message
> news:[email protected]...
>> I'm sick and tired of looking at canned Financial Calculators differing
>> results.
>> I want to calculate how long a fixed value of money will last based on a
>> "Current Value", "Interest rate", "withdrawl". I also want to do a month
>> by month table of the above can someone tell me if this is possible?
>>
>> Paul
>>
>
>