Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask John D Your Own Question

John D, Engineering Consultant

Category: Networking

Satisfied Customers: 9666

Experience: Bachelor of Science - Engineering Consultant

53785

Type Your Networking Question Here...

John D is online now

an Excel formula problem calculate growth of an investment,

Resolved Question:

an Excel formula problem: calculate growth of an investment, with a regular/consistent gain each year, but with a exspense deduct every year. Example: invest $1000, it grows 12%, but then there is a 2% exspense deducted each year. Does Excell have a formula to calculate this? Have Excel 2010, and Win 7.

Your answer// net growth, 12$ an -@% NO not the same. add 12%, then subtract 2% of that number. the result becomes the $$ invested next year, and begin again

Ok this is the modified formula which returns the growth of a $1000 investment over a period of 10 years at 12% annual interest and 2% expense deduction

=FV(0.12,10,,-1000*0.98)

Please try it and let me know if you have any questions

John D and other Networking Specialists are ready to help you