Which questiоn best cаptures the centrаl inquiry оf the Kаne Cоnfidential project?
Estimаte Intrinsic Vаlue Using а Net Incоme Multiple The fоllоwing visualization displays average NI market multiples (market cap divided by net income available to common shareholders) for several industries. a. Which industry has the highest average NI market multiple? {#1} Which industry has the lowest average NI market multiple? {#2} b. Use the following data in Excel data for Walt Disney and Dropbox to estimate intrinsic value per share for each firm. The data is also shown below for convenience. Apply the average NI market multiple for each firm's respective industry to answer this question. When answering this question use the Excel spreadsheet to calculate the answers. Do not use the round function in Excel. Enter values from Excel to the specified number of decimal places into MBC. In millions, except per share amounts Walt Disney Dropbox Market value of equity $147,997.300 $9,660.596 Net income available to common shareholders $2,354.000 $453.600 Common shares outstanding 1,826.0 327.7 Industry Communication Services Information Technology Walt Disney Dropbox NI market multiple (round answer to four decimal places) {#3} {#4} Equity intrinsic value in millions (round answer to two decimal places) ${#5} ${#6} Equity intrinsic value per share (round answer to two decimal places) ${#7} ${#8} Given the calculated intrinsic values of equity, which firm appears to be overvalued? {#9} Given the calculated intrinsic value of equity for Dropbox, how much (in percentage terms) would the current market value of equity have to change to match the intrinsic value of equity calculated above? (round answer to two decimal places) % change for current market value of equity to match intrinsic value of equity {#10}%
Exаmple Questiоn: Cоmpаring Prices tо Anаlyst Prices This example question demonstrates how to complete the second data analytics question in Module 15. Video showing how to complete the visualizations in Power BI a. Download this Excel file containing data on share prices and median analyst estimated prices from December 2023. b. In the Excel file, calculate the percentage difference between the analyst forecasted price and the price, i.e., percentage difference = analyst price / price - 1. Format the values as percentages with two decimal places. In the Excel file, calculate the absolute percentage difference between the analyst forecasted price and the price, i.e., absolute percentage difference = ABS(analyst price / price - 1). Format the values as percentages with two decimal places. c. In Power BI, Create a scatterplot that displays price on the x-axis and analyst price on the y-axis. Weight each point using the absolute percentage difference between the two prices calculated in part a. Use Power BI's symmetry shading feature to highlight firms above and below the y = x line. Shade the area above the line green and below the line red. Are the firms that fall in the area below the y = x line considered undervalued or overvalued by analysts? {#1} d. Add a slicer to the visualization based on Company. Use the slicer to answer the following questions. What is Nvidia's price? ${#2} What is the median analyst forecasted price for Nvidia? ${#3} e. Create a multi-row card visualization and add Company and the percentage difference between the analyst forecasted price and the price as fields in the card. Add a filter to the multi-row card based on the percent difference between the analyst forecasted price and the price. Use the filter to answer the following questions. How many firms have an analyst forecasted price that is greater than or equal to the price? {#4} How many firms have an analyst forecasted price that is less than the price? {#5} Solution The solution is available in the following link: View Solution