Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q1) Analyze the Income statement, calculate margins and groth and comment on financial health using excel. begin{tabular}{|l|r|r|r|r|r|} hline & multicolumn{1}{|c|}{2017} & multicolumn{1}{c|}{2018} & multicolumn{1}{c|}{2019} &
Q1) Analyze the Income statement, calculate margins and groth and comment on financial health using excel.
\begin{tabular}{|l|r|r|r|r|r|} \hline & \multicolumn{1}{|c|}{2017} & \multicolumn{1}{c|}{2018} & \multicolumn{1}{c|}{2019} & \multicolumn{1}{c|}{ 2020 (Projected) } & \multicolumn{1}{c|}{ 2021 (Projected) } \\ \hline Revenue & & & & & \\ \hline Catering & 13,096 & 20,738 & 26,192 & 26,192 & 26,192 \\ \hline Food Sales (Market) & 97,927 & 82,713 & 71,856 & 71,856 & 71,856 \\ \hline Food Sales (New Location) & & 101,190 & 273,600 & 328,500 & 328,500 \\ \hline Total Restaurant Sales & 111,023 & 204,641 & 371,648 & 426,548 & 426,548 \\ \hline & 25,730 & 25,730 & 38,595 & 51,460 & 64,325 \\ \hline Granola (Wholesale) & 25,730 & 44,095 & 57,200 & 57,200 & 57,200 \\ \hline Granola (Retail) & 51,460 & 69,824 & 95,795 & 108,660 & 121,525 \\ \hline Total Granola Sales & & & & & \\ \hline & & & & & \\ \hline Total Revenue & 162,483 & 274,466 & 467,443 & 535,208 & 548,073 \\ \hline & & & & & \\ \hline Restaurant COGS & 48,274 & 89,402 & 163,785 & 188,459 & 188,459 \\ \hline Granola Costs & 50,326 & 51,705 & 69,361 & 79,240 & 89,119 \\ \hline Administrative Expenses & 60,936 & 155,031 & 221,789 & 221,789 & 215,687 \\ \hline Total Expenses & 159,537 & 296,138 & 454,935 & 489,488 & 493,265 \\ \hline & & & & 45,720 & 54,807 \\ \hline Net Income/(Loss) & 2,946 & (21,673) & 12,508 & & \\ \hline \end{tabular}
Step 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