> erm theres an NPV function built in excel.

Exactly!

The LLM just needs to make sure it uses it appropriately. Doing that bit is the non-deterministic part, but the NPV calculation itself is completely deterministic.