given the following information construct a common size balance sheet
A177 X Dividend Payout Ratio B D 1 Note: years increasing from right to left 2 3 Assets 4 5 Current Assets 6 Cash 1420 17510 86060 7 Acc. Rec (net) 338690 201670 128500 8 Inv. 474630 342080 308980 9 Prepaid Exp 1740 3020 3020 10 Total CA 816480 564280 526560 11 12 Fixed Assets 13 Land 60880 14 Automobiles 47850 34350 34350 15 Building 122940 16 Equipment 3990 17 Subtotal 235660 34350 34350 18 Less: Accumulated amortization 34660 10300 19 Net Fixed Assets 201000 24050 34350 20 21 Other Assets 22 Goodwill 30.000 30000 30000 23 Deferred Charges 2750 3850 6570 24 25 Total Assets 1.050.230 622,180 597.480 26 File Home Insert Draw Page Layout Formulas Data Review X Arial Paste - 10 - A E Wrap Text - AS Merge & Cente Clipboard Font Alignment A177 Xfx Dividend Payout Ratio B D E 1,050,230 622,180 597,480 502500 35850 538350 290740 11850 302590 184640 15790 200430 A 24 25 Total Assets 26 27 28 Liabilitites 29 30 Current Lia 31 Acc Payable 32 Other CL 33 Total CL 34 35 Long Term Lia 36 Bank Loan 37 Transport Loan 38 Mortgage Payable 39 CCB mortgage payable 40 Total LTL 41 42 Equity 43 Common Stock 44 Retained Earnings 45 Total Equity 46 47 Total Lia and Equity 48 49 50 nentot 76500 5210 176510 172120 430340 101700 17730 176510 126900 30240 196510 295940 353650 100000 -18460 81540 100000 -76350 23650 100000 -56600 43400 1050230 622180 597480 h . Arial V 10 ' ' V Wrap Text EE E Merge & Center Paste a. Av Clipboard Font Alignment A177 Dividend Payout Ratio B E D 2004 2066820 1476840 589980 1599920 1171760 428160 930110 644190 285920 306170 11100 253910 22200 183620 19430 6710 29100 76430 A 50 itement 51 52 Net Sales 53 COGS 54 Gross Profit 55 56 Opt Exp 57 Wages and Commissions 58 Rent 59 Provision for doubtful accounts 60 General Selling Exp 61 General Admin Exp 62 Amortization 63 Total Opt Exp 64 65 Interest Exp 66 67 Net Inc before tax 68 Income Tax 69 Net Inc (loss) 70 71 Statement of Retained Earnings 72 73 Beginning retained earnings 74 Add: Net Inc 75 Less: Div 23860 132850 24360 498340 27560 104720 10300 418690 315290 33750 29220 27230 57890 -19750 -56600 57890 -19750 -56600 -76350 57890 -56600 -19750 -56600 co 20 EGGIO -18460 -76350 -56600 200 100% 71.45% 28.55% 100% 73.24% 26.76% 100% 69.26% 30.74% 76 Ending retained Earnings 77 78 79 80 81 Net Sales 82 COGS 83 Gross Profit 84 85 Opt Exp 86 Wages and Commissions 87 Rent 88 Provision for doubtful accounts 89 General Selling Exp 90 General Admin Exp 91 Amortization 92 Total Opt Exp 93 94 Interest Exp 95 96 Net Inc before tax 97 Income Tax 98 Net Inc (loss) 99 14.81% 0.54% 15.87% 1.39% 19.74% 2.09% 0.72% 3.13% 8.22% 1.15% 6.43% 1.18% 24.11% 1.72% 6.55% 0.64% 26.17% 33.90% 1.63% 1.83% 2.93% 2.80% -1.23% -6.08% 2.80% -1.23% -6.08%
