Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

I need help calculating the debt and cost of debt for company TECD. I am not sure if my calculations are correct. Something looks off.

I need help calculating the debt and cost of debt for company TECD. I am not sure if my calculations are correct. Something looks off. I have attached a screenshot of my calculations below followed by a copy of the balance sheet. Thank you so much for your help!

Here is a copy of the balance sheet. image text in transcribedimage text in transcribed

G H A B D E F 1 TECD DEBT and Cost of debt ro 2 2014 2015 2016 2017 2018 2019 3 Cash $570,101 $542,995 $531,169 $2,125,591 $955,628 $ 799,123 4 5 Short-term debt 4,574,107 3,729,823 3,914,583 4,337,731 8,132,179 8,496,592 6 Long-term debt 453,467 434,977 419,887 1,051,124 1,734,027 1,442,869 7 8 Net debt 4,457,473 3,621,805 3,803,301 3,263,264 8,910,578 9,140,38 9 10 Interest expense $26,606 26,548 14,488 36,810 112,207 106,725 11 Cost of debt, ro 0.66% 0.39% 1.04% 1.84% 1.18% 12 13 14 15 Jan. 31, 2014 Jan. 31, 2015 2014 2015 Jan. 31, 2016 2016 Jan. 31, 2017 2017 Jan. 31, 2018 2018 Jan. 31, 2019 2019 $570,101 3,215,729 2,450,782 232,423 $542,995 2,811,963 1,959,627 161,832 101,706 5,578,123 63,104 6,469,035 77,631 1 Consolidated Balance Sheet - USD ($) $ in Thousands 2 Fiscal Year 3 Current assets: 4 Cash and cash equivalents 5 Accounts receivable, less allowances of $73,270 and $83,772 6 Inventories 7 Prepaid expenses and other assets 8 Disposal Group, Including Discontinued Operation, Assets, Current 9 Total current assets 10 Property and equipment, net 11 Goodwill 12 Intangible assets, net 13 Other assets, net 14 Total assets 15 Current liabilities: 16 Accounts payable 17 Accrued expenses and other liabilities 18 Revolving credit loans and current maturities of long-term debt, net 19 Disposal Group, Including Discontinued Operation, Liabilities, Current 20 Total current liabilities 21 Long-term debt, less current maturities 22 Other long-term liabilities $ 531,169 2,995,114 2,117,384 178,394 0 5,822,061 66,028 204,114 159,386 106,699 6,358,288 $ 2,125,591 3,047,927 2,118,902 119,906 0 7,412,326 74,239 199,021 130,676 115,604 7,931,866 $955,628 6,035,716 2,965,521 403,548 0 10,360,413 279,091 969,168 1,086,772 224,915 12,920,359 $ 799,123 6,241,740 3,297,385 354,601 0 10,692,849 274,917 892,990 950,858 174,938 12,986,552 0 623,000 7,169,666 0 497,019 6,138,246 3,959,410 614,697 43,481 0 4,617,588 354,121 99,346 3,119,618 538,758 13,303 71,447 3,743,126 353,097 81,880 3,427,580 487,003 18,063 0 3,932,646 348,608 71,279 4,352,533 3,844,532 493,199 373,123 0 4,710,854 989,924 61,200 5,761,978 6,962,193 1,169,986 132,661 0 8,264,840 1,505,248 228,779 9,998,867 7,496,466 1,000,126 110,368 0 8,606,960 1,300,554 142,315 10,049,829 5,071,055 4,178,103 89 89 89 89 89 23 Total liabilities 24 Shareholders' equity: Common stock, par value $.0015; 200,000,000 shares authorized; 59,245,585 shares issued at 25 January 31, 2019 and 2018 26 Additional paid-in capital 27 Treasury stock, at cost (22,305,464 and 21,083,972 shares at January 31, 2019 and 2018) 28 Retained earnings 29 Accumulated other comprehensive income 30 Total shareholders' equity 31 Total liabilities and shareholders' equity 22 89 675,597 (894,936) 1,993,290 324,571 2,098,611 $7,169,666 679,973 (939,143) 2,168,462 50,762 1,960,143 $6,138,246 682,227 (1,077,434) 2,434,198 (33,325) 2,005,755 $6,358,288 686,042 (1,070,994) 2,629,293 (74,542) 2,169,888 $ 7,931,866 827,301 (940,124) 2,745,934 288,292 2,921,492 $ 12,920,359 844,206 (1,037,872) 3,086,514 43,786 2,936,723 $ 12,986,552 G H A B D E F 1 TECD DEBT and Cost of debt ro 2 2014 2015 2016 2017 2018 2019 3 Cash $570,101 $542,995 $531,169 $2,125,591 $955,628 $ 799,123 4 5 Short-term debt 4,574,107 3,729,823 3,914,583 4,337,731 8,132,179 8,496,592 6 Long-term debt 453,467 434,977 419,887 1,051,124 1,734,027 1,442,869 7 8 Net debt 4,457,473 3,621,805 3,803,301 3,263,264 8,910,578 9,140,38 9 10 Interest expense $26,606 26,548 14,488 36,810 112,207 106,725 11 Cost of debt, ro 0.66% 0.39% 1.04% 1.84% 1.18% 12 13 14 15 Jan. 31, 2014 Jan. 31, 2015 2014 2015 Jan. 31, 2016 2016 Jan. 31, 2017 2017 Jan. 31, 2018 2018 Jan. 31, 2019 2019 $570,101 3,215,729 2,450,782 232,423 $542,995 2,811,963 1,959,627 161,832 101,706 5,578,123 63,104 6,469,035 77,631 1 Consolidated Balance Sheet - USD ($) $ in Thousands 2 Fiscal Year 3 Current assets: 4 Cash and cash equivalents 5 Accounts receivable, less allowances of $73,270 and $83,772 6 Inventories 7 Prepaid expenses and other assets 8 Disposal Group, Including Discontinued Operation, Assets, Current 9 Total current assets 10 Property and equipment, net 11 Goodwill 12 Intangible assets, net 13 Other assets, net 14 Total assets 15 Current liabilities: 16 Accounts payable 17 Accrued expenses and other liabilities 18 Revolving credit loans and current maturities of long-term debt, net 19 Disposal Group, Including Discontinued Operation, Liabilities, Current 20 Total current liabilities 21 Long-term debt, less current maturities 22 Other long-term liabilities $ 531,169 2,995,114 2,117,384 178,394 0 5,822,061 66,028 204,114 159,386 106,699 6,358,288 $ 2,125,591 3,047,927 2,118,902 119,906 0 7,412,326 74,239 199,021 130,676 115,604 7,931,866 $955,628 6,035,716 2,965,521 403,548 0 10,360,413 279,091 969,168 1,086,772 224,915 12,920,359 $ 799,123 6,241,740 3,297,385 354,601 0 10,692,849 274,917 892,990 950,858 174,938 12,986,552 0 623,000 7,169,666 0 497,019 6,138,246 3,959,410 614,697 43,481 0 4,617,588 354,121 99,346 3,119,618 538,758 13,303 71,447 3,743,126 353,097 81,880 3,427,580 487,003 18,063 0 3,932,646 348,608 71,279 4,352,533 3,844,532 493,199 373,123 0 4,710,854 989,924 61,200 5,761,978 6,962,193 1,169,986 132,661 0 8,264,840 1,505,248 228,779 9,998,867 7,496,466 1,000,126 110,368 0 8,606,960 1,300,554 142,315 10,049,829 5,071,055 4,178,103 89 89 89 89 89 23 Total liabilities 24 Shareholders' equity: Common stock, par value $.0015; 200,000,000 shares authorized; 59,245,585 shares issued at 25 January 31, 2019 and 2018 26 Additional paid-in capital 27 Treasury stock, at cost (22,305,464 and 21,083,972 shares at January 31, 2019 and 2018) 28 Retained earnings 29 Accumulated other comprehensive income 30 Total shareholders' equity 31 Total liabilities and shareholders' equity 22 89 675,597 (894,936) 1,993,290 324,571 2,098,611 $7,169,666 679,973 (939,143) 2,168,462 50,762 1,960,143 $6,138,246 682,227 (1,077,434) 2,434,198 (33,325) 2,005,755 $6,358,288 686,042 (1,070,994) 2,629,293 (74,542) 2,169,888 $ 7,931,866 827,301 (940,124) 2,745,934 288,292 2,921,492 $ 12,920,359 844,206 (1,037,872) 3,086,514 43,786 2,936,723 $ 12,986,552

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Cases An Active Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

2nd Edition

9781266566899

Students also viewed these Finance questions