Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Computation of Monthly NPV, MIRR, etc
08-12-2010, 10:41 AM,
#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
Reply
08-14-2010, 12:42 AM,
#2
 
send me ur excel sheet containing data
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)

Contact Us | Accountancy | Return to Top | | Lite (Archive) Mode | RSS Syndication