I need a pro forma and a dcf with the data that is in this excel sheet. Please I need help asp.

Spirit Airlines Inc Historic Data Based on S&P Information INCOME STATEMENT Sales Revenue Less: Cost of Goods Sold Gross Profits Less: Operating Expenses: Selling Expense Other Operating Expenses Depreciation Expense Total Operating Expenses Operating Profits Less: Interest Expense Less: Other Income Expense Net Profits Before Taxes Less: Taxes Net Profit After Taxes Less: Pref. Stock Divds. Earnings Available for Common Stockholders 2013 $1,654 $865 $789 2014 $1,932 $988 $944 $330 $145 $32 $507 $282 $0 $282 $105 $177 $0 $389 $153 $47 $589 $355 $0 ($2) $353 $128 $225 $0 $177 $225 BALANCE SHEET Current Assets: Cash Accounts Receivable Deferred Income taxes Prepaid Expenses Other Current Assets Total Current Assets Other long term asset Gross Plant, Property &Equipment Total Gross Fixed Assets Less: Accumulated Depreciation Net Fixed Assets Total Assets Current Liabilities: 2013 $531 $23 $16 $79 2014 $633 $23 $10 $66 $649 $731 $496 $61 $557 ($25) $532 $1,181 $646 $261 $907 ($36) $871 $1,603 2013 2014 Accounts Payable Accruals Taxes Payable Other Current Liabilities Total Current Liabilities Deferred tax liability Deferred Revenues Other Long Term Liability L / T Debt (Inc. Financial Leases) Total Liabilities Common Stock Treasury Stock Accumulated other Paid-In Capital In Excess of Par Retained Earnings Total Stockholders' Equity Total Liabs. & Stockhldrs' Equity $23 $118 $27 $168 $336 $13 $107 $46 $189 $366 $49 $76 $22 $27 $412 $0 ($2) $515 $256 $769 $1,181 $136 $600 $0 ($4) ($1) $526 $482 $1,003 $1,603 ines Inc on S&P Information 2015 CAGR $2,141 -6.25% $885 $1,257 $465 $209 $74 $748 $509 $9 $2 $502 $185 $317 $0 $317 E SHEET 2015 $804 $28 $0 $121 $1,026 $660 $910 $1,570 ($66) $1,504 $2,531 2015 $17 $46 $38 $315 $466 $221 $21 $597 $1,305 $0 ($116) ($2) $544 $799 $1,225 $2,531 Spirit Airlines Inc. Ratios Fiscal Period Dec-13 Dec-14 Current Ratio Quick Ratio Cash Ratio 1.93 1.65 1.03 2.00 1.79 1.20 Return on Equity % Return on Assets % Return on Capital Debt to Equity 26.18 16.84 26.14 25.44 16.2 21.82 Gross Margin % Operating Margin % Net Margin % 47.7 17.1 48.9 18.4 Total Equity to Total Asset LT Debt to Total Asset 0.65 0.22 0.87 0 Asset Turnover Dividend Payout Ratio 1.58 0 1.39 0 Days Sales Outstanding Days Inventory Inventory Turnover COGS to Revenue Inventory to Revenue Income Statement Fiscal Period Sales Revenue Less: Cost of Goods Sold Gross Profits Less: Operating Expenses: Selling Expense Other Operating Expenses Depreciation Expense Total Operating Expenses Operating Profits Less: Interest Expense Less: Other Income Expense Net Profits Before Taxes Less: Taxes Dec-13 $1,654 $865 $789 Dec-14 $1,932 $988 $944 $330 $145 $32 $507 $282 $0 $389 $153 $47 $589 $355 $0 ($2) $353 $128 $282 $105 Net Profit After Taxes Less: Pref. Stock Divds. $177 $0 $225 $0 Earnings Available for Common Stockholders $177 $225 Dec-13 Dec-14 $531 $23 $16 $79 $633 $23 $10 $66 $649 $731 $496 $61 $557 ($25) $532 $1,181 $646 $261 $907 ($36) $871 $1,603 2013 $23 $118 $27 $168 $336 2014 $13 $107 $46 $189 $366 $49 $76 $22 Balance Sheet Fiscal Period Cash Accounts Receivable Deferred Income taxes Prepaid Expenses Other Current Assets Total Current Assets Other long term asset Gross Plant, Property &Equipment Total Gross Fixed Assets Less: Accumulated Depreciation Net Fixed Assets Total Assets Current Liabilities: Accounts Payable Accruals Taxes Payable Other Current Liabilities Total Current Liabilities Deferred tax liability Deferred Revenues Other Long Term Liability L / T Debt (Inc. Financial Leases) Total Liabilities Common Stock Treasury Stock $27 $412 $136 $600 $0 ($2) $0 ($4) Accumulated other Paid-In Capital In Excess of Par Retained Earnings Total Stockholders' Equity Total Liabs. & Stockhldrs' Equity PensionAndRetirementBenefit DeferredTaxAndRevenue Other Long-Term Liabilities Total Liabilities Common Stock Preferred Stock Retained Earnings Additional Paid-In Capital Treasury Stock Total Equity $515 $256 $769 $1,181 0 0 21 552 ($1) $526 $482 $1,003 $1,603 0 0 31 285 0 0 -454 1,453 0 1,003 0 0 -4 1,894 0 1,871 Dec-15 2.20 1.78 1.48 28.47 15.35 21.28 58.7 23.8 0.8 0.06 1.04 0 Dec-15 $2,141 $885 $1,257 $465 $209 $74 $748 $509 $9 $2 $502 $185 $317 $0 $317 Dec-15 $804 $28 $0 $121 $1,026 $660 $910 $1,570 ($66) $1,504 $2,531 2015 $17 $46 $38 $315 $466 $221 $21 $597 $1,305 $0 ($116) ($2) $544 $799 $1,225 $2,531 0 0 33 739 0 0 810 2,206 0 3,028 Tax Rate 35.0% Particulars 2,015 Corporate tax rate 2,016 2,017 2,018 Revenues %growth 2141.00 3,404.19 59% 4,425.45 30% 5,531.81 25% Total Cost %Growth 38609 2042.51 60.0% 2655.27 60.0% 3319.09 60.0% -36468.00 1,361.68 -103.73% 1,770.18 30.00% 2,212.72 25.00% Less Taxes NOPAT Add Depn 12,763.800 -23,704.20 932 -476.587 885.09 978.60 -619.563 1,150.62 1,027.53 -774.453 1,438.27 1,078.91 FCF Discount Fact DCF -22,772.20 1.0 -19,975.61 1,863.69 2.0 1,434.05 2,178.15 3.0 1,470.19 2,517.18 4.0 1,490.37 PV of FCF PV of Termina Debt Enterprise va -14,450.72 7,180.41 6670 -600.31 -600.31 18% 6% 298741.37 7% 316765.73 19% 273480.61 288101.86 EBIT % margin increase Terminal Growth W A C C W A C C 20% 21% 22% 23% 24% 25% 26% 251919.77 233314.95 217108.42 202873.86 190279.86 179064.90 169019.92 263938.72 243307.99 225499.80 209981.90 196347.42 184280.06 173530.24 2,019 2,020Terminal Value CAGR -100% - 0.00 60.0% 0.00 60.0% -100.00% #DIV/0! ### ### 250000 200000 150000 ### 5.0 588.37 ### 6.0 541.92 ### 100000 50000 0 Terminal Growth rate 8% 9% ### ### ### ### Revenues Cash Flow 10% ### ### 11% ### ### Using CAPM Build Up Approach 2010 2011 2012 2013 2014 2015 12% ### ### 13% ### Key Variables WACC Beta Tax Rate D/E Ratio Risk Free Equity Ri Cost of De Cost of Eq Terminal Small Sto ### Company Specific risk premium ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### Industry Revenues Cash Flow g CAPM Build Up Approach Key Variables 14.00% 1 35.00% 0.139566 4.00% 5.00% 6.00% 14.00% 6.00% 2.00% 2.00% CFA Norm 1.00% Spirit Airlines Inc Historic Data Based on S&P Information INCOME STATEMENT Sales Revenue Less: Cost of Goods Sold Gross Profits Less: Operating Expenses: Selling Expense Other Operating Expenses Depreciation Expense Total Operating Expenses Operating Profits Less: Interest Expense Less: Other Income Expense Net Profits Before Taxes Less: Taxes Net Profit After Taxes Less: Pref. Stock Divds. Earnings Available for Common Stockholders 2013 $1,654 $865 $789 2014 $1,932 $988 $944 $330 $145 $32 $507 $282 $0 $282 $105 $177 $0 $389 $153 $47 $589 $355 $0 ($2) $353 $128 $225 $0 $177 $225 BALANCE SHEET Current Assets: Cash Accounts Receivable Deferred Income taxes Prepaid Expenses Other Current Assets Total Current Assets Other long term asset Gross Plant, Property &Equipment Total Gross Fixed Assets Less: Accumulated Depreciation Net Fixed Assets Total Assets Current Liabilities: 2013 $531 $23 $16 $79 2014 $633 $23 $10 $66 $649 $731 $496 $61 $557 ($25) $532 $1,181 $646 $261 $907 ($36) $871 $1,603 2013 2014 Accounts Payable Accruals Taxes Payable Other Current Liabilities Total Current Liabilities Deferred tax liability Deferred Revenues Other Long Term Liability L / T Debt (Inc. Financial Leases) Total Liabilities Common Stock Treasury Stock Accumulated other Paid-In Capital In Excess of Par Retained Earnings Total Stockholders' Equity Total Liabs. & Stockhldrs' Equity $23 $118 $27 $168 $336 $13 $107 $46 $189 $366 $49 $76 $22 $27 $412 $0 ($2) $515 $256 $769 $1,181 $136 $600 $0 ($4) ($1) $526 $482 $1,003 $1,603 ines Inc on S&P Information 2015 CAGR $2,141 -6.25% $885 $1,257 $465 $209 $74 $748 $509 $9 $2 $502 $185 $317 $0 $317 E SHEET 2015 $804 $28 $0 $121 $1,026 $660 $910 $1,570 ($66) $1,504 $2,531 2015 $17 $46 $38 $315 $466 $221 $21 $597 $1,305 $0 ($116) ($2) $544 $799 $1,225 $2,531 Spirit Airlines Inc. Ratios Fiscal Period Dec-13 Dec-14 Current Ratio Quick Ratio Cash Ratio 1.93 1.65 1.03 2.00 1.79 1.20 Return on Equity % Return on Assets % Return on Capital Debt to Equity 26.18 16.84 26.14 25.44 16.2 21.82 Gross Margin % Operating Margin % Net Margin % 47.7 17.1 48.9 18.4 Total Equity to Total Asset LT Debt to Total Asset 0.65 0.22 0.87 0 Asset Turnover Dividend Payout Ratio 1.58 0 1.39 0 Days Sales Outstanding Days Inventory Inventory Turnover COGS to Revenue Inventory to Revenue Income Statement Fiscal Period Sales Revenue Less: Cost of Goods Sold Gross Profits Less: Operating Expenses: Selling Expense Other Operating Expenses Depreciation Expense Total Operating Expenses Operating Profits Less: Interest Expense Less: Other Income Expense Net Profits Before Taxes Less: Taxes Dec-13 $1,654 $865 $789 Dec-14 $1,932 $988 $944 $330 $145 $32 $507 $282 $0 $389 $153 $47 $589 $355 $0 ($2) $353 $128 $282 $105 Net Profit After Taxes Less: Pref. Stock Divds. $177 $0 $225 $0 Earnings Available for Common Stockholders $177 $225 Dec-13 Dec-14 $531 $23 $16 $79 $633 $23 $10 $66 $649 $731 $496 $61 $557 ($25) $532 $1,181 $646 $261 $907 ($36) $871 $1,603 2013 $23 $118 $27 $168 $336 2014 $13 $107 $46 $189 $366 $49 $76 $22 Balance Sheet Fiscal Period Cash Accounts Receivable Deferred Income taxes Prepaid Expenses Other Current Assets Total Current Assets Other long term asset Gross Plant, Property &Equipment Total Gross Fixed Assets Less: Accumulated Depreciation Net Fixed Assets Total Assets Current Liabilities: Accounts Payable Accruals Taxes Payable Other Current Liabilities Total Current Liabilities Deferred tax liability Deferred Revenues Other Long Term Liability L / T Debt (Inc. Financial Leases) Total Liabilities Common Stock Treasury Stock $27 $412 $136 $600 $0 ($2) $0 ($4) Accumulated other Paid-In Capital In Excess of Par Retained Earnings Total Stockholders' Equity Total Liabs. & Stockhldrs' Equity PensionAndRetirementBenefit DeferredTaxAndRevenue Other Long-Term Liabilities Total Liabilities Common Stock Preferred Stock Retained Earnings Additional Paid-In Capital Treasury Stock Total Equity $515 $256 $769 $1,181 0 0 21 552 ($1) $526 $482 $1,003 $1,603 0 0 31 285 0 0 -454 1,453 0 1,003 0 0 -4 1,894 0 1,871 Dec-15 2.20 1.78 1.48 28.47 15.35 21.28 58.7 23.8 0.8 0.06 1.04 0 Dec-15 $2,141 $885 $1,257 $465 $209 $74 $748 $509 $9 $2 $502 $185 $317 $0 $317 Dec-15 $804 $28 $0 $121 $1,026 $660 $910 $1,570 ($66) $1,504 $2,531 2015 $17 $46 $38 $315 $466 $221 $21 $597 $1,305 $0 ($116) ($2) $544 $799 $1,225 $2,531 0 0 33 739 0 0 810 2,206 0 3,028 Tax Rate 35.0% Particulars 2,015 Corporate tax rate 2,016 2,017 2,018 Revenues %growth 2141.00 3,404.19 59% 4,425.45 30% 5,531.81 25% Total Cost %Growth 38609 2042.51 60.0% 2655.27 60.0% 3319.09 60.0% -36468.00 1,361.68 -103.73% 1,770.18 30.00% 2,212.72 25.00% Less Taxes NOPAT Add Depn 12,763.800 -23,704.20 932 -476.587 885.09 978.60 -619.563 1,150.62 1,027.53 -774.453 1,438.27 1,078.91 FCF Discount Fact DCF -22,772.20 1.0 -19,975.61 1,863.69 2.0 1,434.05 2,178.15 3.0 1,470.19 2,517.18 4.0 1,490.37 PV of FCF PV of Termina Debt Enterprise va -14,450.72 7,180.41 6670 -600.31 -600.31 18% 6% 298741.37 7% 316765.73 19% 20% 273480.61 251919.77 288101.86 263938.72 EBIT % margin increase Terminal Growth W A C C W A C C 21% 22% 23% 24% 25% 26% 233314.95 217108.42 202873.86 190279.86 179064.90 169019.92 243307.99 225499.80 209981.90 196347.42 184280.06 173530.24 2,019 2,020Terminal Value CAGR -100% - 0.00 60.0% 0.00 60.0% -100.00% #DIV/0! ### ### 250000 200000 150000 ### 5.0 588.37 ### 6.0 541.92 ### 100000 50000 0 Terminal Growth rate 8% 9% ### ### ### ### ### ### Revenues Cash Flow 10% ### ### ### 11% ### ### ### 2010 2011 2012 2013 2014 2015 Using CAPM Build Up Approach 12% ### ### ### 13% ### Key Variables WACC Beta Tax Rate D/E Ratio Risk Free Equity Ri Cost of De Cost of Eq Terminal Small Sto ### ### Company Specific risk premium Industry ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### Revenues Cash Flow g CAPM Build Up Approach Key Variables 14.00% 1 35.00% 0.139566 4.00% 5.00% 6.00% 14.00% 6.00% 2.00% 2.00% 1.00% CFA Norm