Question about Computers & Internet

You use the "FV" function for future value. See this page for details.

Posted on Jul 25, 2008

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.

goodluck!

Posted on Jan 02, 2017

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

A=P(1+i)^n, where P is the Principal, i is the interest rate per period, and n is the number of periods.

A=10,000(1+0.075)^3, assuming the interest is compounded annually

For 30 years, we would replace the number of period 3 with a 30.

Good luck,

Paul

A=10,000(1+0.075)^3, assuming the interest is compounded annually

For 30 years, we would replace the number of period 3 with a 30.

Good luck,

Paul

Apr 05, 2014 | Texas Instruments TI 30XIIS Scientific...

To get $500,00 four years from now, how much must you invest today, assuming an annual interest rate of 4%?

A=P(1+i)^n, where A is the amount, P is the principal or initial investment, i is the interest rate per period, and n is the number of periods.

500,000 = P (1+0.04)^4

500,000/(1.04^4) = P

P = $427,402.10

Good luck,

Paul

A=P(1+i)^n, where A is the amount, P is the principal or initial investment, i is the interest rate per period, and n is the number of periods.

500,000 = P (1+0.04)^4

500,000/(1.04^4) = P

P = $427,402.10

Good luck,

Paul

Feb 17, 2014 | Sharp EL-738 Scientific Calculator

Invest R10000 in a bank investing at 14% compounded twice a year.

A = P(1+i)^n, where A is the amount, P is the principal or initial investment, i is the interest rate per period, and n is the number of periods.

If the annual rate is 14%, the semi-annual rate is 7%. One year is now composed of 2 6-month periods.

So after one year, we have A = 10 000 (1.07)^2 or 11,449.

Good luck,

Paul

A = P(1+i)^n, where A is the amount, P is the principal or initial investment, i is the interest rate per period, and n is the number of periods.

If the annual rate is 14%, the semi-annual rate is 7%. One year is now composed of 2 6-month periods.

So after one year, we have A = 10 000 (1.07)^2 or 11,449.

Good luck,

Paul

Nov 19, 2013 | Sharp EL-738 Scientific Calculator

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...

If the interest rate is 1 percent per month then it's 12 percent per year. You're making monthly payments so the payments per year is 12.

From the main menu, press FIN then TVM to enter the Time Value of Money mode. Press [SHIFT] [CLEAR DATA] to clear. Press OTHER. Enter 12 P/YR and END. Press EXIT. Enter 48 N. Enter 12 I%YR. Enter -632 PMT. Press PV to see 23,999.54 .

From the main menu, press FIN then TVM to enter the Time Value of Money mode. Press [SHIFT] [CLEAR DATA] to clear. Press OTHER. Enter 12 P/YR and END. Press EXIT. Enter 48 N. Enter 12 I%YR. Enter -632 PMT. Press PV to see 23,999.54 .

Feb 29, 2012 | HP 10b Calculator

FV=PV (1+(i/12)^12n

Assuming it's compound interest.

FV=Future Value i= interest Rate n=interest period PV =Present Value

$12,260

May 30, 2011 | Computers & Internet

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...

Try the FV function
**Syntax**

**FV**(**rate**,**nper**,**pmt**,pv,type)

Nov 03, 2007 | Computers & Internet

Hmmm, I don't think the problem is with your calculator. I'd be checking the accounting question again as I don't think you've got your annuity question structured right.

4 Year Annuity

14% Annual Interest Rate

Your contributing $4,000 per year over the next 4 years

and you already know the future value is $50,069?

You'd have to make annual payments of $11,878.93 (4 of them) at that annual interest rate to get to a future value of $50,069 (which has a present value of $43,632.24).

Are you sure that the FV isn't the trade in value at the end of the 4 years?

4 Year Annuity

14% Annual Interest Rate

Your contributing $4,000 per year over the next 4 years

and you already know the future value is $50,069?

You'd have to make annual payments of $11,878.93 (4 of them) at that annual interest rate to get to a future value of $50,069 (which has a present value of $43,632.24).

Are you sure that the FV isn't the trade in value at the end of the 4 years?

Oct 05, 2007 | Sharp SHREL738 Calculator

30 people viewed this question

Usually answered in minutes!

×