chandler is using the selection filter so that certain values appear. he wants to show only the western states, but they are cro
1 answer:
Answer:
The exclude box is checked, and he needs to uncheck it.
Explanation:
When you don't want to use filters you exclude them out. so for example, if you don't want to see data from the few regions that you have selected already, you could check exclude, click Apply, and you can see that the visualization changes and also the filter dialogue box has been updated so that there is a strike through that has a horizontal line through the names of the regions that are not being displayed.
You might be interested in
Answer:
i. Discounted cashflow equations.
a. $180,000 at the end of five years.
This is a lump sum present value/ discounted cashflow which can be calculated as;
Formula = 180,000 / ( 1 + r)^n
= 180,000/ ( 1 + 12%)^5
= $102,136.83
b. $11,400 a year forever
This is a perpetuity. The present value/ discounted cashflow of a perpetuity is calculated as;
Formula = Amount/rate
= 11,400/12%
= $95,000
c. $19,000 for each of 10 years.
This is an annuity. The formula for calculating the Present value/ discounted cashflow of an annuity is;
where <em>i </em>is interest rate and <em>n</em> is number of periods
= $107,354.24
d. $6,500 next year and increasing thereafter by 5% a year forever.
This is a growing perpetuity. The present value/ discounted cashflow formula is;
= Amount / ( discount rate - growth rate)
= 6,500 / ( 12% - 5%)
= $92,857.14
ii. Choose <u>$19,000 for each of 10 years</u> as it has the highest present value.