Purple Pillows, Inc is using the percent-of-sales method to calculate External Financing Needed (EFN) over the next two years. Assume the following:

* They are at 100% asset capacity

* Depreciation, and interest grow in proportion with sales

* The tax rate remains constant over the three years

* Long-term notes are the plug variable

Use the attached template to:

1) Fill in all the blank yellow cells with the appropriate functions

2) Balance the balance sheet using LT notes as the plug

3) Ensure that your spreadsheet is fully dynamic by changing the yellow-highlighted growth, tax, and dividend rates

4) Use your sheet to calculate EFN for the three scenarios listed on the "Questions" tab

Income Statement Growth Rate Tax Rate Dividend Rate Purple Pillows, Inc 26% 35% 2019 2017 $ 1,000,000 $ (350,000) $(400,000) 250,000 $ (50,000) $200,000 $ $(75,000) $125,000 $ $ (32,500) $ 92,500 $ 2018 Sales COGS SG&A Operating Income Depreciation EBIT Interest paid Taxable income Taxes Net Income Dividend Add to RE $32,375 $60,125