Find number of periods from annuity formula

I have attempted to separate the number of periods (n) from the following equation

pv (1 + i)^n + pmt (1 + i * type) [{(1 + i)^n - 1}/i] + fv = 0

Have I done this correctly? (Thinking)

type has either a value of 0 for end of period payments and 1 for start of period payments

n = log[ { pmt * ( 1 + i * type) - fv * i } / { pmt * ( 1 + i * type) + pv * i } ] / log( 1 + i * type)

Thanks

Re: Find number of periods from annuity formula

Re: Find number of periods from annuity formula

Quote:

Originally Posted by

**SpringFan25** I dont want to discourage questions, but wouldn't it be easier to test this yourself by substituting values, rather than ask us to repeat the algebra looking for errors?

I have not checked your answer in any detail, but look at your denominator:

log( 1 + i * type)

if type=0, then this is log(1). Log(1)=0 and so your expression is undefined (anything divided by 0 is undefined)./

I had a hunch there was something I did wrong

Well time to go back to the paper and pencil and redo the math

Will let you know if I come up with a correct solution

Thanks

Re: Find number of periods from annuity formula

Finally got it working

Thanks

Re: Find number of periods from annuity formula

My site provides complete access Edmonton Real Estate

Re: Find number of periods from annuity formula

Quote:

Originally Posted by

**bradhows** My site provides complete access Edmonton Real Estate

Are spammers allowed on this forum

Your site is a blog about real estate, what the heck that got to do with finding number of periods in an annuity (Punch)