Prepare complete pro forma forecast of great lakes

Assignment Help Finance Basics

Reference no: EM131404426

Assignment:

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?

Expectations for assignment

Accuracy - there are no errors in calculations and data entry.

Technical -The model is fully dynamic and exhibits advanced technical competency.

Formatting- The model is expertly formatted, with good use of color and fonts. There are no inconsistencies. The model is very clear and easy to follow.

Completeness - The analysis provided in the model is complete in that all parts of the assignment are fully addressed.

Attachment:- Assignment Files.rar

Reference no: EM131404426

Questions Cloud

Discuss the concepts of a break-even point and cvp analysis : Discuss the concepts of a break-even (BE) point and CVP analysis and why they are important in business. Give appropriate examples to support your views.

Explain the value of preparing contribution income statement : ACC 304- Explain the value of preparing a contribution income statement. Describe the concept of sensitivity analysis and explain the value of applying it during any budgeting process.

Analyze the information disclosed in delta airlines notes : Analyze the information disclosed in Delta Airlines' notes to their financial statements on property, plant, and equipment. Recommend additional data that Delta Airlines could include that would be useful to potential investors and creditors.

Discuss the highlights of the auditors report : What are the main strategic issues associated with the company that you have chosen? Discuss the highlights of the auditor's report. Do you see any links between corporate governance and auditing?

Prepare complete pro forma forecast of great lakes : 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

Give the answer of muliple choice question : The process used by criminals to convert funds acquired illegally into what appears to be legitimate income that can the used for legal purposes such as investment and purchase, is an example of:The movement of mood altering substances from their p..

What is the difference between roi and roce ratios : What are some ways you can express the accounting equation? What is Agency theory and what is it primarily concerned with? What is the difference between ROI and ROCE ratios?

Determine the mechanical properties of composite materials : Design and describe test methods to determine the mechanical properties of composite materials subjected to these environmental conditions.

How business can use information to improve its performance : Give your interpretation of what the ratios calculations show and how the business can use this information to improve its performance. Justify all answers.

Reviews

len1404426

2/23/2017 2:48:21 AM

Need to complete all questions on page 1 of spreadsheet. Also, need to complete pro forma forecast, income statements and year-end balance sheets. Accuracy -There are very few, if any, errors in calculations and data entry. Those errors that do exist have little bearing on the final analysis. Technical -The model is fully dynamic and exhibits advanced technical competency. Formatting -The model is expertly formatted, with good use of color and fonts. There are few, if any, inconsistencies. The model is very clear and easy to follow. Completeness -The analysis provided in the model is complete in that all parts of the assignment are fully addressed.

Write a Review

Required(*) Message

User Account

All Pages