answersLogoWhite

0

Enter the following formula: =PV(rate,periods,payment,FV,type) Rate is the interest rate you are using. Period is the number of periods, payment is the amount of any periodic payment (if there aren't any, enter 0). FV is the future value you want at the end of the investment (again, enter 0 if there is no remaining balance. Type is 1 if the first periodic payment is at the beginning of the period or 0 if the first payment comes at the end of the period. Remember to keep all of your terms in the same format of time - so if you are getting monthly payments, your periods must be expressed in months (not years) and your annual interest rate must be divided by 12. So, if you wanted to receive monthly payments of $100 for 10 years beginning at the end of month 1, and you wanted $5,000 left over at the end, and the annual interest rate was 8%, you would enter: =PV(.08/12,120,100,5000,0) If you just wanted to know how much you have to invest today at 8% to end up with $5,000 in ten years, the formula is: =PV(.08,10,0,5000,0) However, if the interest is compounded monthly, you would have to change the rate and term to months (.08/12 and 120).

User Avatar

Wiki User

17y ago

What else can I help you with?

Related Questions

A 1 in Microsoft Excel is?

A 1 in Microsoft Excel is a value. A1 is a cell in column A and row 1.


How do you calculate RMS value using Microsoft Excel?

You can use the correlation coefficient to calculate the RMSE value using the Microsoft Excel. The correlation coefficient is used to establish the relationship between the values in question.


What function in Microsoft Excel determines most frequent value?

The MODE function.


How do you calculate the present market value for an export product while filing a shipping bill?

Dear Sir, plz provide export calculation sheet in excel tips


What is the formula for PVIFA in Excel?

The PVIFA formula in excel refers to Present Value Interest Factor of Annuity. This is able to be calculated in an excel document.


What is v - look up?

VLOOKUP is a function of Microsoft Excel. You can use VLOOKUP to find a value in a table or list on an Excel sheet. It looks at a value in a column and finds the corresponding value in another column in the same row.


In Microsoft Excel any value or expression that can be evaluated as being true or false is referred to as what?

Logical Test


Is 8.4999 return a value of 8 in Microsoft Excel sheet?

=ROUND(8.4999,0) function will return 8.


What Excel function can be used to calculate the futue value of any investment?

The FV function.


What is the function of minus in Microsoft Excel?

depends on what context you mean it. if you want to deduct a certain cell value from the other cell value then minus sign will do just that.


What is combining two or more cells in Excel called?

It is called Merging in Microsoft Excel. There is one issue though, you gotta be careful when merging as either of the cell value could get deleted.


In Microsoft Excel which formula will yield a value of 10 5x2 5x2.5 plus 5 51.5 (10052).25?

To calculate the expression "10 + 52 + 52.5 + 5 + 51.5 + (10052)^0.25" in Microsoft Excel, you can use the formula: =10 + 5*2 + 5*2.5 + 5 + 51.5 + (10052^0.25). This formula performs the necessary operations and returns the result based on Excel's order of operations. Ensure that each multiplication and addition is correctly accounted for in the formula.