# Vb programming find the Furure value of an investment at the end of each year with a rate which ranges from 5 to 12 percent number of periods per year which are1,4,12,365. User would specify the the first and the last year and as well as the initial amount.

Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that gotÂ 5 achievements.

Novelist:

An expert who has written 50 answers of more than 400 characters.

Scholar:

An expert who has written 20 answers of more than 400 characters.

• Expert

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

Posted on Jul 25, 2008

Hi,
a 6ya Technician 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 repair professionals here in the US.
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### An investment of R800 grows to the amount of R3200 in 3 years. calculate the singular interest rate per year?

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

Mar 12, 2017 | The Office Equipment & Supplies

### An original investment of 10,000 earns 7.50% interest compound continously, What will the investment be worth in 3 years? 30 years?

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

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

### How much must you invest to get \$500,000 four years from now?

Please see images below. The first one is 500,000 over 4 years with a 4% annual return. The second one is 500,000 over 4 years with a 6% monthly return. The second one is effective right now. More can be found at http://www.acorn2oak-fx.com/managedforexaccounts.html

Apologies but for some reason I cannot upload image 2.

Compare Managed Forex Accounts Providers

Feb 17, 2014 | Sharp EL-738 Scientific Calculator

### I want to invest R10000 in a bank investing at 14% compounded twice a year

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

Nov 19, 2013 | Sharp EL-738 Scientific Calculator

### How to calculate on BA-II Plus the number of annual compounding periods

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

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

### Help using HP17 bII+ to solve for annuity?

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 .

Feb 29, 2012 | HP 10b Calculator

### I want to invest \$5000 for 10 years through internet at 9% , how much would i get in return?

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

### Excel 2007

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.

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

Try the FV function Syntax
FV(rate,nper,pmt,pv,type)

Nov 03, 2007 | Computers & Internet

### Invalid computation

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?

Oct 05, 2007 | Sharp SHREL738 Calculator

## Open Questions:

#### Related Topics:

32 people viewed this question

Level 3 Expert

Level 3 Expert