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
34kurt
3 years ago
7

In cell G5, enter a formula to calculate the total amount due for the first client based on the annual total and the number of y

ears in the contract. Copy the three formulas in columns C, G, and E down their respective columns.
Business
1 answer:
Brilliant_brown [7]3 years ago
5 0
The answers for your question are: 
1) =E5*F5 (copy to cells G6:G13) 

<span>2) =VLOOKUP(B5,Membership,3,FALSE) </span>

<span>3) =PMT(B$23/B$24,F5*B$24,-I5)</span>
You might be interested in
dditional Information Accrued sales salaries amount to $2,400. Prepaid selling expenses of $2,100 have expired. A physical count
saul85 [17]

Answer:

A) Adjusting entries:

Dr Sales salaries expense 2,400

    Cr Sales salaries payable 2,400

Dr Selling expenses 2,100

    Cr Prepaid selling expenses 2,100

Dr Cost of goods sold 3,700

    Dr Merchandise inventory 3,700

B) prepare the closing entries

Dr Sales revenue 550,900 (net = $557,000 - $19,900 - $6,200)

    Cr Income summary 550,900

Dr Income summary 484,200

    Cr Cost of goods sold 239,700 (net = $236,000 + $3,700)

    Cr Sales salaries expense 62,400 (net = $60,000 + $2,400)

    Cr Selling expense 44,100 (net = $42,000 + $2,100)

    Cr Utilities expense 21,000

    Cr Administrative expense 117,000

Dr Income summary 66,700 (= $550,900 - $484,200)

    Cr Retained earnings 66,700

Dr Retained earnings 45,000

    Cr Dividends 45,000

   

7 0
3 years ago
State sales tax y is directly proportional to retail price x. an item that sells for 170 dollars has a sales tax of 10.22 dollar
scZoUnD [109]
Im guessing sales tax would be 6.25%?
6 0
3 years ago
Investigating careers
goldfiish [28.3K]

B. It is a state of actual emergeny.

5 0
2 years ago
Foreign companies that are listed on the New York Stock Exchange (NYSE) and following their domestic GAAP must report their inco
Arlecino [84]
The generally accepted accounting principles of the United States
7 0
2 years ago
Use the following two statements to answer this question:I. The average total cost of a given level of output is the slope of th
Burka [1]

Answer:

B. Both I and II are true.

Explanation:

<em> The average total cost of a given level of output is the slope of the line from the origin to the total cost curve at that level of output</em>

The average total cost is defined as the sum of all total costs divided by the quantity produced. In other words, the cost of one unit of production. The average cost curve as shown in the diagram is U-shaped, where it falls with economies of scale and later rises as diseconomies of scale sets in.

<em />

<em>The marginal cost of a given level of output is the slope of the line that is tangent to the total cost curve at that level of output</em>

Marginal cost is the change that occurs in the total cost when quantity produced increases by one unit. In other words, it is the cost of producing an additional unit of a good. As per the diagram, the slope of the line tangent to the TC (TC = AC x Q1) curve at Q1 is the firm's marginal cost at this output level.

7 0
3 years ago
Other questions:
  • Which of these statements is true? Group of answer choices
    15·1 answer
  • The quote from a U.N. foundation manager talks about donating a cell phone as a "powerful opportunity . . . to engage and connec
    15·1 answer
  • Calculate the annual cash flows (annuity payments) from a fixed-payment annuity if the present value of the 15-year annuity is $
    5·1 answer
  • On April 1, 2017, Shannon Company, a U.S. company, borrowed 100,000 euros from a foreign bank by signing an interest-bearing not
    8·1 answer
  • John's friend just gave him a pair of concert tickets to see his favorite rock group perform this weekend. Each ticket sells for
    5·1 answer
  • On January 1, Year 1, Abbott Company granted 92,000 stock options to certain executives. The options are exercisable no sooner t
    7·1 answer
  • Brenda is the owner of a spa store that operates 50 weeks per year. Spair Shampoo is a high margin stock-keeping unit (SKU), but
    12·1 answer
  • ________ is seen as a way to stimulate gains in economic efficiency by giving owners a powerful incentive—the reward of greater
    9·1 answer
  • Dave Seminsky’s ability to open Sumarian Coffee in Shanghai can be attributed to which of the following?A. ethnocentrismB. avail
    8·1 answer
  • Comparing health insurance policies. Use Worksheet 9.1. Lexi Thomas, a recent college graduate, has decided to accept a job offe
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!