{"id":1257,"date":"2021-03-04T23:45:28","date_gmt":"2021-03-04T15:45:28","guid":{"rendered":"https:\/\/www.yohz.com\/blogs\/?p=1257"},"modified":"2021-03-04T23:46:10","modified_gmt":"2021-03-04T15:46:10","slug":"calculate-npv-xnpv-irr-mirr-and-xirr-like-a-boss","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2021\/03\/04\/calculate-npv-xnpv-irr-mirr-and-xirr-like-a-boss\/","title":{"rendered":"Calculate NPV, XNPV, IRR, MIRR, and XIRR like a boss"},"content":{"rendered":"

So you need to calculate the NPV, IRR, or any of the above financial values for one investment.\u00a0 Simple, right?\u00a0 In Excel, you just use the relevant function on the data e.g.<\/p>\n

\"\"<\/p>\n

But what if you need to calculate the numbers for hundreds of investments, by different categories?\u00a0 For example, say we have a worksheet containing the cash flows for over 200 companies, with varying starting and ending periods, grouped by industry, sector, and risk level.<\/p>\n

\"\"<\/p>\n

Are you able to calculate measures like the NPV and IRR for individual investments or groups of investments in Excel fast?<\/p>\n

What if we said you could compute and display the NPV and IRR measures like this using Easy Excel Analysis<\/a> in 60 seconds<\/strong>?<\/p>\n

\"\"<\/p>\n

Watch this video<\/a> to see how.<\/p>\n

It could not be simpler.\u00a0 Once you’ve set up the summaries, it’s just a matter of dragging which columns you want to group and compute the measures for.<\/p>\n

Download<\/a> a 14-day trial now, and experience working with your data in ways you never thought possible and gain new insights into your data.<\/p>\n

If you need to work with data stored in databases instead of Excel worksheets, then give SQL Data Analysis<\/a> a try.\u00a0 It provides the same analysis capabilities as Easy Excel Analysis<\/a>.<\/p>\n

<\/fb:like><\/div>
<\/div><\/div>","protected":false},"excerpt":{"rendered":"

So you need to calculate the NPV, IRR, or any of the above financial values for one investment.\u00a0 Simple, right?\u00a0 In Excel, you just use the relevant function on the data e.g. But what if you need to calculate the numbers for hundreds of investments, by different categories?\u00a0 For example, say we have a worksheet […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[82,86],"tags":[83,87],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1257"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=1257"}],"version-history":[{"count":2,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1257\/revisions"}],"predecessor-version":[{"id":1311,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1257\/revisions\/1311"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=1257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=1257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=1257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}