Finance: Planning and Forecasting

A1. This financial analysis is for Competition Bikes that was taken from balance sheets and income statements from years 6, 7 & 8.

The rise in revenue was rapid starting from the year of operations. The key period of business was from April to September were revenues were equal to 65% of total revenue as the product was seasonal. The basis of forecasting for the year 1981 & 1982 is the expectations of sales by Mr. Turner & Mr. Rose. It is given that total sales were $ 15.80 million in first half of year 1981 and the total sales in 1981 to reach $ 30 million. Profit after tax was expected to be $ 1 million for 1st half and we assumed for the next half, profit will be in proportion to first half & expected to be amounting to $ 0.90 million. For year 1982, the sales expectation by Mr. Rose was around more than $ 71 million &

3. Was the firm able to generate enough cash from operations to pay for all of its capital expenditures?

Net income on the income statement: $2,377,000,000 ($5.37 per share), which is an increase of 15% compared to 2014.

The Total Current Assets for Competition Bikes is 36.8% in year 8 up from 31.5%, showing that the company has enough funds to settle current debt. Specifically Works in Process Inventory and Raw Materials Inventory remains unchanged from year 7 to 8, this shows that even with a decrease in sales the company is slow moving and has not adjusted inventory to sales. The company has accrued more debt from year 7 to year 8 seeing an increase of Total Current Liabilities moving from 5.4% to 7.0%.

cash receipts. Its total worth was $2.8 billion. Of this, 60% came from farm sales of milk and

Date: Name: ID: Answer the following Questions: 1. Tower Inc. owns 30% of Yale Co. and applies the equity method. During the current year, Tower bought inventory costing $66,000 and then sold it to Yale for $120,000. At year-end, only $24,000 of merchandise was still being held by Yale. What amount of inter-company inventory profit must be deferred by Tower? A. $6,480 B. $3,240 C. $10,800 D. $16,200 E. $6,610 2. All of the following statements regarding the investment account using the equity method are true except A. The investment is recorded at cost B. Dividends received are reported as revenue C. Net income of investee increases the investment account D. Dividends received reduce the investment account E.

Customers come to this restaurant because of the good Italian food at a low price – you can get a meal for $7, including drinks. Customers also eat at Papa Geo’s due to the cleanliness of the facility, the speed of getting their seat and food, and the vending machines which keep the children busy while adults enjoy their meal.

- Merlo, Inc. maintains a debt-equity ratio of 0.25 and follows a residual dividend policy. The company has after-tax earnings of $3,800 for the year and needs $3,200 for new investments. What is the total amount Merlo will pay out in dividends this year?If debt = 0.25 and equity = 1, then debt + equity = 1.25. Equity portion of new investments = $3,200 × (1 / 1.25) = $2,560.00

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

$15.3 million. The return on average invested capital in 1984 was around 20%. Over the past five

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.

Net income totaled $97.8 million in 1984, an increase of 5% from 1983.when looking at the Consolidated Balance Sheet (Exhibit2), we found that the total assets grew 15% to $2.7 billion at the end of fiscal 1984 due to addition of real estate inventories as part of the acquisition of another company. The ratio of debt to total capitalization jumped to 43% at 1984 from 20% at previous year.

For the year 2007 the total asset was $423,504 and total equity is $302,115 which is equal to 28.6%. This is not bad for any company but considering the Banks point of view it would be a lot better if it was higher that 30%.

Before the firm became bankrupt, they had more than $275 billion in assets under management. Furthermore, since the time the bank went public in 1994, the firm had increased net revenues over 600% from $2.73 billion to $19.2 billion and increased its employee headcount over 230% from 8,500 to almost 28,600 (Demyanyk, Y. S. and Hemert, O. V. 2008).