1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
cestrela7 [59]
3 years ago
10

Your lobster fishing business is straightforward, and you run your accounting in Excel. You maintain separate workbooks for each

year, and each workbook has a spreadsheet for every month. The monthly spreadsheets are identical except for their names, which are January, February, etc. You have found that you need to sum your diesel fuel expenditures, which are always recorded in cell D18, for the months of August through December. What three-dimensional formula would give you that result
Business
1 answer:
Oksana_A [137]3 years ago
7 0

Answer:

The three-dimensional formula that would give you the required result, that is suming the diesel fuel expenditures, which are always recorded in cell D18 for the months of August through December is:

=SUM(August:December!D18).

Explanation:

First, enter the excel starting formula "=SUM(". Type "August" or  left-click on the August sheet with the mouse. Type in colon and December or hold the Shift key and left-click on the December sheet. Then, select the cell C3 in the December sheet.  Before pressing "Enter," add a closing bracket.  The sum formula looks exactly like this: "=SUM(August:December!D18)." This formula can completely be typed manually. The formula sums up cell D18 across each of the sheets from August to December, returning a value.

You might be interested in
Parkinson Company (PC) had a beginning balance of $86,000 and an ending balance of $90,000 in itslong-term marketable securities
algol [13]
B I think sorry if wrong :/
8 0
2 years ago
When visiting your sister, you notice that her infant enjoys watching a mobile that hangs over his head. of the various objects
katovenus [111]
The big chainsaw is ur answer I bieleve
3 0
3 years ago
The following data relate to the operations of Slick Software, Inc., during 2018. Continuing operations:
Maurinko [17]

Answer:

A. $5.70

B. $7,625,000

C. $2.25

D. UNFAVORABLE amount of $4.25

Explanation:

a.Preparation of a condensed income statement for 2018,

SLICK SOFTWARE, INC.Condensed Income StatementFor the Year Ended December 31, 2018

Net sales $19,850,000

Costs and expenses $16,900,000

Income from continuing operations$2,950,000

Discontinued operations:

Operating income $140,000

Loss on disposal (net of income tax benefit)(550,000)

Income before extraordinary item $2,540,000 Extraordinary loss (net of income tax benefit)(900,000)

(550,000+350,000)

Net income$1,640,000

($2,540,000-900,000)

Earnings per share:

Earnings from continuing operations$12.25

[($2,950,000 - $500,000) ÷200,000]

Loss from discontinued operations (2.05)

($410,000 ÷ 200,000 shares)

Earnings before extraordinary items $10.20

[($2,540,000 - $500,000 preferred dividends) ÷ 200,000]

Extraordinary loss (4.50)

($900,000 ÷200,000 shares)

Net earnings $5.70

[($1,640,000 - $500,000 preferred dividends)÷200,000 shares]

Calculation for Preferred dividends:

Preferred dividends: 80,000 shares x $6.25 =$500,000

b.Preparation of a statement of retained earnings for the year ended December 31, 2018

SLICK SOFTWARE, INC.Statement of Retained Earnings For the Year Ended December 31, 2018

Retained earnings, December 31 2017 $7,285,000

Less: prior period adjustment350,000

Restated$6,935,000

Net income1,640,000

Subtotal$8,575,000

($6,935,000+1,640,000)

Cash dividends(950,000)

Retained earnings, December 31, 2017 $7,625,000

($8,575,000-$7,625,000)

c.Computation for the amount of cash dividend per share of common stock

Total cash dividends declared during 2018 $950,000

Less: Preferred stock dividend 500,000

(80,000 shares x $6.25 per share)

Cash dividends to common stockholders $450,000

Number of common shares outstanding 200,000

Cash dividend per common share $2.25

($450,000 ÷ 200,000 shares)

D. The amount of $8.00 earnings per share figure in 2019 will have unfavorable figure when compared with the year 2018 reason been that

the year 2019 has one Earnings Per Share amount which is why we should compared it to the earnings per share from continuing operations in year 2018, which gave us the amount of $12.25 per share[($2,950,000 - $500,000) ÷200,000] which inturn makes Slick Software, Inc.’s earnings per share from continuing operations to reduce to the amount of $4.25 per share ($12.25-$8.00) from the year 2018 to 2019

4 0
4 years ago
Interest rates can be measured more accurately and quickly than reserve aggregates; hence an interest rate is preferred to the r
7nadin3 [17]

Answer:

False

Explanation:

This is false.

In reporting reserves aggregate there are lags interest rate such as the federal interest rate are quite easy to measure and easily observable. Such short term interest rate are nominal values and they do not measure the real cost of borrowing well. It does not show accurately what happens to Gross domestic product. Real interest rate equals nominal interest rate as a ratio of reduced inflation gives a representation of true cost of borrowing.

We cannot say with certainty that interests rate is a better policy instrument based on the ground of measurability.

7 0
3 years ago
Rather than generating tax revenue as do tariffs, subsidies require tax revenue. Therefore, they are not an effective protective
KatRina [158]

Yes. Subsidies are benefits that the government can grant to institutions, households and businesses to promote economic efficiency and reduce market failures. They may be distributed through cash or by cutting tax rates. However, there is controversy about the effectiveness of using subsidies for the economy, often related to the inefficiency of promoting a free market, allocating resources that could be used for investment in productive resources and masking the results of economic efficiency. Another major concern with the use of subsidies is the formation of political alliances of those who receive them and those who provide them, creating political interests because of their use.

6 0
3 years ago
Other questions:
  • Agatha's Inc. is about to introduce a new product in the market, but is not sure as to how it should price the product. The comp
    11·1 answer
  • Which is an example of an ethical dilemma?
    13·2 answers
  • Roca, Inc., manufactures and sells two products: Product M6 and Product X7. The company has an activity-based costing system wit
    5·1 answer
  • Suppose the reserve requirement is 5​%. What is the effect on total checkable deposits in the economy if bank reserves increase
    12·1 answer
  • Detailing's cost formula for its materials and supplies is $2,060 per month plus $12 per vehicle. For the month of August, the c
    10·2 answers
  • Progressive companies use __________ to communicate their csr efforts with the public
    15·1 answer
  • What is the main advantage for businesses that participate in the globalized market?
    10·2 answers
  • How to become a firefighter. I want to become one.
    14·1 answer
  • Imagine that you are a professional in the airline industry and you witness a catering agent leaping between a catering truck an
    5·1 answer
  • What would be the net present value of a microwave oven that costs $159 and will save you $68 a year in time and food away from
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!