This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: The vertical analysis of a balance sheet for a coffee shop is created in Excel. Cash assets are in ... (Read 127 times)

jasdeep_brar

  • Hero Member
  • *****
  • Posts: 569
on: Jun 24, 2018
The vertical analysis of a balance sheet for a coffee shop is created in Excel. Cash assets are in Cell C9 and total assets are in Cell C16. Write two ways for keying cash as a percent of total assets into Cell D9.

Question 2

The Smoothie Shoppe's income statement is done in Excel. Cell E8 contains net sales, Cell E17 contains cost of goods sold, and Cell E27 contains total operating expenses. What is the formula to calculate net income before federal income tax?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

Mollythedog

  • Sr. Member
  • ****
  • Posts: 340
Reply #1 on: Jun 24, 2018
Answer to Question 1

=C9/C16; key (=) in Cell D9, then point to Cell C9 with the mouse, then key (/), then point to Cell C16 with the mouse, then press enter.

Answer to Question 2

#REF!


jasdeep_brar

  • Member
  • Posts: 569
Reply 2 on: Jun 24, 2018
Great answer, keep it coming :)

kusterl

  • Member
  • Posts: 315
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

Throughout history, plants containing cardiac steroids have been used as heart drugs and as poisons (e.g., in arrows used in combat), emetics, and diuretics.

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

Only one in 10 cancer deaths is caused by the primary tumor. The vast majority of cancer mortality is caused by cells breaking away from the main tumor and metastasizing to other parts of the body, such as the brain, bones, or liver.

DNA analysis of phylogenetic relationships among modern and extinct flightless birds by Cooper and c DNA analysis of phylogenetic relationships among modern and extinct flightless birds by Cooper and c
Fluid Balance during Exercise Fluid Balance during Exercise
Evolutionary Analysis (5th Edition) Evolutionary Analysis (5th Edition)
Modern Systems Analysis and Design (4th Edition) Modern Systems Analysis and Design (4th Edition)
Acid–Base Balance Acid–Base Balance
Histograms - Analysis and Data Histograms - Analysis and Data
Video: Dendrite Animation

For a complete list of videos, visit our video library