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
Sales, General and administra²ve
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
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)
Answered
QUALITYApproved
DATE ANSWEREDSep 21, 2023
EXPERTTutor
ANSWER RATING
We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.
You can also use these solutions:
