0
How do you solve a pension fund problem using time value of money and the Excel spreadsheet and Excel formulas?
Wiki User
∙ 15y ago
If you have a set dollar goal to reach and a set dollar amount that you can contribute, then I think I can help.
There's a function in Excel called NPER. It stands for number of periods. It will give you the total number of periods, which is essential for time value of money. Click on Insert at the top of the screen and a drop down appears. Then click on Function and choose all, and scroll for NPER, it should explain everything to you. Once you have the number of periods via the formula, you must manually multiply that by the dollar amount of the payments which you'll be making.
Tell me the answer you get so we can do a reasonable-ness test.
Wiki User
∙ 15y ago
Add your answer:
Earn +20 pts
What does ctrl accent mark do in excel?
It displays the formulas in your spreadsheet.
What is Excel and Entourage?
Excel is a Microsoft software designed to calculate formulas and is in a spreadsheet layout. Entourage is the Mac version of Microsoft Outlook.
Why are formulas used in Excel?
For doing a wide range of calculations and other data processing activities in a spreadsheet.
What does Excel use to automatically to modify values?
Formulas will change their results as other things change in a spreadsheet.
Can Excel 2010 formulas be used in Excel 2003?
Formulas that work in Excel 2010 will work in any of the older versions of Excel. The main difference from 2007 onwards is the way Excel looks. Fundamentals like how standard formulas are used never changes. It is still a spreadsheet. If they cannot do those standard things then they are not really spreadsheets.
What are the uses of excel?
Exel is a spreadsheet program that enables you to enter formulas and data into the cells in order to organize information.
What computer software use to analyze row and columns of sales figures?
A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.
Which is spreadsheet package lotus Excel or quattro pro?
All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.
Do radiological technician use Microsoft Excel?
Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.
Is an Excel spreadsheet an example of a file?
A spreadsheet that you create and save with Excel is an example of a file.
Why is Excel referred to as a spreadsheet program?
It is one of the many spreadsheet applications that have computerised the paper-based spreadsheet, so Excel is therefore a spreadsheet program.
What type of of spreadsheet do you maintain in Microsoft Excel?
Excel can do any kind of spreadsheet, so the answer would be any kind of spreadsheet.
