Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write a business case study with the following Recommendations Short Term Immediately to 3 months Medium Term 3 months to 6 months Long Term 6
Write a business case study with the following
Recommendations
- Short Term Immediately to 3 months
- Medium Term 3 months to 6 months
- Long Term 6 months to a year and beyond
Control and Feedback
Contingency Plan
Introduction
Problem statement
Recommendations/Implementation
- Short Term Immediately to 3 months
- Medium Term 3 months to 6 months
- Long Term 6 months to a year and beyond
Control and Feedback
Contingency Plan
Exhibits
Case 1.1 Midi Capital division fell below the goal of 20 per cent, they would have to jus- tify why profit targets had not been met. THE TRANSPORTATION INDUSTRY IN SOUTHERN ONTARIO Canada COMMERCIAL TRANSPORTATION FI- NANCING CASE 1.1 MIDI CAPITAL CANADA, COM- MERCIAL TRANSPORTATION FINANCING DIVISION Commercial Transportation Financing (CTF) was one of Midi Cap- ital's 27 divisions. The majority of CTF's business was loaning money to medium and large-sized transportation and construction companies. Loans from $30,000 to $1 million were provided to pur- chase assets such as transport trucks, trailers, paving equipment and heavy machinery. The trucking industry had been very profitable from 1985 to 1988 until a major recession in 1989. During the recession, there was less manufacturing, resulting in fewer goods being shipped by trucking companies. Many trucking companies went bankrupt and those that survived the recession had to lower prices to stay competitive. The industry recovered during a manufacturing boom in the mid 1990's and the amount of freight shipped between Windsor and Toronto was at its highest level ever; however the transportation industry in Southern Ontario was very competitive with thousands of trucking companies competing for business. By the mid 2000's the trans- portation industry had experienced strong growth, but prices and profits remained low with trucking companies typically generating after tax net incomes of less than 8 per cent of revenues. It was early morning on April 15 2016, when Steve Brant, assistant account manager for the Commercial Transportation Financing Di- vision of Midi Capital Canada in Toronto, Ontario, Canada, fin- ished reading the morning copy of The Financial Post and began reviewing a loan request for $270,000 submitted by an existing client - Simon Carriers Ltd. Simon Carriers, a trucking company, requested the $270,000 loan to purchase two new 2016 Freightliner transport trucks, four new 53-foot trailers and four new mobile sat- ellite systems that would be used to track the location of the transport trucks. Brant had to make a decision on the loan request and forward a report to the senior account manager for approval that afternoon. CTF was under tremendous pressure to generate profits. The selling strategy at CTF was "Find, Win, Keep - Find new business, Win new business and Keep new and existing clients. As of April 1, 2016, less than one percent of CTF's portfolio of over 2,000 ac- counts had been lost to bad debt. Account managers for the South- ern Ontario Region were expected to generate $14 million in new loans each year, without exposing Midi Capital to unreasonable levels of risk. With prices low, trucking companies relied on higher volumes of business to generate profits. One way to increase sales volume was to purchase more trucks and trailers and hire additional drivers. For every truck and trailer, a trucking company would typically gener- ate $150,000 to $200,000 in annual sales. However the high cost of purchasing new trucks and equipment required large loans to fi- nance the purchase new assets. Because so many trucking compa- nies borrowed money to expand, it was important to maximize the amount of time a truck was on the road to generating sales, to cover not only operating expenses but also to cover the loan payments. MIDI CAPITAL Several requirements had to be met before CTF would approve a loan. First, CTF did not deal with any company that had been in business for less than three years. Second, the company applying for the loan had to generate enough cash flow to cover the monthly interest payments on the new loan. Third, the company's debt to equity ratio could be greater than 4:1 when including the new loan. Fourth, CTF would not finance more than 90 per cent of the value of the value of any asset, thereby requiring the company to have enough cash to pay for at least 10 per cent of the assets it wanted to purchase. Lastly, CTF considered the character of the business owners, general economic conditions, and any company assets that could be pledged as collateral as additional factors in the loan re- quest. Midi Capital comprised of 27 diversified businesses, including op- erations in North America, Latin America, Europe and the Asia- Pacific region, its head office was located in Stanford Connecticut. Midi Diversified, Midi Capital's parent company was a publicly traded corporation with net earnings of over US$15 billion. Midi Capital was a major competitor in every industry it competed in, achieving record net earnings of US$3.6 billion in 2015. It expected each of its divisions to generate a 20% after tax-profit, and if a NEW LEGISLATION It was mandatory that all vehicles (trucks and trailers) used by the trucking companies meet the safety standards set by the Ministry of Transportation of Ontario (MTO). These standards were enforced on major highways at weight scale stations where all trucks were required to stop for inspections. Effective February 02, 1998 new make deliveries according to just-in-time inventory schedules, which meant that SCL, would haul multiple trailer loads several days a week. legislation gave the MTO the right to impound any vehicle (truck or trailer) deemed to have a major defect.1 If a critical defect was found during an inspection, the MTO im- pounded the vehicle for 15 days and the vehicle could not be oper- ated until the equipment had been repaired to meet safety standards. If the same or additional critical defects were found during any sub- sequent inspection, the MTO impounded the vehicle for 30 days. In addition to impounding the vehicles the MTO also charged fines ranging from $2,000 to $20,000 for equipment that did not pass in- spection. Despite the risk of impoundment, thousands of trucks have failed safety inspections annually and the MTO has im- pounded thousands of trucks from the inception of the program un- til October, 2015. To accommodate the new contract SCL borrowed $336,000 from Nippissing Credit on April 01, 2014 to finance the purchase of three new transport trucks and three new trailers. The company also hired three new drivers to drive the new trucks. As of December 31, 2014, SCL still owed $189,000 on the loan from Nippissing Credit. SCL paid $7,000 on this loan each month. To expand its fleet, SCL required approximately $300,000. Since SCL was required to pay at least 10 per cent of the cost in cash ($30,000), it requested a $270,000 loan to purchase two new 2016 freightliner transport trucks, four new 53 foot trailers and four new mobile satellite systems. In projecting its income statements for 2016, SCL estimated revenues to be 30 per cent to 60 per cent higher than 2015. Salaries and wages were expected to increase by $60,000 to hire two new drivers and general and administration ex- penses were expected to increase by $13,000 due to the larger fleet. Additionally, bank charges and interest on the new loan would be $17,300. Depreciation on the new assets would be $30.000. Legal and accounting fees and rent and utilities were expected to remain unchanged from 2015 amounts. The operating expenses for 2016 were expected to remain at the same proportion of sales as they had been in 2015. No other purchases of new assets were expected for 2015. The company's income tax rate was approximately 45 per cent. The trucking volume generated by the contract continued to in- crease. In October 2014, SCL sought financing to purchase two new trailers. A loan for $38,400 was arranged through Midi Capital on October 01, 2014, the current balance still owing on the Midi Capital loan was $36,000. CSL paid $800 on this loan each month. The trucking company's financial statements, ratios and sources and uses of cash are shown in Exhibits 1 through 4. SIMON CARRIERS LTD. Background THE NEW CONTRACT William Simon and his wife Mary founded Simon Carriers Ltd. (SCL) in Waterloo Ontario, in the late 1980's. The company began as a one-truck operation hauling freight for a larger trucking com- pany that contracted work to independent truck drivers. William was the driver and mechanic while Mary managed the accounting records. The Simon's survived the economic recession of the early 1990's and continued to operate their business as a one-truck oper- ation until late 2013 when they began searching for exclusive haul- ing contracts. In March 2016, the auto parts manufacturer signed a new supplier contract effective May 01, 2016, with Ford. The new contract re- flected a 60 per cent increase in trucking volume. SCL's two-year contract with the auto parts manufacturer expired on March 31, 2016, and had not been renewed. In an effort to reduce its own costs, and because the trucking volume would increase by 60 per cent, the auto parts manufacturer was allowing several trucking companies (including SCL) to bid for the new trucking contract. If SCL hoped to win the new trucking contract, it would need to ex- pand its fleet to accommodate the higher trucking volume and to "outbid competing trucking companies. In projecting its balance sheets, SCL estimated the value of the new loans to be $270,000 less the monthly payments made between May 2016 and December, 2016. SCL anticipated no changes to the age of receivables or the age of the payables. The company also had a line of credit of up to $50,000 that it had never used. It planned to use $30,000 from this line of credit to make the cash payment re- quired by Midi Capital (10 per cent of the new assets). The Simons had used $50,000 in personal assets to secure the bank line of credit. None of the assets on SCL's current balance sheet were pledged as collateral. The main question for Brant was whether SCL would show a cash surplus on its projected balance sheet. A cash surplus would indicate that SCL would be capable of making the required loan payments, whereas a deficit would indicate that SCL would be incapable of paying back the loan. In March of 2014 SCL signed an exclusive two year contract with a small auto parts manufacturer that supplied the Ford Motor Co. assembly plant in Oakville, Ontario. Ford required its suppliers to 1 Examples of critical defects included loose or broken lug nuts, cracked wheels, cracked brake rotors, broken steering components, broken suspension components and tires with less than 25 per cent of the tread remaining across any part of the tire. PROJECTED REQUIREMENTS FOR THE NEW CONTRACT 2 The monthly principle payment on the new loan would be $5,625 Exhibit 1 5.1% 48,565 7.5% 0.1% 1,330 0.2% Statements of Earnings (Unaudited) and Ratios For the years ending December 31 Since profits remained low across the industry, the Simons believed that continued growth would ensure their profitability. If SCL lost this contract, the Simons knew it would be difficult to find enough work to keep their fleet working at 100 per cent capacity William and Mary had worked hard to grow their business and had never been late with a loan payment, despite having trailers impounded on two occasions. Mary commented: We have been through good times and bad and we've expanded before. I feel that this is the right thing to do. We can't afford to stay small." Deprecation Expense 42,795 14,348 7.1% Advert & Promotion 1,235 0.0% Meals & entertainment 1,042 0.0% Total Operating Exp. $233,570 $ 55,026 27.1% 0.1% 867 0.1% 2015 %Sales 2014 %Sales 2013 %Sales 27.9% $226,277 35.0% ===== Revenue $835,295 100.0% $645,118 100.0% S202,232 100.0% Cost of Sales 3 518,805 62.1% 407,432 63.24 147,309 72.8% Gross Margin $316,490 37.9% $237,686 36.8% $54,993 27.2% BRANTS DECISION 28.0% 11,409 35.1% 9.9% 3,084 1.8% Net Earnings Pre-tax 82,920 (33) 27.2% Provision for Taxes 34,246 0.0% Net earnings after Tax 48,674 (33) 0.0% 5.8% 8,325 1.3% 14.4% $116,757 The new loan would bring the total of SCL's with Midi Capital to $300,000. Brant's report would have to be reviewed by his senior manager since the total loan amount exceeded his account man- ager's credit limit of $200,000. Brant had been with the company for eight months and it was important he made a well thought-out that followed CTF's minimum lending requirements. His report was due in a few hours. 18.1% 2.2% 15,556 2.4% Statements of Retained Earnings (Unaudited) For the Years Ending December 31 8,924 1.1% 6,858 1.1% 0.2% 1,500 0.2 2015 2014 Operating Expenses Salaries & Wages $120,259 26,362 13.0% General & Admin 8,512 2,058 1.0% Telephone & Fax 1,091 0.5% Legal & Accounting 1,491 800 0.4% Travel & Auto 9,430 0.0% Rent & Utilities 10,075 7,140 3.5% Bank Charges & Int 18,505 3,227 1.6% Bad Debts 1,302 0.0% 2013 1.1% 6,734 1.0% 1.2% 8,142 1.3% $ 8,171 $(154) 2.2% 17,127 2.7% 48,674 8,325 0.2% 2,841 0.4% Beginning retained earnings (121) Add: Net earnings after Taxes (33) Ending Retained earnings (154) $56,845 $8,171 ====== ==== 3 The cost of sales includes: the cost of operating the trucking fleet. These costs include fuel licenses, trip permits/toll payments, fine payments and mainte- nance of the trucking fleet. Source: Midi Capital Transportation Financial Division Exhibit 2 Exhibit 3 Balance Sheet (Unaudited) As of December 31 Financial Ratios For the years ending December 31 2015 2014 2013 LIABILITIES Current liabilities Accounts payable 13,676 Bank line of credit (50,00) $ 27,307 $ 15,881 Industry Average 2015 2014 201 ASSETS PROFITABILITY Return on average equity 0.0% 30.2% 52.6% 13. $ 4,230 $ 2.605 $ 27,307 $ 15,881 Total current liabilities 13,676 Long term liabilities Loan Nippissing Credit 1.56:1 2.2:1 4.2:1 42,004 28,230 STABILITY Debt/equity .23:1 Interest coverage 1.0x 189,000 273,000 N/A 5.5x Current Assets Cash 8,107 Accounts receivable 21,912 Other receivables 482 Prepaid expenses 16,237 Total Current Assets $46,738 1.7 429 478 Loan Midi Capital 36,000 15,065 12,820 1 $225,000 $273,000 Total long term liabilities S $ 61,728 $44,133 LIQUIDITY Current Ratio Acid test ratio Working capital $ 33,062 1.1:1 .9:1 N/A 2.3:1 2.8:1 1.7:1 1.9:1 $ 34,421 3.4 2.2 $ 28.2: S252,307 $288,881 TOTAL LIABILITIES $ 13,676 463,800 426,500 EFFICIENCY $ 60,000 S 5,480 5,480 42.6 days 18 days 16 Fixed Assets Trucks & trailers (cost) 95,000 Fixtures (cost) 5,480 Company vehicle (cost) 21,500 Computer (cost) 40 days 8,171 Age of receivables5 days Age of payables days 21,500 21,500 N/A 19 days OWNERS EQUITY Share Capital $ 60,000 60,000 Retained Earnings 56,845 (154) Total Owners equity $116,845 $ 59,846 TOTAL LIABILITIES AND OWNERS EQUITY $369,845 $ 73,522 14 days 3,200 3,200 $ 68,171 GROWTH 143,761 2014-20152013-2014 $357,052 $312.919 Less Accumulated depreciation 186,556 95.196 Total fixed assets (net) $307,424 $26,784 TOTAL ASSETS $369,152 $72,522 4 Compiled from Dunlop & Bradshaw industry norms and key Business ratios, trucking Local & long distance 2015. 5 Age of receivables is based on average daily sales and 365 days per year. 6 Age of payables is based on average daily cost of sales and 365 days per year. $357,052 Source: Midi Capital Transportation Financial Division Case 1.1 Midi Capital division fell below the goal of 20 per cent, they would have to jus- tify why profit targets had not been met. THE TRANSPORTATION INDUSTRY IN SOUTHERN ONTARIO Canada COMMERCIAL TRANSPORTATION FI- NANCING CASE 1.1 MIDI CAPITAL CANADA, COM- MERCIAL TRANSPORTATION FINANCING DIVISION Commercial Transportation Financing (CTF) was one of Midi Cap- ital's 27 divisions. The majority of CTF's business was loaning money to medium and large-sized transportation and construction companies. Loans from $30,000 to $1 million were provided to pur- chase assets such as transport trucks, trailers, paving equipment and heavy machinery. The trucking industry had been very profitable from 1985 to 1988 until a major recession in 1989. During the recession, there was less manufacturing, resulting in fewer goods being shipped by trucking companies. Many trucking companies went bankrupt and those that survived the recession had to lower prices to stay competitive. The industry recovered during a manufacturing boom in the mid 1990's and the amount of freight shipped between Windsor and Toronto was at its highest level ever; however the transportation industry in Southern Ontario was very competitive with thousands of trucking companies competing for business. By the mid 2000's the trans- portation industry had experienced strong growth, but prices and profits remained low with trucking companies typically generating after tax net incomes of less than 8 per cent of revenues. It was early morning on April 15 2016, when Steve Brant, assistant account manager for the Commercial Transportation Financing Di- vision of Midi Capital Canada in Toronto, Ontario, Canada, fin- ished reading the morning copy of The Financial Post and began reviewing a loan request for $270,000 submitted by an existing client - Simon Carriers Ltd. Simon Carriers, a trucking company, requested the $270,000 loan to purchase two new 2016 Freightliner transport trucks, four new 53-foot trailers and four new mobile sat- ellite systems that would be used to track the location of the transport trucks. Brant had to make a decision on the loan request and forward a report to the senior account manager for approval that afternoon. CTF was under tremendous pressure to generate profits. The selling strategy at CTF was "Find, Win, Keep - Find new business, Win new business and Keep new and existing clients. As of April 1, 2016, less than one percent of CTF's portfolio of over 2,000 ac- counts had been lost to bad debt. Account managers for the South- ern Ontario Region were expected to generate $14 million in new loans each year, without exposing Midi Capital to unreasonable levels of risk. With prices low, trucking companies relied on higher volumes of business to generate profits. One way to increase sales volume was to purchase more trucks and trailers and hire additional drivers. For every truck and trailer, a trucking company would typically gener- ate $150,000 to $200,000 in annual sales. However the high cost of purchasing new trucks and equipment required large loans to fi- nance the purchase new assets. Because so many trucking compa- nies borrowed money to expand, it was important to maximize the amount of time a truck was on the road to generating sales, to cover not only operating expenses but also to cover the loan payments. MIDI CAPITAL Several requirements had to be met before CTF would approve a loan. First, CTF did not deal with any company that had been in business for less than three years. Second, the company applying for the loan had to generate enough cash flow to cover the monthly interest payments on the new loan. Third, the company's debt to equity ratio could be greater than 4:1 when including the new loan. Fourth, CTF would not finance more than 90 per cent of the value of the value of any asset, thereby requiring the company to have enough cash to pay for at least 10 per cent of the assets it wanted to purchase. Lastly, CTF considered the character of the business owners, general economic conditions, and any company assets that could be pledged as collateral as additional factors in the loan re- quest. Midi Capital comprised of 27 diversified businesses, including op- erations in North America, Latin America, Europe and the Asia- Pacific region, its head office was located in Stanford Connecticut. Midi Diversified, Midi Capital's parent company was a publicly traded corporation with net earnings of over US$15 billion. Midi Capital was a major competitor in every industry it competed in, achieving record net earnings of US$3.6 billion in 2015. It expected each of its divisions to generate a 20% after tax-profit, and if a NEW LEGISLATION It was mandatory that all vehicles (trucks and trailers) used by the trucking companies meet the safety standards set by the Ministry of Transportation of Ontario (MTO). These standards were enforced on major highways at weight scale stations where all trucks were required to stop for inspections. Effective February 02, 1998 new make deliveries according to just-in-time inventory schedules, which meant that SCL, would haul multiple trailer loads several days a week. legislation gave the MTO the right to impound any vehicle (truck or trailer) deemed to have a major defect.1 If a critical defect was found during an inspection, the MTO im- pounded the vehicle for 15 days and the vehicle could not be oper- ated until the equipment had been repaired to meet safety standards. If the same or additional critical defects were found during any sub- sequent inspection, the MTO impounded the vehicle for 30 days. In addition to impounding the vehicles the MTO also charged fines ranging from $2,000 to $20,000 for equipment that did not pass in- spection. Despite the risk of impoundment, thousands of trucks have failed safety inspections annually and the MTO has im- pounded thousands of trucks from the inception of the program un- til October, 2015. To accommodate the new contract SCL borrowed $336,000 from Nippissing Credit on April 01, 2014 to finance the purchase of three new transport trucks and three new trailers. The company also hired three new drivers to drive the new trucks. As of December 31, 2014, SCL still owed $189,000 on the loan from Nippissing Credit. SCL paid $7,000 on this loan each month. To expand its fleet, SCL required approximately $300,000. Since SCL was required to pay at least 10 per cent of the cost in cash ($30,000), it requested a $270,000 loan to purchase two new 2016 freightliner transport trucks, four new 53 foot trailers and four new mobile satellite systems. In projecting its income statements for 2016, SCL estimated revenues to be 30 per cent to 60 per cent higher than 2015. Salaries and wages were expected to increase by $60,000 to hire two new drivers and general and administration ex- penses were expected to increase by $13,000 due to the larger fleet. Additionally, bank charges and interest on the new loan would be $17,300. Depreciation on the new assets would be $30.000. Legal and accounting fees and rent and utilities were expected to remain unchanged from 2015 amounts. The operating expenses for 2016 were expected to remain at the same proportion of sales as they had been in 2015. No other purchases of new assets were expected for 2015. The company's income tax rate was approximately 45 per cent. The trucking volume generated by the contract continued to in- crease. In October 2014, SCL sought financing to purchase two new trailers. A loan for $38,400 was arranged through Midi Capital on October 01, 2014, the current balance still owing on the Midi Capital loan was $36,000. CSL paid $800 on this loan each month. The trucking company's financial statements, ratios and sources and uses of cash are shown in Exhibits 1 through 4. SIMON CARRIERS LTD. Background THE NEW CONTRACT William Simon and his wife Mary founded Simon Carriers Ltd. (SCL) in Waterloo Ontario, in the late 1980's. The company began as a one-truck operation hauling freight for a larger trucking com- pany that contracted work to independent truck drivers. William was the driver and mechanic while Mary managed the accounting records. The Simon's survived the economic recession of the early 1990's and continued to operate their business as a one-truck oper- ation until late 2013 when they began searching for exclusive haul- ing contracts. In March 2016, the auto parts manufacturer signed a new supplier contract effective May 01, 2016, with Ford. The new contract re- flected a 60 per cent increase in trucking volume. SCL's two-year contract with the auto parts manufacturer expired on March 31, 2016, and had not been renewed. In an effort to reduce its own costs, and because the trucking volume would increase by 60 per cent, the auto parts manufacturer was allowing several trucking companies (including SCL) to bid for the new trucking contract. If SCL hoped to win the new trucking contract, it would need to ex- pand its fleet to accommodate the higher trucking volume and to "outbid competing trucking companies. In projecting its balance sheets, SCL estimated the value of the new loans to be $270,000 less the monthly payments made between May 2016 and December, 2016. SCL anticipated no changes to the age of receivables or the age of the payables. The company also had a line of credit of up to $50,000 that it had never used. It planned to use $30,000 from this line of credit to make the cash payment re- quired by Midi Capital (10 per cent of the new assets). The Simons had used $50,000 in personal assets to secure the bank line of credit. None of the assets on SCL's current balance sheet were pledged as collateral. The main question for Brant was whether SCL would show a cash surplus on its projected balance sheet. A cash surplus would indicate that SCL would be capable of making the required loan payments, whereas a deficit would indicate that SCL would be incapable of paying back the loan. In March of 2014 SCL signed an exclusive two year contract with a small auto parts manufacturer that supplied the Ford Motor Co. assembly plant in Oakville, Ontario. Ford required its suppliers to 1 Examples of critical defects included loose or broken lug nuts, cracked wheels, cracked brake rotors, broken steering components, broken suspension components and tires with less than 25 per cent of the tread remaining across any part of the tire. PROJECTED REQUIREMENTS FOR THE NEW CONTRACT 2 The monthly principle payment on the new loan would be $5,625 Exhibit 1 5.1% 48,565 7.5% 0.1% 1,330 0.2% Statements of Earnings (Unaudited) and Ratios For the years ending December 31 Since profits remained low across the industry, the Simons believed that continued growth would ensure their profitability. If SCL lost this contract, the Simons knew it would be difficult to find enough work to keep their fleet working at 100 per cent capacity William and Mary had worked hard to grow their business and had never been late with a loan payment, despite having trailers impounded on two occasions. Mary commented: We have been through good times and bad and we've expanded before. I feel that this is the right thing to do. We can't afford to stay small." Deprecation Expense 42,795 14,348 7.1% Advert & Promotion 1,235 0.0% Meals & entertainment 1,042 0.0% Total Operating Exp. $233,570 $ 55,026 27.1% 0.1% 867 0.1% 2015 %Sales 2014 %Sales 2013 %Sales 27.9% $226,277 35.0% ===== Revenue $835,295 100.0% $645,118 100.0% S202,232 100.0% Cost of Sales 3 518,805 62.1% 407,432 63.24 147,309 72.8% Gross Margin $316,490 37.9% $237,686 36.8% $54,993 27.2% BRANTS DECISION 28.0% 11,409 35.1% 9.9% 3,084 1.8% Net Earnings Pre-tax 82,920 (33) 27.2% Provision for Taxes 34,246 0.0% Net earnings after Tax 48,674 (33) 0.0% 5.8% 8,325 1.3% 14.4% $116,757 The new loan would bring the total of SCL's with Midi Capital to $300,000. Brant's report would have to be reviewed by his senior manager since the total loan amount exceeded his account man- ager's credit limit of $200,000. Brant had been with the company for eight months and it was important he made a well thought-out that followed CTF's minimum lending requirements. His report was due in a few hours. 18.1% 2.2% 15,556 2.4% Statements of Retained Earnings (Unaudited) For the Years Ending December 31 8,924 1.1% 6,858 1.1% 0.2% 1,500 0.2 2015 2014 Operating Expenses Salaries & Wages $120,259 26,362 13.0% General & Admin 8,512 2,058 1.0% Telephone & Fax 1,091 0.5% Legal & Accounting 1,491 800 0.4% Travel & Auto 9,430 0.0% Rent & Utilities 10,075 7,140 3.5% Bank Charges & Int 18,505 3,227 1.6% Bad Debts 1,302 0.0% 2013 1.1% 6,734 1.0% 1.2% 8,142 1.3% $ 8,171 $(154) 2.2% 17,127 2.7% 48,674 8,325 0.2% 2,841 0.4% Beginning retained earnings (121) Add: Net earnings after Taxes (33) Ending Retained earnings (154) $56,845 $8,171 ====== ==== 3 The cost of sales includes: the cost of operating the trucking fleet. These costs include fuel licenses, trip permits/toll payments, fine payments and mainte- nance of the trucking fleet. Source: Midi Capital Transportation Financial Division Exhibit 2 Exhibit 3 Balance Sheet (Unaudited) As of December 31 Financial Ratios For the years ending December 31 2015 2014 2013 LIABILITIES Current liabilities Accounts payable 13,676 Bank line of credit (50,00) $ 27,307 $ 15,881 Industry Average 2015 2014 201 ASSETS PROFITABILITY Return on average equity 0.0% 30.2% 52.6% 13. $ 4,230 $ 2.605 $ 27,307 $ 15,881 Total current liabilities 13,676 Long term liabilities Loan Nippissing Credit 1.56:1 2.2:1 4.2:1 42,004 28,230 STABILITY Debt/equity .23:1 Interest coverage 1.0x 189,000 273,000 N/A 5.5x Current Assets Cash 8,107 Accounts receivable 21,912 Other receivables 482 Prepaid expenses 16,237 Total Current Assets $46,738 1.7 429 478 Loan Midi Capital 36,000 15,065 12,820 1 $225,000 $273,000 Total long term liabilities S $ 61,728 $44,133 LIQUIDITY Current Ratio Acid test ratio Working capital $ 33,062 1.1:1 .9:1 N/A 2.3:1 2.8:1 1.7:1 1.9:1 $ 34,421 3.4 2.2 $ 28.2: S252,307 $288,881 TOTAL LIABILITIES $ 13,676 463,800 426,500 EFFICIENCY $ 60,000 S 5,480 5,480 42.6 days 18 days 16 Fixed Assets Trucks & trailers (cost) 95,000 Fixtures (cost) 5,480 Company vehicle (cost) 21,500 Computer (cost) 40 days 8,171 Age of receivables5 days Age of payables days 21,500 21,500 N/A 19 days OWNERS EQUITY Share Capital $ 60,000 60,000 Retained Earnings 56,845 (154) Total Owners equity $116,845 $ 59,846 TOTAL LIABILITIES AND OWNERS EQUITY $369,845 $ 73,522 14 days 3,200 3,200 $ 68,171 GROWTH 143,761 2014-20152013-2014 $357,052 $312.919 Less Accumulated depreciation 186,556 95.196 Total fixed assets (net) $307,424 $26,784 TOTAL ASSETS $369,152 $72,522 4 Compiled from Dunlop & Bradshaw industry norms and key Business ratios, trucking Local & long distance 2015. 5 Age of receivables is based on average daily sales and 365 days per year. 6 Age of payables is based on average daily cost of sales and 365 days per year. $357,052 Source: Midi Capital Transportation Financial DivisionStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started