Create proforma income statements and balance sheets for the next year (use the

Create proforma income statements and balance sheets for the next year (use the spreadsheet from the Spirit Proforma Statement )
Perform appropriate sensitivity analysis and alternate scenarios, by varying the growth rate in sales and working capital variables (Accounts Receivables, Inventory and Accounts Payable percentages).
Your analysis will include a comparison between the debt level from the base case (i) and those in the sensitivity/scenarios cases. Rubric
Part 2
Part 2
CriteriaRatingsPts
This criterion is linked to a Learning OutcomeDescription of criterion
10 to >9.0 ptsExcellent
Total Assets = Total Liabilities + equity for all years. Scenario analyses completed with discussion Sensitivity analyses completed with discussion
9 to >8.0 ptsGood
Total Assets = Total Liabilities + Equity for all years. Scenario analyses completed without discussion Sensitivity analyses completed without discussion
8 to >7.0 ptsFair
Total Assets = Total Liabilities + Equity for all years. Scenario analyses or Sensitivity analyses incomplete with discussion
7 to >0.0 ptsPoor
Total Assets not equal to Total Liabilities + Equity for all years. Scenario or sensitivity analyses incomplet
0 ptsNo Marks
No work done
10 pts
Total Points: 10