Search within this section
Select a section below and enter your search term, or to search all click Financial statement presentation
Favorited Content
The net cash flow activity for the period measured in the functional currency multiplied by the difference between the exchange rates used in translating functional currency cash flows and the exchange rate at year end.
|
+
|
The fluctuation in the exchange rates from the beginning of the year to the end of the year multiplied by the beginning cash balance denominated in currencies other than the reporting currency.
|
Code
|
Description
|
GBP to USD
|
B
|
Current rate, beginning of year
|
GBP 1 = USD 1.45
|
E
|
Current rate, end of year
|
GBP 1 = USD 1.55
|
A
|
Average rate for the year
|
GBP 1 = USD 1.50
|
R
|
Rate in effect at time of transaction
|
GBP 1 = USD Varies
|
Functional currency (GBP) |
|||||
12/31/20X1 |
12/31/20X2 |
Change |
|||
Assets |
|||||
Cash and cash equivalents |
256,000 |
457,000 |
201,000 |
||
Accounts receivable |
225,000 |
250,000 |
25,000 |
||
Inventory |
478,000 |
500,000 |
22,000 |
||
Property, plant and equipment, net |
1,000,000 |
1,050,000 |
50,000 |
||
Total assets
|
1,959,000
|
2,257,000
|
298,000
|
||
Liabilities |
|||||
Accounts payable |
300,000 |
340,000 |
40,000 |
||
Accrued expenses |
120,000 |
190,000 |
70,000 |
||
Debt, denominated in USD |
413,000 |
387,000 |
(26,000) |
||
Debt, denominated in GBP |
50,000 |
50,000 |
– |
||
Debt, intercompany |
138,000 |
129,000 |
(9,000) |
||
Deferred income taxes |
100,000 |
80,000 |
(20,000) |
||
Total liabilities |
1,121,000
|
1,176,000
|
55,000
|
||
Stockholders’ equity |
|||||
Common stock |
500,000 |
500,000 |
– |
||
Retained earnings |
338,000 |
581,000 |
243,000 |
||
Total stockholders’ equity |
838,000
|
1,081,000
|
243,000
|
||
Total liabilities and stockholders’ equity
|
1,959,000
|
2,257,000
|
298,000
|
Functional currency (GBP) 12/31/20X2 |
|||
Revenue |
2,000,000 |
||
Cost and expenses |
|||
Cost of sales |
1,000,000 |
||
Selling and administrative expenses |
341,000 |
||
Interest expense |
86,000 |
||
Depreciation |
85,000 |
||
Loss on sale of equipment |
10,000 |
||
Foreign currency transaction gain |
(35,000) |
||
Total costs and expenses |
1,487,000 |
||
Income before income taxes |
513,000 |
||
Current |
190,000 |
||
Deferred |
(20,000) |
||
Total provision for income taxes |
170,000 |
||
Net income |
343,000
|
||
Retained earnings, beginning |
338,000 |
||
Cash dividends |
(100,000) |
||
Retained earnings, ending |
581,000 |
Step 1
|
Step 2
|
|||
GBP
12/31/20X2 |
Code |
Exchange Rate |
USD
12/31/20X2 |
|
Cash flows from operating activities |
||||
Net Income |
343,000 |
A |
GBP 1 = USD 1.50 |
514,500 |
Adjustments to reconcile net income to net cash provided by operating activities |
||||
Depreciation |
85,000 |
A |
GBP 1 = USD 1.50 |
127,500 |
(Gain) loss on sale of equipment |
10,000 |
R |
GBP 1 = USD 1.46 |
14,600 |
(Gain) loss on foreign currency exchange rates |
(35,000) |
A |
GBP 1 = USD 1.50 |
(52,500) |
Deferred income taxes |
(20,000) |
A |
GBP 1 = USD 1.50 |
(30,000) |
Change in operating assets and liabilities |
||||
Accounts receivable |
(25,000) |
A |
GBP 1 = USD 1.50 |
(37,500) |
Inventory |
(22,000) |
A |
GBP 1 = USD 1.50 |
(33,000) |
Accounts payable |
40,000 |
A |
GBP 1 = USD 1.50 |
60,000 |
Accrued expenses |
70,000 |
A |
GBP 1 = USD 1.50 |
105,000 |
Net cash provided by operating activities |
446,000 |
668,600 |
||
Cash flows from investing activities |
||||
Proceeds from sale of equipment |
10,000 |
R |
GBP 1 = USD 1.46 |
14,600 |
Purchases of property, plant and equipment |
(155,000) |
R |
GBP 1 = USD 1.47 |
(227,850) |
Net cash used in investing activities |
(145,000) |
(213,250) |
||
Cash flows from financing activities |
||||
Payment of dividends |
(100,000) |
R |
GBP 1 = USD 1.54 |
(154,000) |
Net cash used in financing activities |
(100,000) |
(154,000) |
||
Effect of exchange rate changes on cash |
— |
35,800 |
||
Change in cash |
201,000 |
337,150 |
||
Cash, beginning of the year |
256,000 |
B |
GBP 1 = USD 1.45 |
371,200 |
Cash, end of the year |
457,000 |
E |
GBP 1 = USD 1.55 |
708,350 |
Calculation of effect of exchange rate changes on cash |
Code
|
Calculation
|
Result
|
|||
Effect on beginning cash balance |
||||||
Beginning cash balance in local currency |
256,000 |
|||||
Net change in exchange rate during the year |
(E - B) |
0.10 |
||||
Effect on beginning cash balance |
25,600 |
|||||
Effect from operating activities during the year |
||||||
Cash provided by operating activities in local currency |
446,000 |
|||||
Year-end exchange rate |
E |
1.55 |
||||
Operating cash flows based on year-end exchange rate |
691,300 |
|||||
Operating cash flows reported in the statement of cash flows |
668,600 |
|||||
Effect from operating activities during the year |
22,700 |
|||||
Effect from investing activities during the year |
||||||
Cash provided by investing activities in local currency |
(145,000) |
|||||
Year-end exchange rate |
E |
1.55 |
||||
Investing cash flows based on year-end exchange rate |
(224,750) |
|||||
Investing cash flows reported in the statement of cash flows |
(213,250) |
|||||
Effect from investing activities during the year |
(11,500) |
|||||
Effect from financing activities during the year |
||||||
Cash provided by financing activities in local currency |
(100,000) |
|||||
Year-end exchange rate |
E |
1.55 |
||||
Financing cash flows based on year-end exchange rate |
(155,000) |
|||||
Financing cash flows reported in the statement of cash flows |
(154,000) |
|||||
Effect from financing activities during the year |
(1,000) |
|||||
Effect of exchange rate changes on cash |
35,800
|
PwC. All rights reserved. PwC refers to the US member firm or one of its subsidiaries or affiliates, and may sometimes refer to the PwC network. Each member firm is a separate legal entity. Please see www.pwc.com/structure for further details. This content is for general information purposes only, and should not be used as a substitute for consultation with professional advisors.
Select a section below and enter your search term, or to search all click Financial statement presentation