Preview

Tire City Inc

Powerful Essays
Open Document
Open Document
2135 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Tire City Inc
Tire City Incorporated

Tire City, Inc. is a rapidly growing retail distributor of automotive tires. Although they have 10 shops located throughout the Northeast region, the bulk of TCI’s inventory is managed at a central warehouse. During the last three years, sales have been growing at a compound annual rate in excess of 20%. With such a great reflection of their excellent service and customer satisfaction in their net income, TCI’s central warehouse is “bulging at the seams”. TCI has decided to expand its warehouse facilities to accommodate future growth, and has requested a five year loan. We, MidBank, previously financed a project for TCI in 1991, which is currently being repaid in equal annual installments. TCI plans to invest $2,400,000 on its expansion, $2,000,000 to be spent in 1996.
In order to establish whether or not Tire City, Inc. will be a reliable debtor, and to determine appropriate loan amounts in 1996 and 1997, we produced pro forma financial statements given Mr. Martin’s projection of 20% annual increases in sales, as well as more conservative projections of 15% and 10%.

Income Statement
See Appendices 1 (A-C) to view the pro forma Income Statements.
In order to achieve an accurate projection of Net Income, we had to make a number of assumptions about the behavior of various accounts. We assumed Net Sales would grow by 20%, 15%, and 10% in 1A, 1B, and 1C, respectively. Based on prior years’ data, we assumed Cost of Sales would remain at 58% of Net Sales. We also assumed Selling, General, and Administrative Expenses would grow at 20%, 15%, and 10%, respectively. TCI will not be allowed to deduct any depreciation on the new building in 1996, but will be able to deduct 5% of the warehouse’s total cost of $2,400,000 in 1997.
Depreciation Expense on all other assets held by TCI will remain the same in 1996 and 1997 as it was in 1995. We assumed Net Interest Expense would remain at the average percentage of Long-Term Debt as it had in

