Question: 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

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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Using the fiscal year financial data from 2012 to 2015, determine how the acquisition of SolarCity would affect Teslas liquidity risk, financial leverage, and profitability, based on the computed...

Assignment Description The final assignment for MBA 675 is to demonstrate one's understanding of the importance of the operations of a firm through an examination of the firm's operations strategy...

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

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,...

Teslas Bid for SolarCity - Case Study Questions 1. Does Teslas acquisition of SolarCity make strategic sense? As a shareholder of Tesla, would you support the deal based on the information provided...

Using the fiscal year financial data from 2012 to 2015, determine how the acquisition of SolarCity would affect Teslas liquidity risk, financial leverage, and profitability, based on the computed...

Hi Ruchi, I need help with the attached assignment. It's due in about a week. Thanks 1) The paper should be written in APA style Research Paper format. This is the link that explains the research...

Profitability ratios: o Gross profit margin o Net profit margin o Return on stockholders' equity Liquidity ratios: o Current ratio o Quick ratio o Inventory turnover Leverage ratios: o Debt-to-assets...

Need help with these discussion postings (in a document) and assignments (all in separate files), all directions are included as well. FINANCE DIRECTIONS Need to provide 1 original post substantial...

Question 4 Solve the ODE of y"(t) - 3y'(t)- 4y = 0 with the initial conditions of y(0) = 2 and y'(0) = 1. (20 marks)

Texas Products employs a process-costing system for its manufacturing operations. All materials are added at the beginning of the process, and conversion costs are incurred uniformly throughout...

True or False: Diversity is beneficial only to women and minorities. Question 1 4 options: TrueFalse

Consider the following game between Kris and Kross in extensive form. Kris b Kross d Kris f a 3,3 C 1,1 e 0,0 (a) Give the number of strategies for Kris and for Kross. (5 marks) (b) Give the number...

Perform a quantitative elemental analysis of the XPS data below, and fill in the last column. Make sure that you use sensitivity factors properly. Peak areas refer to properly fitted peaks for the...

Using the data below and referring to your notes from our discussion in class and the handout "E. Data Interpretation XPS", perform a qualitative elemental analysis of the XPS data below, and fill in...

AL DELTA Investment company is operating business in a dynamic and competitive market of the Far East. To cope with the dynamic variables of the demand and supply markets, the management of the...

The return of goods to the supplier will affect the purchase account. Question 27Answer True False

Brite-Lite Technologies (BLT) has just developed a solar panel capable of generating 200% more electricity than any solar panel currently on the market. As a result, BLT is expected to experience a...

Automated Dynamics had sales of $6.5 million last year, and it earned a 4% return, after taxes, on sales. Recently, the company has fallen behind in its accounts payable. Although its terms of...

Will a lessor likely charge higher or lower lease rates if the lessor's: a. Tax rate increase? b. Cost of borrowing increases? c. Residual value of the asst increases? d. Purchase price of the asset...

For the data in golfsrs.dat, estimate the proportion of golf courses that have 18 holes, and give a 95% CI for the population proportion.

Which of the following SRS designs will give the most precision for estimating a population mean? Assume that each population has the same value of the population variance S2. 1. An SRS of size 400...

To study nutrient content of menus in boarding homes for the elderly in Washington State, Goren et al. (1993) mailed surveys to all 184 licensed homes in Washington State, directed to the...