GAP has a $600,000 line-of-credit with Texas Investment Bank. The limit could be extended, but only...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
GAP has a $600,000 line-of-credit with Texas Investment Bank. The limit could be extended, but only if the bank has sufficient loanable funds and the company is in a good financial condition. The company must maintain a current ratio of 1.5, a times interest earned ratio of 5.0, and can only borrow up to 50 per cent of the value of its accounts receivable and inventory. The company negotiates separate term loans and mortgages to finance its capital purchases Under Jack's leadership, GAP had an excellent relationship with its bank, but John's poor management and interpersonal skills had put this relationship in jeopardy. Retail sales were paid for in cash or by credit card so there were no accounts receivable. Sales to businesses made up to 40 per cent of sales and were on terms 2/10, net 30 with negligible bad debts. GAP bought its auto parts from the manufacturers on terms 2/15, net 30, which was the norm in the industry. Interest was charged on overdue accounts at 12 per cent per annum and many retailers who got too far in arrears were put on a cash-and-carry basis. A slowdown was forecasted in the local economy in 2007 due to the corn fields fires that took place in the summer of 2006 and the collapse of the beef industry caused by the discovery of mad cow decease in more than half of the farms in Texas. The following industry average ratios (based on year-end figures) were available for companies that sold both tires and automotive maintenance services: Current Ratio Quick Ratio Inventory Turnover in Days Account Receivable turnover in Days Accounts Payable Turnover in Days Fixed Assets Turnover Total Assets Turnover Debt Ratio Times Interest Earned Cost of Borrowing Gross Profit Margin Operating Profit Margin Net Profit Margin Return on Assets Return on Equity GAP's marginal tax rate was 40 percent. 1.90 0.51 60 days 30 days 15 days 3.19 2.00 30.00% 14.63 6.50% 42.00% 12.00% 6.71% 13.42% 19.17% Sales Cost of Goods Sold Gross Profit Depreciation Other Operating Expenses Earnings Before Interest and Tax Interest Expense Earnings Before Tax Income Tax Expense Net Income Income Statement For the Year Ended December 31 Cash Accounts Receivable Inventory Prepaid Expenses Total Current Assets Property, Plant and Equipment Less: Accumulated Depreciation Property, Plant and Equipment, net Total Assets Accounts Payable Line of Credit Current Portion of Long-term Debt Total Current Liabilities Long-term Debt Equity Total Liabilities and Equity Balance Sheet As of December 31 2005 2004 2006 6,500,000 5,550,000 4,050,000 3,965,000 3,385,500 2,430,000 2,535,000 2,164,500 1,620,000 287,200 485,600 158,500 1,012,500 1,690,000 1,387,500 449,000 50,645 27,444 329,675 398,355 10,978 131,870 16,467 197,805 359,400 489,800 331,956 160,125 2005 110,000 59,000 723,000 42,000 36,000 1,244,000 928,000 7,288,800 4,819,200 2,432,800 1,947,200 4,856,000 2,872,000 6,100,000 3,800,000 2006 $7,000 95,000 1,050,000 159,342 239,013 2004 155,000 45,000 540,000 25,000 765,000 3,245,000 1,660,000 1,585,000 2,350,000 440,556 165,000 99,000 570,638 353,000 267,435 325,346 162,000 41,461 1,336,540 680,000 407,895 3,253,460 1,620,000 414,605 1,510,000 1,500,000 1,527,500 6,100,000 3,800,000 2,350,00 S You are to prepare the following ratio analysis calculations for the two years 2006 AND 2005 based on the following ratios listed below: Current Ratio Quick Ratio Inventory Turnover in Days Account Receivable turnover in Days Accounts Payable Turnover in Days Fixed Assets Turnover Total Assets Turnover Debt Ratio Times Interest Earned Cost of Borrowing (do your best on this one!) Gross Profit Margin Operating Profit Margin Net Profit Margin Return on Assets Return on Equity GAP has a $600,000 line-of-credit with Texas Investment Bank. The limit could be extended, but only if the bank has sufficient loanable funds and the company is in a good financial condition. The company must maintain a current ratio of 1.5, a times interest earned ratio of 5.0, and can only borrow up to 50 per cent of the value of its accounts receivable and inventory. The company negotiates separate term loans and mortgages to finance its capital purchases Under Jack's leadership, GAP had an excellent relationship with its bank, but John's poor management and interpersonal skills had put this relationship in jeopardy. Retail sales were paid for in cash or by credit card so there were no accounts receivable. Sales to businesses made up to 40 per cent of sales and were on terms 2/10, net 30 with negligible bad debts. GAP bought its auto parts from the manufacturers on terms 2/15, net 30, which was the norm in the industry. Interest was charged on overdue accounts at 12 per cent per annum and many retailers who got too far in arrears were put on a cash-and-carry basis. A slowdown was forecasted in the local economy in 2007 due to the corn fields fires that took place in the summer of 2006 and the collapse of the beef industry caused by the discovery of mad cow decease in more than half of the farms in Texas. The following industry average ratios (based on year-end figures) were available for companies that sold both tires and automotive maintenance services: Current Ratio Quick Ratio Inventory Turnover in Days Account Receivable turnover in Days Accounts Payable Turnover in Days Fixed Assets Turnover Total Assets Turnover Debt Ratio Times Interest Earned Cost of Borrowing Gross Profit Margin Operating Profit Margin Net Profit Margin Return on Assets Return on Equity GAP's marginal tax rate was 40 percent. 1.90 0.51 60 days 30 days 15 days 3.19 2.00 30.00% 14.63 6.50% 42.00% 12.00% 6.71% 13.42% 19.17% Sales Cost of Goods Sold Gross Profit Depreciation Other Operating Expenses Earnings Before Interest and Tax Interest Expense Earnings Before Tax Income Tax Expense Net Income Income Statement For the Year Ended December 31 Cash Accounts Receivable Inventory Prepaid Expenses Total Current Assets Property, Plant and Equipment Less: Accumulated Depreciation Property, Plant and Equipment, net Total Assets Accounts Payable Line of Credit Current Portion of Long-term Debt Total Current Liabilities Long-term Debt Equity Total Liabilities and Equity Balance Sheet As of December 31 2005 2004 2006 6,500,000 5,550,000 4,050,000 3,965,000 3,385,500 2,430,000 2,535,000 2,164,500 1,620,000 287,200 485,600 158,500 1,012,500 1,690,000 1,387,500 449,000 50,645 27,444 329,675 398,355 10,978 131,870 16,467 197,805 359,400 489,800 331,956 160,125 2005 110,000 59,000 723,000 42,000 36,000 1,244,000 928,000 7,288,800 4,819,200 2,432,800 1,947,200 4,856,000 2,872,000 6,100,000 3,800,000 2006 $7,000 95,000 1,050,000 159,342 239,013 2004 155,000 45,000 540,000 25,000 765,000 3,245,000 1,660,000 1,585,000 2,350,000 440,556 165,000 99,000 570,638 353,000 267,435 325,346 162,000 41,461 1,336,540 680,000 407,895 3,253,460 1,620,000 414,605 1,510,000 1,500,000 1,527,500 6,100,000 3,800,000 2,350,00 S You are to prepare the following ratio analysis calculations for the two years 2006 AND 2005 based on the following ratios listed below: Current Ratio Quick Ratio Inventory Turnover in Days Account Receivable turnover in Days Accounts Payable Turnover in Days Fixed Assets Turnover Total Assets Turnover Debt Ratio Times Interest Earned Cost of Borrowing (do your best on this one!) Gross Profit Margin Operating Profit Margin Net Profit Margin Return on Assets Return on Equity
Expert Answer:
Answer rating: 100% (QA)
To calculate the requested ratios well use the given financial data for the years 2006 and 2005 Lets go through each ratio calculation step by step 1 Current Ratio Current Ratio Current Assets Current ... View the full answer
Related Book For
Smith and Roberson Business Law
ISBN: 978-0538473637
15th Edition
Authors: Richard A. Mann, Barry S. Roberts
Posted Date:
Students also viewed these accounting questions
-
High-Performance Tire (HPT) Ltd. is a retail tire chain with a network of company-owned stores in thenB.C. Interior. It was formed by Harry and Edna Wallace in 1952 and was passed on to their...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
In the beginning of January 2009, Mr. L.C. Tandon, Director of Finance of Central Equipment Company (CEC) was evaluating the pros and cons of debt and equity financing for the purpose of expansion of...
-
Describe six danger signs of a bust-out artist.
-
A vibrating source generates a sinusoidal wave on a string under constant tension. If the power delivered to the string is doubled, by what factor does the amplitude change? Does the wave speed...
-
Figure shows a cross section of a long cylindrical conductor of radius a = 4.00 cm containing a long cylindrical hole of radius b = 1.50 cm. The central axes of the cylinder and hole are parallel and...
-
.Which of the following is false regarding the Sarbanes-Oxley act? a. It requires that external auditors report to the company president. b. It applies to publicly traded companies. C. It requires...
-
Callaghan Companys annual factory depreciation is $450,000. Callaghan estimated it would operate the factory a total of 3,600 hours this year. The factory operated 300 hours in November and 200 hours...
-
Business Communication 1. What is Management Report? Cite an example of it. 2. What is an Operational Report? Cite an example of it. 3. What is Investigative Report? Cite an example of it. 4. What is...
-
Suppose that a metal pin has a diameter that has a uniform distribution between 4.182 mm and 4.185 mm. (a)What is the probability that a pin will lit into a hole that has a diameter of 4.184 mm'.'...
-
Nikki wants to buy an investment property. She has a deposit of $22000, and is prepared to pay it off over 4 years at a maximum of $600 per month. Some time ago, she was slowly paying off a loan so...
-
How does this cost of services sold statement differ from the cost of goods sold statement for a manufacturing firm?
-
A plane leaves Seattle, flies 7 6 . 0 mi at 1 8 . 0 north of east, and then changes direction to 5 4 . 0 south of east. After flying at 1 1 8 mi in this new direction, the pilot must make an...
-
A firm with earnings of $500,000 has 100,000 shares outstanding, trading at $12 per share. The firm has $150,000 of free cash that management would like to disburse to shareholders in one of three...
-
Frank has asked you to meet with your colleagues and discuss how risk and returns will influence McCormick's investment decision. Complete the following tasks: Discuss whether McCormick & Company...
-
3-yr bond with face value of $100 has a 7% yield per annum (with continuous compounding) and pays a 9% coupon semi-annually. What is the price of this bond?
-
Prepare an integrated human resource management plan for a new factory for the Al Suwaidi Foundation and appoint about 1,800 workers and administrative staff distributed over the administrative...
-
Explain why it is not wise to accept a null hypothesis.
-
Saul sold goods to Bruce, warranting that the goods were of a specified quality. The goods were not of the quality warranted, however, and Saul knew this at the time of the sale. Bruce drew and...
-
Defendant Michael W. Berger, along with two close friends as partners, formed an offshore investment company known as the Manhattan Investment Fund, Ltd. (the Fund), which was organized under the...
-
Joe Brown gave to his wife, Mary Brown, $350,000 with which to buy real property. They orally agreed that title to the real property should be taken in the name of Mary Brown but that she should hold...
-
Brown & Brown, CPAs, was engaged by the board of directors of Cook Indus tries, Inc. to audit Cooks calendar year 19X5 financial statements. The following report was drafted by an audit assistant at...
-
Your client, S Company is a major manufacturer of widgets. Your audit report for the previous year was unqualified. During the current year, several class- action suits were filed against the company...
-
Q Company is a gas distribution company that is regulated by the state public service commission. The commission must approve all rate changes made by Q Company, but Q Company is allowed to collect...
Study smarter with the SolutionInn App