How does one calculate and present a column of output values for a single
cell as a function of a column of input variables to a different cell?

That is, say, in a financial model, calculate and present a column of 50
NPVs as a function of a column of 50 different inputs for a single year's
revenue?

To extend that, NPVs as a function of 50 dirrerent revenue streams over time.

Use arrays?

Thanks.