Shopping Cart
Your shopping cart is empty!
FIN 419 Week 5 Individual Assignment ICS Manufacturing Company Case Study
$15.00

FIN 419 Week 5 Individual Assignment ICS Manufacturing Company Case Study

This Tutorial was purchased 21 times & rated A+ by student like you.

 

This Tutorial contains following Attachments

  • FIN 419 Week 5 IA ICS Manufacturing Company Case Study.docx
  • FIN 419 Week 5 IA ICS Manufacturing Company Case Study.xlsx

ICS Manufacturing Company Case Study

 

ICS Manufacturing Company produces plastic parts for the automotive industry.  Here is their Income Statement for 2015 –

 

ICS Manufacturing Company

Income Statement for 2015

 

                                    Sales Revenue                                     $35,500,000

                                    Cost of Goods Sold                              12,725,000

                                    Selling, General & Admin Exp                         11,200,000

                                    Depreciation Expense                             3,200,000

                                    EBIT                                                       8,375,000

                                    Interest Expense                                        350,000

                                    Taxable Income                                       8,025,000

                                    Taxes                                                       3,210,000

                                    Net Income                                             4,815,000

 

Transfer this income statement to an Excel spreadsheet and begin to prepare a Pro Forma Income statement for 2016 based on the following information:

 

1.      Sales revenue to increase 5.2%, COGS to increase 4.5%, S,G&A will increase 3.8% and depreciation expense will be $3,255,000.  Assume interest expense to be $375,000 and taxes are to be 40% of taxable income.  You will now have income statements for 2015 and 2016 for ICS Manufacturing. 


 

This is the balance sheet information for ICS Manufacturing Company:

 

ICS Manufacturing Company

Balance Sheet for year ending December 31, 2015

 

            Assets                                                                            Liabilities                                                        

Cash                               $2,625,000                             Accounts Payable            $5,825,000

Accounts Receivable     $2,715,000                              Other Current Liabilities $3,365,000          

Inventories                     $1,514,000                               Total Current Liabilities   $9,190,000        

            Total Current Assets     $6,854,000                            

           

 

             Long Term Assets                                                      Long Term Liabilities

 P, P & E                     $12,745,000                                       Long Term Debt               $1,225,000                      Goodwill                        $1,205,000                           Other LT Debt                      $2,230,000

            Intangible Assets           $5,275,000                           Total LT Liabilities           $3,455,000

            Total LT Assets           $19,225,000                                       Total Liabilities                            $12,645,000

            Total Assets                $26,079,000                          

                                                                                               

 

                                                                                                Owners’ Equity          

                                                                                                Common Stock                $6,425,000

                                                                                                Retained Earnings            $7,009,000

                                                                                                Total Owners’ Equity     $13,434,000

                                                                                                Total Liab/OE               $26,079,000

           

Transfer this balance sheet to an Excel spreadsheet and begin to prepare a Pro Forma Balance Sheet for 2016 based on the following information:

 

2.      Cash will increase to $2,825,000 and accounts receivable will increase by 15%.  The inventories will go up 35% and P, P, &E will go up $2,000,000 with an expansion to the plant. Long term debt will increase to $2,000,000 to help finance the plant expansion and add $1,137,150 to other LT debt.. You will now have balance sheets for 2015 and 2016 for ICS Manufacturing.

 

 

Using the 2015 and 2016 financials for ICS, complete the following – show calculations and/or numbers you used to derive your answer:

 

3.      ICS wants to take around $400,000 of its cash and invest in marketable securities. They anticipate receiving around $7.5% interest on their investment and would like to have it held for 10 years. What will be the FV of this $400,000 investment?

 

4.      ICS believes they will only gain a 6% return on their $400,000 investment. Using the Rule of 72, how many years will it take to double their investment?

 

5.      ICS plans on expanding their plant and will fund $2,000,000. Part of the funding will come from cash, but the balance of $775,000 will be financed. The interest rate will be 5% and ICS plans on borrowing the funds for 4 years. Prepare a loan amortization schedule for the 4 years with 5% interest for the $775,000 and assume making one payment per year. Show the schedule.

 

6.      Using your 2015/2016 Income Statement and Balance Sheet, add a column for percentage of total.  Compute the percentages for each line item for the financial statements.  For the 2015 Income Statement, what is the percentage of COGS as compared to total sales? Is this figure reasonable and what is COGS and why is it important to a company?

 

7.      Financial Ratios provide information to analyze a company’s performance.  Solve the following ratios for 2015 and 2016 using the Income Statement and Balance sheets you prepared for ICS Manufacturing.

 

a.        Current Ratio – current assets/current liabilities

b.       Quick Ratio – (current assets – inventories)/current liabilities

c.        Cash Ratio – cash/current liabilities

d.       Debt Ratio – total liabilities/total assets

