• Using fiscal year financial data from 2012 to 2015, how would the adquisition affect Tesla's liquidity risk and financial leverage?
  • Please calculate the following ratios for (1) Tesla, (2) SolarCity, and (Tesla + SolarCity) for fiscal year end of 2012, 2013, 2014, and 2015 using excel. (Complete the excel sheet "Leverage and Liquidity"?
  • Excel file?
    • Current Ratio
    • Quick Ratio
    • EBITDA Interest Coverage (EBITDA/(Int Income and Int Exp)
    • Cash Flow from Operations to Debt
    • Leverage (Assets/Equity)
    • Debt-to-Equity

Transcribed Image Text:

Dec-31-2013 Dec-31-2014 Dec-31-2015 Q1-3 Month Mar-31-2016 Exhibit 8 (continued) Tesla Financial Statements Income Statement In millions (USD): Revenues Automotive revenue Services and other* Total revenues 118-044 22- Q2-3 Month Jun-30-2016 Q3-3 Month Sep-30-2016 385.70 27.58 413.26 1,997.79 3,192.72 15.710 2,013.50 3,198.36 3,740.97 305.05 4,046.03 1,026.06 120.98 1,147.05 1,181.85 88.17 1,270.02 2,148.727 149.709 2,298.436 Dec-31-2012 Cost of revenues Automotive 371.66 1,543.88 2,310.01 2,823.30 779.32 909.28 Automotive Leasing* Total automotive cost of revenue 371.66 Development services 11.53 1,543.88 13.36 2,310.01 2,823.30 779.32 909.28 1,355.102 161.959 1,517.061 6.67 Services and other* 299.22 115.26 85.96 Total cost of revenues Gross profit 383.19 30.07 1,557.23 456.26 2,316.69 881.67 3,122.52 894.58 995.24 923.50 252.47 274.78 144.640 1,661.701 636.735 Operating Expenses Research and development 0.27 Selling, general and administrative 150.37 Total operating expenses 424.35 0.23 285.57 517.55 Income (loss) from operation (394.28) (61.28) Interest income 0.29 Interest expense (0.25) Other expense, net (1.83) Income (loss) before income taxes (396.08) 0.19 (32.93) 22.60 (71.43) Provision for income taxes 0.14 Net income (loss) (396.21) 2.59 (74.01) 0.47 603.66 1,068.36 (186.69) 1.13 (100.89) 1.81 (284.64) 9.40 (294.04) 0.72 182.48 191.66 214.302 922.23 1,640.13 (716.63) 1.51 (118.85) (41.65) (875.62) 318.21 321.15 336.811 500.69 512.82 551.113 13.04 (888.66) (248.22) 1.25 (40.63) 9.18 (278.42) 3.85 (282.27) (238.04) 85.622 2.24 2.858 (46.37) (46.713) (7.37) (289.54) (11.756) 3.65 (293.19) 30.011 8.133 21.878 Page 163 Tesla's Bid for SolarCity (A) Arrivals | Alt Dec-31-2013 Dec-31-2014 Dec-31-2015 Q1-3 Month Mar-31-2016 Exhibit 8 (continued) Tesla Financial Statements Income Statement In millions (USD): Revenues Automotive revenue Services and other* Total revenues 118-044 22- Q2-3 Month Jun-30-2016 Q3-3 Month Sep-30-2016 385.70 27.58 413.26 1,997.79 3,192.72 15.710 2,013.50 3,198.36 3,740.97 305.05 4,046.03 1,026.06 120.98 1,147.05 1,181.85 88.17 1,270.02 2,148.727 149.709 2,298.436 Dec-31-2012 Cost of revenues Automotive 371.66 1,543.88 2,310.01 2,823.30 779.32 909.28 Automotive Leasing* Total automotive cost of revenue 371.66 Development services 11.53 1,543.88 13.36 2,310.01 2,823.30 779.32 909.28 1,355.102 161.959 1,517.061 6.67 Services and other* 299.22 115.26 85.96 Total cost of revenues Gross profit 383.19 30.07 1,557.23 456.26 2,316.69 881.67 3,122.52 894.58 995.24 923.50 252.47 274.78 144.640 1,661.701 636.735 Operating Expenses Research and development 0.27 Selling, general and administrative 150.37 Total operating expenses 424.35 0.23 285.57 517.55 Income (loss) from operation (394.28) (61.28) Interest income 0.29 Interest expense (0.25) Other expense, net (1.83) Income (loss) before income taxes (396.08) 0.19 (32.93) 22.60 (71.43) Provision for income taxes 0.14 Net income (loss) (396.21) 2.59 (74.01) 0.47 603.66 1,068.36 (186.69) 1.13 (100.89) 1.81 (284.64) 9.40 (294.04) 0.72 182.48 191.66 214.302 922.23 1,640.13 (716.63) 1.51 (118.85) (41.65) (875.62) 318.21 321.15 336.811 500.69 512.82 551.113 13.04 (888.66) (248.22) 1.25 (40.63) 9.18 (278.42) 3.85 (282.27) (238.04) 85.622 2.24 2.858 (46.37) (46.713) (7.37) (289.54) (11.756) 3.65 (293.19) 30.011 8.133 21.878 Page 163 Tesla's Bid for SolarCity (A) Arrivals | Alt