d2jsp
Log InRegister
d2jsp Forums > Off-Topic > General Chat > Homework Help > Basic Finance Excel Help > Anyone Can Help A Bit?
Add Reply New Topic New Poll
Views: 170Replies: 6Track Topic
Member
Posts: 32,501
Joined: Jul 14 2009
Gold: 198,111.35
#1
Jan 15 2014 12:34pm
with finance hwk in excel. pretty basic

“compute NPV and IRR of the project using the Excel Sheet”
“Use the IRR financial function for the computation of IRR.”

This post was edited by TwistedFury on Jan 15 2014 12:37pm
Member
Posts: 23,507
Joined: Feb 19 2005
Gold: 5,319.00
#2
Jan 15 2014 02:26pm
Member
Posts: 32,501
Joined: Jul 14 2009
Gold: 198,111.35
#3
Jan 15 2014 10:41pm
No one can help? I'll offer 800fgs for a tip
Member
Posts: 32,501
Joined: Jul 14 2009
Gold: 198,111.35
#4
Jan 16 2014 03:58am
Bump
Member
Posts: 32,501
Joined: Jul 14 2009
Gold: 198,111.35
#5
Jan 16 2014 08:04am
halp halp

Member
Posts: 6,835
Joined: Apr 17 2010
Gold: 6,315.51
#6
Jan 16 2014 10:29am
put the years from 0 to N in column A, cashflows in column B (first cell in B will be cost of project)
NPV is simply sum of B[i]/(1+rate)^A[i], i being the i-th line

IRR function is f(x) = sum of B[i]/(1+x)^A[i], solve for f(x) = 0

lmk if need more help
Member
Posts: 16,431
Joined: Jan 27 2006
Gold: 6.66
#7
Jan 16 2014 03:15pm
The npv is basically when your irr is 0 what the offsetting cash flow at time 0 would have to be
Go Back To Homework Help Topic List
Add Reply New Topic New Poll

© 2003-2026 d2jsp  Contact