All categories

3 years ago

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

Business

1 answer:

alexandr1967 [171]3 years ago

7 0

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

You might be interested in

Cane Company manufactures two products called Alpha and Beta that sell for $135 and $95, respectively. Each product uses only on

Vika [28.1K]

Answer:

CANE COMPANY

a. total amount of traceable fixed manufacturing overhead

Alpha = $19*105,000 = $1,995,000

Beta = $21*105,000 = $2,205,000

b. Company's total amount of common fixed expenses =

Aplha = $18*105,000 = $1,890,000

Beta = $13* 105,000 = $1,365,000

Total = $3,255,000

c. Increase in profit as result of accepting the offer = additional contribution * additional unit sold

= $14*13,000

= $182,000

additional contribution =$92 - (30 + 23 + 10 + 15)

d. Decrease in profit = loss of contribution * unit sold

= -13 *4000

= ($52,000)

loss of contribution = 42 -( 18+ 16 +8+13)

Explanation:

3 0

4 years ago

What is the economic term for when prices rise and money buys less

mr_godi [17]

Answer:

Inflation

Explanation:

5 0

3 years ago

An investment adviser representative (IAR) asks a customer for a loan of $5,000. The customer agrees, and both the customer and

alexdok [17]

Answer:

D. Has not committed an unethical act since the loan was documented in writing.

Explanation:

Section 102 of the Uniform Securities Act of 1956 specifies that it is unlawful and unethical for an investment adviser representative to enter into a contract with a client except it is provided in writing that he does not stand to gain any financial profit, that no assignment of the contract would be made without the consent of the other party, and that if there is any change in the membership of the contract, the other party would be notified.

So, if the contract was documented between the investment adviser and the client, then it would not be unethical conduct.

6 0

4 years ago

A loan for $100,000 is fully amortized over 25 years with payments of $772 per month, including interest of 8% per annum. the fi

Ilya [14]

I THINK ITS MIDDLE FINGERS AT THESE AHOLE MODERATORS

6 0

4 years ago

Preemptive multitasking is the term used when the operating system processes higher-priority tasks before lower-priority tasks.

Olegator [25]

The answer is <u>"a. True".</u>

Preemptive multitasking refers to a task in which a PC operating system utilizes a few criteria to choose to what extent to allot to any one errand before giving another assignment a swing to utilize the working framework. The demonstration of taking control of the working framework starting with one errand and giving it then onto the next assignment is called preempting.

A typical basis for preempting is basically slipped by time (this sort of framework is now and again called time sharing or time cutting). In some operating systems, a few applications can be given higher need than different applications, giving the higher need programs control when they are started and maybe longer time slices.

5 0

4 years ago