How to Calculate A Return On Investment (Excel Basics)
Originally published: 11/01/2017 16:16
Last version published: 21/06/2017 09:26
Publication number: ELQ-73031-3
View all versions & Certificate
certified

How to Calculate A Return On Investment (Excel Basics)

Calculating an investor's return using the "cash flow method"

Introduction

This tool is made for you to make your own return calculation on a personally made Excel sheet, with a step-by-step procedure. This is done using the "cash flow method".

  • Step n°1 |

    Spreadsheet

    Get an excel sheet and lay out along a single row a number of years. 10 years is suggested to start with.
    How to Calculate A Return On Investment (Excel Basics) image
  • Step n°2 |

    The years

    In the first year show the total investment required as a negative number (because the investors are sending their money to you).
    How to Calculate A Return On Investment (Excel Basics) image

add_shopping_cartContinue reading for free (70% left)


4.7 / 5 (3 votes)

please wait...