![]() |
|
#1
|
|||
|
|||
|
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!
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| New Cost columns are not summing up. | elvanaguven | Project | 3 | 11-08-2014 02:28 PM |
| Cost of Investment with assumptions | lynchbro | Excel | 0 | 06-25-2014 04:07 PM |
Cost Reporting 2013
|
Steve. | Project | 7 | 05-14-2014 06:28 AM |
Need totoal cost despite project being in progress
|
Sognamed | Project | 1 | 07-23-2013 06:06 AM |
| How to rename cost column | ketanco | Project | 3 | 06-15-2012 03:06 PM |