P6.18 Build a spreadsheet containing the quoted information below. Based on the information given, what is the current market cap of the firm? What was the firm's net income. City National Corp. (CYN) NYSE Comprehensive Quote: 11/16/09 04:00 PM EST Stock Data Market Cap Mil) 1920.56 Last Change % Change Volume 37.95 0.66 1.77% 658,323 P/E Ratio 151.96 Prior Day's Open High Low Volume Dividend Yield 1.07% 37.57 38.40 37.57 394,981 Latest Dividend $0.1 52-Week High 52-Week Low Prior Day's Close 48.99 (12/31/2008) 22.59 (03/05/2009) 37.29 Pay Date of Latest Dividend 11/18/09 Snapshot quotes reflect real-time trades reported through Nasdaq only: comprehensive quotes reflect trading in all markets and are delayed at least 15 minutes. Volume updates from 4:00 am - 8:00p.m. ET. (More Info) Other Prices Last Stock Split 5 for 4 or 25% stock div. Date of Last Split 10/17/89 Shares 51.5 Outstanding (Mil) U.S. Germany Xetra Historical Quotes Closing prices since 1/2/1970. date: Go Public Float (Mil) All data updated daily before market opens Source: Reuters 43.44