Reference no: EM131395336
Please read and analyzeTekno is a company involved in the Technology sector specializing in Data Storage and Computer Peripherals. The company is seeking a bank loan and so is preparing an internal assessment of its overall health, financial needs, as well as the potential for value enhancing future investments. Some initial data has been gathered (please see the Historical Financial Statements and Similars sheets in this file.
Your task is to implement the following analysis:
1. Provide an assessment of Tekno's overall financial health. For this part, you are encouraged to use as many of the tools we have covered as possible.
2. Provide an estimate of Tekno's financing needs for 2017.
I have to come up with a forecast ratio by using CAGR (compound annual growth) goal seek function of excel
3. Because the company needs to quantify its future value creation capability, you are also asked to estimate the company's Weighted Average Cost of Capital. You may assume the following:
a) Corporate tax rate for Tekno is 15%
b) Target Capital structure (D/V) for Tekno is 20%
c) The group of similar companies is as listed in the Similars sheet provided in this file.
d) To estimate the corporate tax rate for for the similars, you may use the actual taxes reflected in the most recent Income Statement found in Yahoo Finance.
e) For leverage calculation of similars, your D can be assumed to be equal to Total Debt as presented in Yahoo Finance
Instructor Notes:
1. The optimal format for this report is to provide two files: a word document with your responses and an excel document that contains your calculations.
2. The Word document should (a) clearly identify the question (in bold) and then proceed to provide the answer below it. (b) incorporate relevant tables, graphs or calculations within the body of the word document. In essence, your document should be self-contained in that I should be able to read and understand your analysis without having to continuously go to the excel sheet.
3. The excel sheet should present calculations in a well-structured and organized manner with your answers clearly marked (this is important, as I will not "chase" your answer). While your answers are actually presented in the word document, the supporting excel file will be used to check or clarify any calculation.
4. Please make sure to always explain your steps and clearly identify any additional references you may use. Regarding the former, keep in mind that showing how much you thought about the steps is more important than getting the "correct" answer. Show me that you understand what you are doing.
5. Keep in mind that the score will be a function of two criteria: (a) Did you address the question being asked? and (b) How does your response compare to others?
Attachment:- Project Handout.xls
|
Construct argument patterns - untenured college teachers
: Use the method presented in this section to construct argument patterns. If a statement is redundant or plays no role in the argument, do not include it in the pattern.- There is a lot of pressure on untenured college teachers to dumb down their co..
|
|
Complete a statistical analysis for your research project
: Create a plan for how you would run a statistical analysis for your Research Project. Please note that you will not actually complete a statistical analysis for your Research Project
|
|
Construct argument patterns - research leading development
: The following arguments were abstracted from newspaper articles, editorials, and letters to the editor.- Research leading to the development of a scramjet engine is worthwhile.
|
|
Success of an organization trying to establish
: What are the factors [discuss at last 3] that have an impact on the success of an organization trying to establish its business in a foreign country?" You must provide me an accessible link to your research.
|
|
Provide an estimate of teknos financing needs for 2017
: Provide an estimate of Tekno's financing needs for 2017 - estimate the company's Weighted Average Cost of Capital - Provide an assessment of Tekno's overall financial health. For this part, you are encouraged to use as many of the tools we have cove..
|
|
Exporting to europe for five years
: Imagine that you are working for a company that has been exporting to Europe for five years. The company now sees an opportunity to expand into Asia.
|
|
Which of four components of gdp had greatest positive impact
: In view of the weak economy of the last several years, explain which of the four components of GDP had, or is having, the greatest positive impact in our economy. Use the following historical tables to support your response.
|
|
Creates the objects into a separate method
: Move all the code that creates the objects into a separate method, called populateWorld, in the CrabWorld class. You need to declare the populateWorld method yourself (it takes no parameters and returns nothing) and call it from the constructor. T..
|
|
What factors affect physical development
: Address the following in relation to the selected stage: What factors affect physical development? Consider hereditary and environmental influences. Provide examples. What factors affect cognitive development? Consider hereditary and environmental in..
|