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.