Create dates in a range for future cash-flows

[simon20]

Hi,

I have uploaded an Excel with asset values, calculated based on a start date, an end-date, a payment frequency, a payment and a discount rate. (Basically NPV calculated over time).

Now I want to model the future cash-flow and asset depreciation starting from the start date for all contracts. I have seen some solutions, but they all assume that the data fields are all in the same table. In my case I have the values divided over 3 tables:

Table 1:
Frequency

Table 2: 
Unit price

Table 3:
Start Date
End Date
Discount rate

Table 1 and Table 3 are connected through Table 2. 

[Gysbert_Wassenaar · Accepted solution]

You'll have to create a table that contains all the fields needed to calculate the result values you want. 

[simon20]

Ok, so the answer is in the import script then? In that I need to create one table with all the information needed to create the future cash flow?

[Gysbert_Wassenaar]

Yes, that's correct.