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 82 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

xoxo123

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

« previous next »
 

Did you know?

The average office desk has 400 times more bacteria on it than a toilet.

Did you know?

The eye muscles are the most active muscles in the whole body. The external muscles that move the eyes are the strongest muscles in the human body for the job they have to do. They are 100 times more powerful than they need to be.

Did you know?

If you could remove all of your skin, it would weigh up to 5 pounds.

Did you know?

Asthma cases in Americans are about 75% higher today than they were in 1980.

Did you know?

Pope Sylvester II tried to introduce Arabic numbers into Europe between the years 999 and 1003, but their use did not catch on for a few more centuries, and Roman numerals continued to be the primary number system.

Ground coffee magnified Ground coffee magnified
Monopoly, patented in 1935, was an instant best-seller: Players risk all their assets in an attempt Monopoly, patented in 1935, was an instant best-seller: Players risk all their assets in an attempt
Understanding Food Claims Not all label claims are created equal! Understanding Food Claims Not all label claims are created equal!
Analysis of the dihybrid crosses Analysis of the dihybrid crosses
Chi -Squared Analysis Chi -Squared Analysis
GENETIC ANALYSIS 15.1 (2 of 5) GENETIC ANALYSIS 15.1 (2 of 5)
Video: Type of Cell Junctions - Desmosome, Hemidesmosomes and Gap Junctions

For a complete list of videos, visit our video library