Finding Initial Outlay given IRR and payments

[bkericksen]

I have a problem where I am looking to calculate the Initial Outlay required to meet a given IRR with 10 periods of the same payments.

Desired IRR = 15%
Periods= 10
Payments= $219,174.93
Initial Outlay = x

Is there a function or formula that will calculate this for me in Excel?

Thank you!

 

[VBA Geek]

this could be what you looking for:

https://support.office.com/en-us/article/pv-function-23879d31-0e02-4321-be01-da16e8168cbd

 

[JasonDJ]

You can use PV formula. =PV(15%,10,219174.93).
Better still, give cell reference for the numbers.