You May Also Find These Documents Helpful

  • Good Essays

    Company A started with $250,000 and increased in revenue by 10% each year up to 5 years. Therefore, at the end of 5 years the revenue totaled $146,410. We subtracted the annual expenses from the yearly revenue to determine the profit before depreciation or the profit before the drop in value. Depreciation moves the cost of an asset to depreciation expense during the asset 's useful life. Depreciation expense results when the purchase price of a fixed asset is reduced over time, or its useful life (Keown, Martin, & Petty, 2014). In Corporation A, the Depreciation expense is $5,000 a year. We deducted the $5,000 year depreciation from the profit to obtain the profit before tax. The tax rate of 25% was deducted from the profit before tax to find the net income. The 5 Year Projected Cash Flow is the net income plus the…

    • 796 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Acc/291 Week 3

    • 626 Words
    • 3 Pages

    Sales returns $ 700 Rent expense 1,288 Sales discounts 950 Depreciation expense 600 Cost of merchandise sold 7,600 Gross sales 20,900 Advertising expense 1,650 Salary expense 2,900 Heat expense 900…

    • 626 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Western States Stationary

    • 675 Words
    • 3 Pages

    3. Assessing TFC’s current accounting system, John Malone determined that the system was inadequate because customers which appeared to be similar actually required very different needs in terms of time, storage and delivery. To develop a new accounting system, the managers began to gather information from warehouse managers to understand what happens at the distribution centers and broke it down into five primary value-added activities: storage, requisition handling, basic warehouse stock selection, “pick-pack” activity and desk top delivery. The managers gathered additional information, allowing them to assign costs to those activities. From there, the managers determined the expenses associated with financing, labor and shipping. Once the information was used to…

    • 675 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Revenue Estimates Revenue Item 100% Monthly 75% Monthly 50% Monthly Notes Rooms $2,956,500 $2,217,375 $1,478,250 8,100 daily Leases $180,000 $135,000 $90,000 TOTAL REVENUE $3,136,500 $2,352,375 $1,568,250 Expences TOTAL VARIABLE COSTS $454,000 $340,500 $227,000 TOTAL FIXED COSTS $1,403,000 $1,403,001 $1,403,002 TOTAL EXPENSE BEFORE IT $1,857,000 $1,743,501 $1,630,002 EBIT $1,279,500 $608,874 -$61,752 Depreciation $320,000 $320,001 $320,002 EBITDA $1,599,500 $928,875 $258,250 Furnishing Interest $110,000 $110,000 $110,000 20yr Mortgage Interest $182,000 $182,000 $182,000 TOTAL INTEREST $292,000 $292,000 $292,000 TAXES (40%) $395,000.00 $126,749.60 -$141,500.80 Furnishing Principal $180,160 $180,160 $180,160 20yr Mortgage Principal $49,713 $49,713 $49,713 TOTAL PRINCIPAL $229,873 $229,873 $229,873 NET INCOME $362,627 -$39,749 -$442,124 DIVIDEND PAYMENT $29,010 -$3,180 -$35,370 RETAINED EARNINGS $333,617 -$36,569 EBIT/INTEREST 4.38 2.09 (0.21) EBITDA/INTEREST 5.48 3.18 0.88 BURDEN $675,121.67 $675,121.67 $675,121.67 EBIT/BURDEN 1.90 0.90 (0.09) ROE= Net Income/OE (H1) 32.97% -3.61% -40.19% Revenue Estimates Revenue Item 100% Monthly 75%…

    • 1302 Words
    • 21 Pages
    Satisfactory Essays
  • Good Essays

    f';fa;d'a;f',af;ag';sdagl.;gdlal,g;adl,g,gal;am,dblv .cv z,vz mld;,ag,a;es'g.;'gad;a';ldg;gd;sal;,ger'fa,s.a;l,gdlag,dla,g;ewlwetp;lq4pewql,e;et,q;g,al,gal;g,dla;ew,tqleg,algm,eksgtmaq;,;'.E'S.AFD;Af?D/A>;T',;L,EL;On January 1, 2010, Ameen Company purchased a building for $36 million. Ameen uses straight-line depreciation for financial statement reporting and MACRS for income tax reporting. At December 31, 2012, the carrying value of the building was $30 million and its tax basis was $20 million. At December 31, 2013, the carrying value of the building was $28 million and its tax basis was $13 million. There were no other temporary differences and no permanent differences. Pretax accounting income for 2013 was $45 million.On January 1, 2010, Ameen Company purchased a building for $36 million. Ameen uses straight-line depreciation for financial statement reporting and MACRS for income tax reporting. At December 31, 2012, the carrying value of the building was $30 million and its tax basis was $20 million. At December 31, 2013, the carrying value of the building was $28 million and its tax basis was $13 million. There were no other temporary differences and no permanent differences. Pretax accounting income for 2013 was $45 million.On January 1, 2010, Ameen Company purchased a building for $36 million. Ameen uses straight-line depreciation for financial statement reporting and MACRS for income tax reporting. At December 31, 2012, the carrying value of the building was $30 million and its tax basis was $20 million. At December 31, 2013, the carrying value of the building was $28 million and its tax basis was $13 million. There were no other temporary differences and no permanent differences. Pretax accounting income for 2013 was $45 million.On January 1, 2010, Ameen Company purchased a building for $36 million. Ameen uses straight-line depreciation for financial statement reporting and MACRS for income tax reporting. At December 31, 2012, the carrying value of the…

    • 1122 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    It is essential for industries to be capable to evaluate their economic and financial condition and enhance their approaches to meet the market demands. The task of financial analysts is to utilize diverse estimating and capital budgeting procedures to justify the company’s behavior and be responsible for forthcoming decisions. A balance sheet is one of the most effective and highly used cash flow examination tool used by financial analysts. General and financial managers can both take advantage of the forecasting financial statements. Proforma statements help financial managers to formulate plans accordingly, in terms of the business’s financial requirements. How much financing is desired and when it is necessary can be decided by obtaining an estimate of the company’s future balance sheet accounts and income statement.…

    • 452 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Bob, a friend of Joan’s, is looking to start a new airline business and is looking for a loan for $300 million dollars. Joan researches Bob's background and finds that, Bob worked as an assistant regional manager for a mid-western airline company for 12 years and during that time, Bob's region increased sales by 28%.…

    • 638 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Book

    • 538 Words
    • 3 Pages

    4-Do you agree with Mr. Clarkson’s estimate of the company’s loan requirements? How much will he need to finance the expected expansion in sales to $ 5.5 Million in 1996 and to take all trade discounts?…

    • 538 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Btec Business P5

    • 883 Words
    • 4 Pages

    A profit and loss account is what a business uses to keep track of their finances throughout the previous twelve months.…

    • 883 Words
    • 4 Pages
    Good Essays
  • Better Essays

    Canadian Tire

    • 1625 Words
    • 7 Pages

    References: Strauss, MARINA. "The Globe and Mail." The Globe and Mail. N.p., 07 Mar. 2013. Web. 19 Mar. 2013. http://www.theglobeandmail.com/globe-investor/goodbye-big-box-canadian-tire-thinks-small-to-take-on-giant-target/article9382548/…

    • 1625 Words
    • 7 Pages
    Better Essays
  • Satisfactory Essays

    In conducting the previous analysis, we used different assumptions mentioned in the case. For example, to forecast sales at the store level by year, old, and new, we used the arithmetic mean of corresponding historical growth rates in sales adjusted by the total furniture sales' growth rate in the same year in order to account for the industry shocks. We applied the same process to forecast costs such as COGS, SG&A, and Advertising but without the adjustment for total furniture sales' growth rate since it was taken into account with calculating sales. Corporate expenses as a 5% of the same year sales as…

    • 593 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Although they all seem reasonable, I do have doubt about the cost saving on warehouse. Based on my calculation, referring to Exhibit 3 – second bottom line, the change of working capital is not that considerable due to the increase of sales volume. Thus, the estimation on cost saving on warehouse might be a little bit aggressive in my point of view. Since I have no inside information, I would accept all the estimations and assumptions provided by the case.…

    • 1942 Words
    • 37 Pages
    Satisfactory Essays
  • Good Essays

    Thaifoon Restaurant Case

    • 2432 Words
    • 10 Pages

    For the fixed cost, from exhibit 4, I subtract amortization from the total projected annual cost, and add one month deposit paid to the landlord, which is 87,789-19,414= $68,375. Then variable cost based on the sales, which in total equals $397,371. So gross profit would be revenue- total cost (fixed cost+ variable cost)= $134,854. Then subtract amortization from gross profit, EBIT= $115,440.…

    • 2432 Words
    • 10 Pages
    Good Essays
  • Satisfactory Essays

    Preparing a Master Budget

    • 692 Words
    • 3 Pages

    The policy is to acquire enough inventory each month to equal the following month’s projected cost of goods sold. All purchases are paid for in the month following purchase. Salaries, wages, and commissions average 20% of sales; all other variable expenses are 4% of sales. Fixed expenses for rent, property taxes, and miscellaneous payroll and other items are $55,000 monthly. Assume that these variable and fixed expenses require cash disbursements each month. Depreciation is $2,500 monthly. In June, $55,000 is going to be disbursed for fixtures acquired and recorded in furniture and fixtures in May. The May 31 balance of accounts…

    • 692 Words
    • 3 Pages
    Satisfactory Essays