All categories

2 years ago

You have a list of european stocks that are priced in euros. where can you go to format the prices in euros in excel?

1 answer:

7 0

To convert prices in euros in dollars it means you should make Currency Conversion. In order to do the currency conversion you should take several steps in Excel:
1. Select a blank cell next to the price in Euros and enter the formula =NUMBERVALUE(A2,",",".").
Now you will have the amount. If you also want to have the symbol for dollars you should:
2. Format the cell: Right click-> Format->Currency and select the currency.

You might be interested in

The project is expected to generate the following net cash flows:

iVinArrow [24]

Answer:

Correct option is A 5.01%

Explanation:

Let irr be x%

At irr,present value of inflows=present value of outflows.

1,500,000=350,000/1.0x+475,000/1.0x^2+400,000/1.0x^3+475000/1.0x^4

Hence x=irr=5.01%(Approx).

8 0

2 years ago

The effect of bulky or heavy products on transportation costs can make _______ an inappropriate strategy.

emmainna [20.7K]

Transportation costs can make exporting an inappropriate strategy.

If a product is bulky or heavy, because of its weight or mass the transportation costs will obviously increase and make it more expensive, and unless the product carries an extraordinary high value-to-weight ratio the exporting strategy will be considered the least effective.

3 0

2 years ago

Do It! Review 1-3 Classify the following items as issuance of stock, dividends, revenues, or expenses. Then indicate whether eac

Sphinxa [80]

Answer:

1. Dividends = Dividends, it decreases stockholder's equity.

2. Rent Revenue = Revenue, it increases stockholder's equity

3. Advertising Expense = Expense, it decreases stockholder's equity

4. Stockholder's pay cash into business = Issuance of stock, increases stockholder's equity.

Explanation:

Notes to above:

1. Dividends are paid from current year income or from retained earnings, as both current year earnings and retained earnings are clubbed into equity thus, with payment of dividend, equity is decreased.

2. Rent revenue is a part of income and income is part of equity as with increase in income there is increase in equity also.

3. Advertising expense will decrease the income and with decrease in income there will be decrease in equity.

4. Stockholder's pay cash into business as for issuance of stock and with issue of stock equity will increase.

7 0

2 years ago

The following information is related to Kingbird Company for 2017.

Sati [7]

Answer:

Net income is $2,474,000

Retained earning for the year 2017 is $2,142,000

Retained earnings balance at December 31, 2017 is $3,123,000

Explanation:

A multi-step income statement is an income statement that shows gross profit and the detailed of each category of expenses and incomes to arrive at the net income of a company for a particular period.

This can be prepared as follows:

Kingbird Company

Mutiple step income statement

for the year ended December 31, 2017

Details $

Sales Revenue 26,100,000

Cost of goods sold (16,100,000)

Gross profit 10,000,000

Operating expenses:

Selling and administrative expenses (4,710,000)

Operating income 5,290,000

Other income (loss):

Gain on the sale of investments 111,000

Write-off of goodwill (821,000)

Loss due to flood damage (391,000)

Interest income:

Interest revenue 71,000

Income before tax 4,260,000

Income taxes for 2017 (1,254,000)

Income after tax 3,006,000

Extraordinary items:

Loss on wholesale div. disp. (net of tax) (441,000)

Loss on wholesale div. op. (net of tax) (91,000)

Net income 2,474,000

Preferred stock dividend (81,000)

Common stock dividend (251,000)

Retained earning for the year 2017 2,142,000

Retained earnings balance, Jan. 1, 2017 981,000

Retained earnings bal., Dec. 31, 2017  3,123,000 

8 0

2 years ago

When a firm adopts new technology, it is customary for firms':

Anna35 [415]

I believe the answer is:

a. cost curves to shift upward

6 0

2 years ago

Read 2 more answers