For this assignment, you must submit a PowerPoint with a football field chart that shows the estimated price ranges for D.R. Horton, Inc. implied by the first and third quartiles of EV/EBITDA, EV/EBIT, EV/Revenue, P/E, and P/B for the firm’s per group, as defined by NetAdvantage.Students should first create a chart in Excel and then copy & paste it into PowerPoint, where it should be formatted to look more professional.
Students should follow the procedures and guidelines discussed in class and class overheads with respect to estimating price ranges, formatting the table in Excel & PowerPoint, etc.The chart should have a title, 5 bars with the same color fill and amounts displayed to the cent for the upper and lower limits of each bar based on the 25th and 75th percentile of the peer group, a line showing the actual price of the stock on the valuation date, a textbox noting the price of the stock on the valuation date, a labelled horizontal axis, and a labelled vertical axis.
The relevant valuation date is 10/31/2019.Data should be downloaded from NetAdvantage for the peer group and for D.R. Horton.
0 comments