Calculate This Year Ratio's and Last Year Ratio's and indicate any change, if any that should...

 

  
 
 

Transcribed Image Text:

Calculate This Year Ratio's and Last Year Ratio's and indicate any change, if any that should be made to the spreadsheet. Using the spreadsheet provided, do not make any changes 2. Compare and Comment (this year vs last year) 3. Compare and Comment (this year vs industry) Answer some simple questions 4. Would you extend a line of credit to this company? 5. If you were the bank, how would you feel? 6. Would you invest in this company? 7. Does the Manager deserve a Bonus December 31, 2005, and December 31, 2004 (in thousands) ASSETS Current Assets Cash Glenn Eddieman and Company Balance Sheets Accounts receivable Merchandise inventory Prepaid expenses Total Current Assets It and Equipment idings Less: Accumulated depreciation Buildings, net Equipment Less: Accumulated depreciation Equipment, net Total Plant and Equipment TOTAL ASSETS LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities Accounts payable Notes payable Total Current Liabilities Long-Term Liabilities Total Liabilities Stockholders' Equity Common stock, / par value (3,, c 2005 (ained earnings fotal Stockholders' Equity' TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY $2,240 24 2,340 < 776 200 $ 5,556 75 40 $1,616 53 2,720 < $ 4,336 $ 7,723 $6,423 3,534 3,677 $4,046 157 $2,889 $ 2,687 $2,387 1,564 1,523 $1,123 25 $ 864 $5,169 $10,725 2,000 400 $6,336 (out STAND 2,40;cu (04) $3,000 t 2004 (63) 1,389 357 4,389 $10,725 $1,936 2,490 693 160 $5,279 $3,753 $9,032 2003 1852 2510 503 160 4225 6423 340 3023 2387 1503 384 +3907 9232 820 $1,080 2,920 3080 $4,000 390 Juve. 1,600 $5,600 370 $2,400 24000 1,032 832 $3,432 3232 $9,032 9132 1 Glenn Eddleman and Company Income Statements For the Years Ended December 31, 2005, and December 31, 2004 (in thousands) Sales Revenue Cost of goods sold Gross Profit on Sales Operating Expenses Advertising and sales commissions General and administrative Total Expenses Income before Interest and Taxes 7 Interest expense Income before Taxes Income taxes Net Income 2005 $14,745 10,213 $4,532 $ 1,022 2,721 $3,743 $ 789 172 $ 617 123 494 $ 2. 2004 $12,908 8,761 $ 4,147 546 2,451 $2,997 $ 1,150 137 $ 1,013 355 $ 658 Les 8-34. a. Glenn Eddleman and Company Statement of Cash Flows For the Year Ended December 31, 2005 (in thousands) Cash Flows from Operating Activities: Net Income Adjustments to reconcile net income to net Depreciation expense Decrease in accounts receivable Increase in merchandise inventory Increase in prepaid expense Increase in accounts payable Net Cash Provided By Operating Activities Cash Flows from Investing Activities: Purchase of building Purchase of equipment Net Cash Used By Investing Activities Cash Flows from Financing Activities: Proceeds from long-term loan Proceeds from sale of common stock Payment of Short-Term Loan... Payment of Cash Dividends Net Cash Provided by Financing Activities Net Increase in Cash during 2005 Beginning Cash Balance, January 1, 2005 Ending Cash Balance, December 31, 2005 $184 150 (83) (40) 536 $(1,300) (300) $ 400 600 PARKASTE (200)2 (137) $ 494 747 $1,241 104T (1,600) 563 863 $ 304 1,936 $2,240 ☺) What Do You Think About Eddlemon From Above? 2) What Else Do You wont before making A Decision About Invessing? Liquidity Solvency Profitabilty Efficiency Current Quick Working Capital Debt Times Interest Earned Net Profit % Gross Profit % Earning per Share Return on Assets Return on Equity Asset Turnover Receivable Turnover Days to collect Inventory Turnover Days of Sales This Year 1.2800 1.0600 1220000 59.0800 4.5900 3.4000 30.7000 0.1830 5.0000 12.6000 1.4900 6.1056 59.7800 13.9047 26.2500 Last Year 1.3200 1.1100 1229000 62.0000 8.3900 5.1000 32.1000 0.2740 7.2000 19.7000 1.4200 5.1632 70.6900 12.5516 29.0800 Calculate This Year Ratio's and Last Year Ratio's and indicate any change, if any that should be made to the spreadsheet. Using the spreadsheet provided, do not make any changes 2. Compare and Comment (this year vs last year) 3. Compare and Comment (this year vs industry) Answer some simple questions 4. Would you extend a line of credit to this company? 5. If you were the bank, how would you feel? 6. Would you invest in this company? 7. Does the Manager deserve a Bonus December 31, 2005, and December 31, 2004 (in thousands) ASSETS Current Assets Cash Glenn Eddieman and Company Balance Sheets Accounts receivable Merchandise inventory Prepaid expenses Total Current Assets It and Equipment idings Less: Accumulated depreciation Buildings, net Equipment Less: Accumulated depreciation Equipment, net Total Plant and Equipment TOTAL ASSETS LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities Accounts payable Notes payable Total Current Liabilities Long-Term Liabilities Total Liabilities Stockholders' Equity Common stock, / par value (3,, c 2005 (ained earnings fotal Stockholders' Equity' TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY $2,240 24 2,340 < 776 200 $ 5,556 75 40 $1,616 53 2,720 < $ 4,336 $ 7,723 $6,423 3,534 3,677 $4,046 157 $2,889 $ 2,687 $2,387 1,564 1,523 $1,123 25 $ 864 $5,169 $10,725 2,000 400 $6,336 (out STAND 2,40;cu (04) $3,000 t 2004 (63) 1,389 357 4,389 $10,725 $1,936 2,490 693 160 $5,279 $3,753 $9,032 2003 1852 2510 503 160 4225 6423 340 3023 2387 1503 384 +3907 9232 820 $1,080 2,920 3080 $4,000 390 Juve. 1,600 $5,600 370 $2,400 24000 1,032 832 $3,432 3232 $9,032 9132 1 Glenn Eddleman and Company Income Statements For the Years Ended December 31, 2005, and December 31, 2004 (in thousands) Sales Revenue Cost of goods sold Gross Profit on Sales Operating Expenses Advertising and sales commissions General and administrative Total Expenses Income before Interest and Taxes 7 Interest expense Income before Taxes Income taxes Net Income 2005 $14,745 10,213 $4,532 $ 1,022 2,721 $3,743 $ 789 172 $ 617 123 494 $ 2. 2004 $12,908 8,761 $ 4,147 546 2,451 $2,997 $ 1,150 137 $ 1,013 355 $ 658 Les 8-34. a. Glenn Eddleman and Company Statement of Cash Flows For the Year Ended December 31, 2005 (in thousands) Cash Flows from Operating Activities: Net Income Adjustments to reconcile net income to net Depreciation expense Decrease in accounts receivable Increase in merchandise inventory Increase in prepaid expense Increase in accounts payable Net Cash Provided By Operating Activities Cash Flows from Investing Activities: Purchase of building Purchase of equipment Net Cash Used By Investing Activities Cash Flows from Financing Activities: Proceeds from long-term loan Proceeds from sale of common stock Payment of Short-Term Loan... Payment of Cash Dividends Net Cash Provided by Financing Activities Net Increase in Cash during 2005 Beginning Cash Balance, January 1, 2005 Ending Cash Balance, December 31, 2005 $184 150 (83) (40) 536 $(1,300) (300) $ 400 600 PARKASTE (200)2 (137) $ 494 747 $1,241 104T (1,600) 563 863 $ 304 1,936 $2,240 ☺) What Do You Think About Eddlemon From Above? 2) What Else Do You wont before making A Decision About Invessing? Liquidity Solvency Profitabilty Efficiency Current Quick Working Capital Debt Times Interest Earned Net Profit % Gross Profit % Earning per Share Return on Assets Return on Equity Asset Turnover Receivable Turnover Days to collect Inventory Turnover Days of Sales This Year 1.2800 1.0600 1220000 59.0800 4.5900 3.4000 30.7000 0.1830 5.0000 12.6000 1.4900 6.1056 59.7800 13.9047 26.2500 Last Year 1.3200 1.1100 1229000 62.0000 8.3900 5.1000 32.1000 0.2740 7.2000 19.7000 1.4200 5.1632 70.6900 12.5516 29.0800 Calculate This Year Ratio's and Last Year Ratio's and indicate any change, if any that should be made to the spreadsheet. Using the spreadsheet provided, do not make any changes 2. Compare and Comment (this year vs last year) 3. Compare and Comment (this year vs industry) Answer some simple questions 4. Would you extend a line of credit to this company? 5. If you were the bank, how would you feel? 6. Would you invest in this company? 7. Does the Manager deserve a Bonus December 31, 2005, and December 31, 2004 (in thousands) ASSETS Current Assets Cash Glenn Eddieman and Company Balance Sheets Accounts receivable Merchandise inventory Prepaid expenses Total Current Assets It and Equipment idings Less: Accumulated depreciation Buildings, net Equipment Less: Accumulated depreciation Equipment, net Total Plant and Equipment TOTAL ASSETS LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities Accounts payable Notes payable Total Current Liabilities Long-Term Liabilities Total Liabilities Stockholders' Equity Common stock, / par value (3,, c 2005 (ained earnings fotal Stockholders' Equity' TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY $2,240 24 2,340 < 776 200 $ 5,556 75 40 $1,616 53 2,720 < $ 4,336 $ 7,723 $6,423 3,534 3,677 $4,046 157 $2,889 $ 2,687 $2,387 1,564 1,523 $1,123 25 $ 864 $5,169 $10,725 2,000 400 $6,336 (out STAND 2,40;cu (04) $3,000 t 2004 (63) 1,389 357 4,389 $10,725 $1,936 2,490 693 160 $5,279 $3,753 $9,032 2003 1852 2510 503 160 4225 6423 340 3023 2387 1503 384 +3907 9232 820 $1,080 2,920 3080 $4,000 390 Juve. 1,600 $5,600 370 $2,400 24000 1,032 832 $3,432 3232 $9,032 9132 1 Glenn Eddleman and Company Income Statements For the Years Ended December 31, 2005, and December 31, 2004 (in thousands) Sales Revenue Cost of goods sold Gross Profit on Sales Operating Expenses Advertising and sales commissions General and administrative Total Expenses Income before Interest and Taxes 7 Interest expense Income before Taxes Income taxes Net Income 2005 $14,745 10,213 $4,532 $ 1,022 2,721 $3,743 $ 789 172 $ 617 123 494 $ 2. 2004 $12,908 8,761 $ 4,147 546 2,451 $2,997 $ 1,150 137 $ 1,013 355 $ 658 Les 8-34. a. Glenn Eddleman and Company Statement of Cash Flows For the Year Ended December 31, 2005 (in thousands) Cash Flows from Operating Activities: Net Income Adjustments to reconcile net income to net Depreciation expense Decrease in accounts receivable Increase in merchandise inventory Increase in prepaid expense Increase in accounts payable Net Cash Provided By Operating Activities Cash Flows from Investing Activities: Purchase of building Purchase of equipment Net Cash Used By Investing Activities Cash Flows from Financing Activities: Proceeds from long-term loan Proceeds from sale of common stock Payment of Short-Term Loan... Payment of Cash Dividends Net Cash Provided by Financing Activities Net Increase in Cash during 2005 Beginning Cash Balance, January 1, 2005 Ending Cash Balance, December 31, 2005 $184 150 (83) (40) 536 $(1,300) (300) $ 400 600 PARKASTE (200)2 (137) $ 494 747 $1,241 104T (1,600) 563 863 $ 304 1,936 $2,240 ☺) What Do You Think About Eddlemon From Above? 2) What Else Do You wont before making A Decision About Invessing? Liquidity Solvency Profitabilty Efficiency Current Quick Working Capital Debt Times Interest Earned Net Profit % Gross Profit % Earning per Share Return on Assets Return on Equity Asset Turnover Receivable Turnover Days to collect Inventory Turnover Days of Sales This Year 1.2800 1.0600 1220000 59.0800 4.5900 3.4000 30.7000 0.1830 5.0000 12.6000 1.4900 6.1056 59.7800 13.9047 26.2500 Last Year 1.3200 1.1100 1229000 62.0000 8.3900 5.1000 32.1000 0.2740 7.2000 19.7000 1.4200 5.1632 70.6900 12.5516 29.0800 Calculate This Year Ratio's and Last Year Ratio's and indicate any change, if any that should be made to the spreadsheet. Using the spreadsheet provided, do not make any changes 2. Compare and Comment (this year vs last year) 3. Compare and Comment (this year vs industry) Answer some simple questions 4. Would you extend a line of credit to this company? 5. If you were the bank, how would you feel? 6. Would you invest in this company? 7. Does the Manager deserve a Bonus December 31, 2005, and December 31, 2004 (in thousands) ASSETS Current Assets Cash Glenn Eddieman and Company Balance Sheets Accounts receivable Merchandise inventory Prepaid expenses Total Current Assets It and Equipment idings Less: Accumulated depreciation Buildings, net Equipment Less: Accumulated depreciation Equipment, net Total Plant and Equipment TOTAL ASSETS LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities Accounts payable Notes payable Total Current Liabilities Long-Term Liabilities Total Liabilities Stockholders' Equity Common stock, / par value (3,, c 2005 (ained earnings fotal Stockholders' Equity' TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY $2,240 24 2,340 < 776 200 $ 5,556 75 40 $1,616 53 2,720 < $ 4,336 $ 7,723 $6,423 3,534 3,677 $4,046 157 $2,889 $ 2,687 $2,387 1,564 1,523 $1,123 25 $ 864 $5,169 $10,725 2,000 400 $6,336 (out STAND 2,40;cu (04) $3,000 t 2004 (63) 1,389 357 4,389 $10,725 $1,936 2,490 693 160 $5,279 $3,753 $9,032 2003 1852 2510 503 160 4225 6423 340 3023 2387 1503 384 +3907 9232 820 $1,080 2,920 3080 $4,000 390 Juve. 1,600 $5,600 370 $2,400 24000 1,032 832 $3,432 3232 $9,032 9132 1 Glenn Eddleman and Company Income Statements For the Years Ended December 31, 2005, and December 31, 2004 (in thousands) Sales Revenue Cost of goods sold Gross Profit on Sales Operating Expenses Advertising and sales commissions General and administrative Total Expenses Income before Interest and Taxes 7 Interest expense Income before Taxes Income taxes Net Income 2005 $14,745 10,213 $4,532 $ 1,022 2,721 $3,743 $ 789 172 $ 617 123 494 $ 2. 2004 $12,908 8,761 $ 4,147 546 2,451 $2,997 $ 1,150 137 $ 1,013 355 $ 658 Les 8-34. a. Glenn Eddleman and Company Statement of Cash Flows For the Year Ended December 31, 2005 (in thousands) Cash Flows from Operating Activities: Net Income Adjustments to reconcile net income to net Depreciation expense Decrease in accounts receivable Increase in merchandise inventory Increase in prepaid expense Increase in accounts payable Net Cash Provided By Operating Activities Cash Flows from Investing Activities: Purchase of building Purchase of equipment Net Cash Used By Investing Activities Cash Flows from Financing Activities: Proceeds from long-term loan Proceeds from sale of common stock Payment of Short-Term Loan... Payment of Cash Dividends Net Cash Provided by Financing Activities Net Increase in Cash during 2005 Beginning Cash Balance, January 1, 2005 Ending Cash Balance, December 31, 2005 $184 150 (83) (40) 536 $(1,300) (300) $ 400 600 PARKASTE (200)2 (137) $ 494 747 $1,241 104T (1,600) 563 863 $ 304 1,936 $2,240 ☺) What Do You Think About Eddlemon From Above? 2) What Else Do You wont before making A Decision About Invessing? Liquidity Solvency Profitabilty Efficiency Current Quick Working Capital Debt Times Interest Earned Net Profit % Gross Profit % Earning per Share Return on Assets Return on Equity Asset Turnover Receivable Turnover Days to collect Inventory Turnover Days of Sales This Year 1.2800 1.0600 1220000 59.0800 4.5900 3.4000 30.7000 0.1830 5.0000 12.6000 1.4900 6.1056 59.7800 13.9047 26.2500 Last Year 1.3200 1.1100 1229000 62.0000 8.3900 5.1000 32.1000 0.2740 7.2000 19.7000 1.4200 5.1632 70.6900 12.5516 29.0800 Calculate This Year Ratio's and Last Year Ratio's and indicate any change, if any that should be made to the spreadsheet. Using the spreadsheet provided, do not make any changes 2. Compare and Comment (this year vs last year) 3. Compare and Comment (this year vs industry) Answer some simple questions 4. Would you extend a line of credit to this company? 5. If you were the bank, how would you feel? 6. Would you invest in this company? 7. Does the Manager deserve a Bonus December 31, 2005, and December 31, 2004 (in thousands) ASSETS Current Assets Cash Glenn Eddieman and Company Balance Sheets Accounts receivable Merchandise inventory Prepaid expenses Total Current Assets It and Equipment idings Less: Accumulated depreciation Buildings, net Equipment Less: Accumulated depreciation Equipment, net Total Plant and Equipment TOTAL ASSETS LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities Accounts payable Notes payable Total Current Liabilities Long-Term Liabilities Total Liabilities Stockholders' Equity Common stock, / par value (3,, c 2005 (ained earnings fotal Stockholders' Equity' TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY $2,240 24 2,340 < 776 200 $ 5,556 75 40 $1,616 53 2,720 < $ 4,336 $ 7,723 $6,423 3,534 3,677 $4,046 157 $2,889 $ 2,687 $2,387 1,564 1,523 $1,123 25 $ 864 $5,169 $10,725 2,000 400 $6,336 (out STAND 2,40;cu (04) $3,000 t 2004 (63) 1,389 357 4,389 $10,725 $1,936 2,490 693 160 $5,279 $3,753 $9,032 2003 1852 2510 503 160 4225 6423 340 3023 2387 1503 384 +3907 9232 820 $1,080 2,920 3080 $4,000 390 Juve. 1,600 $5,600 370 $2,400 24000 1,032 832 $3,432 3232 $9,032 9132 1 Glenn Eddleman and Company Income Statements For the Years Ended December 31, 2005, and December 31, 2004 (in thousands) Sales Revenue Cost of goods sold Gross Profit on Sales Operating Expenses Advertising and sales commissions General and administrative Total Expenses Income before Interest and Taxes 7 Interest expense Income before Taxes Income taxes Net Income 2005 $14,745 10,213 $4,532 $ 1,022 2,721 $3,743 $ 789 172 $ 617 123 494 $ 2. 2004 $12,908 8,761 $ 4,147 546 2,451 $2,997 $ 1,150 137 $ 1,013 355 $ 658 Les 8-34. a. Glenn Eddleman and Company Statement of Cash Flows For the Year Ended December 31, 2005 (in thousands) Cash Flows from Operating Activities: Net Income Adjustments to reconcile net income to net Depreciation expense Decrease in accounts receivable Increase in merchandise inventory Increase in prepaid expense Increase in accounts payable Net Cash Provided By Operating Activities Cash Flows from Investing Activities: Purchase of building Purchase of equipment Net Cash Used By Investing Activities Cash Flows from Financing Activities: Proceeds from long-term loan Proceeds from sale of common stock Payment of Short-Term Loan... Payment of Cash Dividends Net Cash Provided by Financing Activities Net Increase in Cash during 2005 Beginning Cash Balance, January 1, 2005 Ending Cash Balance, December 31, 2005 $184 150 (83) (40) 536 $(1,300) (300) $ 400 600 PARKASTE (200)2 (137) $ 494 747 $1,241 104T (1,600) 563 863 $ 304 1,936 $2,240 ☺) What Do You Think About Eddlemon From Above? 2) What Else Do You wont before making A Decision About Invessing? Liquidity Solvency Profitabilty Efficiency Current Quick Working Capital Debt Times Interest Earned Net Profit % Gross Profit % Earning per Share Return on Assets Return on Equity Asset Turnover Receivable Turnover Days to collect Inventory Turnover Days of Sales This Year 1.2800 1.0600 1220000 59.0800 4.5900 3.4000 30.7000 0.1830 5.0000 12.6000 1.4900 6.1056 59.7800 13.9047 26.2500 Last Year 1.3200 1.1100 1229000 62.0000 8.3900 5.1000 32.1000 0.2740 7.2000 19.7000 1.4200 5.1632 70.6900 12.5516 29.0800 Calculate This Year Ratio's and Last Year Ratio's and indicate any change, if any that should be made to the spreadsheet. Using the spreadsheet provided, do not make any changes 2. Compare and Comment (this year vs last year) 3. Compare and Comment (this year vs industry) Answer some simple questions 4. Would you extend a line of credit to this company? 5. If you were the bank, how would you feel? 6. Would you invest in this company? 7. Does the Manager deserve a Bonus December 31, 2005, and December 31, 2004 (in thousands) ASSETS Current Assets Cash Glenn Eddieman and Company Balance Sheets Accounts receivable Merchandise inventory Prepaid expenses Total Current Assets It and Equipment idings Less: Accumulated depreciation Buildings, net Equipment Less: Accumulated depreciation Equipment, net Total Plant and Equipment TOTAL ASSETS LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities Accounts payable Notes payable Total Current Liabilities Long-Term Liabilities Total Liabilities Stockholders' Equity Common stock, / par value (3,, c 2005 (ained earnings fotal Stockholders' Equity' TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY $2,240 24 2,340 < 776 200 $ 5,556 75 40 $1,616 53 2,720 < $ 4,336 $ 7,723 $6,423 3,534 3,677 $4,046 157 $2,889 $ 2,687 $2,387 1,564 1,523 $1,123 25 $ 864 $5,169 $10,725 2,000 400 $6,336 (out STAND 2,40;cu (04) $3,000 t 2004 (63) 1,389 357 4,389 $10,725 $1,936 2,490 693 160 $5,279 $3,753 $9,032 2003 1852 2510 503 160 4225 6423 340 3023 2387 1503 384 +3907 9232 820 $1,080 2,920 3080 $4,000 390 Juve. 1,600 $5,600 370 $2,400 24000 1,032 832 $3,432 3232 $9,032 9132 1 Glenn Eddleman and Company Income Statements For the Years Ended December 31, 2005, and December 31, 2004 (in thousands) Sales Revenue Cost of goods sold Gross Profit on Sales Operating Expenses Advertising and sales commissions General and administrative Total Expenses Income before Interest and Taxes 7 Interest expense Income before Taxes Income taxes Net Income 2005 $14,745 10,213 $4,532 $ 1,022 2,721 $3,743 $ 789 172 $ 617 123 494 $ 2. 2004 $12,908 8,761 $ 4,147 546 2,451 $2,997 $ 1,150 137 $ 1,013 355 $ 658 Les 8-34. a. Glenn Eddleman and Company Statement of Cash Flows For the Year Ended December 31, 2005 (in thousands) Cash Flows from Operating Activities: Net Income Adjustments to reconcile net income to net Depreciation expense Decrease in accounts receivable Increase in merchandise inventory Increase in prepaid expense Increase in accounts payable Net Cash Provided By Operating Activities Cash Flows from Investing Activities: Purchase of building Purchase of equipment Net Cash Used By Investing Activities Cash Flows from Financing Activities: Proceeds from long-term loan Proceeds from sale of common stock Payment of Short-Term Loan... Payment of Cash Dividends Net Cash Provided by Financing Activities Net Increase in Cash during 2005 Beginning Cash Balance, January 1, 2005 Ending Cash Balance, December 31, 2005 $184 150 (83) (40) 536 $(1,300) (300) $ 400 600 PARKASTE (200)2 (137) $ 494 747 $1,241 104T (1,600) 563 863 $ 304 1,936 $2,240 ☺) What Do You Think About Eddlemon From Above? 2) What Else Do You wont before making A Decision About Invessing? Liquidity Solvency Profitabilty Efficiency Current Quick Working Capital Debt Times Interest Earned Net Profit % Gross Profit % Earning per Share Return on Assets Return on Equity Asset Turnover Receivable Turnover Days to collect Inventory Turnover Days of Sales This Year 1.2800 1.0600 1220000 59.0800 4.5900 3.4000 30.7000 0.1830 5.0000 12.6000 1.4900 6.1056 59.7800 13.9047 26.2500 Last Year 1.3200 1.1100 1229000 62.0000 8.3900 5.1000 32.1000 0.2740 7.2000 19.7000 1.4200 5.1632 70.6900 12.5516 29.0800 Calculate This Year Ratio's and Last Year Ratio's and indicate any change, if any that should be made to the spreadsheet. Using the spreadsheet provided, do not make any changes 2. Compare and Comment (this year vs last year) 3. Compare and Comment (this year vs industry) Answer some simple questions 4. Would you extend a line of credit to this company? 5. If you were the bank, how would you feel? 6. Would you invest in this company? 7. Does the Manager deserve a Bonus December 31, 2005, and December 31, 2004 (in thousands) ASSETS Current Assets Cash Glenn Eddieman and Company Balance Sheets Accounts receivable Merchandise inventory Prepaid expenses Total Current Assets It and Equipment idings Less: Accumulated depreciation Buildings, net Equipment Less: Accumulated depreciation Equipment, net Total Plant and Equipment TOTAL ASSETS LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities Accounts payable Notes payable Total Current Liabilities Long-Term Liabilities Total Liabilities Stockholders' Equity Common stock, / par value (3,, c 2005 (ained earnings fotal Stockholders' Equity' TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY $2,240 24 2,340 < 776 200 $ 5,556 75 40 $1,616 53 2,720 < $ 4,336 $ 7,723 $6,423 3,534 3,677 $4,046 157 $2,889 $ 2,687 $2,387 1,564 1,523 $1,123 25 $ 864 $5,169 $10,725 2,000 400 $6,336 (out STAND 2,40;cu (04) $3,000 t 2004 (63) 1,389 357 4,389 $10,725 $1,936 2,490 693 160 $5,279 $3,753 $9,032 2003 1852 2510 503 160 4225 6423 340 3023 2387 1503 384 +3907 9232 820 $1,080 2,920 3080 $4,000 390 Juve. 1,600 $5,600 370 $2,400 24000 1,032 832 $3,432 3232 $9,032 9132 1 Glenn Eddleman and Company Income Statements For the Years Ended December 31, 2005, and December 31, 2004 (in thousands) Sales Revenue Cost of goods sold Gross Profit on Sales Operating Expenses Advertising and sales commissions General and administrative Total Expenses Income before Interest and Taxes 7 Interest expense Income before Taxes Income taxes Net Income 2005 $14,745 10,213 $4,532 $ 1,022 2,721 $3,743 $ 789 172 $ 617 123 494 $ 2. 2004 $12,908 8,761 $ 4,147 546 2,451 $2,997 $ 1,150 137 $ 1,013 355 $ 658 Les 8-34. a. Glenn Eddleman and Company Statement of Cash Flows For the Year Ended December 31, 2005 (in thousands) Cash Flows from Operating Activities: Net Income Adjustments to reconcile net income to net Depreciation expense Decrease in accounts receivable Increase in merchandise inventory Increase in prepaid expense Increase in accounts payable Net Cash Provided By Operating Activities Cash Flows from Investing Activities: Purchase of building Purchase of equipment Net Cash Used By Investing Activities Cash Flows from Financing Activities: Proceeds from long-term loan Proceeds from sale of common stock Payment of Short-Term Loan... Payment of Cash Dividends Net Cash Provided by Financing Activities Net Increase in Cash during 2005 Beginning Cash Balance, January 1, 2005 Ending Cash Balance, December 31, 2005 $184 150 (83) (40) 536 $(1,300) (300) $ 400 600 PARKASTE (200)2 (137) $ 494 747 $1,241 104T (1,600) 563 863 $ 304 1,936 $2,240 ☺) What Do You Think About Eddlemon From Above? 2) What Else Do You wont before making A Decision About Invessing? Liquidity Solvency Profitabilty Efficiency Current Quick Working Capital Debt Times Interest Earned Net Profit % Gross Profit % Earning per Share Return on Assets Return on Equity Asset Turnover Receivable Turnover Days to collect Inventory Turnover Days of Sales This Year 1.2800 1.0600 1220000 59.0800 4.5900 3.4000 30.7000 0.1830 5.0000 12.6000 1.4900 6.1056 59.7800 13.9047 26.2500 Last Year 1.3200 1.1100 1229000 62.0000 8.3900 5.1000 32.1000 0.2740 7.2000 19.7000 1.4200 5.1632 70.6900 12.5516 29.0800 Calculate This Year Ratio's and Last Year Ratio's and indicate any change, if any that should be made to the spreadsheet. Using the spreadsheet provided, do not make any changes 2. Compare and Comment (this year vs last year) 3. Compare and Comment (this year vs industry) Answer some simple questions 4. Would you extend a line of credit to this company? 5. If you were the bank, how would you feel? 6. Would you invest in this company? 7. Does the Manager deserve a Bonus December 31, 2005, and December 31, 2004 (in thousands) ASSETS Current Assets Cash Glenn Eddieman and Company Balance Sheets Accounts receivable Merchandise inventory Prepaid expenses Total Current Assets It and Equipment idings Less: Accumulated depreciation Buildings, net Equipment Less: Accumulated depreciation Equipment, net Total Plant and Equipment TOTAL ASSETS LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities Accounts payable Notes payable Total Current Liabilities Long-Term Liabilities Total Liabilities Stockholders' Equity Common stock, / par value (3,, c 2005 (ained earnings fotal Stockholders' Equity' TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY $2,240 24 2,340 < 776 200 $ 5,556 75 40 $1,616 53 2,720 < $ 4,336 $ 7,723 $6,423 3,534 3,677 $4,046 157 $2,889 $ 2,687 $2,387 1,564 1,523 $1,123 25 $ 864 $5,169 $10,725 2,000 400 $6,336 (out STAND 2,40;cu (04) $3,000 t 2004 (63) 1,389 357 4,389 $10,725 $1,936 2,490 693 160 $5,279 $3,753 $9,032 2003 1852 2510 503 160 4225 6423 340 3023 2387 1503 384 +3907 9232 820 $1,080 2,920 3080 $4,000 390 Juve. 1,600 $5,600 370 $2,400 24000 1,032 832 $3,432 3232 $9,032 9132 1 Glenn Eddleman and Company Income Statements For the Years Ended December 31, 2005, and December 31, 2004 (in thousands) Sales Revenue Cost of goods sold Gross Profit on Sales Operating Expenses Advertising and sales commissions General and administrative Total Expenses Income before Interest and Taxes 7 Interest expense Income before Taxes Income taxes Net Income 2005 $14,745 10,213 $4,532 $ 1,022 2,721 $3,743 $ 789 172 $ 617 123 494 $ 2. 2004 $12,908 8,761 $ 4,147 546 2,451 $2,997 $ 1,150 137 $ 1,013 355 $ 658 Les 8-34. a. Glenn Eddleman and Company Statement of Cash Flows For the Year Ended December 31, 2005 (in thousands) Cash Flows from Operating Activities: Net Income Adjustments to reconcile net income to net Depreciation expense Decrease in accounts receivable Increase in merchandise inventory Increase in prepaid expense Increase in accounts payable Net Cash Provided By Operating Activities Cash Flows from Investing Activities: Purchase of building Purchase of equipment Net Cash Used By Investing Activities Cash Flows from Financing Activities: Proceeds from long-term loan Proceeds from sale of common stock Payment of Short-Term Loan... Payment of Cash Dividends Net Cash Provided by Financing Activities Net Increase in Cash during 2005 Beginning Cash Balance, January 1, 2005 Ending Cash Balance, December 31, 2005 $184 150 (83) (40) 536 $(1,300) (300) $ 400 600 PARKASTE (200)2 (137) $ 494 747 $1,241 104T (1,600) 563 863 $ 304 1,936 $2,240 ☺) What Do You Think About Eddlemon From Above? 2) What Else Do You wont before making A Decision About Invessing? Liquidity Solvency Profitabilty Efficiency Current Quick Working Capital Debt Times Interest Earned Net Profit % Gross Profit % Earning per Share Return on Assets Return on Equity Asset Turnover Receivable Turnover Days to collect Inventory Turnover Days of Sales This Year 1.2800 1.0600 1220000 59.0800 4.5900 3.4000 30.7000 0.1830 5.0000 12.6000 1.4900 6.1056 59.7800 13.9047 26.2500 Last Year 1.3200 1.1100 1229000 62.0000 8.3900 5.1000 32.1000 0.2740 7.2000 19.7000 1.4200 5.1632 70.6900 12.5516 29.0800 Calculate This Year Ratio's and Last Year Ratio's and indicate any change, if any that should be made to the spreadsheet. Using the spreadsheet provided, do not make any changes 2. Compare and Comment (this year vs last year) 3. Compare and Comment (this year vs industry) Answer some simple questions 4. Would you extend a line of credit to this company? 5. If you were the bank, how would you feel? 6. Would you invest in this company? 7. Does the Manager deserve a Bonus December 31, 2005, and December 31, 2004 (in thousands) ASSETS Current Assets Cash Glenn Eddieman and Company Balance Sheets Accounts receivable Merchandise inventory Prepaid expenses Total Current Assets It and Equipment idings Less: Accumulated depreciation Buildings, net Equipment Less: Accumulated depreciation Equipment, net Total Plant and Equipment TOTAL ASSETS LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities Accounts payable Notes payable Total Current Liabilities Long-Term Liabilities Total Liabilities Stockholders' Equity Common stock, / par value (3,, c 2005 (ained earnings fotal Stockholders' Equity' TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY $2,240 24 2,340 < 776 200 $ 5,556 75 40 $1,616 53 2,720 < $ 4,336 $ 7,723 $6,423 3,534 3,677 $4,046 157 $2,889 $ 2,687 $2,387 1,564 1,523 $1,123 25 $ 864 $5,169 $10,725 2,000 400 $6,336 (out STAND 2,40;cu (04) $3,000 t 2004 (63) 1,389 357 4,389 $10,725 $1,936 2,490 693 160 $5,279 $3,753 $9,032 2003 1852 2510 503 160 4225 6423 340 3023 2387 1503 384 +3907 9232 820 $1,080 2,920 3080 $4,000 390 Juve. 1,600 $5,600 370 $2,400 24000 1,032 832 $3,432 3232 $9,032 9132 1 Glenn Eddleman and Company Income Statements For the Years Ended December 31, 2005, and December 31, 2004 (in thousands) Sales Revenue Cost of goods sold Gross Profit on Sales Operating Expenses Advertising and sales commissions General and administrative Total Expenses Income before Interest and Taxes 7 Interest expense Income before Taxes Income taxes Net Income 2005 $14,745 10,213 $4,532 $ 1,022 2,721 $3,743 $ 789 172 $ 617 123 494 $ 2. 2004 $12,908 8,761 $ 4,147 546 2,451 $2,997 $ 1,150 137 $ 1,013 355 $ 658 Les 8-34. a. Glenn Eddleman and Company Statement of Cash Flows For the Year Ended December 31, 2005 (in thousands) Cash Flows from Operating Activities: Net Income Adjustments to reconcile net income to net Depreciation expense Decrease in accounts receivable Increase in merchandise inventory Increase in prepaid expense Increase in accounts payable Net Cash Provided By Operating Activities Cash Flows from Investing Activities: Purchase of building Purchase of equipment Net Cash Used By Investing Activities Cash Flows from Financing Activities: Proceeds from long-term loan Proceeds from sale of common stock Payment of Short-Term Loan... Payment of Cash Dividends Net Cash Provided by Financing Activities Net Increase in Cash during 2005 Beginning Cash Balance, January 1, 2005 Ending Cash Balance, December 31, 2005 $184 150 (83) (40) 536 $(1,300) (300) $ 400 600 PARKASTE (200)2 (137) $ 494 747 $1,241 104T (1,600) 563 863 $ 304 1,936 $2,240 ☺) What Do You Think About Eddlemon From Above? 2) What Else Do You wont before making A Decision About Invessing? Liquidity Solvency Profitabilty Efficiency Current Quick Working Capital Debt Times Interest Earned Net Profit % Gross Profit % Earning per Share Return on Assets Return on Equity Asset Turnover Receivable Turnover Days to collect Inventory Turnover Days of Sales This Year 1.2800 1.0600 1220000 59.0800 4.5900 3.4000 30.7000 0.1830 5.0000 12.6000 1.4900 6.1056 59.7800 13.9047 26.2500 Last Year 1.3200 1.1100 1229000 62.0000 8.3900 5.1000 32.1000 0.2740 7.2000 19.7000 1.4200 5.1632 70.6900 12.5516 29.0800 Calculate This Year Ratio's and Last Year Ratio's and indicate any change, if any that should be made to the spreadsheet. Using the spreadsheet provided, do not make any changes 2. Compare and Comment (this year vs last year) 3. Compare and Comment (this year vs industry) Answer some simple questions 4. Would you extend a line of credit to this company? 5. If you were the bank, how would you feel? 6. Would you invest in this company? 7. Does the Manager deserve a Bonus December 31, 2005, and December 31, 2004 (in thousands) ASSETS Current Assets Cash Glenn Eddieman and Company Balance Sheets Accounts receivable Merchandise inventory Prepaid expenses Total Current Assets It and Equipment idings Less: Accumulated depreciation Buildings, net Equipment Less: Accumulated depreciation Equipment, net Total Plant and Equipment TOTAL ASSETS LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities Accounts payable Notes payable Total Current Liabilities Long-Term Liabilities Total Liabilities Stockholders' Equity Common stock, / par value (3,, c 2005 (ained earnings fotal Stockholders' Equity' TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY $2,240 24 2,340 < 776 200 $ 5,556 75 40 $1,616 53 2,720 < $ 4,336 $ 7,723 $6,423 3,534 3,677 $4,046 157 $2,889 $ 2,687 $2,387 1,564 1,523 $1,123 25 $ 864 $5,169 $10,725 2,000 400 $6,336 (out STAND 2,40;cu (04) $3,000 t 2004 (63) 1,389 357 4,389 $10,725 $1,936 2,490 693 160 $5,279 $3,753 $9,032 2003 1852 2510 503 160 4225 6423 340 3023 2387 1503 384 +3907 9232 820 $1,080 2,920 3080 $4,000 390 Juve. 1,600 $5,600 370 $2,400 24000 1,032 832 $3,432 3232 $9,032 9132 1 Glenn Eddleman and Company Income Statements For the Years Ended December 31, 2005, and December 31, 2004 (in thousands) Sales Revenue Cost of goods sold Gross Profit on Sales Operating Expenses Advertising and sales commissions General and administrative Total Expenses Income before Interest and Taxes 7 Interest expense Income before Taxes Income taxes Net Income 2005 $14,745 10,213 $4,532 $ 1,022 2,721 $3,743 $ 789 172 $ 617 123 494 $ 2. 2004 $12,908 8,761 $ 4,147 546 2,451 $2,997 $ 1,150 137 $ 1,013 355 $ 658 Les 8-34. a. Glenn Eddleman and Company Statement of Cash Flows For the Year Ended December 31, 2005 (in thousands) Cash Flows from Operating Activities: Net Income Adjustments to reconcile net income to net Depreciation expense Decrease in accounts receivable Increase in merchandise inventory Increase in prepaid expense Increase in accounts payable Net Cash Provided By Operating Activities Cash Flows from Investing Activities: Purchase of building Purchase of equipment Net Cash Used By Investing Activities Cash Flows from Financing Activities: Proceeds from long-term loan Proceeds from sale of common stock Payment of Short-Term Loan... Payment of Cash Dividends Net Cash Provided by Financing Activities Net Increase in Cash during 2005 Beginning Cash Balance, January 1, 2005 Ending Cash Balance, December 31, 2005 $184 150 (83) (40) 536 $(1,300) (300) $ 400 600 PARKASTE (200)2 (137) $ 494 747 $1,241 104T (1,600) 563 863 $ 304 1,936 $2,240 ☺) What Do You Think About Eddlemon From Above? 2) What Else Do You wont before making A Decision About Invessing? Liquidity Solvency Profitabilty Efficiency Current Quick Working Capital Debt Times Interest Earned Net Profit % Gross Profit % Earning per Share Return on Assets Return on Equity Asset Turnover Receivable Turnover Days to collect Inventory Turnover Days of Sales This Year 1.2800 1.0600 1220000 59.0800 4.5900 3.4000 30.7000 0.1830 5.0000 12.6000 1.4900 6.1056 59.7800 13.9047 26.2500 Last Year 1.3200 1.1100 1229000 62.0000 8.3900 5.1000 32.1000 0.2740 7.2000 19.7000 1.4200 5.1632 70.6900 12.5516 29.0800

Answer rating: 100% (QA)

1 Based on the ratios calculated it appears that the company is doing slightly worse this year compared to last year The current ratio and quick ratio ... View the full answer