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
RT is about to loan his granddaughter Cynthia $10,000 for 1 year. RT’s TVOM, based upon his current investment earnings, is 12%,
qaws [65]

Answer:

They should not be able to successfully negotiate the terms of this loan within these parameters.

Explanation:

It has been provided that RT earns 12% on his current investments and would not like to receive an interest rate of less than 12% on the loan he gives.

if RT gives a loan of $10,000 for one year, he would charge an interest rate of minimum 12%.  

Interest = $10,000*0.12

             = $1,200

RT requires $1,200 in interest.

It has been provided that Cynthia earns 8% on her investment.

If she borrows $10,000 and invests the amount for one year, she can earn 8% return on such amount.  

Earning = $10,000*0.08

             = $800

Cynthia is going to earn $800

RT requires a minimum of $1,200 as interest for 1-year loan he gives while Cynthia can pay a maximum of $10,000 as interest for 1-year loan she takes. there is mismatch between the minimum expectation to receive of lender and the maximum expectation to pay of borrower.

Therefore, They should not be able to successfully negotiate the terms of this loan within these parameters.

6 0
3 years ago
In recent times, the value of "currency" as well as "checkable deposits" was about $___________ billion each.
Alinara [238K]

Answer:

As of December 2019, the total amount of currency in the US economy was $1,700 billion, while total checkable deposits as of December 2019 was $2,300 billion.

Explanation:

Total M1 money supply in the US economy as of December 2019 was $4 trillion (as stated by the federal reserve)

M1 money supply includes checkable deposits, paper bills and coins (currency) and travelers' checks.

6 0
2 years ago
The term _____ is defined as the activity, set of institutions, and processes for creating, communicating, delivering, and excha
lubasha [3.4K]

Answer:

Marketing

Explanation:

There are various explanations for the term Marketing. It is essentially a group of activities aimed at creating a valuable customer relationship. Unlike traditional approaches which planned their activities based on what the customers would buy, the Marketing approach takes decisions based on wht the customer wants/needs. It places customer at the center and all the activities revolve around them.

7 0
2 years ago
Accounts Receivable from sales to customers amounted to $80,000 and $70,000 at the beginning and end the year, respectively. Inc
Kipish [7]

Answer:

$332,000

Explanation:

<u>Cash flow from operating activities</u>

Net Income                                                                                  $252,000

Adjust for changes in working capital items :

Decrease in Accounts Receivable ($80,000 - $70,000            $80,000

Net Cash Provided by Operating Activities                              $332,000

Conclusion

the cash flows from operating activities to be reported on the statement of cash flows is $332,000

5 0
3 years ago
In the securitization process, mortgages are pooled together and cash flows are packaged into securities to be sold in the secon
Viefleur [7K]

Answer:

conduits

Explanation:

A mortgage-backed security is one in which is similar to bonds but that usually consists of home loans ought from banks that issued them. It is a type asset-backed security which can be sold through brokers.

investment in mortgage-backed assets means the investor is lending out his money to people that intend to get a home.

A mortgage-backed security can be bought directly from banks or through brokers. These brokers are also called conduits.

Cheers

7 0
3 years ago
Other questions:
  • Companies generate income from their "regular" operations and from things like interest on securities they hold, which is called
    14·1 answer
  • Wilson states, "Culture is important to me. Our culture is based on accountability, camaraderie, and results. I’ve moved from fi
    8·1 answer
  • A new manager has been in their role for three months. They take time each day to get to know and socialize with their team, and
    7·2 answers
  • Partner A has a smaller capital balance than Partner L. Partner A, however, has a higher profit-and-loss-sharing percentage than
    9·1 answer
  • Inventory records for Dunbar Incorporated revealed the following:Date Transaction Number of units Unit CostApr. 1 Beginning inve
    12·1 answer
  • On December​ 31, Year​ 10, Brown Company changed its inventory valuation method from the​ weighted-average method to FIFO for fi
    9·1 answer
  • Perfectly competitive industry X has constant costs and its product is an inferior good. The industry is currently in long-run e
    11·1 answer
  • How are time tickets and materials requisition slips similar?
    8·1 answer
  • Jasper makes a $44,000, 90-day, 9% cash loan to Clayborn Company. Jasper's entry to record the collection of the note and intere
    13·1 answer
  • If the demand for product x is inelastic, a 15 percent decrease in the price of x will:____.
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!