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 there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.
Here's a link to this great service
Good luck!
Posted on Jan 02, 2017
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
Jun 25, 2009 | Computers & Internet
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
Jul 18, 2018 | Computers & Internet
995 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!
×