e.        Cash Coverage Ratio – (EBIT + depreciation/interest expense

f.        Inventory Turnover – cost of goods sold/inventory

g.       Receivables Turnover – sales/accounts receivable

h.       Total Asset Turnover – sales/total assets

i.         Profit Margin – net income/sales

j.         Return on Equity – net income/total owner’s equity

 

 

8.      Find the industry ratios for the company using the Dun & Bradstreet® Key Business Ratios.   Locate the Dunn & Bradstreet Database by accessing the University of Phoenix Library and then locating Library Resources. Click on Alphabetical List of Resources and find Dunn and Bradstreet. Click on the link and search for your selected company. ISC is a manufacturing company of plastic parts for the automotive industry – try and select a company closest to our company. Please use 3089 Plastic Products and NAICS of 326199 for manufacturing using 2014 data and the lower amount.  Only provide the Quick and Current Ratios from 2015/2016 from problem 7 and add the ratios from Dun & Bradstreet to compare and briefly suggest what direction ICS should head into with the comparison. 

 

 

9.      ICS plans to expand their operations as stated in Problem 5 – and are considering taking the loan – however, they have a few investors that are interested in lending money for this venture.  They need a total of $775,000, and if they lend the money today, ICS will repay it, with interest, at the end of the year.  Company A agrees to lend $300,000 and they require 5% interest, Company B will lend $200,000 at 6% interest, and Company C will loan the balance but they won’t settle for less than 10% interest.  What is the weighted average cost of this capital (WACC)? 

 

 

10. In 250-350 words, explain what cash flow is and why cash is so important to a business.  

Include in your analysis the cash that ICS maintains on hand and whether it is sufficient or not.

Write a review

Order Id


Order Id will be kept Confidential
Your Name:


Your Review:
Rating:   A   B   C   D   F  

Enter the code in the box below:



Related Tutorials
$25.00

This Tutorial was purchased 10 times & rated A+ by student like you.

FIN 419 Week 1 Individual Assignment Limited Liability Corporation and Partnership Paper (2 Papers) FIN 419 Week 1 DQ 1 FIN 419 Week 1 DQ 2 FIN 419 Week 1 DQ 3 FIN 419 Week 1 DQ 4 FIN 419 Week 1 Individual Finance lab FIN 419 Week 2 Individual Assignment &n..
$3.00

This Tutorial was purchased 0 times & rated No rating by student like you.

What would be the constraints specifically dealing with different currencies and market rate fluctuations? ..
$3.00

This Tutorial was purchased 2 times & rated B+ by student like you.

What is a multinational corporation?  What are some of the constraints facing today’s multinational corporations?  Predict how joint ventures and international mergers might address some of those constraints.   ..
$3.00

This Tutorial was purchased 2 times & rated B+ by student like you.

What would you consider to be a global equivalent(s) to the SEC within the USA?   Are there individual reporting requirements comparable?  Explain?   ..
$3.00

This Tutorial was purchased 2 times & rated No rating by student like you.

What is the SEC?  How does it impact financial decision-making?  What constraints might it put on a company?     ..
$3.00

This Tutorial was purchased 2 times & rated No rating by student like you.

What is EBIT-EPS analysis?  What is the indifference curve?  How is risk factored into the EBIT-EPS analysis?  What are the “basic short comings” of EBIT’s analyses?   ..
$3.00

This Tutorial was purchased 2 times & rated B+ by student like you.

What are the risks of having an excessive amount of financial leverage in an organization?  What is the degree of total leverage?   ..
$3.00

This Tutorial was purchased 3 times & rated No rating by student like you.

What is investment banking?  How would the investment banker assist an organization in going public?  As a CFO, what information would you need to select an investment banker?    ..
$3.00

This Tutorial was purchased 3 times & rated B+ by student like you.

What is the difference between operating and financial leverage?  What is the importance of assessing operating vs. financial leverage?   ..
$3.00

This Tutorial was purchased 4 times & rated B+ by student like you.

What is an asset?  What is a liability?  What is the difference between assets and liabilities?  Can an organization operate without current liabilities? Explain   ..
$3.00

This Tutorial was purchased 2 times & rated No rating by student like you.

What is zero working capital? How would you define zero working capital?  When would this methodology be used?  Would this model be applicable to all organizations? Explain.   ..
$3.00

This Tutorial was purchased 1 times & rated No rating by student like you.

How would the intrinsic value of assets differ from the market value? Explain. ..
$3.00

This Tutorial was purchased 2 times & rated B+ by student like you.

What is the difference between present values and future values?  How would you use present and future value techniques in preparing a financial plan for retirement?  How would various required rates of return affect your decision? Explain.   ..
$3.00

This Tutorial was purchased 2 times & rated B+ by student like you.

What is a loan amortization schedule?  How would you use it determine your loan interest rate?  What factors would impact your choice between two loans?   ..
$3.00

This Tutorial was purchased 2 times & rated No rating by student like you.

What are the three key inputs to the valuation model?  How would you determine the valuation of an asset? How would the intrinsic value of assets differ from the market value? Explain.   ..
$3.00

This Tutorial was purchased 2 times & rated B+ by student like you.

What are some risk management techniques?  How would you use portfolio management to assess the risk and return of an investment?    Predict how the results would be different based on different risk preferences?   ..
$3.00

This Tutorial was purchased 0 times & rated No rating by student like you.

Based on your assessment of risk using portfolio Management, what factors would you use to make different risk preferences? ..
$3.00

This Tutorial was purchased 4 times & rated A by student like you.

What is a limited liability corporation? What is a limited liability partnership?    What are the differences?  What are the advantages and disadvantages of each?   ..
$3.00

This Tutorial was purchased 2 times & rated B+ by student like you.

What is a sensitivity analysis?  What is a scenario analysis?  How would you apply each one to a potential investment opportunity?  How would you use the information from this analysis? Explain.    ..
$12.00

This Tutorial was purchased 6 times & rated A by student like you.

True/False (1point each) 1. The sole proprietor has unlimited liability; his or her total investment in the business, but not his or her personal assets, can be taken to satisfy creditors.    2. Time-value of money is based on the belief that a dollar that will be received a..
$9.00

This Tutorial was purchased 6 times & rated A by student like you.

P9-7 Net present value. Quark Industries has a project with the following projected cash​ flows:     a.  Using a discount rate of 9​% for this project and the NPV​ model, determine whether the compan..
$9.00

This Tutorial was purchased 11 times & rated A by student like you.

This Tutorial contains excel sheet   P10-4 (similar to)               Opportunity cost. ​ Richardses' Tree​ Farm, Inc. has ..
$9.00

This Tutorial was purchased 5 times & rated A by student like you.

This Tutorial comes with a excel sheet   P3-1 Future Value.   Fill in the future values for the following table using one of  the three methods below: a.       Use the future value formula, FV = PV*(1+r)n. b.   &..
$9.00

This Tutorial was purchased 9 times & rated A by student like you.

This Tutorial contains excel sheet     P 11-1 Eric has another​ get-rich-quick idea, but needs funding to support it. He chooses an​ all-debt funding scenario. He will borrow $3683 from​ Wendy, who will charge him 7% on the loan. He will also borrow ​$3165 from​&nb..
$15.00

This Tutorial was purchased 6 times & rated A by student like you.

) Risk and probability Micro-pub, Inc., is considering the purchase of one of two microfilm cameras, R and S. Both should provide benefits over a10-year period, and each requires an initial investment of $4,000. Management has constructed the following table of elements of rates of return and pos..
$8.00

