Excel$-$Basics Project, Cost$-1,$ Fall$-24\backslash$

Brittany Baker is trying to create financial statements for her start$-$up company, Pizza Heaven. "Brittany

began the business on Jan $1,2023$ with a $$1,000$ investment from her parents. $-$ The year $2023$ is over,

and Brittany needs help to generate a profit and loss statement $($Income statement$)$ and Balance sheet..

She is only able to ascertain that her cash is about even with what she started the year with $($ $$1,000).$

Two types of pizzas are sold, Vegetable and Carnivore. $-$ Brittany's business model is to buy the finished

pizzas from her father, also a baker, shrink wrap them and ship with dry ice to states in the Southeastern

US$..$ She purchased initial inventory of $50$ pizzas of each product in mid$-$January, $2023..$ Brittany pays her$-$

father $$10$ for the vegetarian and $$12$ for the meat pizza. $*$ q$$

Sales have been good. Brittany advertises solely on her internet website. Pizza Heaven has sold$-150$

vegetable and $130$ carnivore pizzas. "She charges $$19$ and $$22$ each for the products, respectively. Her$-$

website hosting site charges $$\mathrm{.}60$ for each unit sold. Brittany has replenished her inventory by

purchasing $150$ units of each type of pizza from her father at the same cost as her initial inventory

purchases. "Brittany's other costs are packaging and shipping; she incurs $$4$ per pizza for these costs,

regardless of pizza type. She does not currently pay herself a salary as she is running the business after

her regular.job.$-$

TO:DO:$$

$$ Generate an income statement and balance sheet for Pizza Heaven using Excel. $*$ You will $*$ have $*3$

worksheets within one workbook: $]$

$$ Input sheet: $*$ Type in the data given in this case; $$

$-$ Income statement: Create an income statement for the year ended $12/31/23.$ The income

statement should look $*$like this: $|$

$-$ Balance sheet: Create a balance sheet as of $\frac{1}{1}\frac{?}{23}$ and $\frac{12}{31}\frac{?}{23},$ which looks like this: $||$

You will$-$need to compute your ending cash balance as of $\frac{12}{31}\frac{?}{23}$; it is within $$100$ of the beginning

cash balance as of $\frac{1}{1}\frac{?}{23}.$

$$ Create a conditional'"if$"$ statement showing that Assets $=$ Liabilities$-$Owner's Equity. $-$If the

condition is met, it should say EQUAL. If the condition is not met, it should say PROBLEM. $**|$

$$ All numbers on the income statement and balance sheet MUST BE either a formula or a cell $*$

reference. No numbers can be input on these sheets. $-$You will cell reference back to the input

sheet. $*$

$$ Use the number format ##$,$###$.$##$.$ Make the statements look presentable, i$.$e$.$ use spacing,

underlines, bold, colors etc. as if you were making a presentation to Brittany.

GRADING RUBRIC:

$-$ Cell referencing and formulas used for income statement and balance sheet. $\text{'}$ Statements look

presentable.$($format$,$ spacing.etc.$),,,,,,............\mathrm{.}5\mathrm{.}5.$points ${?}^{||}$

$$ TOTAL $*......................................................................................................10$ points

$$