Just deduct my account questions with the 9 questions required by this problem.

Case Study #1: Bigger Isn't Always Better! Andre Pires opened his automobile parts store, Quickfix Auto Parts, five years ago, in a mid-sized city located in the mid-western region of the United States. Having worked for an automobile dealership, first as a technician, and later as the parts department manager, for over 15 years, Andre had learned the many nuances of the fiercely competitive automobile servicing business. He had developed many contacts with dealers and service technicians, which came in really handy when establishing his own retail store. Business had picked up significantly well over the years, and as a result, Andre had more than doubled his store size by the third year of operations. The industry and local forecasts for the next few years were very good and Andre was confident that his sales would keep growing at or above recent levels. However, Andre had used up most of his available funds in expanding the business and was well aware that future growth would have to be funded with external sources of funds. What was worrying Andre was the fact that over the past two years, the store's net income figures had been negative, and his cash flow situation had gotten pretty weak (See Tables 1 and 2). He figured that he had better take a good look at his firm's financial situation and improve it, if possible, before his suppliers found out. He knew fully well that being shut out by suppliers would be disastrous! Andre's knowledge of finance and accounting, not unlike many businessmen's, was very limited. He had often entertained the thought of taking some financial management courses, but could never find the time. One day, at his weekly bridge session, he happened to mention his problem to Tom Andrews, his long-time friend and bridge partner. Tom had often given him good advice in the past and Andre was desperate for a solution. "I'm no finance expert, Andre", said Tom, "but you might want to contact the finance department at our local university's business school and see if you can hire and MBA student as an intern. These students can often be very insightful, you know." That's exactly what Andre did. Within a week he was able to recruit Juan Plexo, a second semester MBA student, who had an undergraduate degree in Accountancy and was interested in concentrating in Finance. When Juan started his internship, Andre explained exactly what his concerns were. I'm going to have to raise funds for future growth, and given my recent profit situation, the prospects look pretty bleak. I can't seem to put my finger on the exact cause. The bank's commercial loan is going to want some pretty convincing arguments as to why they should grant me the loan. I need to put some concrete remedial measures in place, and was hoping that you can help sort things out, Juan," said Andre. "I think I may have bitten off more than I can currently chew." Table 1 Quickfix Autoparts Balance Sheets ASSETS 2000 2001 2002 2003 2004 Cash and Marketable Securities Accounts Receivable Inventory $155,000 $309,099 10,000 12,000 250,000 270,000 $75,948 20,000 500,000 $28,826 77,653 520,000 $18,425 90,078 560,000 Current Assets $415,000 $591,099 $595,948 $626,479 $668,503 Land, Buildings, Plant, and Equipment Accumulated Depreciation Net Fixed Assets $250,000 $250,000 $500,000 $500,000 $500,000 (25,000) (50,000) (100,000) (150,000) (200,000) $225,000 $200,000 $400,000 $350,000 $300,000 $640,000 $791,099 $995,948 $976,479 $968,503 Total Assets LIABILITIES AND EQUITIES Short-term Bank Loans Accounts Payable Accruals $50,000 $145,000 10,000 10,506 5,000 5,100 $140,000 19,998 7,331 $148,000 15,995 9,301 $148,000 16,795 11,626 Current Liabilities $65,000 $160,606 $167,329 $173,296 $176,421 Long-term Bank Loans Mortgage Long-term debt $63,366 $98,000 $196,000 $190,000 $183,000 175,000 173,000 271,000 268,000 264,000 $238,366 $271,000 $467,000 $458,000 $447,000 Total Liabilities $303,366 $431,606 $634,329 $631,296 $623,421 Common Stock (100,000 shares) Retained Earnings $320,000 $320,000 16,634 39,493 $320,000 41,619 $320,000 25,184 $320,000 25,082 Total Equity $336,634 $359,493 $361,619 $345,184 $345,082 Total Liabilities and Equity $640,000 $791,099 $995,948 $976,480 $968,503 Table 2 Quickfix Autoparts Income Statements Net Sales Cost of Goods Sold Gross Profit 2000 2001 $600,000 $655,000 480,000 537,100 $120,000 $117.900 2002 2003 $780,000 $873,600 655,200 742,560 $124,800 $131,040 2004 $1,013,376 861,370 $152,006 Admin and Selling Exp Depreciation Miscellanous Expenses Total Operating Expenses EBIT Interest on ST Loans Interest on LT Loans Interest on Mortgage Total Interest Before-tax earnings Taxes Net Income Dividends on Stock Addition to Retained Earnings EPS (100,000 shares) $30,000 25,000 2,027 $57,027 $62,973 15,000 8,000 12,250 $35,250 $27,723 11,089 $16,634 0 $16,634 $0.17 $15,345 25,000 3,557 $43,902 $73,998 15,950 7,840 12,110 $35,900 $38,098 15,239 $22,859 0 $22,859 $0.23 $16,881 $43,680 50,000 50,000 5,725 17,472 $72,606 $111, 152 $52,194 $19,888 14,000 13,320 15,680 15, 200 18,970 18,760 $48,650 $47,280 $3,544 ($27,392) 1,418 (10,957) $2,126 ($16,435) 0 $2,126 $16,435 $0.02 ($0.16) $40,535 50,000 15,201 $105,736 $46,270 13,320 14,640 18,480 $46,440 ($169) (68) ($102) 0 $102 ($0.00) Questions: 1. How does Quickfix's average compound growth rate in sales compare with its earnings growth rate over the past five years? 2. Which statements should Juan refer to and which ones should he construct so as to develop a fair assessment of the firm's financial condition? Explain why? 3. What calculations should Juan do in order to get a good grasp of what is going on with Quickfix's performance? 4. Juan knows that he should compare Quickfix's condition with an appropriate benchmark. How should he go about obtaining the necessary comparison data? 5. Besides comparison with the benchmark what other types of analyses could Juan perform to comprehensively analyze the firm's condition? Perform the suggested analyses and comment on your findings. 6. Comment on Quickfix's liquidity, asset utilization, long-term solvency, and profitability ratios. What arguments would have to be made to convince the bank that they should grant Quickfix the loan? 7. If you were the commercial loan officer and were approached by Andre for a short-term loan of $25,000, what would your decision be? Why? 8. What recommendations should Juan make for improvement, if any? 9. What kinds of problems do you think Juan would have to cope with when conducting a comprehensive financial statement analysis of Quickfix Auto Parts? What are the limitations of financial statement analysis in general? Case Study #1: Bigger Isn't Always Better! Andre Pires opened his automobile parts store, Quickfix Auto Parts, five years ago, in a mid-sized city located in the mid-western region of the United States. Having worked for an automobile dealership, first as a technician, and later as the parts department manager, for over 15 years, Andre had learned the many nuances of the fiercely competitive automobile servicing business. He had developed many contacts with dealers and service technicians, which came in really handy when establishing his own retail store. Business had picked up significantly well over the years, and as a result, Andre had more than doubled his store size by the third year of operations. The industry and local forecasts for the next few years were very good and Andre was confident that his sales would keep growing at or above recent levels. However, Andre had used up most of his available funds in expanding the business and was well aware that future growth would have to be funded with external sources of funds. What was worrying Andre was the fact that over the past two years, the store's net income figures had been negative, and his cash flow situation had gotten pretty weak (See Tables 1 and 2). He figured that he had better take a good look at his firm's financial situation and improve it, if possible, before his suppliers found out. He knew fully well that being shut out by suppliers would be disastrous! Andre's knowledge of finance and accounting, not unlike many businessmen's, was very limited. He had often entertained the thought of taking some financial management courses, but could never find the time. One day, at his weekly bridge session, he happened to mention his problem to Tom Andrews, his long-time friend and bridge partner. Tom had often given him good advice in the past and Andre was desperate for a solution. "I'm no finance expert, Andre", said Tom, "but you might want to contact the finance department at our local university's business school and see if you can hire and MBA student as an intern. These students can often be very insightful, you know." That's exactly what Andre did. Within a week he was able to recruit Juan Plexo, a second semester MBA student, who had an undergraduate degree in Accountancy and was interested in concentrating in Finance. When Juan started his internship, Andre explained exactly what his concerns were. I'm going to have to raise funds for future growth, and given my recent profit situation, the prospects look pretty bleak. I can't seem to put my finger on the exact cause. The bank's commercial loan is going to want some pretty convincing arguments as to why they should grant me the loan. I need to put some concrete remedial measures in place, and was hoping that you can help sort things out, Juan," said Andre. "I think I may have bitten off more than I can currently chew." Table 1 Quickfix Autoparts Balance Sheets ASSETS 2000 2001 2002 2003 2004 Cash and Marketable Securities Accounts Receivable Inventory $155,000 $309,099 10,000 12,000 250,000 270,000 $75,948 20,000 500,000 $28,826 77,653 520,000 $18,425 90,078 560,000 Current Assets $415,000 $591,099 $595,948 $626,479 $668,503 Land, Buildings, Plant, and Equipment Accumulated Depreciation Net Fixed Assets $250,000 $250,000 $500,000 $500,000 $500,000 (25,000) (50,000) (100,000) (150,000) (200,000) $225,000 $200,000 $400,000 $350,000 $300,000 $640,000 $791,099 $995,948 $976,479 $968,503 Total Assets LIABILITIES AND EQUITIES Short-term Bank Loans Accounts Payable Accruals $50,000 $145,000 10,000 10,506 5,000 5,100 $140,000 19,998 7,331 $148,000 15,995 9,301 $148,000 16,795 11,626 Current Liabilities $65,000 $160,606 $167,329 $173,296 $176,421 Long-term Bank Loans Mortgage Long-term debt $63,366 $98,000 $196,000 $190,000 $183,000 175,000 173,000 271,000 268,000 264,000 $238,366 $271,000 $467,000 $458,000 $447,000 Total Liabilities $303,366 $431,606 $634,329 $631,296 $623,421 Common Stock (100,000 shares) Retained Earnings $320,000 $320,000 16,634 39,493 $320,000 41,619 $320,000 25,184 $320,000 25,082 Total Equity $336,634 $359,493 $361,619 $345,184 $345,082 Total Liabilities and Equity $640,000 $791,099 $995,948 $976,480 $968,503 Table 2 Quickfix Autoparts Income Statements Net Sales Cost of Goods Sold Gross Profit 2000 2001 $600,000 $655,000 480,000 537,100 $120,000 $117.900 2002 2003 $780,000 $873,600 655,200 742,560 $124,800 $131,040 2004 $1,013,376 861,370 $152,006 Admin and Selling Exp Depreciation Miscellanous Expenses Total Operating Expenses EBIT Interest on ST Loans Interest on LT Loans Interest on Mortgage Total Interest Before-tax earnings Taxes Net Income Dividends on Stock Addition to Retained Earnings EPS (100,000 shares) $30,000 25,000 2,027 $57,027 $62,973 15,000 8,000 12,250 $35,250 $27,723 11,089 $16,634 0 $16,634 $0.17 $15,345 25,000 3,557 $43,902 $73,998 15,950 7,840 12,110 $35,900 $38,098 15,239 $22,859 0 $22,859 $0.23 $16,881 $43,680 50,000 50,000 5,725 17,472 $72,606 $111, 152 $52,194 $19,888 14,000 13,320 15,680 15, 200 18,970 18,760 $48,650 $47,280 $3,544 ($27,392) 1,418 (10,957) $2,126 ($16,435) 0 $2,126 $16,435 $0.02 ($0.16) $40,535 50,000 15,201 $105,736 $46,270 13,320 14,640 18,480 $46,440 ($169) (68) ($102) 0 $102 ($0.00) Questions: 1. How does Quickfix's average compound growth rate in sales compare with its earnings growth rate over the past five years? 2. Which statements should Juan refer to and which ones should he construct so as to develop a fair assessment of the firm's financial condition? Explain why? 3. What calculations should Juan do in order to get a good grasp of what is going on with Quickfix's performance? 4. Juan knows that he should compare Quickfix's condition with an appropriate benchmark. How should he go about obtaining the necessary comparison data? 5. Besides comparison with the benchmark what other types of analyses could Juan perform to comprehensively analyze the firm's condition? Perform the suggested analyses and comment on your findings. 6. Comment on Quickfix's liquidity, asset utilization, long-term solvency, and profitability ratios. What arguments would have to be made to convince the bank that they should grant Quickfix the loan? 7. If you were the commercial loan officer and were approached by Andre for a short-term loan of $25,000, what would your decision be? Why? 8. What recommendations should Juan make for improvement, if any? 9. What kinds of problems do you think Juan would have to cope with when conducting a comprehensive financial statement analysis of Quickfix Auto Parts? What are the limitations of financial statement analysis in general