Brigham Mini Case Solution Chapter 14 (Indonesia)

First, the projected cash flows range from $21.2 million in 2007 to $29.5 million in 2011 as shown in the data exhibit ‘DCF model.’ To generate these numbers Liedtke’s base case performance projections are used for the projected 2007 – 2011 net revenue numbers and the estimated depreciation and then his projections for Balance sheet accounts were used to determine the current net working capital and capital expenditure as in the exhibit ‘Financial statements.’ These projections were based by Liedtke under the following assumptions, women’s casual footwear would be wound down within one year and the historical corporate overhead-revenue ratio would conform to historical averages. These annual cash flows give us a PV (Cash flows) of $96.15 million over the next 5 years.

This step involves short and long term debt equity analysis. The proportion of equity capital depends on the possessing and additional funds will be raised. The choice of the source of funds the company has are the issue of shares and debentures, loans to be taken from banks and financial institutions and public deposits to be drawn in form of bonds. The choice will depend on relative merits and demerits of each source and period of financing. The management of the investment funds is key in allocating that the funds are going in the correct place. The profits that are made can be down in two ways dividend declaration which includes identifying the rate of dividends and retained profits in which the volume has to be decided which will depend upon expansion and diversification of the company. The management of cash is another important function. Cash is needed for all different aspects of the company such as payment of salaries, overhead and bills. All of these are important in a company and how successful the financial aspect is going to be.The financial management practices include capital structure decision, investment appraisal techniques, dividend policy, working capital management and financial performance assessment. A company needs to have well financial in order to be successful. “A company that sells well but has poor financial management can fail.” (Johnston)

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 &

1. Using the historical data as a guide (Exhibit 6.1), construct a pro forma (forecasted) profit and loss statement for the clinic's average month for all of 2010 assuming the status quo. With no change in volume (utilization), is the clinic projected to make a profit?

No, Mr. Clarkson’s estimation for loan requirements ($ 750K) is not enough. He needs to borrow more than $ 750K. As you can see from our 1996 pro-forma Balance Sheet (with discount, without discount, respectively), in the both of cases, the company still needs more than $750K from bank to meet their financial needs. In case of not taking all trade discount, (1996 pro-forma without discount) the company needs to borrow $ $905K, on the other hand, in no trade discount case, the company even needs more money ($1,112K) to finance their expected expansion. (Please refer to attached excel file for 1996 pro forma B/S and I/S.)

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

2. Based on Mr. Martin’s prediction for 1996 sales of $28,206,000, and for 1997 sales of $33,847,000 and relying on the other assumptions provided in the Tire City case, prepare complete pro forma forecasts of TCI’s 1996 and 1997 income statements and year-end balance sheets. As a preliminary assumption, assume any new financing required will be in the form of bank debt. Assume all debt (i.e., existing debt and any new bank debt) bears interest at the same rate of 10%.

INPUT DATA: Amount Needed to Raise Flotation Costs Stock Offer Price Market Value/Book Value Ratio (Dollars in thousands) Assets Cash U.S. Treasuries Mortgage-backed Securities Municipal Bonds Government Agency Securities Total Cash & Securities Residential Mortgage Loans Consumer Loans Business Loans Total Loans Fixed Assets Total Assets Liabilities Passbook Savings Non-interest Checking N.O.W. Accounts Money Market Accounts Certificate of Deposits Total Savings Borrowed Money Other Liabilities Total Liabilities Capital Stock ($100 par value) Retained Earnings Total Equity Total Claims Loan Loss Reserve Allowable Risk Adjustment Weights: No default risk Low default risk Res. loans &

Rajat Singh, a managing director at Hudson Bancorp, needs to find a way to rejuvenate the paper check corporation. One main part that needs to be calculated is the appropriate mixture of debt and equity for the firm. The company needs to determine the correct mixture so that they can both minimize the cost of capital and increase the shareholders value. I will analyze the current and future situation of the company, trying to find the correct credit rating to use that will increase income. With the new credit rating, I will be able to recommend a certain amount of debt for the company to take on and be profitable.

We assume linear increase in the EBIT and EBITDA at 3% for 1999 from 1998 figures. Considering the debt will be long-term, we test both 10- and 20-year corporate yields as interest rates to see what would be the coverage ratios, using the 1999 projected figures.

3. Refer to the monthly sales forecasts given in the first Table. Assume that these amounts are realized and that the firm’s customers pay exactly as predicted.

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

4. In Tab #4, why are financing requirements less than the total growth in assets? (The same issue arises in Tab #3)?

The purpose of this assignment is to study the finance sources available to a company. Here according to the assignment requirement, we have to select a British public company to study the available sources of finance from where the firm collects its capital requirement. Following the guidelines we have to analyze various sources with their potentiality and then we make viable analysis of Cash and sales budget. Here some salient financial ratios are employed for the purpose of analyzing the financial statement of the company.

Filem ‘Indie’ adalah filem bebas yang dihasilkan oleh pengarah bebas yang menekan aspek seni dan aspek kehidupan sekeliling. Di sini filem ‘Indie’ di Malaysia juga terdapat nilai keseniannya yang tersendiri sama seperti filem-filem yang dihasilkan oleh pembikin filem yang lain. Terdapat banyak cabaran yang dihadapi oleh pembikin-pembikin filem ‘Indie’ di Malaysia dalam mengharungi kemelut industri filem tempatan. Cabarannya di sini adalah seperti masalah ego pembikin filem ‘Indie’ itu sendiri, tentang menghadapi konflik dengan kerajaan dan permasalahan dengan masyarakat. ‘Indie’ atau dalam perkataan penuhnya ‘Independent’ dan semua sudah sedia maklum bahawa ‘Independent’ bermaksud bebas atau berdiri sendiri menurut