In a cross border world with investors sitting in multiple jurisdictions, assessing investment opportunities in emerging or
submerging markets, often requires managers or underwriters to convert the local or native currency into a currency that the
analyst is comfortable with. This gives the analyst a better “feel” of the risk in question.
Similarly, MNCs that have operations in different countries often require accountants sitting in different countries send
their spread sheets in two or more currencies. Atleast, important rations and analysis.
Examples like these are more common than expected and vital in countries where Financial Statements need to be read in
besides the US$.
The Euro Tool is partial answer; regrettably it restricts itself to Euro Currencies only. The other restriction which
accentuates my problem if one needs to see results in another currency, one needs to select cells, convert those cells into a
currency of choice and the display those results in destination cells. For currencies other than Euro Zone one has to do a
similar operation using the conversion ratio as the index cell.
1. Do you know if there an add-in available that
can REPLACE my (i) selected cells, indeed my (ii_) entire worksheet or (iii) workbook by another currency(s), converted from
the native currency and importantly vice versa by selecting them from a drop down menu? If an add-in is not available, can
it be done in Excel?
2. I sit in India, where # 1 is very relevant; compounding this problem is the Indian concept
of Lakhs and Crores. Indians place there commas behind the zeros very different to the rest of the world. For example
1,000,000 (Million) is 10, 00,000 Lakhs. 100,000,000 (100 million/billion) is 10, 00, 00,000 Crores. In addition to the
currency replacement problem as stated in #1, for the Indian Rupee, the commas have to be repositioned as well!
anyone knows a way to address these questions, I think the accounting community would be grateful for those inputs.