All categories

3 years ago

Circular errors are caused by adding the cell name of an _________ cell formula?

1 answer:

7 0

The answer is an active cell. A circular reference occurs when a cell in an Excel<span> 2010 worksheet refers to itself.</span>

You might be interested in

Q 2.29: Val-Tek has current assets of $1,700,000 and current liabilities of $900,000. If they pay $100,000 owed to a creditor, w

irina1246 [14]

Answer:2 : 1

Explanation:

current ratio = current asset/current liability

If current liability was $900,000 less $100,000= $800,000

Therefore the current ratio=

$1,700,000/$800,000 =

2 : 1

3 0

3 years ago

Read 2 more answers

Meester Corporation has an activity-based costing system with three activity cost pools--Machining, Order Filling, and Other. In

KIM [24]

Answer:

$26,110

Explanation:

See attached file

3 0

2 years ago

Consider an offer to supply 5 paintings per year to an art gallery in Rome for the next five years. The contract is exclusive, m

IceJOKER [234]

Answer:

I will accept the offer if the price per painting is $56,312.41 or higher.

Explanation:

We will calculate the present value of the other option which is, selling our painting as a freelancer.

$C \times \frac{1-(1+r)^{-time} }{rate} = PV\\$

C 315,000.00

time 5

rate 0.2

$315000 \times \frac{1-(1+0.2)^{-5} }{0.2} = PV\\$

PV $942,042.8241

Now, we subtract the signing bonus of 100,000

942,042.83 - 100,000 = 842,042.83

And solve for the annual proceeds from the painting we need to equalize the opportunity cost:

$PV \div \frac{1-(1+r)^{-time} }{rate} = C\\$

PV 842,042.83

time 5

rate 0.2

$842042.83 \div \frac{1-(1+0.2)^{-5} }{0.2} = C\\$

C $ 281,562.03

Now, we divide by the 5 painting per year:

$281,562.03 per year / 5 painting per year = $56,312.41

3 0

2 years ago

One of your customers is delinquent on his accounts payable balance. You’ve mutually agreed to a repayment schedule of $500 per

jekas [21]

Answer: Number of months = 66.87 months

Explanation:

Given that,

Monthly Payment = $500

Interest rate(r) = 1.95% per month

Current Balance = $18,500

Number of months(t) = ?

$Current\ balance = Monthly\ payment\times(\frac{1-present\ value\ factor}{r})$

$Current\ balance = Monthly\ payment\times(\frac{1-\frac{1}{(1+r)^{t}} }{r})$

$18,500 = 500\times(\frac{1-\frac{1}{(1+0.0195)^{t}} }{0.0195})$

$\frac{18,500}{500}\times0.0195=1-\frac{1}{1.0195^{t} }$

$\frac{1}{1.0195^{t}}=1-0.7215$

$1.0195^{t}=\frac{1}{0.2785}$

$1.0195^{t}=3.5906$

Taking log on both side

t log(1.0195) = log(3.5906)

$t = \frac{0.5551}{0.0083}$

t = 66.87 months

6 0

3 years ago

Which of the following kinds of price discrimination occurs when each customer is charged one price for the first set of units p

olasank [31]

Answer:

Explanation:

Price discrimination is when the same product is sold at different prices to customers in different markets

types of price discrimination

1. first degree price discrimination : here sellers charge each consumer at their willingness to pay in order to eliminate consumer surplus.

2. second degree price discrimination : here firms offer different prices depending on the quantity purchased. e.g. giving discounts for bulk purchases.

3, third degree price discrimination : firms charge different prices to different groups of customers. e.g. having a certain price for senior citizens, students

3 0

3 years ago