{"id":12475,"date":"2015-09-30T18:54:20","date_gmt":"2015-09-30T18:54:20","guid":{"rendered":"http:\/\/www.oracletutoring.ca\/blog\/?p=12475"},"modified":"2015-09-30T18:54:20","modified_gmt":"2015-09-30T18:54:20","slug":"spreadsheets-internal-rate-of-return-irr-on-libreoffice-calc","status":"publish","type":"post","link":"https:\/\/www.oracletutoring.ca\/blog\/spreadsheets-internal-rate-of-return-irr-on-libreoffice-calc\/","title":{"rendered":"Spreadsheets: internal rate of return (IRR) on LibreOffice Calc"},"content":{"rendered":"

The tutor promotes his equal-opportunity point of view towards computing.<\/h1>\n

I use Microsoft’s programs: witness my post from Sept 28<\/a> about using Excel to calculate IRR.<\/p>\n

However, some of my computers aren’t Windows; rather, they’re Linux. I don’t have a Mac.<\/p>\n

Although Windows dominates the PC landscape, I want to offer equal opportunity to those using Linux. My Linux computers come with the LibreOffice suite, which is under the Mozilla Public License. Today I’ll tell how to calculate IRR using LibreOffice Calc, which is the LibreOffice spreadsheet.<\/p>\n

I’m no expert on spreadsheets, but I’d say LibreOffice Calc reminds me of an earlier version of Excel, or perhaps Lotus. The point: it’s not that different.<\/p>\n

Here’s what I find the easiest way to calculate IRR for the set of cash flows<\/p>\n

-130000, -60000, 0, 215000, -7500<\/p>\n

on LibreOffice Calc:<\/p>\n

    \n
  1. Open LibreOffice Calc. Enter the cash flow values across a row of cells, for instance a6 to e6.<\/li>\n
  2. Now select another cell, maybe g6.<\/li>\n
  3. In that cell, type =IRR(a6:e6)<\/span>, then press ENTER. The value 3.38% will likely appear in the cell:)<\/li>\n<\/ol>\n

    Recall the answer from Excel in my post from Sept 28:<\/a> 0.033777697<\/span> or 3.3777697%. Rounded to two decimal places, it agrees with the 3.38% we are getting from LibreOffice Calc.<\/p>\n

    In Excel, the instructions above will also work.<\/p>\n

    I’ll be talking much more about Excel and LibreOffice Calc.<\/p>\n

    Jack of Oracle Tutoring by Jack and Diane,<\/a> Campbell River, BC.<\/p>\n","protected":false},"excerpt":{"rendered":"

    The tutor promotes his equal-opportunity point of view towards computing. I use Microsoft’s programs: witness my post from Sept 28 about using Excel to calculate IRR. However, some of my computers aren’t Windows; rather, they’re Linux. I don’t have a …<\/p>\n

    Spreadsheets: internal rate of return (IRR) on LibreOffice Calc<\/span> Read More »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1073,3,1065],"tags":[1076,1077,1075,1078,1044,1074],"class_list":["post-12475","post","type-post","status-publish","format-standard","hentry","category-computer-skills","category-math","category-spreadsheets","tag-calculating-internal-rate-of-return-with-libreoffice-calc","tag-calculating-irr-with-excel","tag-calculating-irr-with-libreoffice-calc","tag-excel","tag-internal-rate-of-return","tag-libreoffice-calc"],"_links":{"self":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/12475","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/comments?post=12475"}],"version-history":[{"count":13,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/12475\/revisions"}],"predecessor-version":[{"id":12488,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/12475\/revisions\/12488"}],"wp:attachment":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/media?parent=12475"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/categories?post=12475"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/tags?post=12475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}