Hi everyone, does anyone know the formulae behind the NPER function in excel
Dear Smartest Excel Masters in The World,
Why does the NPER function deliver a #NUM! Error when PV too big?
For example I have these Input variables and the NPER function says 88.367992 periods:
PV = 2,000.00
rate = 0.015
PMT = -41.00
Type 0
NPER function (months)= 88.367992
But if I change the PV to 3000, the NPER function yields a #NUM! Error. Here is my example:
PV = 3,000.00
FV = 0
rate = 0.015
PMT = -41.00
Type 0
NPER function (months)= #NUM!
However, if I change the PMT to a positive (I did not want to do that because it is a cash flow out), I get this:
PV = 3,000.00
FV = 0
rate = 0.015
PMT = 41.00
Type 0
NPER function (months)= -49.754484
What is going on here? Am I not remembering my exponent math correctly?
Greetings, can you help me figure out the payback period for the following. I think I have the NPV and IRR correct. Thank you
COST 30,000.00
COST OF CAPITAL 14%
YEAR PROJECT A PROJECT B
0 (30,000.00) (30,000.00)
1 16,500.00 5,000.00
2 8,000.00 8,500.00
3 3,000.00 13,500.00
4 2,000.00 11,500.00
NPV 23,838 26,847
IRR -0.994% 9.415%
PAY BACK PERIOD
is it possible to copy a formula down a column for as long as the column
exists - ie ALL cells within the column - not just those visible?
thanks again
suzanne
helloo
okay i know my question is kind of noob but anyways
I have a formula that looks like this : =SUM(A3:A1000)
I would like to know if it is possible to SUM to infinity. so when i enter my 1001 row for example i won't have to rearrange my formula.
thanks in advance!
Code:
Dim a As Long
a = 2
Dim b As Long
b = 2
Dim c As Long
c = (Me.LongerRepeatInput.Value / Me.RepeatTimeInput.Value)
Do While Cells(b, 1).Value <= Me.FirstRangeInput1.Value
Cells(a, 7).Value = Cells(b, 1).Value
Cells(a, 8).Value = Cells(b, 2).Value
a = a + 1
b = b + c
Loop
in my test, LongerRepeatInput = 120, FirstRangeInput1 = 2000 and RepeatTimeInput=5
a computer can't understand what infinity is, can it?
Hello
I have this code that take some data from already open TXT file (by different routine) and suppose to write into WS. I don't get any error messages but my loop goes into infinity (doesn't stop at the "last_row"-1.
This "loop" is over my head so I would greatly appreciate your help how to stop the loop if there is no more data in txt or reaches the "last_row"-1 in my WS.
Thank you
John
Sub Get_Set2()
ActiveSheet.Unprotect
Dim start_row, start_col, stop_row, stop_col As Integer
Dim cur_col, cur_row As Integer
Dim inx As Integer
Dim filenumber As Integer
Dim recNum
Dim curVal As Variant
Dim cel As Variant
Dim d As data_rec
start_row = Range("axis").Row + 1
start_col = Range("axis").Column
stop_row = Range("last_row").Row - 1
stop_col = Range("last_col").Column - 1
cur_col = 0
cur_row = start_row
For inx = start_col To stop_col
If Cells(start_row, inx) = "" Then
cur_col = inx
Exit For
End If
Next inx
On Error Resume Next
recNum = 0
Do While Not EOF(filenumber) And cur_row
Hi,
Can anyone tell me the actual mathematical formula that Excel uses in the NPER function. I need to develop an excel model outside of Excel and don't know how to translate this.
Any help gratefully received.
Many Thanks,
Lyn
how to calculate Rate when PMT, Nper & PV is known
