Question

In: Finance

At the end of its June 30, 2008, fiscal year, Microsoft Corporation reported $23.7 billion in...

At the end of its June 30, 2008, fiscal year, Microsoft Corporation reported $23.7 billion in short-term interest-bearing investments and cash equivalents. The firm had no debt obligations. Subsequently, in September of that year, the firm announced a $40 billion stock repurchase and its intention to raise the annual dividend to 52 cents a share, from 44 cents, or to a total of $4. 7 billion.

Cash flow from operations for fiscal year 2009 was projected to be $23.4 billion, up from $21.6 billion for 2008; interest receipts were expected to be $702 million; and the firm was expected to maintain cash investment at the 2008 level of $3 .2 billion. Cash receipts from the issue of shares to employees were expected to be $2.5 billion. The firm's tax rate is 36 percent.

a. By applying the treasurer's rule, lay out the strategy for Microsoft's treasurer for managing cash flows.

b. Microsoft is actively looking for acquisitions to enhance its presence in the Web search and Web applications area. What would be the effect on the treasurer's plan if Microsoft decided to make a $4.2 billion cash acquisition?

c. For many years, Microsoft has carried no debt (obligations). At the time of the share repurchase announcement, Microsoft also said that it had received authorization from its board of directors for debt financing up to $6 billion. Why would the management seek such authorization at this stage?

Solutions

Expert Solution

Part (a)

Let's first prepared an abridged cash flow statement for the treasurer to figure out how cash flows will look like for the year. Please see the table below. Cash flows are in $ bn. A figure in parenthesis means a negative value. The column titled "Linkage" explains how each value has been calculated. IN the first column, there is a sign like [+] or [-] before each item which will help you understand whether a line item / value is added or subtracted to get the final value.

Expected Cash flow statement for the treasurer for 2009

Parameter

Linkage

$ bn

Cash flow from operations

A

23.40

[+] Interest receipts

B

0.70

[-] Taxes on interest received

C=36% x B

0.25

[-] Cash investments

D

3.20

[+] Proceeds from issue of shares

E

2.50

[-] Dividends to be paid

F

4.70

[-] Share repurchase

G

40.00

Expected cash flow during the year 2009

A + B - C - D + E - F - G

(21.55)

There will be a cash shortfall of $ 21.55 bn. There are three possible strategies for the treasurer, based on the cash flows statement shown in the table above:

  1. Redeem the $ 23.7 billion in short-term interest-bearing investments and cash equivalents it has on its balance sheet as June 2008 and use the same to bridge the cash flow gap.
  2. Raise fresh debt to bridge the cash shortfall.
  3. A combination of option (1) and (2)

Part (b)

If Microsoft decided to make a $4.2 billion cash acquisition, the revised cash flow position will be $ (21.55) - $ 4.2 = $ (25.75). So the shortfall will further increase. The treasurer will have to necessarily resort to fresh debt because even after redeeming the full $ 23.7 billion in short-term interest-bearing investments and cash equivalents, there will still be shortfall.

Part (c)

It would not take Microsoft long to realize that there will be cash shortfall next year, primarily driven by share repurchase program. We have seen a negative cash flow for the year in the table above, on a gross basis. The timing of the cash flows may make the gap even larger. The cash acquisition pipeline will further increase the gap. It's therefore wiser on the part of the management to be prudent and proactive; and seek and receive authorization from its board of directors for debt financing up to $6 billion.


Related Solutions

