• Ask an Expert
• Get a Professional Answer
• 100% Satisfaction Guarantee
jstinehelfer, Information Systems Manager
Category: Microsoft
Satisfied Customers: 23
Experience:  A+ Comptia Certified computer repair
63323962
Type Your Microsoft Question Here...
jstinehelfer is online now

# Hi Im trying to do a fomular for annual return on investment. I

### Customer Question

Hi
I'm trying to do a fomular for annual return on investment.

I can work out return on investment (ROI) =SUM(A7/B7)

Where A7 is the profit and B7 is the investment (100 profit/50 investment) = 50%

What I can't work out is how to get the annual return on investment (AROI) when months are involved C7 being how many months

i.e If this took 12 months to complete then it would be 50%
but if it took 6 months then it would be 100%
and if it took 18 months to complete then it would be 25% ... and so on
can you help please
thanks
Submitted: 4 years ago.
Category: Microsoft
Expert:  Jess M. replied 4 years ago.
Hi, welcome and thank you for your question. My name is Jess and I am glad to assist you today.

Can you give me a dummy Excel file (just sample data) so that I will know what you are computing?

As I understood your description, you divide A7 by B7 to get ROI. Now you have C7 telling you how many months it is covered and you want to integrate this C7 to your computation for the AROI.

If this correct?

If you can send me a dummy file (just with dummy data), upload it to wikisend.com and give me the 6-digit File ID. More information in this link:

http://technicalforum.org/windows/how-easily-share-files-using-wikisend

Best regards,
Jess