Question
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
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:
Fill in all the blank yellow cells with the appropriate functions
Balance the balance sheet using LT notes as the plug
Ensure that your spreadsheet is fully dynamic by changing the yellow-highlighted growth, tax, and dividend rates
Use your sheet to calculate EFN for the three scenarios listed on the "Questions" tab (note: I need the actual excel functions in the yellow areas! Not just the number) Thank you :)
Income Statement 10% 26% 35% Growth Rate Tax Rate Dividend Rate Purple Pillows, Inc 2019 2017 $ 1,000,000 $ (350,000) $(400,000) 2018 Sales COGS SG&A Operating Income 250,000 Depreciation EBIT Interest paid $(50,000) $200,000 $ $(75,000) Taxable income 125,000 $ $ (32,500) $ 92,500 $ Taxes Net Income Dividend Add to RE $32,375 $60,125Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started