BUSI 690 - I will need to do the following as part of Individual Case Study, I
Question:
BUSI 690 - I will need to do the following as part of Individual Case Study, I have not got my company yet; but I do not know how to do these things-and I am not proficient in Excel, which is what I see where people have posted their completed/submitted assignments. I am panicking as this my last course for graduate program and I have not done any of this type of work in any other course work! Please help! I just need assistance as to how to do this on my own-
I will need to do the following as part of Individual Case Study:
1.Historical Financial Statements (Income Statement (I/S), Balance Sheet (B/S) and Statement of Cash Flows) from the 3 most current years for the firm
a. The financial statements must include horizontal and vertical analysis between years.
b. The financial statements must include changes (deltas) and analysis between years.
2.Ratios from the most current and available 3 years with analysis
a.Internal Factor Evaluation (IFE) Matrix
b.External Factor Evaluation (EFE) Matrix
c.SWOT Bivariate Strategy Matrix
2.BCG Matrix (follow the Strategy Club's template, not the textbook's format)
3.Competitive forces, Competitive Profile Matrix (CPM), and competitor's ratios
a.Competitive forces analysis
b.CPM and analysis
c.Competitor's ratios and analyis
6.Alternative strategies (giving advantages and alternatives for each)
7.Pro-Forma Financial Statements (I/S, B/S and Statement of Cash Flows) with deltas out 3 years and analysis
a. Each year must have 2 columns: 1 with your strategy and 1 without your strategy.
b.Include Pro-Forma ratios for the first year out with deltas contrasting from the most current year's ratios.
8.Net Present Value analysis of proposed strategy's new cash flow and EPS/EBIT analysis
NOTE: To construct the first cash flow (cf1) at the very minimum, the new revenue from your strategy(s) must be discounted back to the present value by calculating EBIT and that figure will be your cfn for each year. cf0 (initial cost of your strategy), cf1 (discounted cash flow first year), r (opportunity cost of capital, the rate of the next best alternative use of cash/debt/equity resources).