Question about Computers & Internet

1 Answer

Using Excel Formulas for Economics

I am looking for the equivalent formula in Excel for the following

(A/P,i,N)

(F/P,i,N)

(A/F,i,N)

Thank you

Posted by on

  • loveslife Nov 22, 2008

    I am using Excel Program for an Economics Project. The Professor said there was EXISTING formulas in Excel that equalled the following formulas



    A/P,i,N)

    (F/P,i,N)

    (A/F,i,N)

    I hope I a asking the right Expert.

    Do I use the Wizard???

  • loveslife Nov 23, 2008

    Thank you very much!

×

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Master
  • 19,396 Answers

Give more details on the original formula, where did you get that from, they do not mean nothing to me, as they are.

Posted on Nov 22, 2008

  • 2 more comments 
  • Ginko
    Ginko Nov 22, 2008

    They are cash flow functions.
    Excel has native functions to elaborate cash flow models.

    For example:



    • Single Payments



        • Notation: (P/F, i, n)

        • Excel Function: PV(i%,n,,F)


        • Notation: (F/P, i, n)

        • Excel Function: FV(i%,n,,P)



    Check:



    Chapter 2: Factors: How Time and Interest Affect Money

    and


    Chapter 2

    Check also the following:


    Parisay's EGR 403, Excel & Eng. Econ.
    ME 450, Financial En


    CE 203 More Interest Formulas (EEA Chap 4


    CHAPTER 4 • Capital Recovery • Spreadsheet Use CHAPTER 5 ...


  • Ginko
    Ginko Nov 22, 2008

    Open the following document to get a complete and organic table of Excel Time Value Functions.



    Basic Time Value Functions

    Thanks and good luck.



  • Ginko
    Ginko Nov 22, 2008

    I already posted the required information, I wonder if you can see my messages.

    Start with

    Function Excel function










    Normal
    0


    false
    false
    false








    MicrosoftInternetExplorer4









    /* Style Definitions */
    table.MsoNormalTable
    {mso-style-name:"Table Normal";
    mso-tstyle-rowband-size:0;
    mso-tstyle-colband-size:0;
    mso-style-noshow:yes;
    mso-style-parent:"";
    mso-padding-alt:0in 5.4pt 0in 5.4pt;
    mso-para-margin:0in;
    mso-para-margin-bottom:.0001pt;
    mso-pagination:widow-orphan;
    font-size:10.0pt;
    font-family:"Times New Roman";
    mso-fareast-font-family:"Times New Roman";
    mso-ansi-language:#0400;
    mso-fareast-language:#0400;
    mso-bidi-language:#0400;}









    Future value of a
    present lump sum (F/P,r,t) =FV(r,n,pmt,pv,type)












    Normal
    0


    false
    false
    false








    MicrosoftInternetExplorer4









    /* Style Definitions */
    table.MsoNormalTable
    {mso-style-name:"Table Normal";
    mso-tstyle-rowband-size:0;
    mso-tstyle-colband-size:0;
    mso-style-noshow:yes;
    mso-style-parent:"";
    mso-padding-alt:0in 5.4pt 0in 5.4pt;
    mso-para-margin:0in;
    mso-para-margin-bottom:.0001pt;
    mso-pagination:widow-orphan;
    font-size:10.0pt;
    font-family:"Times New Roman";
    mso-fareast-font-family:"Times New Roman";
    mso-ansi-language:#0400;
    mso-fareast-language:#0400;
    mso-bidi-language:#0400;}








    Present value of
    a future lump sum (P/F,r,t) =PV(r,n,pmt,fv,type)






  • Ginko
    Ginko Nov 22, 2008

    I cannot publish excel formulas.

    Just open this link: Basic Time Value Functions

    Or see here:




×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I have an assignment where 4 worksheets were provided. I did autosum for the total amounts on each sheet. I need to make a summary sheet now to add all of those totals What formula and steps do I take? ...


I'd say you need to pay better attention to the Excel or other spreadsheet books and help you have handy, and categorize your problem according to the behavior you get inconsistent with the suggested solutions already available.

No excuse for your laziness!

Nov 13, 2009 | Computers & Internet

1 Answer

How to create short cut keyboard keys in ms-excel ( if we insert hyperlink in one cell ,with out clicking that cell how to operate that link with the help of key board keys)


I think it made already all the shortcut keys in keyboard and the problem is on how. This short cut keyboard keys in Microsoft Excel is definitely defaulted by the problem Excel and you can change it.
To see all the listing, here is the link.
Open this link:

www.yboyandrei.com/shortcutexcel

Good luck!

If i am helpful to you, please rate me.
Thank you.

Yboyandrei

Aug 25, 2009 | Computers & Internet

1 Answer

Excel formulas


Below is the formula for "2". The logic should be obvious from this so you can adapt for "1" or a combination of 1 and 2. This need to be written as one long formula so I have pasted it in to this reply so you can do a copy and paste into your spreadsheet. Sorry its not very readable in this form but you could paste into word so you can break it down and examine structure.

=IF(OR((AND(Sheet3!A12="WA",OR(Sheet3!AH2="Lewis",Sheet3!AH2="Pacific",Sheet3!AH2="Wahkiakum"))),(AND(Sheet3!A12="OR",OR(Sheet3!AH2="Clackmas",Sheet3!AH2="Multnomah",Sheet3!AH2="Washington")))),"X"," ")

Aug 18, 2009 | Microsoft Office Excel 2007 Full Version...

4 Answers

Excel password recovery


There are several " free " or Trial softwares available to clear the password from excel files, your best bet is to make a copy / backup of the original, and try your luck at either guessing, or using one of the multitude of free software's available to get the document unlocked.

You can do a simple google search, or search CNET.com for related softwares.

May 30, 2009 | AccessData Password Recovery Tool Kit (ftk...

2 Answers

Covert lotus notes address book "names.nsf" to an excel file


I just stumbled on this one. Actually it's EASY! Open up your contacts list in Notes, go to the File menu, choose export. You can pick either "Structured Text", "Tabular Text", or "Comma Separated Value". All of these import well into either of those programs.

Apr 18, 2009 | Computers & Internet

1 Answer

Excel formula


The IF() is the wrong one to use. Use "Iif()", as in:

=IiF(A3='Audit Exception Register'!B:B, COUNTIF('Audit Exception Register'!P:P,Y), 0)

See:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=799

Caveat about using Iif(), one that doesn't probably apply in this case, but keep it in mind: Don't use Iif when trying to return the values of "real" objects. Examples of "non-real" objects in the VB/A world are:

String
Integer, Double, etc... all the numeric "objects"
Boolean

These are fine to use in IIf() statements. If however you will be returning some value that is part of an object, as in:

Iif(x=2, myObject.getSomeVal(), 0)

You run the very real risk that is myObject is null, your program will simply stop running. Iif() will NOT return a null error/exception; it will in fact just stop. This is a bug in the VB interpreter and/or in the Iif() function itself.

I am referring here to classic VBA (ie, pre-VB dot-Net). How .NET handles such cases, I don't know.

Mar 07, 2008 | Computers & Internet

1 Answer

Excel formula with example


Go to fx and click on it. a small window will open asking you what formula would you like to apply. click on the formula, then select your numbers and hit OK. you are done.

Nov 17, 2007 | Computers & Internet

1 Answer

How to convert numericals in to words.


You will have to delve into some Visual Basic within Excel:

See this KB article from MS:

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

Oct 22, 2007 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

994 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

98765 Answers

David Payne
David Payne

Level 3 Expert

14065 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...