Screenshot 2024-04-10 at 5.55.40 PM ' Screenshot Sc Screenshot 2024-0....53.33 PM 2024-0....41.29 PM 2024- 1 A...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Screenshot 2024-04-10 at 5.55.40 PM ' Screenshot Sc Screenshot 2024-0....53.33 PM 2024-0....41.29 PM 2024- 1 A B C A B C 1 Balance Sheet (Millions of $) 2 Assets 2 Income Statement (Millions of $) 3 Net sales 4 Operating costs except depr'n 5 Depreciation 2012 2013 3 Cash and securities Screenshot 6 Earnings bef int and taxes (EBIT) 2024-0....42.52 PM Sc 2024- 7 Less interest 8 Earnings before taxes (EBT) 9 Taxes 10 Net income $58,200.00 $57,036.00 $54,558.00 $48,556.62 $1,024.00 $1,136.64 $2,618.00 $7,342.74 170.2 $211.05 $2,447.80 $7,131.69 $881.20 $2,567.41 $1.566.60 5 4 Accounts receivable Inventories 6 Total current assets 8 Total assets $4,564.28 11 Notes payable 12 Accruals 11 Other data: 13 Total current liabilities 12 Shares outstanding (millions) Screenshot 2024-0....53.42 PM Sc 2024- 13 Common dividends (Millions of $) 14 Int rate on notes payable & L-T bonds 15 Federal plus state income tax rate 16 Year-end stock price 173 $511.21 6.50% $1,489.41 36% $77.97 7 Net plant and equipment 9 Liabilities and Equity 10 Accounts payable 14 Long-term bonds 15 Total debt 16 Common stock 17 Retained earnings 2012 2013 $1,594.00 $2,506.33 9,940.00 $11,132.80 13,560.00 $15,322.80 $25,094.00 $28,961.93 15,946.00 $16,105.46 $41,040.00 $45.067.39 $7,440.00 $7,291.20 5,630.00 $5,067.00 4,570.00 $3,975.90 $17,640.00 $16,334.10 10,940.00 $12,471.60 $28,580.00 $28,805.70 3,160.00 $3,886.80 9,300.00 $12,374.89 17 18 Total common equity $12,460.00 $16,261.69 19 Total liabilities and equity 20 $41,040.00 $45,067.39 Screenshot 2024-04-10 at 5.54.35 PM A B 1 Ratios 2 1 Current Ratio (CR) 3 2 Quick Ratio (QR) 4 3 Days Sales Outstanding (DSO) 5 4 Total Assets Turnover (TAT) 6 5 Inventory Turnover Ratio 7 6 Times Interest Earned (TIE) 8 7 EBITDA Coverage 9 8 Debt Ratio 10 9 Return on Assets (ROA) 11 10 ROE (Return on Equity) 12 11 Basic Earning Power (BEP) 13 12 Net Profit Margin (NPM) 14 13 Dividends Per Share (DPS) 15 14 Cash Flow Per Share (CFPS) 16 15 Earnings Per Share (EPS) 17 16 P/E Ratio 18 17 Book Value Per Share (BVPS) 19 18 Market-To-Book Ratio (M/B or P/B) 20 19 Equity Multiplier (EM) 21 22 23 21 C 2012 D 2013 Notes Insert formulas using cell references in cells highlighted green above. Do not use values! E F Points Change 0.31 0.31 Use 365 day year 0.31 0.31 Use C23 to represent COGS 0.31 0.31 Assume Principal Repayments and Lease Payments are zero Use Total Debt 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 Search G Comment on the change from 2012 to 2013 Point out whether performance has improved or worsened and on what measure C M Screenshot 2024-04-10 at 5.55.40 PM ' Screenshot Sc Screenshot 2024-0....53.33 PM 2024-0....41.29 PM 2024- 1 A B C A B C 1 Balance Sheet (Millions of $) 2 Assets 2 Income Statement (Millions of $) 3 Net sales 4 Operating costs except depr'n 5 Depreciation 2012 2013 3 Cash and securities Screenshot 6 Earnings bef int and taxes (EBIT) 2024-0....42.52 PM Sc 2024- 7 Less interest 8 Earnings before taxes (EBT) 9 Taxes 10 Net income $58,200.00 $57,036.00 $54,558.00 $48,556.62 $1,024.00 $1,136.64 $2,618.00 $7,342.74 170.2 $211.05 $2,447.80 $7,131.69 $881.20 $2,567.41 $1.566.60 5 4 Accounts receivable Inventories 6 Total current assets 8 Total assets $4,564.28 11 Notes payable 12 Accruals 11 Other data: 13 Total current liabilities 12 Shares outstanding (millions) Screenshot 2024-0....53.42 PM Sc 2024- 13 Common dividends (Millions of $) 14 Int rate on notes payable & L-T bonds 15 Federal plus state income tax rate 16 Year-end stock price 173 $511.21 6.50% $1,489.41 36% $77.97 7 Net plant and equipment 9 Liabilities and Equity 10 Accounts payable 14 Long-term bonds 15 Total debt 16 Common stock 17 Retained earnings 2012 2013 $1,594.00 $2,506.33 9,940.00 $11,132.80 13,560.00 $15,322.80 $25,094.00 $28,961.93 15,946.00 $16,105.46 $41,040.00 $45.067.39 $7,440.00 $7,291.20 5,630.00 $5,067.00 4,570.00 $3,975.90 $17,640.00 $16,334.10 10,940.00 $12,471.60 $28,580.00 $28,805.70 3,160.00 $3,886.80 9,300.00 $12,374.89 17 18 Total common equity $12,460.00 $16,261.69 19 Total liabilities and equity 20 $41,040.00 $45,067.39 Screenshot 2024-04-10 at 5.54.35 PM A B 1 Ratios 2 1 Current Ratio (CR) 3 2 Quick Ratio (QR) 4 3 Days Sales Outstanding (DSO) 5 4 Total Assets Turnover (TAT) 6 5 Inventory Turnover Ratio 7 6 Times Interest Earned (TIE) 8 7 EBITDA Coverage 9 8 Debt Ratio 10 9 Return on Assets (ROA) 11 10 ROE (Return on Equity) 12 11 Basic Earning Power (BEP) 13 12 Net Profit Margin (NPM) 14 13 Dividends Per Share (DPS) 15 14 Cash Flow Per Share (CFPS) 16 15 Earnings Per Share (EPS) 17 16 P/E Ratio 18 17 Book Value Per Share (BVPS) 19 18 Market-To-Book Ratio (M/B or P/B) 20 19 Equity Multiplier (EM) 21 22 23 21 C 2012 D 2013 Notes Insert formulas using cell references in cells highlighted green above. Do not use values! E F Points Change 0.31 0.31 Use 365 day year 0.31 0.31 Use C23 to represent COGS 0.31 0.31 Assume Principal Repayments and Lease Payments are zero Use Total Debt 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 Search G Comment on the change from 2012 to 2013 Point out whether performance has improved or worsened and on what measure C M
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
The trial balance of Terry manning Fashion Center contained the following accounts at November 30, the end of the companys fiscal year. Adjustment data: 1. Store supplies on hand totaled $2,500. 2....
-
A 0.1 m (3.9 in.) rod of a metal elongates 0.2 mm (0.0079 in.) on heating from 20 to 100C (68 to 212F). Determine the value of the linear coefficient of thermal expansion for this material.
-
Provide a critique of the research model introduced in this chapter. What other factors might be considered when talking of alignment?
-
Percentage of Credit Sales CORNERSTONE 5.2 Shanghai Company has credit sales of \(\$ 550,000\) during 2018 and estimates at the end of 2018 that \(2.5 \%\) of these credit sales will eventually...
-
Sigma Company is authorized to issue 100,000 shares of common stock. The company sold 5,000 shares at $12 per share. Prepare journal entries to record the sale of stock for cash under each of the...
-
a firm with a WACC of 10% . is considering the following mutually exclusive projects: Click here to read the eBook: Net Present Value (NPV) CAPITAL BUDGETING CRITERIA: MUTUALLY EXCLUSIVE PROJECTS A...
-
Corny and Sweet grows and sells sweet com at its roachide produce stand. The selling price per dozen is $2.50, variable costs are $2.25 por docen, and total feed costs are $150 00 What are becake...
-
Elya and her group members are interested to examine the level of organizational commitment among support staff of public sectors in Putrajaya. Based on the population frame obtained from the Human...
-
Question 4 (Total: 10 marks) (a) Let .L denote the future loss random variable for a whole life insurance policy issued to a life aged x. Premiums of $P are payable at the beginning of each year...
-
Discuss your own experience level with stocks and bonds. What do you think is your top strength and weakness in this area? How do you leverage that strength and work on the weakness in pursuit of...
-
What are the causes and consequences of reproductive disorders, such as infertility, endometriosis, polycystic ovary syndrome (PCOS), and male factor infertility, and how do advances in assisted...
-
Research the bilateral agreement between the two countries where your product originated and where it's being sold. (Not U.S.) Identify its stated purpose of the bilateral agreement. Briefly discuss...
-
Cheapo brand alarm clocks have a 85% probability of working. Nervous Nelly has a big job interview tomorrow morning and is setting two Cheapo brand alarm clocks. As long as one of them goes off,...
-
An auto-parts manufacturer is considering establishing an engineering computing center. This center will be equipped with three engineering workstations each of which would cost $25,000 and have a...
-
How should the sample company decide which capital projects to fund?
-
How can a general manager defend discretionary projects that may appear to shareholders to be perks?
-
What role does cash play in the restructuring of a company through acquisitions and divestitures?
Study smarter with the SolutionInn App