Investment and present value

[ivixinja]

Hi!
I have a task, where I have to find the present value of an investment considering the inflation rate and continuously growing (by constant value and by rate) recieved incomes.
It's pretty complicated to explain, so I attached the task.

The basic PV function doesn't work here, since the payment isn't constant. I had an idea, that there would be a possible way to insert an additional formula in Pmt field (something that would help with that growth)... but I struggle to find the right one. So I'm really looking for some help

[shg]

What is the income strream? It can't start at $700/mo and increase by $350/mo; that would return $428K.

[ivixinja]

What is the income strream? It can't start at $700/mo and increase by $350/mo; that would return $428K.

It is said in the task: You invest in a project 70000; in the first month you recieve 700 and +350 in every sequent month.

You gave me the point, that it might be impossible to calculate without cash flow... Is it so?

[shg]

Reckon you just make a payment table and use XNPV:

Please Login or Register  to view this content.

[ivixinja]

I would never find that function, so you really saved me I'm ssooooo happy right now!
THANK YOU so much!!!

Reckon you just make a payment table and use XNPV:

Please Login or Register  to view this content.