Answer:
it's Jake, Kim, or Lyron or basically the first one but yours appears to be different
1. Vlookup and Hlookup
2. Pivot table
3. some IF functions such as countif, countifs
Answer:
The answer is: underperform passive fixed-income indexes by an amount equal to fund expenses
Explanation:
According to Blake, Elton, and Gruber (The Journal of Business, 1993), the only people who benefit from actively managed bond mutual funds are those that work for the mutual funds and not their clients.
They discovered that when the mutual funds increased their fees in 1%, the total performance decreases in 1%.
Answer:
$1,081,434
Explanation:
<em>At indifference point, the present value of cash outflow equals present value of cash inflow.</em>
Present value of cash inflow = Annual cash inflow * PV annuity factor (12%, 5 years)
Present value of cash inflow = $300,000*3.60478
Present value of cash inflow = $1,081,434
So, the amount at which the firm would be indifferent between accepting or rejecting the investment is $1,081,434.
Answer:
None of the options are correct as the price today will be $26.786
Explanation:
The price of a stock whose dividends are expected to grow at a constant rate forever can be calculated using the constant growth model of the dividend discount model approach (DDM). The DDM bases the value of a stock on the present value of the future expected dividends from the stock.
The formula for price under constant growth model is,
P0 = D1 / (r - g)
Where,
- D1 is the dividend expected for the next period
- r is the required rate of return or cost of equity
- g is the growth rate in dividends
However, as the constant growth rate in dividends is to be applied from Year 2 onwards, we will use the D2 to calculate the price at Year 1 and we will then discount this further for one year to calculate the price today.
P1 or Year1 price = 2 * (1+0.05) / (0.12 - 0.05)
P1 or Year 1 price = $30
The price of the stock today or P0 will be,
P0 = 30 / (1+0.12)
P0 = $26.786