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) =
Answers
Cash Flow Statement: Amount $ Cash from operating activities: Net Income 7639 Add:Depreciation 2550 Add:Amortization 45 Less:Gain on sale of Property & eq. -169 Less: increase in AR -10 Less:Increase in MI -215 Add:decrease in other current assets 43 Less:decrease in AP -260 add:increase in AL 46 add:increase in ITP 52 add:current LTD 17 Net cash from operating activities 9738 Cash from investing activities: less: purchase of equip -2091 add:sale of equip 476 Net cash outflow of Investing act. -1615 Cash from financing activities: less:treasury stock purchased -970 add:issued CS 204 less:dividend paid -16 add:debt added 417 Net Cash outflow of financing act. -365 Net Cash inflow of all activities 7758 add:opening cash and cash equivalent 1407 Closing cash and cash equivalents 9165
RATIOS Formula Calculations Result Current ratio CA/CL 15120/2714 5.57 Acid Test ratio (CA-Inv.)/CL (15120-4029)/2714 4.09 AR Turnover Sales / Avg AR (44452*2)/(1600+16100) 5.02 Days sale uncollected 365 / AR t/o 365/5.02 72.71 Inventory turnover COGS/ Avg Inv. (24969*2)/(4029+3814) 6.37 Days sales in Inventory 365/ Inv. T/o 365/6.37 57.30 Total Asset Turnover Sales /Avg TA (44452*2)/(23062+15933) 2.28 Debt to equity T. Debt/ Sh. Eq. 8614/23062 0.37 Times interest earned EBIT / Int exp. 9706/205 47.35 profit margin NP/ Sales 7639/44452 0.17 return on total Assets NP / TA 7639/23062 0.33 return on stockholders' equity NP / SH. Eq. 7639/14448 0.53 EPS NP / Number of O/s shares 7639/370 20.65
Similar Solved Questions
1 answers
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.5mnC. 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...
1 answers
No more information can be added. This is the entire question. $10100 is wrong answer. DOMAIN...
No more information can be added. This is the entire question. $10100 is wrong answer. DOMAIN 2 - 2.4 Schedule C, Self-Employment: 2.4.7 Depreciation: 2.4.7.2 Luxury Auto Depreciation Limi Question 45 of 100. What is the maximum amount of depreciation that can be claimed on any van placed into servi...
1 answers
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]]....
1 answers
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...
1 answers
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...
1 answers
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...
1 answers
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 ?...
1 answers
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...
1 answers
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...
1 answers
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...
1 answers
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...
1 answers
Terry Baxter is owner of Alpha Company. Baxter provided Alpha Company with $75,000 of computer equipment....
Terry Baxter is owner of Alpha Company. Baxter provided Alpha Company with $75,000 of computer equipment. The journal entry to record this transaction is?...
1 answers
Hello, I need help with these two functions blockPrint and wordPrint.The program is written in C....
Hello, I need help with these two functions blockPrint and wordPrint.The program is written in C. Thank you. ent the prototype for blockPrint. a) Intextfunctions.h, uncon Write the function definition for block Print dentical characters on a separate line. (See example This function should print eac...
1 answers
Sandhill Inc, Issues $2,800,000 of 7% bonds due in 10 years with interest payable at year-end....
Sandhill Inc, Issues $2,800,000 of 7% bonds due in 10 years with interest payable at year-end. The current market rate of interest for bonds of similar risk is 12% Click here to view factor tables What amount will Sandhill receive when it issues the bonds? (For calculation purposes, use 5 decimal pl...
1 answers
Which best represents the flow of information in a cell (from recipe to function)? A Protein--RNA--DNA...
Which best represents the flow of information in a cell (from recipe to function)? A Protein--RNA--DNA B RNA--DNA--Protein C DNA--RNA--Protein...