Question
Prepare a financial analysis of the company being reviewed. Use the excel template provided. 1. Profile (max 500 words): Create an overview of the company
Prepare a financial analysis of the company being reviewed. Use the excel template provided.
1. Profile (max 500 words):
Create an overview of the company including (but not limited to):
- A description of the business including products/services, strategy, competitors, andthe industry it operates in.
- An overview of the history and the future direction of the company, including itsgrowth and/or restructuring initiatives.
- Approximate size of the company including annual sales, number of employees,number of customers and locations.
2. Trend Analysis: Prepare a variance (horizontal) analysis for the three most current years for each of thefinancial statements listed below. Provide an explanation for significant variances in thefinancial statement line items. Do not select totals / subtotals eg. total assets, total liabilities,net income, etc). For each statement, a minimum of 2-3 line items should be supported by anexplanation, but not less than 5 in total.
A. Balance Sheet B. Income Statement
3. Ratio Analysis: Create an intercompany ratio analysis to compare against a relevant competitor in theindustry to evaluate the three classifications below. Provide an interpretation where ratios aresignificantly different than their competitor. A minimum of one ratio from each categoryrequire interpretation. (Show your work!)
A. Liquidity B. Solvency C. Profitability
4. Conclusion:
- Based on your analysis provide a summary of the company's financial position andperformance.
- Make a recommendation to your client as to whether they should invest in thecompany based on the company's solvency, liquidity, and profitability.
5. Include a copy or screen shots of the company financial statements with your analysis.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started