Computation of Monthly NPV, MIRR, etc - Printable Version +- Accountancy Forum (https://www.accountancy.com.pk/forum) +-- Forum: The Profession (https://www.accountancy.com.pk/forum/forumdisplay.php?fid=4) +--- Forum: Accounting and Audit (https://www.accountancy.com.pk/forum/forumdisplay.php?fid=7) +--- Thread: Computation of Monthly NPV, MIRR, etc (/showthread.php?tid=8547) |
Computation of Monthly NPV, MIRR, etc - Shafi - 08-12-2010 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 - Information Consultant - 08-14-2010 send me ur excel sheet containing data |