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
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
They are cash flow functions.
Excel has native functions to elaborate cash flow models.
For example:
Open the following document to get a complete and organic table of Excel Time Value Functions.
Basic Time Value Functions
Thanks and good luck.
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)
I cannot publish excel formulas.
Just open this link: Basic Time Value Functions
Or see here:
×
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
May 17, 2014 | Computers & Internet
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
Jan 14, 2009 | Microsoft Office Excel 2003 for PC
Sep 29, 2008 | Microsoft Computers & Internet
Sep 20, 2008 | Microsoft Computers & Internet
Aug 08, 2008 | Microsoft Computers & Internet
Apr 04, 2008 | Microsoft Excel for PC
Jan 10, 2008 | Microsoft Excel for PC
Sep 17, 2007 | Microsoft Office Standard for PC
May 29, 2017 | AVG Computers & Internet
994 people viewed this question
Usually answered in minutes!
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???
Thank you very much!
×