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

Calculating Standard Quantities for Actual Production Guillermo's Oil and Lube Company is a service company that offers oil chan

vova2212 [387]

Answer:

Number of quarts for 960 oil changes= 6,144 quarts

No of hours for 960 oil changes = 432 hours

Number of quarts for 950 oil changes=6,080 quarts

No of hours for 950 oil changes= 427.5 hours

Explanation:

Guillermo's Oil and Lube Company

1.Number of quarts for 1 oil change = 6.4 quarts of oil

Number of quarts for 960 oil changes= 6.4 quarts of oil *960= 6,144 quarts

2. Number of minutes for 1 oil change = 27 minutes

Number of minutes for 960 oil changes = 27 minutes*960= 25920 minutes

No of hours for 960 oil changes = 25920/60= 432 hours

3.Number of quarts for 1 oil change = 6.4 quarts of oil

Number of quarts for 950 oil changes= 6.4 quarts of oil *950= 6,080 quarts

Number of minutes for 1 oil change = 27 minutes

Number of minutes for 950 oil changes = 27 minutes*950= 25650 minutes

No of hours for 950 oil changes= 25650/60= 427.5 hours

5 0

2 years ago

Question 8

Ghella [55]

Answer:

Explanation:

I know the answer

8 0

2 years ago

Read 2 more answers

You are asked to recommend whether a firm should make or purchase product A. The following are data concerning the two options.

Alexxandr [17]

Answer:

Instructions are listed below

Explanation:

Giving the following information:

For the purchase option:

Buying price= $22 per unit.

For the make option:

Weekly rental payment of $30,800

The firm also has to hire five operators to help make product A. Each operator works eight hours per day, five days per week at the rate of $14 per hour.

The material cost for the make option is $15 per unit of product A.

A) We need to find the number of units that makes the unitary fixed costs= $7

Weekly rental= 30800

Direct labor= ($14*8 hours*5workes)*5 days= 2800

Total fixed costs= $33,600

Unitary fixed costs= total fixed costs/ Q

7=33600/Q

Q= 4800 units

B) Now Q= 6600

Buy= 6600*22= $145,200

Make= 6600*15 + 33600= $132,600

3 0

2 years ago

Crackling Fried Chicken bought equipment on January 2, 2016, for $21,000. The equipment was expected to remain in service for fo

rjkz [21]

Answer:

Please see attachment

Explanation:

Please see attachment

5 0

3 years ago

Get-away Inc. is a vacation planning company. It provides various holiday packages, such as camping outdoors, adventure sports,

galben [10]

Get-away represents lifestyle segmentation.

<h3>What is lifestyle segmentation?</h3>

Customer lifestyle segmentation is the technique of breaking each customer's information into small sub-groups.
These sub-groups are created using data from each and every consumer.
These groups are formed in order to make conclusions regarding customer preferences, likes, and dislikes.
One method of market segmentation is lifestyle segmentation.
It is directly related to psychographic segmentation.
The AIO is the most extensively utilized instrument for lifestyle segmentation (Activities, interests, and opinions).
The idea is to target one or more lifestyle categories with your marketing mix.

Therefore, Get-away represents lifestyle segmentation.

Know more about lifestyle segmentation here:

brainly.com/question/13686011

#SPJ4

8 0

1 year ago