ca.moazzam
Board Regular
- Joined
- Jan 2, 2011
- Messages
- 182
Hi experts. I am desperately trying to convert a Quattro Pro file in to Excel and stuck up with a formula.
In Quattro Pro it is as follows:
A B C
1 6 27,176
2 12 27,176
3 12 27,176
4 12 27,176
5 12 28,308
6 12 28,308
7 12 28,308 1,621,278 Formula is @NETPV(0.08/12,B1..C7,0,6,0,0,0,0)
As evident, these are uneven cash flows (monthly rentals which are for 6 months in year 1 and 12 in other years), interest rate used is 8% p.a. 6 in the formula as per the help is delay between initial and first cash flow which I didn't understand).
Anyway, could anybody let me know which comparative formula I should use in Excel to give me the same result. I am pressed with time and a quick response with or without explanation would be a great favor.
Thanks a million!
In Quattro Pro it is as follows:
A B C
1 6 27,176
2 12 27,176
3 12 27,176
4 12 27,176
5 12 28,308
6 12 28,308
7 12 28,308 1,621,278 Formula is @NETPV(0.08/12,B1..C7,0,6,0,0,0,0)
As evident, these are uneven cash flows (monthly rentals which are for 6 months in year 1 and 12 in other years), interest rate used is 8% p.a. 6 in the formula as per the help is delay between initial and first cash flow which I didn't understand).
Anyway, could anybody let me know which comparative formula I should use in Excel to give me the same result. I am pressed with time and a quick response with or without explanation would be a great favor.
Thanks a million!
Last edited:
