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
At the beginning of the year (January 1), Buffalo Drilling has $12,000 of common stock outstanding and retained earnings of $7,1
Mrrafil [7]

Answer:

                                Statement of stockholders' equity

                              at the end of the year (December 31)

                                     <u>Common Stock</u>        <u>Retained Earning</u>       <u>Total</u>

Opening Balance              $12,000                       $7,100               $19,100

Income for the year                                                $7400              $7400

Dividend Paid                                                        ($2,100)             ($2,100)

Common stock issuance  <u> $6,900  </u>                  <u>                 </u>           <u> $6900  </u>

End of the year Balance    $18,900                    $12,400             $31300

3 0
3 years ago
A monopolist will find that its marginal revenue curve Grupo de opciones de respuesta Lies below its demand curve and has the sa
alexdok [17]

Answer:

Lies below its demand curve and is steeper than its demand curve.

Explanation:

The marginal revenue curve for a monopolist lies below the demand curve because of the quantity effect. The quantity effect refers to the fact that even a monopolist must lower its price if it wants to sell a larger quantity of goods or services.

The slope of the marginal revenue curve is steeper than the demand curve because it reflects the market power of the monopolist. Instead, the marginal revenue curve for a perfectly competitive firm (with 0 market power) is horizontal or perfectly elastic.

5 0
3 years ago
Suppose labor's share of output is 60% and capital's share of output is 40%. If labor grows at a rate of 5%, then this will caus
12345 [234]

If capital grows at a rate of 5%, then this will cause output to grow at a rate of 1%.

Given,

Labor's share of output = 60%

Capital's share of output = 40%

Labor grows on a rate of = 5%

Capital grows on a rate of = 5%

Thus, output will grow at a rate of = ?

SR(t) = Δy/Δt/Y - (αΔk/Δt/k(t) + (1-α)(ΔL/Δt/L(t))

Here, α = 60%

So, labor's share = (1 - 0.6) × 5  = 2%

Capitals contribution = 0.4 × 5  = 2%

Implied rate of growth in technology is also given,

SR = (5) - (2+2)

= 1%

Hence, if capital grows at a rate of 5%, then this will cause output to grow at a rate of 1%.

To learn more about capital here:

brainly.com/question/24212838

#SPJ1

8 0
1 year ago
The net income reported on the income statement for the current year was $210,000. Depreciation recorded on equipment and a buil
Lana71 [14]

Answer:

Cash flows from operating activities section

                                                                  Amount in $  

Net income                                             210,000.00    

Depreciation                                              62,500.00        

Change in Accounts Receivable              -2,400.00

Change in Inventories                              13,500.00  

Change in Prepaid Expenses                 -600.00

Change in Accounts Payable                      3,800.00  

Change in Salaries Payable                    <u>     -750.00</u>

Cash flows from operating activities    <u> 286,050.00</u>    

Explanation:

The operating activities includes net income, depreciation and changes in current assets and current liabilities. The depreciation as a non-cash item is added back in the cash flows statement.

An increase in current assets represents an outflow of cash hence the negative value and vice versa. The increase in current liabilities represents an inflow of cash hence it is positive and vice versa. Below are the changes.

                                          Amount in $   Amount in $   D ifference

Change in Accounts Receivable  71,000    73,400       (2,400.00)

Change in Inventories                140,000    126,500   13,500.00  

Change in Prepaid Expenses    7,800       8,400      (600.00)

Change in Accounts Payable  62,600    66,400      3,800.00  

Change in Salaries Payable             9,000       8,250      (750.00)

7 0
4 years ago
Hal and Gavin are siblings who own a mattress recycling company. Demand has been increasing for their services and the brothers
Yakvenalex [24]

I think it's A. They decide to open a mattress drop off site, downtown, because the marginal, cost of the new location is less than the other projects.

4 0
3 years ago
Other questions:
  • An approach to combining risk identification, risk assessment, and risk appetite into a single strategy. is known as risk protec
    8·1 answer
  • A ________ is a graph of decisions and their possible consequences.a. decision structureb. corporate hierarchyc. resolution grap
    13·1 answer
  • Car payments are determined using simple interest. If you don’t remember this formula, go back and look it up! To finance your v
    10·1 answer
  • When a company purchases another company and the purchase price is greater than the fair value of the net assets acquired, this
    14·1 answer
  • What is marketing mix definition
    15·1 answer
  • Promotion tends to a. overemphasize physiological and safety needs. b. capitalize on existing needs. c. avoid focusing on people
    6·1 answer
  • Effects on currrent ratio
    14·1 answer
  • Susan saved $5000 per year in her retirement account for 10 years (during age 25-35) and then quit saving. However, she did not
    14·1 answer
  • Assume the corporate tax view of capital structure. Your unleveraged cost of capital is 13%. Your corporate tax rate is 30%. You
    11·1 answer
  • Positive outcomes of entrepreneurship in marketplace
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!