Balance sheet for Foriegn Currency translation
 

Anyone have a Balance Sheet setup to do Foriegn currency translation

Balance sheet for Foriegn Currency translation
 

Microsoft has one at:
http://office.microsoft.com/en-us/te...CT101444811033

- KC Rippstein
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"JOhnCrow56" wrote:

Anyone have a Balance Sheet setup to do Foriegn currency translation

Balance sheet for Foriegn Currency translation
 

The link is to show currency conversion. My request is a balalnce sheet witrh
formulas that convert from USD to EURO or vice versa.

Hope this helps


"KC Rippstein" wrote:

Microsoft has one at:
http://office.microsoft.com/en-us/te...CT101444811033

- KC Rippstein
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"JOhnCrow56" wrote:

Anyone have a Balance Sheet setup to do Foriegn currency translation

Balance sheet for Foriegn Currency translation
 

Using that template from Microsoft and assuming your balance sheet USD are in
column C:
=C5/'[Currency rate calculator1.xls]MSN MoneyCentral Currency Rates'!$B$27
Then drag the formula down for every balance sheet line item.
You should open that template and save the updates prior to working with
your balance sheet that day.

--
Please remember to indicate when the post is answered so others can benefit
from it later.


"JOhnCrow56" wrote:

The link is to show currency conversion. My request is a balalnce sheet witrh
formulas that convert from USD to EURO or vice versa.

Hope this helps


"KC Rippstein" wrote:

Microsoft has one at:
http://office.microsoft.com/en-us/te...CT101444811033

- KC Rippstein
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"JOhnCrow56" wrote:

Anyone have a Balance Sheet setup to do Foriegn currency translation