For its fiscal year ending on June​ 30, 2018, Microsoft reported net income of ​$15.3315.33 billion...
For its fiscal year ending on June​ 30, 2018, Microsoft reported net income of ​$15.3315.33 billion from sales of $107.07107.07 billion. The company also reported total assets of ​$230.53230.53 billion. a. Calculate​ Microsoft's total asset turnover and its net profit margin. b. Find the​ company's ROA,​ ROE, and book value per​ share, given that it has a total net​ stockolders' equity of ​$77.3177.31 billion and 4.024.02 billion shares of common stock outstanding.
At June 30, 2017, the end of its most recent fiscal year, Green River Computer Consultants’...
At June 30, 2017, the end of its most recent fiscal year, Green River Computer Consultants’ post-closing trial balance was as follows: Debit Credit Cash $5,230 Accounts receivable 1,200 Supplies 690 Accounts payable $400 Unearned service revenue 1,120 Common stock 3,600 Retained earnings 2,000 $7,120 $7,120 The company underwent a major expansion in July. New staff was hired and more financing was obtained. Green River conducted the following transactions during July 2017, and adjusts its accounts monthly. July 1 Purchased...
In 2015 Microsoft Corporation reported a $5.1 billion charge for the impairment of goodwill and a...
In 2015 Microsoft Corporation reported a $5.1 billion charge for the impairment of goodwill and a $2.2 billion charge for the impairment of intangible assets in one of its reporting units (segments) in its 10-K annual report. Referring to Microsoft's 2015 financial statements and any other information from the media, address the following: 1. Microsoft's segments serve as its reporting units for assessing goodwill for potential impairments. Which segment suffered a 2015 impairment? Describe the revenue model for this segment....
At June 30, 2017, the end of its most recent fiscal year, Sheffield Computer Consultants’ post-closing...
At June 30, 2017, the end of its most recent fiscal year, Sheffield Computer Consultants’ post-closing trial balance was as follows: Debit Credit Cash $5,650 Accounts receivable 1,300 Supplies 750 Accounts payable $430 Unearned service revenue 1,210 Common stock 3,900 Retained earnings 2,160 $7,700 $7,700 The company underwent a major expansion in July. New staff was hired and more financing was obtained. Sheffield conducted the following transactions during July 2017, and adjusts its accounts monthly. July 1 Purchased equipment, paying...
At June 30, 2017, the end of its most recent fiscal year, Sheffield Computer Consultants’ post-closing...
At June 30, 2017, the end of its most recent fiscal year, Sheffield Computer Consultants’ post-closing trial balance was as follows: Debit Credit Cash $5,650 Accounts receivable 1,300 Supplies 750 Accounts payable $430 Unearned service revenue 1,210 Common stock 3,900 Retained earnings 2,160 $7,700 $7,700 The company underwent a major expansion in July. New staff was hired and more financing was obtained. Sheffield conducted the following transactions during July 2017, and adjusts its accounts monthly. July 1 Purchased equipment, paying...
Anytown's fiscal year end is June 30. Anytown sends out its real estate tax bills on...
Anytown's fiscal year end is June 30. Anytown sends out its real estate tax bills on July 1, 20X1. The billings amount to $5 million, which 25% is due August 1 20X1, 25% is due December 1, 20X1, and 50% is due February 1, 20X2. What amount of these billings should Anytown recognize as revenue in its June 30, 20X1 governmental fund financial statements?
At June 30, 2017, the end of its most recent fiscal year, Bramble Computer Consultants’ post-closing...
At June 30, 2017, the end of its most recent fiscal year, Bramble Computer Consultants’ post-closing trial balance was as follows: Debit Credit Cash $4,080 Accounts receivable 940 Supplies 540 Accounts payable $310 Unearned service revenue 870 Common stock 2,800 Retained earnings 1,580 $5,560 $5,560 The company underwent a major expansion in July. New staff was hired and more financing was obtained. Bramble conducted the following transactions during July 2017, and adjusts its accounts monthly. July 1 Purchased equipment, paying...
At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing...
At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing trial balance was as follows: Debit Credit Cash $6,380 Accounts receivable 1,460 Supplies 840 Accounts payable $490 Unearned service revenue 1,370 Common stock 4,400 Retained earnings 2,420 $8,680 $8,680 The company underwent a major expansion in July. New staff was hired and more financing was obtained. Blue conducted the following transactions during July 2017, and adjusts its accounts monthly. July 1 Purchased equipment, paying...
At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing...
At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing trial balance was as follows: Debit Credit Cash $6,380 Accounts receivable 1,460 Supplies 840 Accounts payable $490 Unearned service revenue 1,370 Common stock 4,400 Retained earnings 2,420 $8,680 $8,680 The company underwent a major expansion in July. New staff was hired and more financing was obtained. Blue conducted the following transactions during July 2017, and adjusts its accounts monthly. July 1 Purchased equipment, paying...
At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing...
At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing trial balance was as follows: Debit Credit Cash $6,380 Accounts receivable 1,460 Supplies 840 Accounts payable $490 Unearned service revenue 1,370 Common stock 4,400 Retained earnings 2,420 $8,680 $8,680 The company underwent a major expansion in July. New staff was hired and more financing was obtained. Blue conducted the following transactions during July 2017, and adjusts its accounts monthly. July 1 Purchased equipment, paying...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT