Numbers

Created at: 2021-03-14 02:40:24
Questioner General

how to calculate portfolio growth in numbers for the year as a percentage

Answer #1:

By: Dr. Lesley Tillman I

how to calculate portfolio growth in numbers for the year as a percentage

Answer #2:

By: Miss Alana Bartoletti

(Value at end of year - value at beginning of year) divided by value at beginning of year. Format Data format of cell containing the formula as Percentage.



Regards,

Barry

Answer #3:

By: Arlie Abernathy

(Value at end of year - value at beginning of year) divided by value at beginning of year. Format Data format of cell containing the formula as Percentage.



Regards,

Barry

Answer #4:

By: Ms. Constance Lehner DVM

The simplest formula most financial analysts use is:



Ending Value/Beginning Value -1



If the value at the beginning of the years is in, say B2 and value at the end of the year is in C2 you would simply use C2/B2-1 .



SG