Networking

Networking

# an Excel formula problem calculate growth of an investment,

Customer Question
an Excel formula problem: calculate...
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.
Submitted: 6 years ago.Category: Networking
Show More
Show Less
6/10/2011
Network Technician: John D, Engineering Consultant replied 6 years ago
John D, Engineering Consultant
Category: Networking
Satisfied Customers: 9,666
Experience: Bachelor of Science - Engineering Consultant
Verified

Hi,

So isn't that the same as net growth of 10% (i.e. 12%-2%)

Customer reply replied 6 years ago

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

Network Technician: John D, Engineering Consultant replied 6 years ago

Not sure I understand what you are trying to say!

I never said anything about 12\$. If you read my reply I typed the arithmetic expression for this statement

12 percent less 2 percent equals 10 percent

Customer reply replied 6 years ago
Network Technician: John D, Engineering Consultant replied 6 years ago

I wish I have crystal ball with me today so it could tell me the number of years you are applying this to... lol

How many years is this answer calculated for?

Customer reply replied 6 years ago
that would be for one year
Network Technician: John D, Engineering Consultant replied 6 years ago

Thanks.

Ok here you go

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

(just copy the above formula and paste it as is into any cell)

Hope this is ok. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution

John D, Engineering Consultant
Category: Networking
Satisfied Customers: 9,666
Experience: Bachelor of Science - Engineering Consultant
Verified
Customer reply replied 6 years ago

first, add .12% then subtract 2% I am using Excell, enter .2% and 12%

I will leave *.98 to those better at math.

Network Technician: John D, Engineering Consultant replied 6 years ago

Thanks

the 0.98 is (1-0.02) or (100%-2%). So you can replace the 0.98 in the formula by

=FV(0.12,1,,-1000*(100%-2%))

which will give you the same result

John D, Engineering Consultant
Category: Networking
Satisfied Customers: 9,666
Experience: Bachelor of Science - Engineering Consultant
Verified
Customer reply replied 6 years ago
same result for at the end of ten years? or for one year?
Network Technician: John D, Engineering Consultant replied 6 years ago

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, Engineering Consultant
Category: Networking
Satisfied Customers: 9,666
Experience: Bachelor of Science - Engineering Consultant
Verified
Customer reply replied 6 years ago

Could not get the FV function to work right, \$3107.x; doing year, I get \$3355.63

using your version, guess I m essed up, that was way off. progress comes stages

Network Technician: John D, Engineering Consultant replied 6 years ago

Ok could you give me the following values

1- Invested amount

2- Annual % growth

3- Number of years invested

4- Expenses percentage

Customer reply replied 6 years ago

\$1000, 12% gro each year; 10 years; expenses each year 2%

what are we doing up so late? now 4 am for you

Network Technician: John D, Engineering Consultant replied 6 years ago

lol... no I'm in California, 9:40 pm

one moment...

Network Technician: John D, Engineering Consultant replied 6 years ago

Ok using this formula:

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

the result is

\$3,043.73

John D, Engineering Consultant
Category: Networking
Satisfied Customers: 9,666
Experience: Bachelor of Science - Engineering Consultant
Verified
John D, Engineering Consultant
Category: Networking
Satisfied Customers: 9,666
9,666 Satisfied Customers
Experience: Bachelor of Science - Engineering Consultant

John D is online now

A new question is answered every 9 seconds

• Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
• Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

## What Customers are Saying:

I am very happy with my very fast response. Eric is very knowledgeable in the subject area. Thank you!

RPAustin, TX

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

< Previous | Next >

## Meet the Experts:

Claws224

IEEE Network Engineer

1,256 satisfied customers

IEEE, Microsoft

Kevin

LAN/WAN Specialist

1,165 satisfied customers

Certified MCSA and MCP Network Administrator with over 20 years of PC experience.

Byron

PC Support Tech

640 satisfied customers

CCNA, A+, MCSE 11 years at a large law firm.

Eric K.

510 satisfied customers

13 years of desktop, server and network support experience

Mr. Clark

Network Engineer

510 satisfied customers

Computer Business Owner / Former DoD Network Specialist

Chris L.

Support Specialist

447 satisfied customers

Certified Networking expert with over 10 years experience.

A. Stevens

428 satisfied customers

