Case #02: Kota Fibres LTD.
(Questions for Case Preparation)
The following questions will help you in the preparation and analysis of this case. Use these questions as a guide in your study of the case. However, do not limit yourselves to these questions only, but rather allow yourselves to expand your thinking and analysis of this case.
1. How did Mehta construct his financial forecast? Using the financial forecast, prepare to show the “cash cycle” of the firm (i.e., the flow of funds through the working-capital accounts of the firm).
2. Examine the exhibits in the case. On the basis of Mehta’s forecast, how much debt will Kota need to arrange for the coming year? Will Kota be able to repay the line of credit this year?
3. Why do
…show more content…
Mehta also prepared a forecast of cash receipts and disbursements. To prepare a forecast on a business-as-usual basis, Mr. Mehta used various parameters such as Cost of goods sold (a figure that was up from recent years because of increasing price competition), operating expenses (up from recent years to include the addition of a quality control department, two new sales agents, and three young nephews in whom she hoped to built an allegiance to the Pundir family business), the company's income tax rate, and the exercise tax.
Calculation using 2001 Forecast Annual Income Statements (Exhibit 2) and 2001 Forecast Balance Sheets (Exhibit 3)
Days Inventories Outstanding (DIO) = Inventories / COGS per Day = 2,225,373 / (66,993,380 / 365) = 12.12 ( Round Up = 13 Days
Days Sales Outstanding (DSO) = Account Receivable / Sales per Day = 3,715,152 / (90,900,108 / 365) = 14.92 ( Round Up = 15 Days
Days Payables Outstanding (DPO) = Account Payable / COGS per Day = 1,157,298 / 66,993,380 / 365) = 6.31 ( Round Up = 7 Days
Kota Fibres’ Cash Cycle = DIO + DSO – DPO = 13 + 15 – 7 = 21 Days
2. Total Debt Outstanding = 153,303,169 Total New Borrowings = 2,779,599 Total Kota Fibres’ Debt = Total Debt Outstanding + Total New Borrowings = 156,082,768
Total Sales = 90,900,108 Total Account
Figures are taken from the Income statement and Balance sheet as at 30 January 2009 and as at 30 January 2010.
4.How does Judge Jean Boyds reasoning in the local newspaper (in regards to why he didnt send Ethan to jail) relate to the novels to Kill a Mockingbird when Boo radley got in trouble? Use an examples from the article for your first piece of evidence, and an example from TKAM (pages 12-14) for you second piece of
Your managing partner has handed you the Supreme Court of Queenslands’ decision in The Public Trustee of Queensland and Anor v Meyer and Ors [2010] QSC 291 and asked you to answer the following questions. You should assume you are answering questions for someone who has not read the case, so be sure to provide sufficient detail in your answers. You do not need to provide reference details for Part A of the assignment.
* Our company’s sales forecast has been based on performance from previous years along with market circumstances. We are looking at the future of the business objectively which we then can evaluate past to
3) Do you agree with what was done in the case regarding the problem? Why or why not?
Please answer the questions following each of the cases or problems. The assigned questions should be answered thoroughly in your own words in essay format and submitted using the on-line testing system at www.agu.edu. The level of writing should reflect the graduate level and the content should reflect a solid understanding of the subject matter.
Note Exhibit 3, Year 2 cash flows, the “add total change in cash” is an incorrect number. It should be $1,371,350.
Name: ________________________________ Date: _________________ [1]BASIC BANK01 - BAT 003 Which of the following statements is true? A. An asset account is increased by a credit B. An expense account is increase by a credit C. A revenue account is decreased by a credit D. An equity account is decreased by a debit [2]BASIC BANK02 - BAT 010 The Income Summary account contains: A. Total revenues and total expenses for the year B. Total assets and total liabilities at year end C. Total revenues, expenses, assets, and liabilities
This will be a basic forecast created from pro-forma financial statements, using basic forecasting procedures.
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
1. In the last five years the growth in sales for the company has been around 10% per annum, except for the 1997, the growth was 18.78%. In the case, nothing is mentioned that company has made any drastic changes in its strategy to grow faster. In such a scenario, projected a consistent growth of 20% per annum for the next 5 years is too optimistic.
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%.
The full report shows all the forecasting data for 2012 – 2016, it clearly estimate the financial trend of our company (attachment). For the data used in this model, some of them are current data, the other are historical or most recently or average number. It only depends on actually situation – for which method is much more realistic.
8. Times interest earned = (Net Income + Interest) in Statement of Operations / Interest in
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.