1) Accounting Component a) Obtain the most recent ten years of annual total sales (total revenue)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1) Accounting Component a) Obtain the most recent ten years of annual total sales (total revenue) data from the firm's financial history. In addition, use just the last three years for the firm's financial statement data: I recommend, you use abbreviated financial statements. They can be found in Nasdaq.com, Yahoo Finance, MSN Money. DO NOT GET BOGGED DOWN IN THE DETAILED OF THE AGGREGATE FINANCIALS i) Income Statement ii) Balance Sheet iii) Statement of Cash Flow b) Derive common size statements for the income statement and the balance sheet NOT the cash flow i) Looking at trends in the data ii) Looking at variations in the same data as well as variations in the trends 2) General Component a) No more than one paragraph describing the history and industry of the company. 3) Economic Component a) How does the above relate to the industry that the company is in, i.e. need to perform competitive economic analysis about the company: i) Macroeconomic analysis----is the company's sales cyclical or counter cyclical for example? ii) Industry analysis---market share. Are the company's sales growing, declining, or staying the same? How is the company performing relative to its competition? 4) SWOT a) STRENGTHS and WEAKNESSES should focus EXCLUSIVELY on the INTERNAL CHARACTERISTICS OF THE FIRM'S FINANCES. b) The OPPORTUNITIES and THREATS should focus EXCLUSIVELY on the EXTERNAL CHARACTERISTICS OF THE FIRM'S FINANCES. 5) Trends and Deviations in the company's historical data 6) Finance Component a) The PERCENT OF SALES MODEL and the above should provide you the assumptions for deriving proformas for each of the three financial statements (balance sheet, income statement, and statement of cash flow), and will allow you to do your critical financial analysis of the firm. i) The pro forma, must be forecasted out three years. ii) Make sure you focus on your assumptions and EXPLICITLY show them since they will drive your forecasted data, which will allow you to perform the critical analysis where the company is going, based on your forecasted data INCLUDING THE FORECASTED SHARE PRICES. iii) This should be the focus of your written analysis; stated differently, the focus needs to be on the future of your company and where it is going and why. b) The emphasis should not be on the history of the company, other than what I have asked you to include, that is stated above. c) Finally, in your analysis you need to justify your conclusions. For example, is the company in a strong financial position based on its EXPECTED SHARE PRICES and MARKET CAPITALIZATION? Why or why not? What direction does the company need to go in either case? These are some of the questions that need answered. 1) Accounting Component a) Obtain the most recent ten years of annual total sales (total revenue) data from the firm's financial history. In addition, use just the last three years for the firm's financial statement data: I recommend, you use abbreviated financial statements. They can be found in Nasdaq.com, Yahoo Finance, MSN Money. DO NOT GET BOGGED DOWN IN THE DETAILED OF THE AGGREGATE FINANCIALS i) Income Statement ii) Balance Sheet iii) Statement of Cash Flow b) Derive common size statements for the income statement and the balance sheet NOT the cash flow i) Looking at trends in the data ii) Looking at variations in the same data as well as variations in the trends 2) General Component a) No more than one paragraph describing the history and industry of the company. 3) Economic Component a) How does the above relate to the industry that the company is in, i.e. need to perform competitive economic analysis about the company: i) Macroeconomic analysis----is the company's sales cyclical or counter cyclical for example? ii) Industry analysis---market share. Are the company's sales growing, declining, or staying the same? How is the company performing relative to its competition? 4) SWOT a) STRENGTHS and WEAKNESSES should focus EXCLUSIVELY on the INTERNAL CHARACTERISTICS OF THE FIRM'S FINANCES. b) The OPPORTUNITIES and THREATS should focus EXCLUSIVELY on the EXTERNAL CHARACTERISTICS OF THE FIRM'S FINANCES. 5) Trends and Deviations in the company's historical data 6) Finance Component a) The PERCENT OF SALES MODEL and the above should provide you the assumptions for deriving proformas for each of the three financial statements (balance sheet, income statement, and statement of cash flow), and will allow you to do your critical financial analysis of the firm. i) The pro forma, must be forecasted out three years. ii) Make sure you focus on your assumptions and EXPLICITLY show them since they will drive your forecasted data, which will allow you to perform the critical analysis where the company is going, based on your forecasted data INCLUDING THE FORECASTED SHARE PRICES. iii) This should be the focus of your written analysis; stated differently, the focus needs to be on the future of your company and where it is going and why. b) The emphasis should not be on the history of the company, other than what I have asked you to include, that is stated above. c) Finally, in your analysis you need to justify your conclusions. For example, is the company in a strong financial position based on its EXPECTED SHARE PRICES and MARKET CAPITALIZATION? Why or why not? What direction does the company need to go in either case? These are some of the questions that need answered.
Expert Answer:
Answer rating: 100% (QA)
1 Accounting Component a Obtain the most recent ten years of annual total sales total revenue data from the firms financial history In addition use just the last three years for the firms financial st... View the full answer
Related Book For
Statistics for Managers Using Microsoft Excel
ISBN: 978-0133130805
7th edition
Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat
Posted Date:
Students also viewed these accounting questions
-
Please discuss on the process of order entry involves with traditional ways and electronic method . Statement: In logistics management, information technology (IT) plays a critical role. The system...
-
A new project has an initial cost of $136,000. The equipment will be depreciated on a straight-line basis to a book value of $41,000 at the end of the four-year life of the project. The projected net...
-
Firms should obtain as much financing as possible from suppliers through accounts payable because it is a free source of funds. Do you agree? Why or why not?
-
Which of the following divisions of plants does NOT have a well differentiated body? A) Gymnosperms B) Bryophyta C) Thallophyta D) Pteridophyta
-
Clarksdale has a property tax rate of $17.20 per $1,000 of assessed valuation and expects an increase in expenses of $197,500 over the current commitment of $6,985,000. The city must increase the tax...
-
Miles per hour at which a car is traveling Classify the variable as qualitative or quantitative.
-
A consumer advocacy agency, Equitable Ernest, is interested in providing a service that allows an individual to estimate their own credit score (a continuous measure used by banks, insurance...
-
You have just received a report suggesting that a chemical your company uses in its manufacturing process is very dangerous. You have not read the report, but you are generally aware of its contents....
-
1. The marital deduction: a. What is the marital deduction? b. How is the marital deduction "unlimited"? c. What requirements must be met in order to obtain the marital deduction? d. Why does the use...
-
Moravanti Italian Imports has four employees and pays biweekly. Assume that box 2 is not checked for L. Torabi and R. Beninati and is checked for G. Fisher and J. Tillman. Required: Complete the W-4...
-
Section 37 of the Design and Building Practitioners Act 2020 (NSW), What does the act try to achieve? Why did they introduce it? What is section 37 specifically? How does this affect common law?
-
Suppose a 20-year Treasury bond with 5% semiannual coupon is currently traded at a yield of 6% (APR). 1) Is the price above or below 100? 2) What is the current price of the bond? 3) If the yield...
-
Suppose the exchange rate between U.S. dollars and Swiss francs is CHF 0.92 = $1.00, and the exchange rate between the U.S. dollar and the euro is $1.00 = 0.84 euro. What is the cross rate of Swiss...
-
1. Change and list directories. a. Change the directory to the /etc directory. (3 marks) b. Display your current working directory. (3 marks) c. How do you go to the root directory? (3 marks) d. List...
-
Interserve and Kier Group can borrow for one year at the following rates: Interserve Kier Group Fixed rate 4.50% 5.10% Floating rate LIBOR + 0.15% LIBOR + 0.35% Calculate the quality spread...
-
What are the key advantages of a deposit account over a money market account? What are the key advantages of a credit line with a bank over commercial paper issuance? Before the 2008 Financial...
-
Albert skis down a hill at an angle of 19. He has a mass of 101 kg. What is the normal force on Albert?
-
The power company must generate 100 kW in order to supply an industrial load with 94 kW through a transmission line with 0.09 resistance. If the load power factor is 0.83 lagging, find the...
-
Students in a business statistics course performed a completely randomized design to test the strength of four brands of trash bags. One-pound weights were placed into a bag, one at a time, until the...
-
The file contains the percentage alcohol, number of calories per 12 ounces, and number of carbohydrates (in grams) per 12 ounces for 150 of the best-selling domestic beers in the United States. For...
-
The U.S. Department of Transportation maintains statistics for mishandled bags per 1,000 airline passengers. In May 2012, Delta mishandled 1.93 bags per 1,000 passengers. What is the probability that...
-
Suppose Starbucks is considering introducing a new low-calorie blended coffee drink called FrapZero. The firm believes that the drinks flavor and appeal to calorie-conscious drinkers will make it a...
-
By using the yield to maturity on AT&Ts debt, we found that its pretax cost of debt is 3.65%. If AT&Ts tax rate is 25%, what is its effective cost of debt?
-
You work in Walt Disney Companys corporate finance and treasury department and have been assigned to the team estimating Disneys WACC. You must estimate this WACC in preparation for a team meeting...
Study smarter with the SolutionInn App