View Single Post
 
Old 06-11-2015, 08:26 AM
lynchbro lynchbro is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
 
Join Date: Jun 2014
Location: New York
Posts: 41
lynchbro is on a distinguished road
Default Calculating the cost of an investment

I am trying to calculate the cost of a $10,000 investment. I can calculate this easily without accounting for annual operating expenses. Does anyone know how to add this into the calculation?
Here is my example:

Beginning Investment $10,000.00
Annual Return 5.00%
Annual Operating Expenses 1.00%
Number of Compounding Periods Per Year 1
Number of Years 10
Profit on Investment $3,439.16
Total Investment Value $13,439.16

My formula in cell B6 to calculate the profit on investment is as follows:

=(B1*(1+B2/B4)^(B4*B5)-B1)

I am a lost on how to add in the annual operating expenses into this equation.

Please help!
Reply With Quote