Question: 13. Switch to the Income Statement worksheet. For the Add 1 Truck scenario, project the income from Food sales for 2020-2022 (cells D5:F5) using a

13. Switch to the Income Statement worksheet. For the Add 1 Truck scenario, project the income from Food sales for 2020-2022 (cells D5:F5) using a Growth Trend interpolation. (Hint: Select the range C5:G5 before filling this series with values.)

13. Switch to the Income Statement worksheet. For the Add 1 Truck

The Mobile Vegan Expansion Plan Income Statement Add 1 Truck Income Food sales Beverage sales Catering Total Revenue 2019 2020 2021 2022 2023 96,000 48,000 90,000 236,019 $ 280,000 115,000 220,000 617,023 58,000 70,000 88,000 60,020 $ 72,021 $ 90,022 $ Expenses Food cost of goods Beverage cost of goods Payroll Maintenance Insurance 50,000 $ 52,000 $ 28,500 48,000 $ 55,000 $ 58,000 32,000 24,000 27,500 30,000 120,000 1,500 2.400 12,000 207,900 $ 2,000 2.400 12,000 93,900 $ 2,000 2,400 12,000 96,900 $ 2,500 2,600 12,000 102,100 $ 2,500 2,600 12,000 107,100 Total General Expenses Initial Earnings 28,119 $ (33,880) $ (24,879) S (12,078) $ 509,923 The Mobile Vegan Expansion Plan Income Statement Add 1 Truck Income Food sales Beverage sales Catering Total Revenue 2019 2020 2021 2022 2023 96,000 48,000 90,000 236,019 $ 280,000 115,000 220,000 617,023 58,000 70,000 88,000 60,020 $ 72,021 $ 90,022 $ Expenses Food cost of goods Beverage cost of goods Payroll Maintenance Insurance 50,000 $ 52,000 $ 28,500 48,000 $ 55,000 $ 58,000 32,000 24,000 27,500 30,000 120,000 1,500 2.400 12,000 207,900 $ 2,000 2.400 12,000 93,900 $ 2,000 2,400 12,000 96,900 $ 2,500 2,600 12,000 102,100 $ 2,500 2,600 12,000 107,100 Total General Expenses Initial Earnings 28,119 $ (33,880) $ (24,879) S (12,078) $ 509,923

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!