answer.
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
Bess [88]
2 years ago
14

Filter the data in place so that only rows where the category value is meals and the cost value is greater than 20 are shown. th

e criteria range has been set up for you in cells a1:c2.
Business
1 answer:
Anestetic [448]2 years ago
4 0

Explanation:

To find :

Filter the data in order such that only rows where the sum of the type is food and the sum of the amount is greater than 20 are displayed. The selection of requirements has been set for you in cells a1:c2.

Now,

You clicked the Advanced button on the Data Ribbon Tab in the Sort & Filter Ribbon Section.

You tapped on cell A1.

You pressed the OK button in the Advanced Filter window.

You might be interested in
Your client has been offered a 5-year, $1,000 par value bond with a 10 percent coupon. Interest on this bond is paid quarterly.
Serjik [45]

Answer:

$906.18

Explanation:

Step 1: Calculation of the present value of the coupon (PVC) cash flow

The formula for calculating the PV of an ordinary annuity is used as follows:

PVC = P × [{1 - [1 ÷ (1+r)]^n} ÷ r] …………………………………. (1)

Where;

PVC = Present value of the coupon (PVC) payment =?

P = Quarterly coupon amount = $1,000 × (10%/4) = $25

r = interest rate = 12% annual = 12% ÷ 4 quarterly = 3% or 0.03 quarterly

n = number of period = 5 years = 7 × 4 quarters = 28 quarters

Substitute the values into equation (1) to have:

PVC = 25 × [{1 - [1 ÷ (1+0.03)]^28} ÷ 0.03] = $469.10

Step 2: Calculation of the present value of the face value (PVFAV) of the bond

The simple PV formula is used as follows:

PVFAV = FAV ÷ (1 + r)^n ……………………………………. (2)

Where;

PVFAC = Present value of the face value of the bond = ?

FAC = Face value of the bond = $1,000

r and n are as already given in step 1 above

Substituting these values into equation (2), we have:

PVFAV = FAV ÷ (1 + 0.03)^28 = $437.08

Step 3: Calculation of the market price of the bond

Market price of the bond = PVC + PVFAC …………………………… (3)

From step 1, PVC is $469.10, and PVFAC is $437.08 from Step 2. We can them substitute for them  in equation (3) and have:

Market price of the bond = $469.10 + $437.08 = $906.18

Conclusion

Therefore, she should pay $906.18 for the bond.

5 0
2 years ago
The sales for​ January, February, and March are​ $150,000, $180,000 and​ $220,000, respectively. For any particular month of​ sa
Gekata [30.6K]

Answer:

Total cash= $193,000

Explanation:

Giving the following information:

Estimated sales ($):

January= $150,000

February= $180,000

March= $220,000

40% in cash from that same month of​ sales

50% in cash from the previous​ month's sales

10% in cash from the sales from two months ago

C<u>ash collection March:</u>

From March= 220,000*0.4= 88,000

From February= 180,000*0.5= 90,000

From January= 150,000*0.1= 15,000

Total cash= $193,000

3 0
2 years ago
Jeff jones earns $1,200 per week. he is married and claims four withholding allowances. the social security rate is 6.2% on $118
myrzilka [38]
<span>Answer: Gross Pay: $1200 Less Health Ins: (42.50) Taxable Pay: 1157.50 SS Tax: 71.77 (1157.50 *.062) Medicare Tax: 16.78 (1157.50 *.0145) FIT: 91.79 Net Pay: 977.17 FIT calcualted as follows: Taxable less allowances (1157.50 less (71.15*4) = 872.9 (872.9 * .15)-39.15 = 91.79</span>
4 0
2 years ago
What is a flexible​ budget? A. The difference between the master budget and the flexible budget B. The orginally planned budget
Anestetic [448]

Answer:

I do believe the answer is a please correct me if I'm worng

8 0
1 year ago
Polk Products is considering an investment project with the following cash flows:
Andrei [34K]

Answer:

b. 1.86 years

Explanation:

The computation of the project's discounted payback is shown below:-

Year   Cash Flows      Discounted CFs (at 10%)        Cumulative

 

                                                                                Discounted CFs

0        -$100,000           -$100,000                          -$100,000

1          $40,000              $36,363.64                       -$63,636.36

2          $90,000              $74,380.17                        $10,743.80

3          $30,000               $22,539.44                      $33,283.25

4          $60,000               $40,980.81                      $74,264.05

Discounted Payback Period = Years before full recovery +

(Uncovered Cost at start of the year ÷ Cash Flow during the year)

Now we will put the values into the formula

= 1 + ($63,636.36 ÷ $74,380.17)

= 1 + 0.86

= 1.86 years

6 0
2 years ago
Other questions:
  • Can cathy withdraw money from her ira savings account
    9·2 answers
  • Poland requires 4 hours of labor to produce 1 ton of coal and 1 hour of labor to produce a bushel of wheat. The Czech Republic r
    6·1 answer
  • Slapshot Company makes ice hockey sticks. During the month of June, 1,900 sticks were completed at a cost of goods manufactured
    5·1 answer
  • During the current year, Comma Co. had outstanding: 25,000 shares of common stock, 8,000 shares of $20 par, 10% cumulative prefe
    12·1 answer
  • The marginal utility of the last unit of apples consumed is 12 and the marginal utility of the last unit of bananas consumed is
    6·1 answer
  • Troy starts a job right out of college. He feels lucky to have found a position in the financial industry. Troy knows that he ne
    15·1 answer
  • There are three categories of cash flows: single cash flows, also referred to as "lump sums," a stream of unequal cash flows, an
    10·1 answer
  • Show how Cablevision can conduct an ROI analysis. Describe the information that the company should collect and how it should b c
    15·1 answer
  • Sunspot Beverages, Ltd., of Fiji uses the weighted-average method in its process costing system. It makes blended tropical fruit
    13·1 answer
  • Finally, help Anastasia by thinking of three professionals that can help her in the next steps of her course development. Do som
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!