Going Deeper into Business Metrics :Business Metrics for Data-Driven Companies (Excel to MySQL: Analytic Techniques for Business Specialization) Answers 2025
✅ FINAL ANSWERS IN EXACT SAME FORMAT
-
Question 1
The “Sharpe Ratio” is:
✔️ A revenue metric divided by a risk metric
❌ A risk metric
❌ A risk metric divided by a revenue metric
❌ A revenue metric
-
Question 2
Actual CPC divided by the conversion rate is:
✔️ Acquisition Cost
❌ Quality Score
❌ Maximum Cost per Click-through
❌ Ad Rank
-
Question 3
Which of the following is NOT a demographic for targeted ads?
✔️ Future Customer
❌ Income
❌ Level of education
❌ Age
❌ Location by zip code
❌ Member of Vegetarian Interest Group Facebook page
-
Question 4
“Organic link” means visitor came from:
✔️ An unpaid listing of our website returned in search results
❌ Directly typing the URL
❌ Clicking a sponsored link
❌ Clicking a blog/article link
-
Question 5
SEO steps (Select all):
✔️ Increase social signal (likes, retweets)
✔️ Get authoritative sites to mention us and link
✔️ Make sure content is current, relevant, substantive
❌ Increase links from all possible third-party websites
-
Question 6
IRR must be used when:
✔️ Cash is invested at several different times
❌ Necessary to compare two different returns
❌ Necessary to annualize the return
❌ Many methods exist but one is preferred
-
Question 7
Why know both return & volatility?
✔️ Returns can be increased through leverage but volatility increases equally, so returns must not be judged alone
❌ Volatility is a measure of risk and avoiding risk is the main goal
❌ Higher volatility = lower returns
❌ Higher volatility = higher returns
-
Question 8
Why is relying on LTV risky?
✔️ It ignores the high negative cash flow during initial customer acquisition
❌ LTV is a profitability metric, not a risk metric
❌ LTV is difficult to calculate
❌ Only useful if CPC ÷ conversion < LTV
-
Question 9
Borrowing money increases target return but also:
✔️ Increases volatility at the same rate it increases excess returns
❌ Requires a more skilled manager
❌ Inversely affects discrete return
❌ None of the above
-
Question 10
NOT included in expense ratio:
✔️ The manager’s performance bonus
❌ Operating expenses associated with marketing
❌ Brokerage fees
❌ Lawsuit-related costs
-
Question 11
If managers pick portfolios randomly, % outperforming before fees:
✔️ 50%
❌ 10%
❌ 28%
❌ 80%
-
Question 12
Why is large tracking error undesirable?
✔️ It implies wide variation from the benchmark (a risk metric)
❌ Directly correlated with decreased profit
❌ Standard deviation of excess returns
❌ None of the above
-
Question 13
Most established metric for VC/PE funds:
✔️ Internal Rate of Return (IRR)
❌ Tracking Error
❌ Quality Score
❌ Positive Cash Flow
-
Question 14
Why want low correlation to equity markets?
✔️ Because investors already invest heavily in equities and want highest risk-adjusted return on whole portfolio
❌ Because they invest in derivatives
❌ Because they make money when stock price falls
❌ Because they want a linear trend of log wealth
-
Question 15
Mutual fund managers judged on:
✔️ Excess return and tracking error
❌ Maximum drawdown and tracking error
❌ Linearity of log return and maximum drawdown
❌ All of the above
🧾 Summary Table of All Answers
| Q No. | Correct Answer(s) |
|---|---|
| 1 | A revenue metric ÷ risk metric |
| 2 | Acquisition Cost |
| 3 | Future Customer |
| 4 | Unpaid search result |
| 5 | 1, 3, 4 |
| 6 | Cash invested at different times |
| 7 | Leverage increases return + volatility |
| 8 | LTV ignores early negative cash flow |
| 9 | Volatility increases same as excess return |
| 10 | Manager’s performance bonus |
| 11 | 50% |
| 12 | Tracking error = deviation (risk) |
| 13 | IRR |
| 14 | Diversification (low correlation) |
| 15 | Excess return + tracking error |