For an income balance sheet excel table, I have to input net revenue/net sales and use...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
For an income balance sheet excel table, I have to input net revenue/net sales and use the cost of goods sold to compute gross profit. For DAL, there's no section in the 10-K that explicitly states either, I'm assuming since they are an airline and sell services the format is a little different. Would total operating revenue and operating expenses be the correct substitute for these? For the same balance sheet I had trouble addressing this question: "What is the dollar amount of contributed capital? [preferred stock + common stock + additional paid-in capital - treasury stock]", I was having trouble solving for it since the common stock entry has no given value (I attached a screenshot of shareholder's equity for reference) and the only time preferred stock is explicitly referenced in the 10-K is in the following quote from Authorized Shares of Capital Stock: "500,000,000 shares of preferred stock, without par value". I looked up the definition of the term without par value and determined it means that these stocks are the price investors are willing to pay on the open market. However, I'm not sure how this would translate into a numerical value for the given equation. I don't need anyone to solve the equation for me, I only need help identifying the values to put into the equation for preferred stock and common stock since they aren't obvious/explicit. One final clarification point, does the amount of comparative data years include the most prior year, so in my case 2019? DELTA AIR LINES, INC. Consolidated Statements of Stockholders' Equity (in millions, cxcel por share data) Balance at January 1, 2017 Net income Dividends declared Other comprehensive income Shares of common stock issued and compensation expense associated with equity awards (Treasury shares withheld for payment of taxes, $48.31 per share) Stock options exercised Treasury stock, net, contributed to our qualified defined benefit pension plans Stock purchased and retired Balance at December 31, 2017 Net income Change in accounting principle and other Dividends declared Other comprehensive loss Shares of common stock issued and compensation expense associated with equity awards (Treasury shares withheld for payment of taxes, $54.900 per share) Stock options exercised Stock purchased and retired Balance at December 31, 2018 Net income Dividends declared Other comprehensive loss Shares of common stock issued and compensation expense associated with equity awards (Treasury shares withheld for payment of taxes, $50.20 per share) Stock purchased and retired Balance at December 31, 2019 Weighted average price per share. Common Stock Additional Shares Amount Paid-In Capital 745 S S 12,294 S 1 (33) 715 (29) 688 2 (38) 652 S 111 - 11111111111111 S 111 107 28 188 (564) 12,053 91 13 (486) 11,671 114 (656) 11,129 S Retained Earnings 6,895 3,205 (731) (1.113) 8,256 3,935 (154) (909) (1,089) 10,039 4,767 (981) Accumulated Other Comprehensive Loss (7,636) S (1,371) 12,454 S 15 11 1 (7,621) (106) (98) (7.825) (164) (7,989) Treasury Steck Amount Total 14 S (274) S 11,279 1 Ⓡ 7 1 1 (39) 155 (158) (40) (198) (38) 3,205 (731) 15 68 28 343 (1,677) 12,530 3,935 (260) (909) (98) 51 13 (1,575) 13,687 4,767 (981) (164) 76 (2,027) 9 S (236) $ 15.358 Commitments and Contingencies Stockholders' Equity: Common stock at $0.0001 par value; 1,500,000,000 shares authorized, 651,731,443 and 688,1 36,306 shares issued at December 31, 2019 and 2018, respectively Additional paid-in capital Retained earnings Accumulated other comprehensive loss Treasury stock, at cost, 8,959,730 and 8,191.831 shares at December 31, 2019 and 2018, respectively Total stockholders' equity Total liabilities and stockholders' equity The accompanying notes are an integral part of these Consolidated Financial Statements. 11,129 12,454 (7.989) (236) 15.358 64,532 11,671 10,039 (7.825) (198) 13,687 60,266 For an income balance sheet excel table, I have to input net revenue/net sales and use the cost of goods sold to compute gross profit. For DAL, there's no section in the 10-K that explicitly states either, I'm assuming since they are an airline and sell services the format is a little different. Would total operating revenue and operating expenses be the correct substitute for these? For the same balance sheet I had trouble addressing this question: "What is the dollar amount of contributed capital? [preferred stock + common stock + additional paid-in capital - treasury stock]", I was having trouble solving for it since the common stock entry has no given value (I attached a screenshot of shareholder's equity for reference) and the only time preferred stock is explicitly referenced in the 10-K is in the following quote from Authorized Shares of Capital Stock: "500,000,000 shares of preferred stock, without par value". I looked up the definition of the term without par value and determined it means that these stocks are the price investors are willing to pay on the open market. However, I'm not sure how this would translate into a numerical value for the given equation. I don't need anyone to solve the equation for me, I only need help identifying the values to put into the equation for preferred stock and common stock since they aren't obvious/explicit. One final clarification point, does the amount of comparative data years include the most prior year, so in my case 2019? DELTA AIR LINES, INC. Consolidated Statements of Stockholders' Equity (in millions, cxcel por share data) Balance at January 1, 2017 Net income Dividends declared Other comprehensive income Shares of common stock issued and compensation expense associated with equity awards (Treasury shares withheld for payment of taxes, $48.31 per share) Stock options exercised Treasury stock, net, contributed to our qualified defined benefit pension plans Stock purchased and retired Balance at December 31, 2017 Net income Change in accounting principle and other Dividends declared Other comprehensive loss Shares of common stock issued and compensation expense associated with equity awards (Treasury shares withheld for payment of taxes, $54.900 per share) Stock options exercised Stock purchased and retired Balance at December 31, 2018 Net income Dividends declared Other comprehensive loss Shares of common stock issued and compensation expense associated with equity awards (Treasury shares withheld for payment of taxes, $50.20 per share) Stock purchased and retired Balance at December 31, 2019 Weighted average price per share. Common Stock Additional Shares Amount Paid-In Capital 745 S S 12,294 S 1 (33) 715 (29) 688 2 (38) 652 S 111 - 11111111111111 S 111 107 28 188 (564) 12,053 91 13 (486) 11,671 114 (656) 11,129 S Retained Earnings 6,895 3,205 (731) (1.113) 8,256 3,935 (154) (909) (1,089) 10,039 4,767 (981) Accumulated Other Comprehensive Loss (7,636) S (1,371) 12,454 S 15 11 1 (7,621) (106) (98) (7.825) (164) (7,989) Treasury Steck Amount Total 14 S (274) S 11,279 1 Ⓡ 7 1 1 (39) 155 (158) (40) (198) (38) 3,205 (731) 15 68 28 343 (1,677) 12,530 3,935 (260) (909) (98) 51 13 (1,575) 13,687 4,767 (981) (164) 76 (2,027) 9 S (236) $ 15.358 Commitments and Contingencies Stockholders' Equity: Common stock at $0.0001 par value; 1,500,000,000 shares authorized, 651,731,443 and 688,1 36,306 shares issued at December 31, 2019 and 2018, respectively Additional paid-in capital Retained earnings Accumulated other comprehensive loss Treasury stock, at cost, 8,959,730 and 8,191.831 shares at December 31, 2019 and 2018, respectively Total stockholders' equity Total liabilities and stockholders' equity The accompanying notes are an integral part of these Consolidated Financial Statements. 11,129 12,454 (7.989) (236) 15.358 64,532 11,671 10,039 (7.825) (198) 13,687 60,266
Expert Answer:
Related Book For
Horngrens Financial and Managerial Accounting
ISBN: 978-0133866292
5th edition
Authors: Tracie L. Nobles, Brenda L. Mattison, Ella Mae Matsumura
Posted Date:
Students also viewed these accounting questions
-
Sales for 2017 were $245,000, and the cost of goods sold was 60 percent of sales Selling and administrative expense was $24,500 Depreciation expense was 8 percent of plant and equipment (gross) at...
-
For a merchandising company, the cost of goods sold section of the income statement contains purchases. In a manufacturing company, purchases in the cost of goods sold section is replaced with Group...
-
The actual variable cost of goods sold for a product was $ 70 per unit, while the planned variable cost of goods sold was $68 per unit. The volume increased by 1,200 units to 7,000 actual total...
-
A 110 g hockey puck sent sliding over ice is stopped in 15 m by the frictional force on it from the ice. (a) If its initial speed is 6.0m/s, what is the magnitude of the frictional force? (b) What is...
-
For many years, AT&T was a regulated monopoly, providing both local and long-distance telephone service. a. Explain why long-distance phone service was originally a natural monopoly. b. Over the past...
-
1. What potential harm could come from a workplace culture of technical compliance in which employees do only whats minimally required of them? Is such behavior ethical among public servants...
-
A research project examining the impact of income on the consumption of gourmet foods was conducted. Each variable was classified into three levels of high, medium, and low. The following results...
-
Bay Front Co. receives $240,000 when it issues a $240,000, 10%, mortgage note payable to finance the construction of a building at December 31, 2012. The terms provide for semiannual installment...
-
Annual interest rates are 10%. You buy a smartphone for $300 and use it for two years. Each month, you pay a $30 fee for your asm data plan. At the end of two years, you decide to upgrade to the...
-
Knowing that the tension in wire BD is 1300 N, determine the reaction at the fixed support C of the frame shown. 750 N 150 mm 250 mm 500 mili- 450 N 600 mm 400 mm
-
___________ focuses on the cost of enforcement or check and balance mechanisms, such as internal and external audit control, information disclosure, and independent outside directors. Transaction...
-
Discuss the factors that may lead one nation to spend more per person on health care than another nation. What are the implications of fi nding health care to be income elastic in cross-national...
-
Does the Medicare PPS payment under DRGs reduce costs? Discuss.
-
Which of the three reference states of stress are, by nature, isotropic?
-
Let Q opt in Figure 18.4 represent the optimal level of health care in society under the external benefi ts rationale for social health care programs. Would members of society necessarily view Q opt...
-
Consider a diagram like Figure 22.3 where states are offered the opportunity to buy into Medicaid under the ACA for a 9:1 match. (a) Mark an initial level of expenditures if the state is spending $20...
-
The balance sheet of Recreation, Inc., at December 31, 2017, reported 500,000 shares of $1 par common stock authorized with 100,000 shares issued and outstanding. Paid-in capital in excess of...
-
The company manufactures three products: wooden chairs, tables and dressers. AFC started off as a 'Mom & Pop' shop but has grown rapidly. AFC uses one assembly line to build all three products,...
-
Bobs Hamburgers issued 8%, 10-year bonds payable at 70 on December 31, 2016. At December 31, 2018, Bob reported the bonds payable as follows: Bobs pays semiannual interest each June 30 and December...
-
At December 31, MediAssist Precision Instruments owes $51,000 on Accounts Total Liabilities $358,000Payable, Salaries Payable of $12,000, and Income Tax Payable of $10,000. MediAssist also has...
-
Humble Company has provided the following budget information for the first quarter of 2016: Total sales ....................$ 208,000 Budgeted purchases of direct materials ....... 40,150 Budgeted...
-
Find the Laplace transform of the following signals and locate the poles and zeros of \(F(s)\). (a) \(f(t)=-8 u(t)\). (b) \(f(t)=0.5 t u(t)\). (c) \(f(t)=10 e^{-20000 t} u(t)\).
-
Find the Laplace transform of \(f(t)=-5 u(t)+5 e^{-5 t}\) \(u(t)-5 t u(t)\). Locate the poles and zeros of \(F(s)\).
-
Find the Laplace transform of \(f(t)=\delta^{\prime}(t)+\delta(t)-e^{-t} u\) \((t)\). Locate the poles and zeros of \(F(s)\).
Study smarter with the SolutionInn App