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 96 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
Thanks for the timely response, appreciate it

debra928

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

« previous next »
 

Did you know?

There are 60,000 miles of blood vessels in every adult human.

Did you know?

During the twentieth century, a variant of the metric system was used in Russia and France in which the base unit of mass was the tonne. Instead of kilograms, this system used millitonnes (mt).

Did you know?

People with alcoholism are at a much greater risk of malnutrition than are other people and usually exhibit low levels of most vitamins (especially folic acid). This is because alcohol often takes the place of 50% of their daily intake of calories, with little nutritional value contained in it.

Did you know?

For about 100 years, scientists thought that peptic ulcers were caused by stress, spicy food, and alcohol. Later, researchers added stomach acid to the list of causes and began treating ulcers with antacids. Now it is known that peptic ulcers are predominantly caused by Helicobacter pylori, a spiral-shaped bacterium that normally exist in the stomach.

Did you know?

Alzheimer's disease affects only about 10% of people older than 65 years of age. Most forms of decreased mental function and dementia are caused by disuse (letting the mind get lazy).

Cloud Types: Vertical Development Cloud Types: Vertical Development
The disaccharides sucrose, maltose, and lactose are created from the monosaccharides The disaccharides sucrose, maltose, and lactose are created from the monosaccharides
Modern Systems Analysis and Design (4th Edition) Modern Systems Analysis and Design (4th Edition)
Table - Analysis Table - Analysis
GENETIC ANALYSIS 15.1 (2 of 5) GENETIC ANALYSIS 15.1 (2 of 5)
Genetic complementation analysis Genetic complementation analysis
Video: Introduction to Epilepsy

For a complete list of videos, visit our video library