1. Use the following spreadsheet solve the questions Income Statement Sales Cost of Goods Gross Profit S&A Depreciation EBIT 2019 2020 $150,000.00 $175,000.00 $35,000.00 $38,500.00 $115,000.00 $136,500.00 $15,000.00 $16,500.00 $20,000.00 $20,000.00 $80,000.00 $100,000.00 $5,450.00 $3,437.18 $74,550.00 $96,562.82 $29,820.00 $38,625.13 $44,730.00 $57,937.69 $13,419.00 $17,381.31 $31,311.00 $40,556.38 Interest EBT Taxes Net Income Dividends Addition to Retained Earnings 2019 2020 Balance Sheet Assets Cash and Cash Equivalents Acc Receivable Inventory Short Term Investments Current Assets Gross PPE Accumulated Depreciation Net PPE Total Assets $3,000.00 $3,300.00 $20,000.00 $22,000.00 $10,000.00 $11,000.00 $0.00 $2,000.00 $33,000.00 $38,300.00 $500,000.00 $530,000.00 $100,000.00 $120,000.00 $400,000.00 $410,000.00 $433,000.00 $448,300.00 Liabilities and Equity Accounts Payable Accruals Notes Payables Current Liabilities Long Term Debt Total Liabilities $20,000.00 $3,000.00 $15,000.00 $38,000.00 $100,000.00 $138,000.00 $22,000.00 $3,000.00 $15,000.00 $40,000.00 $59,743.62 $99,743.62 Retained Earnings Preferred Stock Common Stock Total Equity $98,000.00 $138,556.38 $10,000.00 $10,000.00 $200,000.00 $200,000.00 $308,000.00 $348,556.38 Total Liabilities and Equity $433,000.00 $448,300.00 a. Compute the 2020 NOPAT b. Compute the 2020 NIOC c. Compute the 2020 FCFs d. Write out the years 2021 to 2025 projected annual FCFs given multistage growth. The short-term growth rate in FCFs is 3% for the next 4 years and the long-run growth rate in FCFs is 1%. e. Compute the intrinsic value using these 5 years of projected FCFs assuming the terminal value is a growth perpetuity. The WACC is 10% and the first cash flow in the terminal value is the year 5 future FCF. f. What is the equity value per share assuming there is 9000 shares outstanding? 1. Use the following spreadsheet solve the questions Income Statement Sales Cost of Goods Gross Profit S&A Depreciation EBIT 2019 2020 $150,000.00 $175,000.00 $35,000.00 $38,500.00 $115,000.00 $136,500.00 $15,000.00 $16,500.00 $20,000.00 $20,000.00 $80,000.00 $100,000.00 $5,450.00 $3,437.18 $74,550.00 $96,562.82 $29,820.00 $38,625.13 $44,730.00 $57,937.69 $13,419.00 $17,381.31 $31,311.00 $40,556.38 Interest EBT Taxes Net Income Dividends Addition to Retained Earnings 2019 2020 Balance Sheet Assets Cash and Cash Equivalents Acc Receivable Inventory Short Term Investments Current Assets Gross PPE Accumulated Depreciation Net PPE Total Assets $3,000.00 $3,300.00 $20,000.00 $22,000.00 $10,000.00 $11,000.00 $0.00 $2,000.00 $33,000.00 $38,300.00 $500,000.00 $530,000.00 $100,000.00 $120,000.00 $400,000.00 $410,000.00 $433,000.00 $448,300.00 Liabilities and Equity Accounts Payable Accruals Notes Payables Current Liabilities Long Term Debt Total Liabilities $20,000.00 $3,000.00 $15,000.00 $38,000.00 $100,000.00 $138,000.00 $22,000.00 $3,000.00 $15,000.00 $40,000.00 $59,743.62 $99,743.62 Retained Earnings Preferred Stock Common Stock Total Equity $98,000.00 $138,556.38 $10,000.00 $10,000.00 $200,000.00 $200,000.00 $308,000.00 $348,556.38 Total Liabilities and Equity $433,000.00 $448,300.00 a. Compute the 2020 NOPAT b. Compute the 2020 NIOC c. Compute the 2020 FCFs d. Write out the years 2021 to 2025 projected annual FCFs given multistage growth. The short-term growth rate in FCFs is 3% for the next 4 years and the long-run growth rate in FCFs is 1%. e. Compute the intrinsic value using these 5 years of projected FCFs assuming the terminal value is a growth perpetuity. The WACC is 10% and the first cash flow in the terminal value is the year 5 future FCF. f. What is the equity value per share assuming there is 9000 shares outstanding