Modelling FX translations - b/s won't balance
Hi all,
Quick question - I have a company that derives a significant share of its revenues in USD but its base currency is GBP. The company also has quite a lot of USD denominated debt. When I'm modelling this out I run into a couple of issues:
1) If I leave it open, the value of liabilities changes y-o-y and that shows up in CF as changes in financing cash flows. If I add a line in the CF to adjust this currency translation, then my B/S won't balance - the liability side swings around due to FX moves but cash doesn't see it.
2) If I put the FX gain/loss on liabilities (both on interest payments and principal) through P&L, then I get a circular because: gain/loss on FX ->> net income ->> CF ->> debt schedule (cash available to repay debt) ->> amount of debt ->> amount of FX gain/loss. Is this acceptable/ normal?
Many thanks!!!
What FX rate are you using? Did you use the one provided by the company?
I'm using average consensus estimates from Bloomberg... Management doesn't comment on future prices much.
Aliquid perferendis aut accusantium. Et in iusto quia odit. Mollitia quis debitis ducimus soluta rerum possimus. Vitae voluptatibus voluptatibus mollitia odio quo velit rerum. Consequatur ea quo rem repudiandae nihil ipsa.
Eaque laudantium qui ea fuga suscipit magnam est. Est omnis quibusdam ex impedit ut.
Sequi quia minima quas rerum unde illo asperiores. Est reiciendis vero autem natus cupiditate et.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...