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

pratush dev

  • Member
  • Posts: 321
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

About one in five American adults and teenagers have had a genital herpes infection—and most of them don't know it. People with genital herpes have at least twice the risk of becoming infected with HIV if exposed to it than those people who do not have genital herpes.

Did you know?

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

Did you know?

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

Did you know?

The oldest recorded age was 122. Madame Jeanne Calment was born in France in 1875 and died in 1997. She was a vegetarian and loved olive oil, port wine, and chocolate.

Did you know?

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

Hematuria. An analysis of urine is performed to evaluate kidney function. In this illustration, the Hematuria. An analysis of urine is performed to evaluate kidney function. In this illustration, the
Sodium Balance Sodium Balance
Protein Needs Are Determined by Nitrogen Balance in Your Body Protein Needs Are Determined by Nitrogen Balance in Your Body
Systems Analysis and Design, 10th Edition Systems Analysis and Design, 10th Edition
The time at which the mailman delivers the mail to Ace Bike Shop follows a normal distribution ... The time at which the mailman delivers the mail to Ace Bike Shop follows a normal distribution ...
Analysis of yeast transcription patterns using microarrays Analysis of yeast transcription patterns using microarrays
Video: Properties of macromolecules (Explained with No Audio)

For a complete list of videos, visit our video library