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 1Truck scenario, project the income from Food sales for 2020-2022 (cells D5:F5)

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.) The Mobile Vegan Expansion Plan Income Statement - Add 1 Truck 2020 2021 2022 Income Food sales Beverage sales Catering Total Revenue 2019 96,000 48,000 90,000 236,019 $ 58,000 70,000 88,000 2023 280,000 115,000 220,000 617,023 60,020 $ 72,021' $ 90,022 $ $ 50,000 27,500 52,000 $ 28,500 55,000 30,000 $ 58,000 32,000 Expenses Food cost of goods Beverage cost of goods Payroll Maintenance Insurance Advertising Total General Expenses 48,000 $ 24,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 Initial Earnings 28,119 $ (33,880) $ (24,879) $ (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 Accounting Questions!