Use market multiples (the comparable companies method) to value the equity of Gap, Inc. Use three comparable companies, two enterprise value ratios and two equity value ratios. Ticker symbol is GPS.

Please show all work in Excel, and show formulas as well. I'd like to know how all answers are formulated, not just the answer. Thank you!