Question: Part 5: Financials (Topic 6)
Grand Canyon University Market Expansion
You are to put the information in a PPT. You wiill complete the excel, but put the information in the PPT and explain in the speaker notes. Remember to make sure you are defining the concepts in your speaker notes and then explaining what your numbers mean.
A projected financial statement analysis seeks to forecast the impact of various implementation decisions. The pro forma financial statement can be part of the risk analysis of strategic plan. The goal of this assignment is to ensure your strategic plan is viable financially. In other words, does it create value for the firm?
Consider the cost structure and revenue streams for your strategic initiative plan. Research and data collected so far and will likely change once your product or service is commercialized. Each statement should address financial components of features, expenses, and sales of your product or service. It is typical for net income to be negative at this point. Do not assume that you have sales at this point unless you have sold your product or service.
Research the following if your plan is a market expansion plan for an existing organization, or a mergers and acquisitions plan:
1. Balance sheet
2. Income statement
3. Statement of cash flow
4. Fixed and variable expenses
5. A projected budget
6. Breakeven analysis
Complete the "Projected Financial Statement Analysis (Pro Forma 3-Year Financial Plan)"including the "Questions" tab, "12 Month P& L" tab, "Year 1" tab, "Year 2 P&L" tab, and "Year 3 P&L" tab.
The first year is monthly and the second and third year are presented quarterly.
1. What is the vital financial information needed to determine the viability of your plan ?
2. What ratios will you use to determine if the proposed plan is a success?
3. What other, nonfinancial, information did you use to put your plan together?
4. Consider the assumptions made when completing Part 3. What assumptions are made? List the assumptions that you used to formulate this plan.
5. Discuss the financial results from your Pro Forma projections. Include the net income results, breakeven analysis, and required expenses to commercialize your product or service.
6. Explain how you would determine your pricing model. What seems most appropriate for your business and industry in which you will compete?
7. Identify your cost structure. Is your business model cost-driven or value driven? Justify your selection.
8. Review your decision for a revenue model. Based on the financial statements, will this model generate a profit? Provide evidence to prove it.
9. Where are you getting capital to meet your strategic initiative? What terms will be most likely deemed acceptable?
10. Did you have to reevaluate (go back) why?
Information related to above question is enclosed below:
Attachment:- MGT-660-RS-ProjectedFinancialStatementAnalysis.rar