10+ years of Desktop, Laptop, and Server troubleshooting and support.

< Previous | Next >

Related Networking Questions
Trying to get dm200 to work with centurylink 80 meg service
trying to get dm200 to work with centurylink 80 meg service - I believe it is vdsl2? The DM200 worked fine with their 20 meg service,, … read more
Suhasini Velu
Bachelor of Engineering
143 satisfied customers
I am not able to communicate with computers on my network.
I am not able to communicate with computers on my network. Error on all machines "Windows could not automatically detect proxy server" … read more
Jason Jones
AAS Information Technology
6,320 satisfied customers
I paid for a membership under the name Caryn Bergman
I paid for a membership under the name Caryn Bergman (*****@******.***) on December 16 and I still haven't received me card … read more
Kris R
IT Manager
Computing
2,652 satisfied customers
It will not find my wireless Internet access. Will find
It will not find my wireless Internet access. Will find neighborhood connection … read more
Patrick Evans
Network Engineer
MS
10 satisfied customers
My microsoft outlook email has been locked because of an
My microsoft outlook email has been locked because of an attack on my system. I have a second email account on outlook and I can get into that one, but not my main email. I tried to chat with an outlo… read more
Kris R
IT Manager
Computing
2,652 satisfied customers
I HAVE TRIED TO 30 TO REGISTER PRODUCT help. I HAVE VERIZON-
i HAVE VERIZON- SUPPLY ALL i JUST WANT TO REGISTER AND HOOK UP i AM 80 RECOVERING FROM STROKE … read more
Kris R
IT Manager
Computing
2,652 satisfied customers
I cannot connect my tablet to the internet. My internet is
My internet is fine. I can get on the internet on my laptop but not my tablet. … read more
Karthik
Senior Engineer
Bachelor of Engineering
70 satisfied customers
I am not having a problem with computer. I am attempting to
I am not having a problem with computer. I am attempting to retrieve my password ***** restore one of the computers in my office at home to be able to access the internet. … read more
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
953 satisfied customers
I can't remember my Comcast wifi password. Can't remember. I
can't remember. I did not think I changed it but the original one doesn't work. … read more
Isaac Franklin
Associate of Science in Social Sciences
971 satisfied customers
I need my external ip address. I need to enter it into my
I need my external ip address. I need to enter it into my cameras DVR … read more
Patrick Evans
Network Engineer
MS
10 satisfied customers
The router is only showing an light. Netgear. Unplugging and
there is something called an Arris connected to it.… read more
Karthik
Senior Engineer
Bachelor of Engineering
70 satisfied customers
Need helps to reset password. ago months perhaps
Need helps to reset password JA: When did you last change your Wi-Fi password? Customer: Long ago months perhaps JA: Have you connected to this Wi-Fi network from a laptop or desktop (either Mac or PC… read more
Jason Jones
AAS Information Technology
6,320 satisfied customers
I have an Appletv. For the past few months I have been
I have an Appletv. For the past few months I have been unable to watch CCNN nor CBS neither on my laptop. I get a notice to contact my provider. My internet connection is with Optimum. Can you help? … read more
David L.
Bachelor\u0027s Degree
6 satisfied customers
i can get on my laptop but not my ipad i had reset asking for the password ***** the one on the bottom of the modem does not work … read more
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
953 satisfied customers
I have confirmed by ID ([email protected]) but my Passwords
I have confirmed by ID (*****@******.***) but my Passwords are opening the file. Is there a way to reset the password; do you have in on file. I'm a long term user but update Quicken a few times a yea… read more
David L.
Bachelor\u0027s Degree
6 satisfied customers
I have forgotton my router password, never, yes, im trying
im trying to connect a TV box and need the password… read more
Suhasini Velu
Bachelor of Engineering
143 satisfied customers
My orbi 13 system is dropping out. I get a good signal, but
my orbi 13 system is dropping out. I get a good signal, but it does not last. Heretofore, I have had no problems for several years. The main WIFI signal is strong and stable. … read more
RussellA
Solutions Architect
Bachelor\u0027s Degree
123 satisfied customers
Wi-fi is off line. My wi-fi ie from spectruim, wireiess
my wi-fi ie from spectruim, wireiess network name {ssid} failed. Printer name is*****: What have you tried so far?… read more
Russell H.
computer technology consultant