Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Computation of Monthly NPV, MIRR, etc
08-12-2010, 10:41 AM
Post: #1
Computation of Monthly NPV, MIRR, etc
Dear members,
I have a case of agriculture cash flow pattern from which I need your assistance. The cash inflow appears only once in July of each year but outflows are spread through out the year – a typical situation with agricultural business. I need your help on how can I compute NPV, MIRR (I hope it is MIRR in this case due to the nature of cash flow), Pay back period and profitability index <b>ON MONTHLY BASIS. </b> Also how to incorporate the issue of terminal value in this case. I will appreciate if you will demonstrate this case on how to go about using excel. I wanted to attach the case for clarification but there is no facility to upload file here. Your assistance will be highly appreciated.
Kind regards
Visit this user's website Find all posts by this user
Quote this message in a reply
08-14-2010, 12:42 AM
Post: #2
 
send me ur excel sheet containing data
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)