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 117 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
Excellent

aruss1303

  • Member
  • Posts: 314
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

The Romans did not use numerals to indicate fractions but instead used words to indicate parts of a whole.

Did you know?

According to the CDC, approximately 31.7% of the U.S. population has high low-density lipoprotein (LDL) or "bad cholesterol" levels.

Did you know?

The training of an anesthesiologist typically requires four years of college, 4 years of medical school, 1 year of internship, and 3 years of residency.

Did you know?

Cocaine was isolated in 1860 and first used as a local anesthetic in 1884. Its first clinical use was by Sigmund Freud to wean a patient from morphine addiction. The fictional character Sherlock Holmes was supposed to be addicted to cocaine by injection.

Did you know?

Illicit drug use costs the United States approximately $181 billion every year.

Example of an accounts receivable aging analysis report. Example of an accounts receivable aging analysis report.
Thermodynamic Diagrams and Vertical Temperature Profiles Thermodynamic Diagrams and Vertical Temperature Profiles
Experimental Analysis of Metabolism Experimental Analysis of Metabolism
Sodium’s chief role is regulation of fluid balance Sodium’s chief role is regulation of fluid balance
Normal (A) and Abnormal (B) Balance between Dopamine and Acetylcholine Normal (A) and Abnormal (B) Balance between Dopamine and Acetylcholine
Genetic analysis of vulval development in C. elegans Genetic analysis of vulval development in C. elegans
Video: Hip Animation

For a complete list of videos, visit our video library