Answered step by step
Verified Expert Solution
Question
1 Approved Answer
If the sales growth rate continues, in which year the Sales cross $2 million? Please provide the excel function or formula to get the answer?
If the sales growth rate continues, in which year the Sales cross $2 million?
Please provide the excel function or formula to get the answer?
D 2015 Growth Rate 24.63% A B 1 Winter Park Web Design 2 Income Statements 3 For the Years 2015 and 2016 4 2016 5 Sales $ 280,419 $ 6 Cost of Goods Sold 154,229 7 Gross Profit 126,191 8 Depreciation Expense 5,295 9 Selling & Admin Expense 825 10 Net Operating Income 120,071 11 Interest Expense 1,020 12 Earnings Before Taxes 119,051 13 Taxes 44,049 14 Net Income 75,002 15 16 Notes: 17 Tax Rate 37.0% 18 Shares Outstanding 7,500 19 Earnings per Share $ 10.00 $ 20 Dividends per Share $6.00 21 Addition to RE per Share $ 4.00 $ 225,000 123,750 101,250 4,646 720 95,884 810 95,074 33,276 61,798 35.0% 7,500 8.24 $5.00 3.24Step 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