ROIC - calculation

HI 

I'm trying to come up with ideas to analyse:

1. Acumulated balance per month/year (investment capital)

2. Average balance during the period (month/year) 

3. ROIC budget and real --> based on average capital invested, for EX: stock market, considering buy/sell activity

Does any one has suggestions?

Hello luciapernambuco
I am V. Arya, Independent Advisor, to work with you on this issue. Please post a screenshot of your data (no confidential data) so that we can give you ideas. Pivot table looks prime candidate for your first two needs.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

This is a standard warning that I give whenever I see a thread had a message from a support scammer. You may have not seen the message (it was deleted) and only if you had subscribed to the thread would you have seen the posting, but just in case, here's my boilerplate:

 

 

Do NOT respond to replies asking you to call Microsoft Support or an advisor.

 

Microsoft and Microsoft Advisors, and MVPs will NEVER ask you to call them in this forum or in an email message resulting from your posting here.

 

This is an attempt to take over your computer, steal your data and your identity.

Protect yourself from phishing schemes and other forms of online fraud - Office Support

 

Be sure to include the version number and OS version when asking your question.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Excel has various functions for calculating return on investment.

You might check out MIRR

MIRR function

For a complete list of built-in financial functions, see this:

Financial functions (reference)

Be sure to include the version number and OS version when asking your question.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 13, 2025 Views 134 Applies to: