Greetings! Would you know what is the function in excel on how to compute for the future value of investment at the amount adjusted for inflation? e.g. amount invested = 100,000; years to invest = 30 years; interest rate per yr.= 8%; inflation rate per yr.= 3%; additional investment per month = 5,000.

Assumptions are monthly compounding of interest; interest earnings are tax deferred. Your help will be greatly appreciated. Many thanks!

Ad

Hi,

A 6ya expert can help you resolve that issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).

click here to download the app (for users in the US for now) and get all the help you need.

Good luck!

Posted on Jan 02, 2017

Ad

From basic finance formula for future value which equals primary value multiplied by 1 plus the interest rate to the power of the number of terms

fv=pv(1+i)^t

3200=800x(1+i)^3

3200/800=(1+i)^3

4=(1+i)^3

4^-3=(1+i) >>> third square root on 4

1.5874105=1+i

.5874=i

in percentage this is 58.74 percent

fv=pv(1+i)^t

3200=800x(1+i)^3

3200/800=(1+i)^3

4=(1+i)^3

4^-3=(1+i) >>> third square root on 4

1.5874105=1+i

.5874=i

in percentage this is 58.74 percent

Mar 12, 2017 | The Office Equipment & Supplies

I think gold investment is an excellent idea for any investor, but only as part of a balanced portfolio.For most people about 10% of their investment portfolio is sensible to invest in gold.

There are many benefits to gold investment and one of the main ones is that gold is generally perceived as a safe medium-long term investment. There are pros and cons, so it's important to know what you need from your investments. Gold for example doesn't offer dividend yield like shares. There are many benefits though including gold is easy to buy/sell, it's a highly liquid form of asset and it's generally better to invest in gold in times of economic uncertainty and high inflation. Tax regimes vary from country to country, but in some there are tax advantages of investing in gold.

Investing in gold coins adds a bit of interest in terms of collectability, but also investing in gold bullion is a sound idea too.

There are many benefits to gold investment and one of the main ones is that gold is generally perceived as a safe medium-long term investment. There are pros and cons, so it's important to know what you need from your investments. Gold for example doesn't offer dividend yield like shares. There are many benefits though including gold is easy to buy/sell, it's a highly liquid form of asset and it's generally better to invest in gold in times of economic uncertainty and high inflation. Tax regimes vary from country to country, but in some there are tax advantages of investing in gold.

Investing in gold coins adds a bit of interest in terms of collectability, but also investing in gold bullion is a sound idea too.

Dec 26, 2016 | Cars & Trucks

There are 2 values for interest, say R and r, and R = 0.05, r = 0.04

There are 2 values for the amount earned, from the 2 banks, say I and i, and we know I + i = 100

There are 2 values for principal invested, say P and p, and we know P + p = 2125

There is only one value for period, say t = 1

So then I = P * 0.05 * 1 and

i = p * 0.04 * 1 and

I + i = 100 and

P + p = 2125

then

0.05P + 0.04p = 100

P + p = 2125

P = 2125 - p

0.05 ( 2125 - p) +0.04p = 100

106.25 - 0.05p + 0.04p = 100

106.25 - 0.01p = 100

0.01p = 6.25

p = 625

so

P = 2125 - 625 = 1500

so the amounts were $1500 and $625

There are 2 values for the amount earned, from the 2 banks, say I and i, and we know I + i = 100

There are 2 values for principal invested, say P and p, and we know P + p = 2125

There is only one value for period, say t = 1

So then I = P * 0.05 * 1 and

i = p * 0.04 * 1 and

I + i = 100 and

P + p = 2125

then

0.05P + 0.04p = 100

P + p = 2125

P = 2125 - p

0.05 ( 2125 - p) +0.04p = 100

106.25 - 0.05p + 0.04p = 100

106.25 - 0.01p = 100

0.01p = 6.25

p = 625

so

P = 2125 - 625 = 1500

so the amounts were $1500 and $625

Oct 20, 2014 | Mathsoft StudyWorks! Middle School Deluxe...

Actually, you don't need the y^x key.

Clear the financial registers with 2nd [CLR TVM]

Enter the present value: 1 0 0 0 0 0 0 +/- FV

Enter the future value: 2 0 0 0 0 0 0 FV

Enter the interest rate: 7 I/Y

Compute the number of periods: CPT N

Clear the financial registers with 2nd [CLR TVM]

Enter the present value: 1 0 0 0 0 0 0 +/- FV

Enter the future value: 2 0 0 0 0 0 0 FV

Enter the interest rate: 7 I/Y

Compute the number of periods: CPT N

Mar 24, 2013 | Texas Instruments BA II PLUS Financial...

The VLOOKUP and HLOOKUP functions contain an argument called range_lookup that allows you to find an exact match to your lookup value without sorting the lookup table

I have posted below link to know more .Please have a look..

http://www.howtodothings.com/computers-internet/how-to-use-the-vlookup-and-hlookup-functions-in-microsoft-excel

http://support.microsoft.com/kb/181213

http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx

http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel

Please rate & vote if you like soution..

Thanks

Sandeep

I have posted below link to know more .Please have a look..

http://www.howtodothings.com/computers-internet/how-to-use-the-vlookup-and-hlookup-functions-in-microsoft-excel

http://support.microsoft.com/kb/181213

http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx

http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel

Please rate & vote if you like soution..

Thanks

Sandeep

Mar 14, 2011 | Microsoft Excel for PC

2nd [CLR TVM] (clear TVM registers)

2 4 0 0 +/- PV ($2400 initial investment, negative because you're paying it out)

6 I/Y (6% annual interest)

1 N (one year)

CPT FV (compute future value, see 2544.00, the value after one year)

5 N (five years)

CPT FV (see 3211.74, the value after five years)

1 0 N (ten years)

CPT FV (see 4298.03, the value after ten years)

2 4 0 0 +/- PV ($2400 initial investment, negative because you're paying it out)

6 I/Y (6% annual interest)

1 N (one year)

CPT FV (compute future value, see 2544.00, the value after one year)

5 N (five years)

CPT FV (see 3211.74, the value after five years)

1 0 N (ten years)

CPT FV (see 4298.03, the value after ten years)

Feb 19, 2011 | Texas Instruments BA II PLUS Financial...

2 0 0 0 0 +/- PV (present value, negative because you're paying it out)

5 *P/YR (5 years)

1 0 . 5 I/YR (interest rate)

FV (calculate future value, about 33,732)

5 *P/YR (5 years)

1 0 . 5 I/YR (interest rate)

FV (calculate future value, about 33,732)

Aug 09, 2010 | HP 10bII Calculator

The IRR function is provided by Excel so you can calculate an
internal rate of return for a series of values. The IRR is the interest
rate accrued on an investment
consisting of payments and income that occur at the same regular
periods. In the values provided to the function, you enter payments you
make as negative values and income you receive as positive values.

For instance, let's say you are investing in your daughter's business, and she will make payments back to you annually over the course of four years. You are planning to invest $50,000, and you expect to receive $10,000 in the first year, $17,500 in the second year, $25,000 in the third, and $30,000 in the fourth.

Since the $50,000 is money you are paying out, it is entered in Excel as a negative value. The other values are entered as positive values. For instance, you could enter –50000 in cell D4, 10000 in cell D5, 17500 in cell D6, 25000 in cell D7, and 30000 in cell D8. To calculate the internal rate of return, you would use the following formula:

=IRR(D4:D8)

The function returns an IRR of 19.49%.

The ranges you use with the IRR function must include at least one payment and one receipt. If you get a #NUM error, and you have included payments and receipts in the range, then Excel needs more information to calculate the IRR. Specifically, you need to provide a "starting guess" for Excel to work with. For example:

=IRR(D4:D8, -5%)

This usage means that the IRR function starts calculating at –5%, and then recursively attempts to resolve the IRR based on the values in the range.

For instance, let's say you are investing in your daughter's business, and she will make payments back to you annually over the course of four years. You are planning to invest $50,000, and you expect to receive $10,000 in the first year, $17,500 in the second year, $25,000 in the third, and $30,000 in the fourth.

Since the $50,000 is money you are paying out, it is entered in Excel as a negative value. The other values are entered as positive values. For instance, you could enter –50000 in cell D4, 10000 in cell D5, 17500 in cell D6, 25000 in cell D7, and 30000 in cell D8. To calculate the internal rate of return, you would use the following formula:

=IRR(D4:D8)

The function returns an IRR of 19.49%.

The ranges you use with the IRR function must include at least one payment and one receipt. If you get a #NUM error, and you have included payments and receipts in the range, then Excel needs more information to calculate the IRR. Specifically, you need to provide a "starting guess" for Excel to work with. For example:

=IRR(D4:D8, -5%)

This usage means that the IRR function starts calculating at –5%, and then recursively attempts to resolve the IRR based on the values in the range.

Jun 09, 2010 | Microsoft Office Professional 2007 Full...

Using the calculator at http://www.ecentralcu.org/futurevalue-pp.html I get $35,065.70

Payments = $21,600 + $13,465.70 in interest.

Payments = $21,600 + $13,465.70 in interest.

Aug 27, 2009 | HP 10bII Calculator

Mar 22, 2018 | The Computers & Internet

129 people viewed this question

Usually answered in minutes!

×