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

rleezy04

  • Member
  • Posts: 322
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

Eat fiber! A diet high in fiber can help lower cholesterol levels by as much as 10%.

Did you know?

Acute bronchitis is an inflammation of the breathing tubes (bronchi), which causes increased mucus production and other changes. It is usually caused by bacteria or viruses, can be serious in people who have pulmonary or cardiac diseases, and can lead to pneumonia.

Did you know?

Your skin wrinkles if you stay in the bathtub a long time because the outermost layer of skin (which consists of dead keratin) swells when it absorbs water. It is tightly attached to the skin below it, so it compensates for the increased area by wrinkling. This happens to the hands and feet because they have the thickest layer of dead keratin cells.

Did you know?

Only 12 hours after an egg cell is fertilized by a sperm cell, the egg cell starts to divide. As it continues to divide, it moves along the fallopian tube toward the uterus at about 1 inch per day.

Did you know?

Drug-induced pharmacodynamic effects manifested in older adults include drug-induced renal toxicity, which can be a major factor when these adults are experiencing other kidney problems.

Ecosystem and Balance Ecosystem and Balance
An example of a Material Safety Data Sheet (MSDS). An example of a Material Safety Data Sheet (MSDS).
Cloud Types: Vertical Development Cloud Types: Vertical Development
Fluid–solute balance in freshwater and marine bony fishes Fluid–solute balance in freshwater and marine bony fishes
Morgan’s analysis of genetic linkage of X-linked genes for eye color Morgan’s analysis of genetic linkage of X-linked genes for eye color
Morgan’s test-cross analysis of genetic linkage between autosomal genes Morgan’s test-cross analysis of genetic linkage between autosomal genes
Video: Premenstrual Syndrome

For a complete list of videos, visit our video library