(Solution) ALPHABET INC CLASS C CAPITAL STOCK (GOOG) CashFlowFlag INCOME STATEMENT Fiscal year ends in December. USD in millions except per share data. > Snapessays.com

(Solution) ALPHABET INC CLASS C CAPITAL STOCK (GOOG) CashFlowFlag INCOME STATEMENT Fiscal year ends in December. USD in millions except per share data.

Please provide solutions on ExcelAttached is the income statement and balance sheet of Google Co. please calculate the following ratio for the two most recent years;Price/Earnings Ratio Price/Cash Flow Ratio Market/Book Ratio Common Size Analysis Percentage Change AnalysisWhat can you conclude from the ratios? Any warning signs? Anything that stands out? Ch17, 19 Problems17-1) At today's exchange rate 1 U.S. dollar can be exchange for 9 Mexican pesos or for 111.23 Japanese yen. You have pesos that you would like to exchange for yen. What is the cross rate between the yen and the peso; that is, how many yen would you receive for every peso exchanged?17-2) The nominal yield on 6-month T-bills is 7%, while default-free Japanese bonds that mature in 6 months have a nominal rate of 5.5%. In the spot exchange market, 1 yen equals \$0.009. If interest rate parity holds, what is the 6-month forward exchange rate?17-3) A computer costs \$500 in the United States. The same model costs 550 euros in France. If purchasing power parity holds, what is the spot exchange rate between the euro and the dollar?17-6) Suppose the exchange rate between U.S. dollars and the Swiss franc is SFr 1.6 = \$1 and the exchange rate between the dollar and the British pound is £1 = \$1.50. What then is the cross rate between francs and pounds?17-10) In 1983 the Japanese yen - U.S. dollar exchange rate was 245 yen per dollar, and the dollar cost of a compact Japanese-manufactured car was \$8,000. Suppose that now the exchange rate is 80 yen per dollar. Assume there has been no inflation in the yen cost of an automobile so that all price changes are due to exchange rate changes. What would the dollar price of the car be now, assuming the car's price changes only with exchange rates? 19-1) Reynolds Construction needs a piece of equipment that costs \$200. Reynolds can either lease the equipment or borrow \$200 from a local bank and buy the equipment. If the equipment is leased, the lease would NOT have to be capitalized. Reynolds's balance sheet prior to the acquisition of the equipment is as follows:Current Assets                   \$300                      Debt                    \$400Net fixed assets                 \$500                      Equity                  \$400                                             _______                                               _________Total Assets                        \$800                      Total Claims       \$800a)1. What is Reynolds's current debt ratio? 2. What would be the company's debt ratio if it purchased the equipment? 3. What would be the debt ratio if the equipment were leased? b)Would the company's financial risk be different under the leasing and purchasing alternatives? 19-2) Consider the data in Problem 19-1. Assume that Reynolds's tax rate is 40% and the equipment's depreciation would be \$100 per year. If the company leased the asset on a 2-year lease, the payment would be \$110 at the beginning of each year. If Reynolds borrowed and bought, the bank would charge 10% interest on the loan. In either case, the equipment is worth nothing after 2 years and will be discarded. Should Reynolds lease or buy the equipment?19-4) Big Sky Company must install \$1.5 million of new machinery in its Nevada mine. It can obtain a bank loan for 100% of the purchase price, or it can lease the machinery. Assume that the following facts apply:1) The machinery falls into the MACRS 3-year class 2) Under either the lease or purchase, Big Sky must pay for insurance, property, taxes, and maintenance. 3) The firm's tax rate is 40% 4) The loan would have an interest rate of 15%. It would be non-amortizing, with only interest paid at the end of each year for four years and the principle repaid at Year 4. 5) The lease terms call for \$400,000 payments at the end of year of the next 4 years. 6) Big Sky Mining has no use for the machine beyond the expiration of the lease, and the machine has an estimated residual value of \$250,000 at the end of the 4th year. What is the NAL of the lease?ALPHABET INC CLASS C CAPITAL STOCK

(GOOG) CashFlowFlag INCOME STATEMENT

Fiscal year ends in December. USD in millions except per share data.

2010-12 2011-12 2012-12 2013-12 2014-12 TTM

Revenue

29321

37905

50175

59825

66001 71763

Cost of revenue

10417

13188

20634

25858

25691 26897

Gross pro±t

18904

24717

29541

33967

40310 44866

Opera²ng expenses

Research and development

3762

5162

6793

7952

9832 11585

4761

7313

9988

12049

13982 14902

Other opera²ng expenses

500

Total opera²ng expenses

8523

12975

16781

20001

23814 26487

Opera²ng income

10381

11742

12760

13966

16496 18379

Interest Expense

58

84

83

101

103

Other income (expense)

415

642

710

613

864

702

Income before taxes

10796

12326

13386

14496

17259 18978

Provision for income taxes

2291

2589

2598

2282

3331

3537

Net income from con²nuing opera²ons

8505

9737

10788

12214

13928 15441

Net income from discon²nuing ops

-51

706

516

967

Net income

8505

9737

10737

12920

14444 16408

Preferred dividend

522

Net income available to common shareholders

8505

9737

10737

12920

14444 15886

Earnings per share

Basic

13.36

15.1

16.42

19.43

21.37

23.28

Diluted

13.17

14.89

16.17

19.08

21.02

23.08

Weighted average shares outstanding

Basic

637

645

645

665

676

682

Diluted

646

654

645

677

687

688

EBITDA

11777

14235

16432

18518

22339 24007

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Sep 21, 2023

Solution~00021147635896.zip (25.37 KB)

This attachment is locked

Our expert Writers have done this assignment before, you can reorder for a fresh, original and plagiarism-free copy and it will be redone much faster (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Sep 21, 2023

EXPERT

Tutor