Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Analyzing Debt Terms, Yields, Prices, and Credit Ratings Reproduced below is the

ID: 2542285 • Letter: A

Question

Analyzing Debt Terms, Yields, Prices, and Credit Ratings
Reproduced below is the debt footnote from the 2011 10-K report of Dell Inc.

Aggregate future maturities of long-term debt at face value were as follows at January 28, 2011:

There is an $86 difference between the total referenced in this table and the $5,146 referenced for long-term debt in the table above. The difference arises because the maturity table reports
the face value of the debt $(5,050). The first table above reports the carrying value (net book value) of the debt. Many of the notes are not carried at par. The largest difference is the senior
debentures that have a premium of $89 (in millions).

Reproduced below is a summary of the market values of the Dell bonds maturing from 2021 to 2040 (from Morningstar, quicktake.morningstar.com).


(a) What is the amount of long-term debt reported on Dell’s January 28, 2011, balance sheet?
$Answer

What are the scheduled maturities for this indebtedness? Year ($ millions)


(b) Dell’s $300 million 5.4% notes traded at 94.8, or 94.8% of par, as of December 2010. What is the market value of these notes on that date? (round your answer to one decimal place)
Answer

($ million)


January 28, January 29, Long-Term Debt (in millions) 2011 2010 Notes $400 million issued on June 10, 2009, at 3.375% due June 2012 $ 400 $ 401 $600 million issued on April 17, 2008, at 4.70% due April 2013 609 599 $500 million issued on September 7, 2010, at 1.40% due September 2013 499 -- $500 million issued on April 1, 2009, at 5.625% due April 2014 500 500 $700 million issued on September 7, 2010, at 2.30% due September 2015 700 -- $500 million issued on April 17, 2008, at 5.65% due April 2018 499 499 $600 million issued on June 10, 2009, at 5.875% due June 2019 600 600 $400 million issued on April 17, 2008, at 6.50% due April 2038 400 400 $300 million issued on September 7, 2010, at 5.40% due September 2040 300 -- Senior Debentures $300 million issued on April 3, 1998 at 7.10% due April 2028 389 394 Other India term loan: entered into on October 15, 2009 at 8.9% due October 2011 -- 24 Structured financing debt $ 250 $ -- Total long-term debt $ 5,146 $ 3,417 Short-Term Debt Commercial paper -- 496 Structured financing debt 850 164 Other 1 3 Total short-term debt 851 663 Total debt $ 5,997 $ 4,080

Explanation / Answer

Answer:

a. The amount of long-term debt reported on Dell’ s January, 2011,balance sheet is $5146. The scheduled maturities for this indebtedness are $0 millionsin 2012, $595 million in 2013, $1,155 million in 2014, $500 million in 2015, $700 million in 2016, and $2.1 billion, thereafter.

b. The market value of these notes is 300x0.948=$284.4million.