Income Statement - FA.xlsx - In-class Exercise Template for...

This preview shows page 1 - 9 out of 27 pages.

In-class Exercise- Template for In-class exercise Team Name_______ Part 1: Compile data from all group members using the template below Firm #1 Firm #2 Name of team member Name of firm Industry Peroid for statement Values (RMB) % of Revenue Values Net Income CFO CFI CFF Foreign currency translation change Change in cash Net income EBITDA (provide a description of how you calculate this metric) Free cash flow(provide a description of how you calculated this metric) % of net income Total Dividends paid in cash this period Total Treasury shares purchased with cash this period EBITDA /Market price
Image of page 1
Firm #3 % of Revenue Values (EUR) Values (¥) @ 7.84 % of Revenue Values (S$) % of net income % of net income
Image of page 2
Firm #4 Firm #5 Values (¥) @ 5.18 % of Revenue Values (EUR) Values (¥) @ 7.84 % of net income
Image of page 3
Firm #6 % of Revenue Values (¥) % of Revenue Values % of total assets % of net income % of net income
Image of page 4
Template for in-class exercise team name: team 5 Firm#1 Name of student Dhanaphol Taesopapong Name of firm General Motors and Subsidiaries Period for statement Fiscal Year (2018) Values(m$) % of total Revenue Revenue $ 147,049.00 100% Gross margin $ 14,095.00 10% Operating income $ 4,445.00 3% Interest expense $ 655.00 0% Income before tax $ 8,549.00 6% Tax provision $ 474.00 0% Net income $ 8,005.00 5% $ 1,461.00 N/A $ 11,869.00 N/A Total assets $ 227,339.00 N/A Revenue/Total assets 0.65 N/A Actual Values Market price per share 2018 $ 37.97 N/A # shares outstanding 1,330,000,000 N/A 50,500,100,000 N/A Net income $8,005,000,000.00 N/A Price-to-earning ratio 6.31 N/A ROA 3.52% N/A Market price per share 2017 $ 41.38 Industry and summary of its primary characteristics Automotive, Producers of cars, trucks, automobile parts and financials Change in revenue year over year (2017-2018) Change in net income year over year (2017-2018 Total market value of stockholders' equity
Image of page 5
Firm#2 Firm Wu Aiyao Shreyas P Tesla.Inc Ford Mo Fiscal Year (2018) Fiscal Year Values(m$) % of total Revenue Values(m$) $ 21,461.27 100% $ 160,338.00 $ 4,042.02 19% $ 24,069.00 $ (388.07) -2% $ 3,203.00 $ 638.54 3% $ 1,228.00 $ (1,004.75) -5% $ 4,345.00 $ 57.84 0% $ 650.00 $ (1,062.58) -5% $ 3,695.00 $ 9,702.52 N/A $ 3,562.00 $ 1,178.00 N/A $ (4,062.00) $ 29,739.61 N/A $ 256,540.00 0.72 N/A 0.63 Actual Values Actual V $ 332.80 N/A $ 8.89 172,603,000 N/A 3,914,690,010 57,442,278,400 N/A 34,801,594,189 $ (1,062,582,000.00) N/A $ 3,695,000,000.00 -54.06 N/A 9.42 -3.57% N/A 1.44% $ 311.64 $ 12.53 Electric Vehicles (“EVs”) and energy generation and storage systems Automotive; large-scale m primarily known as one manufactures
Image of page 6
m#3 Firm#4 Pradhan Hu Leqi otors Mondelez International r (2018) Fiscal Year (2018) % of total Revenue Values(m$) % of total Revenue 100% $ 25,938.00 100% 15% $ 10,352.00 40% 2% $ 3,312.00 13% 1% $ 520.00 2% 3% $ 2,842.00 11% 0% $ 773.00 3% 2% $ 3,381.00 13% N/A $ 42.00 N/A N/A $ 553.00 N/A N/A $ 62,729.00 N/A N/A 0.41 N/A Values Actual Values N/A $ 52.45 N/A N/A 1,996,537,778 N/A N/A 104,718,406,456 N/A N/A $ 3,381,000,000.00 N/A N/A 30.97 N/A N/A 5.39% N/A $ 43.36 manufacturing of cars, e of the big three car s in America World's largest snack company.Make and sell snacks,grocery and powdered beverage product.
Image of page 7
Firm#5 Firm#6 XIE Tianyu Zhu Xingyu Starbucks Corporation McDONALD’S CORPORATION Fiscal Year (2018) Fiscal Year (2018) Values(m$) Values(m$) $ 24,719.50 100% $ 21,025.20 100.00% $ 3,582.10 14% $ 10,786.00 51.30% $ 3,883.30 16% $ 8,822.60 41.96% $ (170.30) -1% $ 981.20 4.67% $ 5,780.00 23% $ 7,816.10 37.17% $ 1,262.00 5% $ 1,891.80 9.00% $ 4,518.30 18% $ 5,924.30 28.18% $ 6,076.00 N/A $ (1,795.20) N/A $ 1,633.60 N/A $ 732.30 N/A $ 24,156.40 N/A $ 32,811.20 N/A 1.02 N/A 0.64 N/A Actual Values Actual Values $ 56.91 N/A $ 177.57 N/A 1,431,600,000 N/A 765,317,332 N/A 81,472,356,000 N/A 135,897,398,643 N/A $ 4,518,300,000.00 N/A $5,924,300,000.00 N/A 18.03 N/A 22.94 N/A 18.70% N/A 18.06% N/A $ 58.03 $ 172.90 Sell a variety of coffee and tea products and license our trademarks through other channels McDonald’s restaurants, which serve a locally-relevant menu of quality food and beverages in more than 100 countries.
Image of page 8
Image of page 9

You've reached the end of your free preview.

Want to read all 27 pages?

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes