Answer:
The formula for average is =AVERAGE(E15,E16).
The formula for highest is =MAX(F15,F16).
The formula for lowest is =MIN(G15,G16).
Explanation:
In MS Excel, on the left hand side below the tool bar there is a small box which tells the cell name where the cursor is clicked, the name of the cell can be changed from here easily, click on the desired cell and then by clicking on the box you can enter the name of the cell. After a cell is renamed the formula can be written by simply putting the name of the cell instead of the original e.g. E13
The formula for average is =AVERAGE(E15,E16).
The formula for highest is =MAX(F15,F16).
The formula for lowest is =MIN(G15,G16).
The cells provided in the formula above is just an example and more than two cells can be selected.
Answer: $8.81
Explanation:
To solve this, add the present values of the dividends from years 3, 4 and 5 and then add the present value of the terminal value of the stock at year 5.
Year 3 dividend = $0.50
Year 4 dividend = 0.50 * (1 + 49%) = $0.745
Year 5 dividend = 0.745 * 1.49 = $1.11005
= Dividend in year 3 / (1 + required rate of return)³ + Dividend in year 4 / (1 + required rate of return)⁴ + Dividend in year 5 / (1 + required rate of return)⁵ + (Dividend in year 5 * (1 + growth rate) / ( required rate of return - growth rate ) ) / (1 + required rate of return)⁵
= 0.5 / 1.16³ + 0.745/1.16⁴ + 1.11005/1.16⁵ + ( 1.11005 / (16% - 9%)) / 1.16⁵
= $8.81
Answer:
The correct answer is letter "A": geographic characteristics.
Explanation:
Market segmentation refers to the classification companies make of their consumers based on different features such as age, gender, or income for instance so that firms can decide in which of those sectors they are likely to have more success based on the know-how and resources it counts on. As well, companies consider the sector that provides more opportunities so the likelihood of generating more revenue increases.
Therefore, <em>Universal Concerts must focus on geographic characteristics at the moment of choosing what type of concerts they will handle if there is a need to set one type of them only.</em>
An instance where sellers should work to keep relationships with consumers is when they feel that the product
Answer:
The computer's OS is a well-known example of system software. Widely used operating systems include Microsoft Windows, Mac OS and Linux.
