Please format answer like above.

Using the financial statement information for Ford (F) evaluate the company using Warren Buffet's 15 percent rule. 1. 2. Is Ford an attractive investment? Why or why not? FORD MOTOR WIE 8.75 RAO 10.5 ) REL 0.628 6.9% 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 20152016 2017 2018 2019 2020 VALUE LINE PUB LLC 22-24 .95 9.20 9.50Book V vg Ann Div'd Yield 118308 128954 136264134252 146917 144077 149558 151800 156776 160338 156500 158500Revenues (Smil) Total Debt $153.5 bill. Due in 5 Yrs $113.0 bil 80 7549.0 78920 5665.0 65950 4633.07373.0 7054.0 7602.0 367704800 5440Net Profit (Smill) CURRENT POSITMON 2016 2017 9/3018 18562 | BUSINESS: Ford Motor Company is the second-largest domestic for about 40% of 2017 sales. Sold Volvo, 8/10. Has about 202,000 62062 automobile manufacturer. Its vehicle brands ncludo Ford and Lin employees. Officers and directors own 0.5% of stock. State Street coin. Sales represented 14.8% of us. car and truck market in 90%; Vanguard Group, 72%; BlackRock, 5.9% (3/18 Proxy) TAM 2017. Also engages n vehicle leasing and rental, and the manufac Charman: William aay Ford Jr. President & CEO James Hackett, turing of electronic equipment. Financial Services Group includes Inc: DE. Address: One American Road, Dearborn, MI 48126. Tele- 15905 12439 57368 62809 Ass 1 RA 1 SO 2 49669 51651 50763 Ford Motor Credit and U.S. Leasing Foreign operations accounted phone: 313-322-3000. Intemet: www.ford.com Ford's North America segment wl plus side, its commercial vehicle market likely remain its strongest-performing share reached its highest since 1994. The division. Wholesale volumes for the re com pany is working on restructuring and earnings fared relatively well, falling 6.2% duction in passenger-vehicle complexity 2016 37718 39465 359 30634 1600| gions reported losses. The next couple of while exiting unprofitable ones eali ng-term selection 04, (59c): 06, (23c): 06, ($5.22); 2c 07,2c. Next eamings report due late Apri 46 40 LI le a ru nebod ar 46 104 90 60 7 84 62 31 1%- 5% 3%-2.0 4% 8%-202 7% 8% 4% 77 87 84 60 82 23 01 1 8 25-17 veus. In 10 09 56 91-08 18 27 67 43 2%-0.0 3% 0%-TE 28 3. : 74 49 00-42 43 0.5 53 72 20 7% 2i 7 14 79 9-3 55 : NY Dec-15 15 15 15 -tes 26 39 25 Sec ep 15 15 15 15 93 25 40 07 02 5.0 44 SA100 10-8-6 10 1 500 was 52 51 27 29 32 ((-i 41 13 40 68 76 09-68 36 8% 20 20 20 20 20 20 20 20 20 20 A) 03 07 11 2 THE d Price: EPS: P/E: Growth Rate: Average P/E: Dividend Payout: Price needed in 10 years to get 15% Year 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Total Expected Price in 2027: EPS Plus the expected dividends: Total Return in 10 year Expected 10 year rate or return: Highest price you can pay to get 15% return: Using the financial statement information for Ford (F) evaluate the company using Warren Buffet's 15 percent rule. 1. 2. Is Ford an attractive investment? Why or why not? FORD MOTOR WIE 8.75 RAO 10.5 ) REL 0.628 6.9% 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 20152016 2017 2018 2019 2020 VALUE LINE PUB LLC 22-24 .95 9.20 9.50Book V vg Ann Div'd Yield 118308 128954 136264134252 146917 144077 149558 151800 156776 160338 156500 158500Revenues (Smil) Total Debt $153.5 bill. Due in 5 Yrs $113.0 bil 80 7549.0 78920 5665.0 65950 4633.07373.0 7054.0 7602.0 367704800 5440Net Profit (Smill) CURRENT POSITMON 2016 2017 9/3018 18562 | BUSINESS: Ford Motor Company is the second-largest domestic for about 40% of 2017 sales. Sold Volvo, 8/10. Has about 202,000 62062 automobile manufacturer. Its vehicle brands ncludo Ford and Lin employees. Officers and directors own 0.5% of stock. State Street coin. Sales represented 14.8% of us. car and truck market in 90%; Vanguard Group, 72%; BlackRock, 5.9% (3/18 Proxy) TAM 2017. Also engages n vehicle leasing and rental, and the manufac Charman: William aay Ford Jr. President & CEO James Hackett, turing of electronic equipment. Financial Services Group includes Inc: DE. Address: One American Road, Dearborn, MI 48126. Tele- 15905 12439 57368 62809 Ass 1 RA 1 SO 2 49669 51651 50763 Ford Motor Credit and U.S. Leasing Foreign operations accounted phone: 313-322-3000. Intemet: www.ford.com Ford's North America segment wl plus side, its commercial vehicle market likely remain its strongest-performing share reached its highest since 1994. The division. Wholesale volumes for the re com pany is working on restructuring and earnings fared relatively well, falling 6.2% duction in passenger-vehicle complexity 2016 37718 39465 359 30634 1600| gions reported losses. The next couple of while exiting unprofitable ones eali ng-term selection 04, (59c): 06, (23c): 06, ($5.22); 2c 07,2c. Next eamings report due late Apri 46 40 LI le a ru nebod ar 46 104 90 60 7 84 62 31 1%- 5% 3%-2.0 4% 8%-202 7% 8% 4% 77 87 84 60 82 23 01 1 8 25-17 veus. In 10 09 56 91-08 18 27 67 43 2%-0.0 3% 0%-TE 28 3. : 74 49 00-42 43 0.5 53 72 20 7% 2i 7 14 79 9-3 55 : NY Dec-15 15 15 15 -tes 26 39 25 Sec ep 15 15 15 15 93 25 40 07 02 5.0 44 SA100 10-8-6 10 1 500 was 52 51 27 29 32 ((-i 41 13 40 68 76 09-68 36 8% 20 20 20 20 20 20 20 20 20 20 A) 03 07 11 2 THE d Price: EPS: P/E: Growth Rate: Average P/E: Dividend Payout: Price needed in 10 years to get 15% Year 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Total Expected Price in 2027: EPS Plus the expected dividends: Total Return in 10 year Expected 10 year rate or return: Highest price you can pay to get 15% return