Hello VBA fans,
i´ve got differnt Kind of contracts, with different kind of running time.
In this table i have the year and the costs.
For example.
Year/Costs
2010/10
2011/600
2012/1500
2013/3000
2014
2015
2016
2018
2019
The costs for 2014 - 2019 are not know yet.
Now i have 6 different kind of contracts. The contracts have several running time´s.
Now i want to calculate the expecting costs of the contract.
For each contract with a several running time, i´ve created percentages, in several Sheets.
So for example, if a contract runs 8 years, after 4 years, 19% of the total costs have allready arisen.
With this i want to calculate the expected costs.
This would be then 3000€ (year 4) / 19 (percentage of the total costs in year 4, by a running time of 8 years) * 100.
Then i have the expected costs.
It something likes this possible?
I really have not so much clue how to do that.
Help, please!
I put a file in the Appendix.
Here are further informations.
greetz benjamin
Bookmarks