Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

\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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Wiley Not-for-Profit GAAP 2020 Interpretation And Application Of Generally Accepted Accounting Principles

Authors: Richard F. Larkin, Marie DiTommaso, Warren Ruppel

1st Edition

1119595959, 978-1119595953

More Books

Students also viewed these Accounting questions