Reference no: EM133367224
Financial Management
Project - Financial Analysis
Instructions
The project will teach you how to perform a financial analysis on a set of financials. A financial analysis report is constructed by a person who is researching a company, usually with the intent of recommending its stock to investors or to a board of directors. The report contains multiple components, such as company overview, investment essentials, valuation, risk analysis, and a summary. However, for the purpose of this class, we will focus on the investment essentials. In this component - "investment essentials", you will need to analyze the financials by using ratio analysis, trend analysis, and provide a quick summary of your findings.
The TechOne Company was established in the Spring of 2015. During the first couple of years, the company experienced a rapid increase in its sales. Despite good profits, the company had experienced a shortage in cash and had found it necessary to increase its borrowing from the bank in the following year (2016). The maximum loan that the bank would extend to the owner Mr. Company was $200,000. In addition, the bank did not ask the company to secure the debt with its real property. Mr. Company, sole owner and president of the TechOne Company was therefore asking his VP of Finance to perform a financial analysis to understand whether the shortage of cash was due to money tied up in its inventory or was it due to cash tied up elsewhere.
Please use the financialsprovided by the case to help the bank with their analysis. Please follow the steps below to successfully complete the project:
Question 1. Please recreate the financial statements using excel
Question 2. Please create a Common-size Income Statement and discuss your findings
a. i.e. COGS is x% of revenue. This line item has increase during the past x years, etc...
Question 3. Please create a Common-Size Balance Sheet and discuss your findings
a. i.e. A/R is x% of Total Assets. This line item has decrease during the past x years
Question 4. Please use your trend analysis to project the Income Statement (3 years)
Question 5. Please open the file labelled "Note on Financial Ratio Formula", and compute three ratios from each category.
Attachment:- Financial Analysis.rar