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
Mekhanik [1.2K]
3 years ago
12

Enter a logical function in cell F5 that calculates employee FICA withholding. If the employee is full-time and has at least one

dependent, then he or she pays 7% of the annual salary minus any deductions. All other employees pay 5% of the annual salary minus any deductions. Copy the function down through column F. Format the data in column F with Accounting Number Format.

Business
1 answer:
mixer [17]3 years ago
3 0

Answer:

the formula in cell F5 =IF(AND(B5="FT",C5>0),0.07*(D5-E5),0.05*(D5-E5))

Explanation

Check attachment for the given data and solution data

You might be interested in
XYZ Development, Inc. leases commercial space to businesses. Most of the leases are long-term, from five to fifteen years in len
prisoha [69]

Answer:

B. Escalator Clause

Explanation:

An escalation clause is a clause in a lease or contract that guarantees a change in the agreement price once a particular factor beyond control of either party affecting the value has been determined. An important example of this is a contract that adjusts for inflation.

4 0
3 years ago
A(n) ____ cannot be changed or ended. irrevocable trust living will power of attorney revocable trust will
xxMikexx [17]
<span>Like its name implies, an irrevocable trust cannot be changed or ended. Grantors who transfer their assets into such a trust are effectively gifting them to it, revoking their ownership of said assets. This trust is often used as a more tax-effective way to protect an estate.</span>
5 0
3 years ago
Suppose that real domestic output in an economy is 20 units, the quantity of inputs is 10, and the price of each input is $4. An
weqwewe [10]

Answer:

A. supply curve shifts to the left

Explanation:

An increase in the prices of inputs from $4 to $6 shows economic problems that include a reduction in capital stock, labor, and an increased unemployment rate. This can also give room for inflation.

This increase shows that due to shortage in labor supply, it now costs more to produce a product.

Due to all the above mentioned reasons, the supply curve of both long run and short run supply curves shifts left.

Cheers.

7 0
3 years ago
a 17-year annuity pays $1,100 per month, and payments are made at the end of each month. The interest rate is 16 percent compoun
zzz [600]

Answer:

The present value of the annuity is $73,091.50

Explanation:

Use the following formula to calculate the present value of the annuity

Present value of annuity = ( Annuity Payment x Annuity factor for first 6 years ) + [ ( Annuity Payment x Annuity factor for after 6 years ) x Present value factor  for 6 years ]

Where

Annuity Payment = $1,000

Annuity factor for first 6 years = 1 - ( 1 + 16%/12 )^-(6x12) / 16%/12 = 46.10028344

Annuity factor for after 6 years = 1 - ( 1 + 13%/12 )^-((17-6)x12) / 13%/12 = 70.0471029820

Present value factor for 6 years = ( 1 + 16%/12)^-(6x12) = 0.385329554163

Placing values in the formula

Present value of annuity = ( $1,000 x 46.10028344 ) + [ ( $1,000 x 70.0471029820 ) x 0.385329554163 ]

Present value of annuity = $46,100.28 + $26,991.22

Present value of annuity = $73,091.50

4 0
3 years ago
Which products are considered "covered products" by the Treasury Department and are subject to anti-money regulations?
AURORKA [14]

Answer:

B) C and D

  • C. Whole life insurance
  • D. Annuities

Explanation:

Anti-Money Laundering (AML) regulations identified the following insurance products as covered products:

  • Permanent life insurance policy, other than a group and term life insurance policy
  • An annuity contract, other than a group annuity contract
  • Any other insurance product with features of cash value or investment.

The AML's main goal is detect and stop terrorist financing.

5 0
3 years ago
Other questions:
  • In most of the 1970s, the fed's policy created expectations of high inflation. true false
    6·1 answer
  • In a command economy, which group is most responsible for producing the
    15·1 answer
  • One suggestion for effective teamwork is to resolve disputes _____.
    9·2 answers
  • Garcia manufacturing's april sales forecast projects that 5,000 units will sell at a price of $10.50 per unit. the desired endin
    8·1 answer
  • An economist studying the market for wild Alaskan salmon determines the price elasticity of supply to be 0.43. a. In this case,
    6·2 answers
  • Which of the following is an example of marginal cost?
    12·1 answer
  • Many businesses today appear to have some type of corporate social responsibility edict. When might the need for social responsi
    10·1 answer
  • Procter &amp; Gamble markets its popular multipurpose cleaner as Mr. Clean in North America and Asia but uses several different
    8·1 answer
  • You want to buy an annuity that will pay you $1000 per year for 20 years. You find an account that will pay 4% per year, compoun
    9·1 answer
  • The following strategy(ies) could be used to sustain the value provided by an organization: Group of answer choices Run Strategy
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!