50.1K

Verified Solution

Link Copied!

given the following information compute statement of cashflows attached in excel file

A177 *** X Dividend Payout Ratio A 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 2 4 25 Total Assets 26 1,050.230 622.180 597.480 File Home Insert Draw Page Layout Formulas Data Review X Arial - 10 - Au == 2 Wrap Text Paste v Merge & Cente Clipboard Font Alignment A177 X fx Dividend Payout Ratio B C 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 so neem tot 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 anns and Arial V 10 ' ' Wrap Text E E Merge & Center Paste v 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 29 100 76430 A 50 tement 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 2 SGGA -18460 -76350 -56600 76 Ending retained Eamings 77 78 79 80 100% 71.45% 28.55% 100% 73.24% 26.76% 100% 69.26% 30.74% 14.81% 0.54% 15.87% 1.39% 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 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% se X Arial 10 ' ' == @ Merge Wrap Paste BIU - - - - Clipboard 12 Font Alignment J140 C 0.14% 32.25% 45.19% 0.17% 77.74% 2.81% 32.41% 54.98% 0.49% 90.69% 14.40% 21.51% 51.71% 0.51% 88.13% A 100 101 Assets 102 103 Current Assets 104 Cash 105 Acc. Rec (net) 106 Inv. 107 Prepaid Exp 108 Total CL 109 110 Fixed Assets 111 Land 112 Autom les 113 Building 114 Equipment 115 Subtotal 116 Less: Accumulated amortization 117 Net Fixed Assets 118 119 Other Assets 120 Goodwill 121 Deferred Charges 122 123 Total Assets 124 125 Liabilitites 126 Current li 5.52% 5.75% 5.80% 4.56% 11.71% 0.38% 22.24% 3.30% 19.14% 5.52% 1.66% 3.87% 5.75% 0.00% 5.75% 2.86% 0.26% 4.82% 0.62% 5.02% 1.10% 100.00% 100.00% 100.00% X Arial v 10 ' ' > as Wrap Text Paste B 1 0 - 1 - 2 - A = = = += = Merge &c Clipboard Font Alignment J140 B C D E 47.85% 3.41% 51.26% 46.73% 1.90% 48.63% 30.90% 2.64% 33.55% A 126 Current Lia 127 Acc Payable 128 Other CL 129 Total CL 130 131 Long Term Lia 132 Bank Loan 133 Transport Loan 134 Mortgage Payable 135 CCB mortgage payable 136 Total LTL 137 138 Equity 139 Common Stock 140 Retained Earnings 141 Total Equity 142 7.28% 0.50% 16.81% 16.39% 40.98% 16.35% 2.85% 28.37% 21.24% 5.06% 32.89% 47.57% 59.19% 9.52% -1.76% 7.76% 16.07% - 12.27% 3.80% 16.74% -9.47% 7.26% board Font Alignment 4 fo . A B C E D 2004 Ratios 2006 2005 LO 1.517 0.630 124 1.865 0.724 91 2.627 1.070 105 -7 A. Liquidity Ratio 78 49 Current Ratio 50 Quick Ratio 151 Acc Payable Days 152 153 154 B. Profitability Ratio 155 156 Return on Equity 157 Gross Profit Mg 158 Operating Margin 159 Net Profit Margin 160 161 162 C. Efficiency 163 164 TAT 165 FAT 166 Avg. Collection Period 167 Inventory Days 168 57.89% 28.55% 4.43% 2.80% -19.75% -56.60% 26.76% 30.74% 0.59% -3.16% -1.23% 6.08% 1.97 18.37 48 2.57 54.79 38 101 1.56 27.2 50 175 101 12 25 13 .68 169 170 D. Leverage 171 172 Debt to Equity 173 174 175 Sales Growth 176 177 Dividend Payout Ratio 178 29.18% 72.01% 0 0 0 Jx B 2006 D 2005 2004 - 2005 A 180 Cash Flow Statement 181 182 183 Cash Flow of Operations 184 185 186 187 188 189 190 191 192 193 Toatl CFO 194 195 Cash Flow of Investing 196 197 198 199 200 201 Total CFI= 202 203 Cash Flow from Financing 204 205 Clipboard Font LA E174 . B. C A 200 201 Total CFI= 202 203 Cash Flow from Financing 204 205 206 207 208 209 210 211 212 Total CFO= 213 214 CFO+CFI+CFF= 215 216 Change in Cash- 217 218 219 220 221 222 223 224

Answer & Explanation Solved by verified expert

See Answer