New answers tagged spreadsheet
-1
Would it be correct to use the formula: FV(20, 12, 1000, -10000)
EDIT: both you and I overlooked percentage. The first parameter should be 20% not 20.
Yes. (I'd write the formula as -FV(20%/12, 12, 1000, 10000). Mathematically they are identical, and I interpret -10000 as a negative amount of money. However, maybe trained analysts use -10000 and I'm the ...
3
Now I try to cumulate the interest (for 1 month) with following
formula: CUMIPMT(annualRate/12, loanYears*12, loanReceived, 1, 2, 0) -
I receive 237
That formula is calculating the first two months. That is why the answer, 237, is about double the 119 from the first formula.
Top 50 recent answers are included
Related Tags
spreadsheet × 54calculation × 16
investing × 10
compound-interest × 9
rate-of-return × 8
loans × 7
interest × 6
portfolio × 6
interest-rate × 5
stocks × 4
credit-card × 3
savings × 3
payment × 3
statistics × 3
mortgage × 2
banking × 2
trading × 2
financial-literacy × 2
foreign-exchange × 2
apr × 2
credit-unions × 2
google-finance × 2
quickbooks × 2
stock-markets × 1
mutual-funds × 1