All categories

2 years ago

What are some Excel functions that a financial planner might use or need?

Business

1 answer:

alexandr1967 [171]2 years ago

7 0

1. Vlookup and Hlookup
2. Pivot table
3. some IF functions such as countif, countifs

You might be interested in

Mauro Products distributes a single product, a woven basket whose selling price is $19 per unit and whose variable expense is $1

Eduardwww [97]

Answer:

Results are below.

Explanation:

Giving the following information:

Selling price= $19

Unitary variable cost= $15

Fixed costs= $12,000

To calculate the break-even point in units and dollars, we need to use the following formulas:

Break-even point in units= fixed costs/ contribution margin per unit

Break-even point in units= 12,000 / 4

Break-even point in units= 3,000

Break-even point (dollars)= fixed costs/ contribution margin ratio

Break-even point (dollars)= 12,000 / (4/19)

Break-even point (dollars)= $57,000

Now, the fixed costs are $12,600:

Break-even point in units= 12,600 / 4

Break-even point in units= 3,150

Break-even point (dollars)= 12,600 / (4/19)

Break-even point (dollars)= $59,850

7 0

2 years ago

which of the following describes an important difference between general partnership and limited partnerships

dexar [7]

The main difference between a general partnership and a limited partnership is that "A general partnership has unlimited liability for all partners while a limited partnership has limited liability." In addition, the liability of the personal assets in a general partnership is its obligation.

8 0

2 years ago

Read 2 more answers

Part of the decision to accept additional business should be based on a comparison of the incremental (differential) costs of th

postnew [5]

Answer:

TRUE

Explanation:

Marginal Benefit is addition to total benefit due to a business decision.

Marginal Cost is addition to total cost due to a business decision.

Marginal Benefit & Marginal Costs are determinants while considering a business decision. A decision will be taken if : Marginal Benefit ≥ Marginal Cost, as entrepreneurial decision maker would be better off or at least neutral while taking decision. If MB < MC , it is loss making for the entrepreneur to take that decision & hence is discouraged to take that.

6 0

3 years ago

The index weighting that results in portfolio weights shifting away from securities that have increased in relative value toward

Sliva [168]

Answer: B. Fundamental weighting.

Explanation:

A fundamentally weighted index refers to a type of equity index whereby the components that are chosen based on the fundamental criteria like the dividend rates, book value, revenue, dividend rates, etc.

Fundamental weighting is the index weighting which results in portfolio weights shifting away from securities that have increased in relative value toward securities that have fallen in relative value whenever the portfolio is rebalanced.

3 0

2 years ago

Even with international trade, countries rarely specialize because A. Some countries do not have a comparative advantage in any

Rina8888 [55]

Letter A marks the spot

8 0

2 years ago