Question

1 Approved Answer

Posted on Aug 25, 2024

The Excel file Corporate Default Database summarizes financial information for 32 companies and their perceived risk of default. Convert these data into an Excel table.

The Excel file Corporate Default Database summarizes financial information for 32 companies and their perceived risk of default. Convert these data into an Excel table. Use table-based calculations to find the average credit score, average debt, and average equity for companies with a risk of default, and also for those without a risk of default. Does there appear to be a difference between companies with and without a risk of default?

image text in transcribed

AutoSave om A 2 Y CorporateDefaultDatabase - Excel Ga DO AL AL - Page Layout Formulas Data Review File Home Insert Draw View Help Team Analytic Solver Share Comments y X (6 Arial == ab Currency - 12 AA A Insert Delete Format AY O Paste $ % 78-98 Ideas BIU Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font E Alignment Number Colle Editing Ideas Sensitivity E4 fx 11672388 D D E F H 1 J months ? Yes Assessment Yes Manufacturing A B 1 Corporate Default Database 2 3 Company Category 4 1 Service 5 2 Manufacturing 6 3 Manufacturing 7 4 8 5 Service 9 6 Manufacturing 10 10 7 Service 11 8 Manufacturing 12 12 9 g Service 40 10 13 10 Service 14 11 Manufacturing 15 12 Manufacturing 16 13 Service 17 14 Manufacturing 18 15 Manufacturing 19 16 Manufacturing 20 17 Manufacturing Data + No No No No Na NO Na NO No No No No Yes Yes No Score 604 714 732 792 623 702 764 690 802 610 500 590 824 762 601 655 792 721 Debt $11,672,388 $3,294,252 $192,816 $8,778,744 $3,206,736 $13,018,512 $4,485,312 $7,813,104 $7,149,948 $14,759,472 $8,254,740 $542,568 $873,600 $1,631,604 $32,253,936 $4,853,472 $3,705,468 Equity $3,742,284 $2,391,324 $1,574,352 $11,463,348 S710,580 $4,048,356 $6,107,868 $5,870,904 $11,444,628 $3,911,232 $19,771,284 $31,290,168 $4,524,000 $320,112 $14,777,724 $4,532,736 $14,046,552 Amount Profit $336,024 Profit $298,584 Profit $704,496 Profit $3,208,764 Loss $159,588 Loss $66,924 Profit $752,076 Profit $801,528 Profit $2,864,004 Loss $1,560,312 Profit $2,003,352 Profit $11,336,832 Loss $66,456 Profit $34,164 Loss $407,472 Profit $751,452 $5,451,264 NO No Yes No No No Yes No No No No Yes No No No Yes Yes No No Profit Ready lal + 100% 1 Type here to search J'. 1 11:21 PM 8/26/2020 0 c e CH F fra ENG AutoSave om A 2 Y CorporateDefaultDatabase - Excel Ga DO AL AL - Page Layout Formulas Data Review File Home Insert Draw View Help Team Analytic Solver Share Comments y X (6 Arial == ab Currency - 12 AA A Insert Delete 47 O Paste $ % 78-98 Ideas BIU Sensitivity Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font E Alignment Number Cells Editing Ideas Sensitivity E4 fx 11672388 D D E F H 1 J S A B 1 Corporate Default Database 2 3 Company Category 20 17 Manufacturing 21 18 Manufacturing 22 19 Manufacturing 23 20 Service 24 21 Manufacturing 25 22 Manufacturing 26 23 20 Service 27 24 Manufacturing 28 25 Manufacturing 26 29 26 Service 20 27 27 30 Manufacturing 31 28 Manufacturing 32 29 Service 33 30 Service 34 31 Manufacturing 35 32 Manufacturing 36 Data + Score 721 750 762 598 742 821 657 798 695 819 671 771 832 759 613 705 months? No No No Yes No Na NO Na NO No Debt $3,705,468 $12,623,676 $5,384,340 $2,764,788 $7,101,588 $3,923,088 $3,950,544 $3,341,988 $9,971,208 $10,583,508 $23,596,092 $9,741,576 $11,858,496 $895,128 $5,965,440 $6,745,908 Equity $14,046,552 $11,253,060 $18,725,616 $534,924 $4,167,228 $14,434,524 $5,349,084 $3,121,872 $5,556,252 $9,030,684 $6,685,692 $6,742,788 $13,613,652 $1,894,932 $828,672 $5,966,220 Profit Profit Profit Profit Profit Loss Loss Profit Profit Profit Loss Profit Profit Profit Loss Profit Amount $5,451,264 $1,446,432 $1,257,048 $76,752 $409,032 $1,872 $264,732 $2,698,176 $784,524 $6,391,476 $51,324 $1,077,024 $533,988 $163,332 $146,796 $878,280 Assessment No No No Yes No No NO Yes No No No Yes No No No Yes No NO No Na No No No No No No Ready lal + 10056 1 Type here to search J'. e 1 11:21 PM 8/26/2020 O CH 19 F fra ENG AutoSave om A 2 Y CorporateDefaultDatabase - Excel Ga DO AL AL - Page Layout Formulas Data Review File Home Insert Draw View Help Team Analytic Solver Share Comments y X (6 Arial == ab Currency - 12 AA A Insert Delete Format AY O Paste $ % 78-98 Ideas BIU Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font E Alignment Number Colle Editing Ideas Sensitivity E4 fx 11672388 D D E F H 1 J months ? Yes Assessment Yes Manufacturing A B 1 Corporate Default Database 2 3 Company Category 4 1 Service 5 2 Manufacturing 6 3 Manufacturing 7 4 8 5 Service 9 6 Manufacturing 10 10 7 Service 11 8 Manufacturing 12 12 9 g Service 40 10 13 10 Service 14 11 Manufacturing 15 12 Manufacturing 16 13 Service 17 14 Manufacturing 18 15 Manufacturing 19 16 Manufacturing 20 17 Manufacturing Data + No No No No Na NO Na NO No No No No Yes Yes No Score 604 714 732 792 623 702 764 690 802 610 500 590 824 762 601 655 792 721 Debt $11,672,388 $3,294,252 $192,816 $8,778,744 $3,206,736 $13,018,512 $4,485,312 $7,813,104 $7,149,948 $14,759,472 $8,254,740 $542,568 $873,600 $1,631,604 $32,253,936 $4,853,472 $3,705,468 Equity $3,742,284 $2,391,324 $1,574,352 $11,463,348 S710,580 $4,048,356 $6,107,868 $5,870,904 $11,444,628 $3,911,232 $19,771,284 $31,290,168 $4,524,000 $320,112 $14,777,724 $4,532,736 $14,046,552 Amount Profit $336,024 Profit $298,584 Profit $704,496 Profit $3,208,764 Loss $159,588 Loss $66,924 Profit $752,076 Profit $801,528 Profit $2,864,004 Loss $1,560,312 Profit $2,003,352 Profit $11,336,832 Loss $66,456 Profit $34,164 Loss $407,472 Profit $751,452 $5,451,264 NO No Yes No No No Yes No No No No Yes No No No Yes Yes No No Profit Ready lal + 100% 1 Type here to search J'. 1 11:21 PM 8/26/2020 0 c e CH F fra ENG AutoSave om A 2 Y CorporateDefaultDatabase - Excel Ga DO AL AL - Page Layout Formulas Data Review File Home Insert Draw View Help Team Analytic Solver Share Comments y X (6 Arial == ab Currency - 12 AA A Insert Delete 47 O Paste $ % 78-98 Ideas BIU Sensitivity Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font E Alignment Number Cells Editing Ideas Sensitivity E4 fx 11672388 D D E F H 1 J S A B 1 Corporate Default Database 2 3 Company Category 20 17 Manufacturing 21 18 Manufacturing 22 19 Manufacturing 23 20 Service 24 21 Manufacturing 25 22 Manufacturing 26 23 20 Service 27 24 Manufacturing 28 25 Manufacturing 26 29 26 Service 20 27 27 30 Manufacturing 31 28 Manufacturing 32 29 Service 33 30 Service 34 31 Manufacturing 35 32 Manufacturing 36 Data + Score 721 750 762 598 742 821 657 798 695 819 671 771 832 759 613 705 months? No No No Yes No Na NO Na NO No Debt $3,705,468 $12,623,676 $5,384,340 $2,764,788 $7,101,588 $3,923,088 $3,950,544 $3,341,988 $9,971,208 $10,583,508 $23,596,092 $9,741,576 $11,858,496 $895,128 $5,965,440 $6,745,908 Equity $14,046,552 $11,253,060 $18,725,616 $534,924 $4,167,228 $14,434,524 $5,349,084 $3,121,872 $5,556,252 $9,030,684 $6,685,692 $6,742,788 $13,613,652 $1,894,932 $828,672 $5,966,220 Profit Profit Profit Profit Profit Loss Loss Profit Profit Profit Loss Profit Profit Profit Loss Profit Amount $5,451,264 $1,446,432 $1,257,048 $76,752 $409,032 $1,872 $264,732 $2,698,176 $784,524 $6,391,476 $51,324 $1,077,024 $533,988 $163,332 $146,796 $878,280 Assessment No No No Yes No No NO Yes No No No Yes No No No Yes No NO No Na No No No No No No Ready lal + 10056 1 Type here to search J'. e 1 11:21 PM 8/26/2020 O CH 19 F fra ENG