How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask jstinehelfer Your Own Question
jstinehelfer, Information Systems Manager
Category: Microsoft
Satisfied Customers: 23
Experience:  A+ Comptia Certified computer repair
Type Your Microsoft Question Here...
jstinehelfer is online now

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

Customer Question

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
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 and give me the 6-digit File ID. More information in this link:

Best regards,