Finance (need this HM in 12 hours)
financestudent
income_statement_assignment7_todo.xlsxSheet1
| Income Statement: The Next 10 Years | |||||||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | ||
| Lemonade Stands | 1 | 2 | 3 | 4 | 7 | ||||||
| Cups sold per stand | $ 800.00 | $ 840.00 | $ 882.00 | $ 926.10 | $ 972.41 | $ 1,021.03 | $ 1,072.08 | $ 1,125.68 | $ 1,181.96 | $ 1,241.06 | |
| Cups sold | 800.00 | 1,680.00 | 2,646.00 | 3,704.40 | 6,806.84 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| Price per cup | $ 1.00 | 1.05 | 1.10 | 1.15 | 1.20 | 1.25 | 1.30 | 1.35 | 1.40 | 1.45 | |
| Revenue | $ 800.00 | $ 1,764.00 | $ 2,910.60 | $ 4,260.06 | $ 8,168.20 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Less: Cost of Goods Sold | $ (200.00) | $ (420.00) | |||||||||
| Less: Depreciation | $ (60.00) | $ (120.00) | $ (180.00) | $ (240.00) | $ (420.00) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Less: Labor | $ (530.00) | $ (1,060.00) | $ (1,590.00) | $ (2,120.00) | $ (3,710.00) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| EBIT | $ 10.00 | $ 164.00 | |||||||||
| Margin | 1.25% | 9.30% | 0.00% | 0.00% | 0.00% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |
| Less: Interest | $ (25.00) | $ (25.00) | $ (25.00) | $ (25.00) | $ (25.00) | $ (25.00) | $ (25.00) | $ (25.00) | $ (25.00) | $ (25.00) | |
| EBT | (15.00) | 139.00 | (25.00) | (25.00) | (25.00) | (25.00) | (25.00) | (25.00) | (25.00) | (25.00) | |
| Less: Taxes | $ (5.25) | $ 48.65 | $ (8.75) | $ (8.75) | $ (8.75) | $ (8.75) | $ (8.75) | $ (8.75) | $ (8.75) | $ (8.75) | |
| Net Income | $ (9.75) | $ 90.35 | $ (16.25) | $ (16.25) | $ (16.25) | $ (16.25) | $ (16.25) | $ (16.25) | $ (16.25) | $ (16.25) | |
| Per Share | |||||||||||
| Growth |
