Hello Dam,

What you want is quite complex. Your best bet would be to invest in some off the shelf Excel Financial programs that do what you're asking. This site has links to financial software solutions for Excel. Search Google and you will find plenty to choose from.

Sincerely,
Leith Ross