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"

basiccashflowexcelinvestmentinvestor returnreturntemplateventure capital

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)

Reviews


keyboard_arrow_leftkeyboard_arrow_right

Any questions on How To Calculate A Return On Investment (Excel Basics)?

The user community and author are here to help. Go ahead!

please wait...