This Tutorial was purchased 9 times & rated B+ by student like you.

In case different Questions/problems are asked by your instructor just email me   Complete the following problem sets in Financial Management using Microsoft® Excel®: Chapter 7 : 5, 15 Chapter 9 : 10 Chapter 11 : 12 Chapter 16: 9, 10..
$9.00

This Tutorial was purchased 18 times & rated A+ by student like you.

Read the "Mini-Case Biocom, Inc.: Part 2, Evaluating a New Product Line" from the end of Chapter 10 of Financial Management: Core Concepts. Complete questions 1-7 in Microsoft® Excel. Evaluate the following in a 350-word response: Explain what depreciation, cas..
$7.00

This Tutorial was purchased 0 times & rated No rating by student like you.

This Tutorial contains 2 Papers   Research two companies' financial statements from one of the following industries: Airline Automotive Pharmaceutical Oil/gas Retail Computer Hardware Analyze table 14.8 in Financial Managemen..
$9.00

This Tutorial was purchased 4 times & rated B+ by student like you.

Complete the following problem sets in Financial Management using Microsoft® Excel®: Chapter 2: 1, 2, 3, 4 Chapter 5: 1, 3, 5, 7 Chapter 5: Advanced Problems 1a and 1b Chapter 14: 9, 10, 11, 12 Format your assignment consistent with AP..
$9.00

This Tutorial was purchased 3 times & rated A+ by student like you.

Review the "Richardses' Tree Farm Grows Up - Mini Case" located in Chapter 1 of Financial Management: Core Concepts. Develop a 1,050-word analysis of the case study. Include the following: Analyze whether the major financial management decisions of the Richards..
$8.00

This Tutorial was purchased 3 times & rated No rating by student like you.

With Excel File (This Tutorial contains excel file to solve question for any values)   P18-1 Foreign exchange and commodity prices.  While traveling in the following​ countries, you see​ twenty-ounce plastic bottles of​ Coca-Cola. You know the price in the United S..
$12.00

This Tutorial was purchased 5 times & rated A+ by student like you.

Ch 10 Advanced Problem 2 Chapter 13 Problem 18 Chapter 12 Problem 17 Ch 11 Advanced problem 1   ADVANCED PROBLEMS FOR SPREADSHEET APPLICATION These problems are available in MyFinanceLab. 1. Erosion costs. Ice Cream City plans to introduce a new flavor, w..
Fin419Assist © 2017 All Rights Reserved.Powered by:Webzindagi.