how to calculate portfolio growth in numbers for the year as a percentage
(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.
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 .