a.) comment on the trend in total revenue. Is it increasing or decreasing during the three year period?
b.) how has the gross profit percentage changed over the three year period?
c.) Comment on the ratio of total operating expenses to operating revenues over the three year period.
d.) Comment on individual revenue & expenses items that had significant percentage changes ( changes as a percentage of total revenue or total expenses) over the three years.
e.) Comment on the overall trend in operating income & net income as a percent of sales over a three year period.
f.) Comment on the significance of these changes. do they indicate a positive or negative trend for Tesla? Explain
g.) comment on anything else that might be relevant.
(‘c) The ratio of operating expenses to gross profit for the periods in the report is as under:
2016 – 142% of gross profits
2017 – 173% of gross profits
2018 - 110% of gross profits
On analysis, it is evident that the operating revenues have increased sufficiently but the Company has not been able to generate operating profits The research and development and the selling, general and administrative expenses increased by approximately 100% in 2017 when compared with 2016 figures. However, they have stabilized in 2018 as the increase is not significant. The reason for a such big increase in 2017 could be that the company expanded its operations, keeping the future operations in mind, and as result the fixed costs of the company increased in 2017.
(d) Revenue Items
Expense Items
(e) The operating income have remained steady in the range of 19% to 23 % during the period 2016
To 2018. The net income/(losses) have shown fluctuations, it was (10%) in 2016, (14%) in 2017
and (2%) in 2018.
The increase in the net losses in 2017 can be attributed to increased investment in Research and
development (increased by 65% in 2017) and increase selling, general and administrative
expenses (increase by 73% in 2017) which can be due to expansion of operations as is evident
from the revenue levels.
The figures of 2018 show that the company’s increased expenses in the year 2017 have paid off
and the increased revenues have almost compensated the increase in operating expense and the
trend of increasing revenues would result in net incomes in the coming years.
(f) The trends clearly show that company’s plans have paid off and the significant investments it
made in the year 2017 to generate higher revenues have been successful. The trends are
positive and Tesla can look forward to good growth in revenues and incomes in the coming years.
(g) The significant increase in the interest expense which has increased from $ 198,810 in 2016 to
$ 663,071 indicates that a major part of the expansion has been financed through borrowings and at current levels the interest coverage is negative. The company should streamline its leverage
levels,else it could have a negative effect on the future viability of the operations which are
showing consistent positive trends.
a.) comment on the trend in total revenue. Is it increasing or decreasing during the three...
b.) Calculate the following ratios for each of the three years presented: Gross Profit (2018) _________ (2017)__________ (2016) _________ Ratio of operating expenses to sales (or operating revenue) (%) (2018) _________ (2017)__________ (2016) _________ Profit Margin (%) Net income/sales or operating revenues (2018) _________ (2017)__________ (2016) _________ Return on assets Net income/average total assets (2018) _________ (2017)__________ (2016) _________ tsla-10k 20181231.htm Page 77 of 180 Tesla, Inc. Consolidated Statements of Operations (in thousands, except per share data) Year Ended December...
a.) Does the format of the statement more closely follow a single-step or a multiple step format? How is it possible to tell? tsla-10k 20181231.htm Page 77 of 180 Tesla, Inc. Consolidated Statements of Operations (in thousands, except per share data) Year Ended December 31, 2017 2018 2016 $ $ $ 17,631,522 883,461 18,514,983 1,555,244 1,391,041 21,461,268 8,534,752 1,106,548 9,641,300 1,116,266 1,001,185 11,758,751 5,589,007 761,759 6,350,766 181,394 467.972 7,000,132 13,685,572 488,425 14,173,997 1,364,896 1,880,354 17,419,247 4,042,021 6,724,480 708,224 7,432,704 874,538...
Current ratio Quick ratio Debt to equity ratio Times interest earned ratio Receivables turnover ratio Average collection period Inventory turnover ratio Average days inventory held Payables turnover ratio Average days payables outstanding Asset turnover ratio Profit margin on sales Return on assets (ROA) Return on shareholders' equity (ROE) To calculate the above statement using the following material: FORD MOTOR COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEET (in millions) December 31 2018 December 31 2017 ASSETS Cash and cash equivalents (Note 9)...
Question 1: Basic Income Statement Information COSTCO WHOLESALE CORPORATION CONSOLIDATED STATEMENTS OF INCOME (amounts in millions, except per share data) 3,672 (134) 52 Weeks Ended 53 Weeks Ended 52 Weeks Ended September 2, September 3, August 28, 2018 2017 2016 REVENUE Net sales 138,434 $ 126,172 $ 116,073 Membership fees..... 3,142 2,853 2,646 Total revenue ....... 141,576 129,025 118,719 OPERATING EXPENSES Merchandise costs 123,152 111,882 102,901 Selling, general and administrative...... 13,876 12,950 12,068 Preopening expenses.... 68 82 78 Operating income...
What is the net balance of "above the line" items on the Starbucks financials for the Fiscal year ended Oct. 1, 2017 (in millions)? STARBUCKS CORPORATION CONSOLIDATED STATEMENTS OF EARNINGS in millions, except per share data) Sep 30, 2018 Oct 1. 2017 Oct 2, 2016 al Year Ended et revenues: Company-operated stores 19,690.3 $ 17,650.7 S 355.0 652.2 2,377.0 24,719.5 10,174.5 7,193.2 539.3 16,844.1 2,154.2 2,317.6 21,315.9 8,509.0 064.3 499.2 980.8 1,408.9 stores Other 2,381.1 net revenues 386.8 Cost of...
What is the ratio for Trend in Net Cash from Operating Activities, must provide excel formula. Dec 31, 2018 Dec 31, 2017 Hasbro, Inc. Consolidated Balance Sheets - USD ($) $ in Thousands Current assets Cash and cash equivalents $1,182,371 $1,581,234 Accounts receivable, less allowance for doubtful accounts of $9,100 in 2018 and $31,400 in 2017 1,188,052 1,405,399 Inventories 443,383 433,293 Prepaid expenses and other current assets Total current assets 268,698 3,082,504 214,000 3,633,926 256,473 259,710 Property, plant and equipment,...
Part 5: Forecast of EPS Determine the latest quarterly reporting that company provided. When will be the next earnings announcement? Obtain Balance Sheet and Income Statements for all quarterly reporting in current fiscal year. Make your prediction of the next earnings per share (EPS). Be prepared to explain how you arrived to your forecast and what assumptions you made. Hints (procedure). 1. Forecast next quarter Sales based on prior growth and management guidance or any other information you have. 2....
Please follow the report and answer the following question. show work Consolidated Statements of Earnings $ $ in milions excent per common share amounts) Revenue Cost of products sold Gross margin 2019 145,534 138,700 6,834 2018 2010 136,809 $ 129,628 7,181 2017 129,976 123,432 6 ,544 3.775 Operating expenses: Distribution, selling, general and administrative expenses Restructuring and employee severance Amortization and other acquisition-related costs Impairments and gain loss on disposal of assets, net Litigation (recoveries)/charges, net Operating earnings 4.480 125...
Preparing a consolidated income statement-Cost method with noncontrolling interest, AAP and upstream and downstream intercompany inventory profits A parent company purchased a 70% controlling interest in its subsidiary several years ago. The aggregate fair value of the controlling and noncontrolling interest was $300,000 in excess of the subsidiary's Stockholders' Equity on the acquisition date. This excess was assigned to a building that was estimated to be undervalued by $180,000 and to an unrecorded Trademark valued at $120,000. The building asset...
Preparing a consolidated income statement—Cost method with noncontrolling interest, AAP and upstream and downstream intercompany inventory profits A parent company purchased a 70% controlling interest in its subsidiary several years ago. The aggregate fair value of the controlling and noncontrolling interest was $300,000 in excess of the subsidiary’s Stockholders’ Equity on the acquisition date. This excess was assigned to a building that was estimated to be undervalued by $180,000 and to an unrecorded Trademark valued at $120,000. The building asset...