Reference no: EM131404448
Great Lakes Industrial Supply, Inc.
Chuck Kolias, Chief Financial Officer of Great Lakes Industrial Supply, Inc. was preparing for a meeting with his company's bank later in the week. At that meeting, Mr. Kolias intended to present a request that the bank grant Great Lakes Industrial Supply a five-year loan to finance anticipated growth in the company and the expansion of the company's warehouse facilities.
In preparation for his meeting, Mr. Kolias had gathered some recent financial statements for Great Lakes.
1. Based on Mr. Kolias' prediction of 20% sales growth in 2017 and 2018 and relying on other assumptions provided in the Great Lakes case, prepare complete pro forma forecast of Great Lakes' 2017 and 2018 income statements and year-end balance sheets. Assume that any new financing, if needed, will be in the form of bank debt. Assume that all debt (any exisitng or new debt) carries an interest rate of 10%.
2. How much does Great Lakes have to borrow in 2017? How much in 2018?
3. Assess the financial health of Great Lakes Indusrial Supply, Inc. in past and forecasted periods. Specifically, calculate the financial ratios defined in the worksheet financial ratios and interpret the results.
Will Great Lakes Industrial Supply be in a stronger or weaker financial condition two years from now?
4. Suppose that the proposed terms of the bank credit included a covenant (a contractual obligation that binds the borrower to specific actions or outcomes as a condition for extending a loan) that read as follows: "The company must maintain net working capital (defined for purposes of this loan as accounts receivable plus inventories minus accounts payable) of at least $4 million. For purposes of this covenant, net working capital will be measured at the end of each fiscal year." Is Great Lakes likely to be able to satisfy this covenant in both 2017 and 2018?
5. What would be the impact on Great Lakes' external funding needs and interest coverage (calculated as EBIT / Interest expense) as of the end of 2017 and 2018 if:
a. Inventory were not reduced by the end of 2017?
b. Great Lakes experienced higher growth in its revenues than was originally anticipated in 2017 and 2018?
c. Days receivables were reduced to 45 days?
d. Accrued Expenses were to grow less than expected in 2017 and 2018?
6. As a lender, would you be willing to loan Great Lakes Indusrial Supply, Inc. the funds needed to expand it warehouse facilities and finance its growth? Why or why not?
Attachment:- Assignment Files.zip
|
Discuss the trends and patterns in hate crime
: Over the last 15 years, the United States has enjoyed a steady decline in nearly every category of violent crime.The last few years, however, has seen a rising trend in the incidence of particular types of violent criminal activity. One area has se..
|
|
Write a first order linear model relating the mean value
: Write a first-order linear model relating the mean value of y, E(y), to two quantitative independent variables and four quantitative independent variables.
|
|
Discuss what is a form 990 and what is its focus
: Discuss what is a form 990, what is its focus, and what it's intended to do. Finally, compare the form 990 to a CCR or American Cancer Society annual report and discuss the different audiences/needs/users/purpose of same.
|
|
Write a complete second order linear model
: Write a complete second-order linear model relating the mean value of y, E(y), to two quantitative independent variables.
|
|
What would be the impact on great lakes external funding
: What would be the impact on Great Lakes' external funding needs and interest coverage (calculated as EBIT / Interest expense) as of the end of 2017 and 2018 if: Inventory were not reduced by the end of 2017
|
|
Write a model relating to a qualitative independent variable
: Write a model relating E(y) to a qualitative independent variable with two levels, A and B and four levels, A, B, C, and D Interpret the β parameters in each case.
|
|
Discuss about the inchoate offenses of conspiracy
: The police videotaped an apparent drug deal, wherein Beth sold a bag of apparent marijuana to Miriam. Both women were arrested and charged with drug offenses. The laboratory analysis of the apparent marijuana revealed that it was actually some dri..
|
|
How do the graphed curves relate to each other
: Graph the relationship between y and x1 for x2 = 0, 1, and 2.- Are the graphed curves in part a first-order or second-order?
|
|
List five red flags for fraud that internal auditors need
: Comment on Phil's preparation for and conduct of the audit. What should Phil have done differently? List five red flags for fraud that internal auditors need to be aware of.
|