[Type the company name] | Mark X Company (A) | Financial Analysis and Forecasting | | labtech | [Pick the date] |
Analysis Analyzing Mark X Company’s financial statements and projecting the expected numbers for the coming years we make a decision on whether or not Mark X Company qualifies for the loan extension of $6,375,000.
The strength of Mark X as a company is its fixed assets turnover ratio, which rose from 1990 to 1992. This tells us Mark X 's ability to generate net sales from each addition of a fixed asset. Sales generated from the fixed assets are greater than the costs of the fixed assets, which imply that the fixed assets that were purchased are good investments for the company. This is really the only positive
…show more content…
One of the major factors in the possible denial of the new loan is the lack of payments on their short term loans. Mark X could pay off their outstanding short-term loans by the end of 1993. The 1993 forecasted balance sheet shows a cash balance of $35,874 (all dollar values in thousands). Their current outstanding short term bank loans are projected to be $24,608. Assuming that the company can survive on a cash balance of $11,266, it would be possible for Mark X to pay off all the short term debt by the end of the year. There is a potential that the bank could withdraw its line of credit and demand immediate repayment of the two existing loans. If that happens, Mark X has very limited plans of action. If the bank were to demand immediate payment of all outstanding loans, Mark X would have a real mess on their hands. They would need to make payments of $18,233 for the short term debt and $9,563 for the long term debt. This means that Mark X would need to pay $27,796 within a period of 10 days. Their total ending cash at the end of the 1992 year is only $3,906 which would only be a small chunk of the outstanding loans. The company now would be forced to demand payment from their accounts receivables which are valued at $29,357 and would cover the total of the loan. However, they would need to collect the entire amount in under 10 days to pay the bank back. If they do not succeed in obtaining the $27,796, their only other option
revolving loan (such as a large line-of-credit or a car loan), which would make it harder for them
The company has an agreement with a bank that allows the company to borrow the exact amount needed at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. At the end of the quarter, the company will pay the bank all of the accrued interest on the loan and as much of the loan as possible while still retaining at least $50,000 in cash.
received claims totaling $0.75 million for medical care costs incurred before December 31, 2010. Line of Credit Modification As of December 31, 2010, Shakespeare had a line of credit with a bank of $8 million (with a $10 million maximum amount available) due in approximately three years from the balance sheet date. Interest accrues on amounts drawn under the line at the London Interbank Offered Rate (LIBOR) (subject to a 3.5 percent floor) plus 7.5 percent per year. Shakespeare is also required to pay a commitment fee equal to 2 percent per year on the portion of the line of credit that was not drawn upon. On March 1, 2011, the Company completed its modification of the terms of the line of credit with the bank to finance the acquisition of a competitor printing and publishing company (see further facts of acquisition below). The key modified terms are as follows: • • • • The maximum amount available under the line of credit was increased from $10 million to $20 million. The term was
The Lawsons’ efficiency ratios are another section the bank will find troubling. The company’s age of payables has nearly tripled over the last four years. This can be detrimental to the company’s image and reliability including their reliability toward the bank if granted the loan. Along with increasing age of payables is increasing age of receivables and age of inventory. Indicating that Mr. Mackay is taking longer to collect his receivables and that he has purchased too much inventory. Too much inventory results can result in further issues
2. Forecast the firm’s financial statements for 2002 and 2003. What will be the external financing requirements of the firm in those years? Can the firm repay its loan within a reasonable period? In order to forecast the financial statements of 2002 and 2003, the following assumptions need to be made. The growth of sales is 15%, same as 2001, which is estimated by managers. The rate of production costs and expenses per sales is constant to 50%. Administration and selling expenses is the average of last 4 years. The depreciation is $7.8 million per year, which is calculated by $54.6 million divided by 7 years. Tax rate is 24.5%, which is provided. The dividend is $2 million per year only when the company makes profits. Therefore, we assume that there will be no dividend in 2003. Gross PPE will be $27.3 million (54.6/2) per year. We also assume there is no more long term debt, because any funds need in the case are short term debt, it keeps at $18.2 million. According to the forecast, Star River needs external financing approximately $94 million and $107 million in 2002 and 2003, respectively. In order to analysis if the company can repay the debt, we need to know the interest coverage ratio, current ratio and D/E ratio. The interest coverage ratios through the forecast were 1.23 and 0.87 respectively, which is the danger signal to the managers, because in 2003, the profits even not
The third scenario involves the same $100 million borrowing capacity:, only each draw does not have its own maturity date specified. Instead, whatever outstanding balance remaining is due by the end of the three-year credit line term, or December 31, 2012. The first draw is made on June 30, 2010, in the amount of $70 million. Another draw for $15 million is made on September 30 of the same year, followed by another draw for $15 million on November 30. The only repayment made by Buck is that made on December 15, 2010, in the amount of $50 million.
The company lost money almost every year since its leveraged buyout by Coniston Partners in 1989. The income generated was not sufficient to service the interest expenses of the company which stood at $2.62B in 1996. From Exhibit 1, we can say that interest coverage ratio computed as EBIT / Interest Expense was 1.31 in 1989 and has been decreasing over years and currently stands at 0.59. This raises a question of how the company can meet its interest payments without raising cash or selling assets.
The reason why Butler Lumber Co. is considering finding a different line of credit is because they’ve nearly exhausted all their usable credit with Suburban National Bank, using up $247,000 of the $250,000 of the credit limit. To compile this issue, the bank is wishing to secure the loan with some of Butler’s property. Considering the company’s large debt ratios, they have decided to check with Northrop National Bank’s offer to extend their line of credit by $215,000.
Mark X would be able to retire all of the outstanding short-term loans by the end of 1993. The forecasted balance sheet for the year 1993 shows a cash
The company currently faces serious financial challenges. It was struggling with declining sales and increasing costs. Since 2004, revenues had fallen by more than 40% while costs especially for employees health insurance, maintenance, and utilities climbed. Credits and loans had been borrowed to
The Standard Oil Company of California(Socal) is trying to determine how much to bid on the Gulf Oil Corporation. George Keller, the CEO of Socal, would need to borrow 14 billion dollars in order to make a substantial bid. While banks are willing to lend the money because of Socal's low to debt ratio, the loan would put the company in a highly leveraged position. In order to alleviate that debt, some of Gulf's assets could be sold. Keller has to consider the value of Gulf's exploration and development program when calculating future returns. Two billion dollars were being spent on the exploration and development program. This money could instead be used to reduce the debt if Socal acquired the company. However, the exploration program
Chevron operates in the hydrocarbon industry, where it is one of the world's largest companies with sales of $241.9 billion and net income of $26.18 billion. It is the conclusion of this analysis that a creditor should lend Chevron an additional $20.9 billion. The company has the liquidity, solvency and the cash flow to pay back this amount of debt. The company currently finances its operations largely from operating cash flows, with a small amount of long-term debt. This low debt level has left the company with a balance sheet strong enough to withstand a further $20.9 billion in debt. As a lender, it has been found that Chevron meets all of the lending
The main problem of the company is that it couldn’t liquidate a seasonal working capital loan for the requisite 30 days each year. It reflects the company doesn’t have sufficient cash and they need more loan but the bank is reluctant to give any unless the company can give a reliable financial plan to show they can pay off their loan by the end of 2012. So, Mr Malik came up with a financial forecast for the month to month operation to gain the bank’s trust. Sadly, the forecast portrays it cannot afford to pay off its debt by end of 2012 and would owe a balance of IND 3,858.00. This
It’s noticeable how the company’s operations have been deteriorating as they are having a more difficult time translating sales into cash. Their A/R turnover is not where it needs to be, and in line with that, their liabilities are increasing as well. The company has also been inefficient with the use of their assets as their current activity ratios are not up to par with the industry standards.
I have included the firm's original income statement and balance sheet without the purchase and then with the machine purchase. I have assumed that the firm would use the $218,000 to reduce the bank loans balance for each year. This reduction of the bank loan balance will lower their three restrictive financial ratios.