1. Business
  2. Finance
  3. create a model from an empty spreadsheet use the information...

Question: create a model from an empty spreadsheet use the information...

Question details

Create a model from an empty spreadsheet. Use the information below You must project Cleos Nail Salons income statement for 5 years. Here is the historical information you have received from Cleos. Previous years income statement for Cleos Sales COGS SG&A EBIT Interest Expense EBT Taxes Net Income 500,000 300,000 100,000 100,000 10,000 90,000 28,800 61,200 Cleos assumptions for the next five years at Sales growth COGS % of Sales SG&A % of Sales Interest Expense S Tax Rate Year 1 4% 60% Year 2 5% 60% Year 3 5% 61% 21% 12,500 Year 4 6% 62% 20% 2,500 Year 5 6% 63% 20% 12.500 11,000 32% 11,000 32%

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution