1

# Create the 2018 statement of cash flows, and it should be created on the appropriate tab...

## Question

###### Create the 2018 statement of cash flows, and it should be created on the appropriate tab...

Create the 2018 statement of cash flows, and it should be created on the appropriate tab of the Excel. Also finish the last picture of the all totals and sub totals.

Income Statement For the Years Ended December 31, 2018 and 2017 $in millions 2018 2017 Revenue$ Net sales Cost of merchandise sold Gross Profit 44,452 $24,969 19,483 37,043 20,807 16,236 Operating Expenses Selling, general and administrative Depreciation Amortization Operating income 7,182 2,550 45 9,706 5,985 2,499 45 7,707 205 171 Interest expense, net Gain/(Loss) on sale of property & equip Income before income taxes 169 114 9,670 7,650 Provision for income taxes 2,031 1,762 Net income$ 7,639 $5,888 Balance Sheet December 31, 2018 and 2017$ in millions 2018 2017 $Current Assets Cash and cash equivalents Accounts Receivable, net Merchandise inventories Other current assets Total Current Assets 9,165 1,610 4,029 316 15,120 1,407 1,600 3,814 359 7,180 7,749 Long-Term Assets Property and equipment, net Intangible assets, net Total Long-Term Assets Total Assets 193 8,515 238 8,753 15,933 7,942 23,062$ Current Liabilities Accounts payable Accrued liabilities Income taxes payable Current portion of long-term debt Total Current Liabilities 1,251 $1,206 130 127 2,714 1,511 1,160 78 110 2,859 Non-current Liabilities Long-term debt Total Liabilities 5,483 5,900 8,614 8,342 Shareholders' Equity Common stock;.01 par value; 9,000 share authorized; 370 and 367 shares issued & outstanding respectively Paid-in capital Treasury stock, at cost Retained earnings Total Shareholders' Equity Total Liabilities and Shareholders' Equity 2,927 (9,714) 21,231 14,448 23,062 2,723 (8,744) 13,608 7,591 15,933$ Additional Information: The company paid dividends of $16 in 2018. The company purchased treasury stock of$970 during 2018, and sold common stock for $204 during 2018. No other stock transactions took place. The company purchased$2,091 in equipment during the year. In addition, equipment was sold for $476; the equipment had a book value at the time of sale of$307. There were no purchases or sales of intangible assets. The company made payments of $176 on its debt obligations, and took an additional$610 in debt during the year.
Current Ratio = Acid-Test Ratio = AR Turnover = Days Sales Uncollected = Inventory turnover = Days sales in Inventory = Total Asset Turnover = Debt to Equity = Times Interest Earned = Profit Margin = Return on Total Assets = Return on Stockholders Equity = Earnings per Share (EPS) =

#### Similar Solved Questions

##### An infinite line of uniform positive charge runs along the x axis and has a line...
An infinite line of uniform positive charge runs along the x axis and has a line charge density of \lambda = 26.5 \frac{nC}{m}λ=26.5​m​​nC​​. Consider the point (0 m, 2.67 m) which is located 2.67 meters above the infinite line. What is the magnitude of the elect...
##### Suppose that the marginal PDF of X is fX(X)=6x(1−x), for 0≤x ≤1, and theconditional PDF of...
Suppose that the marginal PDF of X is fX(X)=6x(1−x), for 0≤x ≤1, and theconditional PDF of Y given X =x is fY|X(y|x)= 1/ 1−x, for 0≤x ≤y ≤1. (a) Find E[Y |X =x]. (b) Find E[E[Y|X]]....
##### Assume a company needs to produce 60 units of product A and 30 units of product...
Assume a company needs to produce 60 units of product A and 30 units of product B each day. The firm operates using Lean practices. Also assume the firm has reduced setup times to negligible values. Which of the following would be the best strategy for the company to follow to produce these units? S...
##### Falcon Design is an interior design firm. The firm uses a job.cost system in which each...
Falcon Design is an interior design firm. The firm uses a job.cost system in which each client is a different Falcon Design traces direct labor, boensing costs and travel costs directly to each dient alocales indred costs to Jobs based on a predetermined indirect cost allocation rate computed as a p...
##### As Mel Smith was doing his year-end accounting, he noticed that the bookkeeper had made errors...
As Mel Smith was doing his year-end accounting, he noticed that the bookkeeper had made errors in recording several transactions. The erroneous transactions are as follows: id When making the entry to record the year's depreciation expense, the bookkeeper debited Accumulated Depreciation-Equipme...
##### How do you graph an absorbance vs mole fraction graph when doing lab for Methods for...
how do you graph an absorbance vs mole fraction graph when doing lab for Methods for determining the Stiochiometry of a complex ?...
##### Solve the system of equations. Express your answer in fractions. 5x – 7y = 31 4x...
Solve the system of equations. Express your answer in fractions. 5x – 7y = 31 4x + 3y = 19...
##### Ob Quod ? a'.acyd 67+2 = 11* ex+2 = 11
ob Quod ? a'.acyd 67+2 = 11* ex+2 = 11...
##### In order to allow efficient communication between scientists it is important to have a standardized nomenclature...
In order to allow efficient communication between scientists it is important to have a standardized nomenclature system. Draw structures for the compounds named below: a) 2,2-dimethylpropanal b) Draw the structure of the product formed by the oxidation of 2,2-dimethylpropanal c) Determine the produc...
##### A teacher decided to test the effect of sound when students were studying Students in de...
A teacher decided to test the effect of sound when students were studying Students in de were randomly assigned into three groups of eight. All groups where when the same material and 30 minutes to study prior to being given a quiz. One group was exposed to consistent background music, one group was...
##### All of the following are true regarding calories except a. Calorie requirements vary depending on individual...
All of the following are true regarding calories except a. Calorie requirements vary depending on individual characteristics b. Calories include essential minerals. c. Calories listed on food labels actually represent kilocalories d. Calories indicate the amount of energy we obtained from a particul...