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
uranmaximum [27]
3 years ago
12

Enter a formula in cell B1 using the SUMPRODUCT function to calculate the total value of the current leases by multiplying the c

urrent monthly rents by the remaining months on each lease. Use the range names Rents and Leases.
Business
1 answer:
Burka [1]3 years ago
5 0

Answer:

The answer is " =SUMPRODUCT(Rents, Leases in cell B1, and pressed Enter)".

Explanation:

The function "SUMPRODUCT" returns the total of products with their respective ranges or arrays. Its main operation is multiplying, although it is necessary to add, subtract, and divide.

To calculate the "SUMPRODUCT", we just click on the cell B1 and type the "SUMPRO" by typing the in cell B1, and double-clicked and apply the above formula that is "=SUMPRODUCT(Rents, Leases in cell B1, and pressed Enter)".

You might be interested in
Last year, Hampton Corporation had sales of $1,855,000. The firm's costs of goods sold amounted to 70% of sales. Hampton also pa
jeka57 [31]

Answer:

Tax Liability = $74,550

Explanation:

Particular                                   Amount

Sales                                             $1,855,000

Less: COGS(70% of sales)           <u>$1,298,500</u>

Gross Profit                                   $556,500

Less: Operating expenses           <u>$225,000</u>

Operating profit                            $331,500

Add: Taxable dividend income    $40,000

Add: Capital gain                           $10,000

Less: Interest Expenses                <u>$26,500</u>

Net Taxable Income                      $355,000

Tax rate = $355,000 * 21%  

Tax Liability = $74,550

Note: 21% is the Tax rate approved by the Tax cuts and Job Acts of 2017.

3 0
3 years ago
in forward and futures contracts, the risk of non-fulfilment of contract terms is most likely borne by:
topjm [15]

In forward and futures contracts, the risk of non-fulfillment of contract terms is most likely borne by <u>both parties</u><u> to the contract</u>.

<h3>What are forward and futures contracts?</h3>

The difference between a forward and futures contract lies in their establishment.

A forward contract is a personal arrangement traded over the counter whereas, a futures contract is a standardized contract made through an established exchange.

Thus, in forward and futures contracts, the risk of non-fulfillment of contract terms is most likely borne by <u>both parties</u><u> to the contract</u>.

Learn more about forward and futures contacts at brainly.com/question/15581105

#SPJ12

7 0
1 year ago
Soprano Corporation allocates administrative costs on the basis of staff hours. Short-run monthly usage and anticipated long-run
Nuetrik [128]

Answer:

$850,000

Explanation:

Total Hours of Department 1=$80,000+$90,000

=$170,000/$200,000*1000,0000

8 0
2 years ago
An anticipated purchase of equipment for $1,000,000, with a useful life of eight years and no residual value, is expected to yie
exis [7]

Answer:

3 years

The average rate of return method includes the entire amount of the income earned over the life of the proposal.

a. rate of return on investments

b. may be reconsidered if funds later become available.

Explanation:

Cash payback period measures how long it takes to recover the amount invested in a project from the cumulative cash flow.

Amount invested = $-1,000,000

Amount recovered in year 1 = $-1,000,000 + $400,000 = $-600,000

Amount recovered in year 2 = $-600,000 + 320,00 = $-280,000

Amount recovered in year 3 = $-280,000 + 280,000 = 0

The amount invested is recovered In the 3 year

Average accounting rate = average net income/ average book value

Net present value is the present value of after tax cash flows from an investment less the amount invested. The interest rate used is the rate of return on investments.

The hurdle rate is the least acceptable rate that a project can have for it to be acceptable.

I hope my answer helps you

8 0
3 years ago
Marcella has a $65,000 basis in her 50% partnership interest in the JM Partnership before receiving any distributions. This year
PSYCHO15rus [73]

Answer:

C) $40,000 inventory basis, $15,000 JM basis.

Explanation:

JM distributed $80,000 worth of inventory, since Marcella has a 50% partnership interest, then half of the inventory belongs to her, $40,000 (= $80,000 / 2).

Since Marcella also received $10,000 in cash from JM, then her remaining basis in the partnership is:

$65,000 - $40,000 - $10,000 = $15,000

3 0
2 years ago
Other questions:
  • These are selected 2022 transactions for Flounder Corporation: Jan. 1 Purchased a copyright for $96,000. The copyright has a use
    13·1 answer
  • In what way does the article describe the two-party system as a positive system when compared with a multiparty system?
    6·2 answers
  • HELP I AM CONFUSED!!!
    9·1 answer
  • Suppose that the rise in the price of coffee beans resulted in a large decrease in the supply of Starbucks coffee while the lowe
    14·1 answer
  • Caribou Fruit Drink Company planned to make 200,000 containers of apple juice. It expected to use two cups of frozen apple conce
    9·1 answer
  • Consider the economies of Gobbledigook and Hermes, both of which produce agricultural products using only land and labor. The fo
    6·1 answer
  • A ________ rate means the value of the currency is fixed relative to a reference currency and then the exchange rate between tha
    15·1 answer
  • Donna Company makes three types of products. The company has two types of customers. The cost to serve all customers is $12,000
    12·1 answer
  • It is important to accommodate diverse cultural needs to set your
    8·1 answer
  • Bakan Corporation has provided the following production and average cost data for two levels of monthly production volume. The c
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!