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 126 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
Wow, this really help

cdmart10

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

« previous next »
 

Did you know?

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

Did you know?

The most common childhood diseases include croup, chickenpox, ear infections, flu, pneumonia, ringworm, respiratory syncytial virus, scabies, head lice, and asthma.

Did you know?

Approximately 500,000 babies are born each year in the United States to teenage mothers.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

Multiple experimental evidences have confirmed that at the molecular level, cancer is caused by lesions in cellular DNA.

Renal regulation of sodium and potassium balance Renal regulation of sodium and potassium balance
VITROS DT60II automated blood analysis system. VITROS DT60II automated blood analysis system.
Stretch the flexor muscles with hyperextension at the wrist. Hold the forearm vertical with one ... Stretch the flexor muscles with hyperextension at the wrist. Hold the forearm vertical with one ...
The Romberg test for balance The Romberg test for balance
Table - Correlation Analysis Table - Correlation Analysis
Morgan’s test-cross analysis of genetic linkage between autosomal genes Morgan’s test-cross analysis of genetic linkage between autosomal genes
Video: Lower Limb Arteries Animation

For a complete list of videos, visit our video library