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
timama [110]
3 years ago
13

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
The manager of a 150-unit apartment complex knows from experience that all units will be occupied if the rent is $1000 per month
Roman55 [17]

The rent that the manager should charge to maximize revenue will be $2,000.

In business, a rent is known as the cost incurred by a business to utilize a property or location for an office, retail space, factory, or storage space.

Initially, to find revenue by coming up we can calculate with an equation below:

Revenue = Price × Revenue

Where, price = 1000 + 20x

Quantity = 150 - x

R(x) = (1000+20x) (150-x)

R(x) = 150000 - 1000x + 3000x - 20x²

R(x) = - 20x² + 2000x + 150000

To maximize the revenue, we calculate the derivative and set it to zero:

R(x) = - 20x² + 2000x + 150000

R(x) = -40x + 2000

-40x + 2000 = 0

40x = 2000

x = 50

After we find the amount of X, thus we determine the rent that the manager should  charge to maximize revenue

Price=$1000+20x

Price=$1000+20(50)

Price=$1,000 + 1,000

Price = $2,000

Learn more about the rent at brainly.com/question/2254034

#SPJ4

5 0
1 year ago
Bonita Corporation had net income of $1550000 and paid dividends to common stockholders of $400000 in 2017. The weighted average
artcher [175]

Answer:

16 times

Explanation:

Calculation to determine what Bonita Corporation's price-earnings ratio is

Price-earnings ratio= ($1550000 -$400000)/387500

Price-earnings ratio=$1,150,000/387500

Price-earnings ratio=2.97

Price-earnings ratio= 48/2.97

Price-earnings ratio=16 times

Therefore Bonita Corporation's price-earnings ratio is 16 times

3 0
3 years ago
On September 11, 2016, Home Store sells a mower for $590 with a one-year warranty that covers parts. Warranty expense is estimat
Ad libitum [116K]

Answer:

Sep 11

Dr Cash 590.00

Cr Sales 590.00

Dec 31

Dr Warranty expense 59.00

Cr Estimated warranty liability 59.00

July 24

Dr Estimated warranty liability 41.00

Cr Repair parts inventory 41.00

Explanation:

Home Store Journal entry

Sep 11

Dr Cash 590.00

Cr Sales 590.00

Dec 31

Dr Warranty expense (590*10%) 59.00

Cr Estimated warranty liability 59.00

July 24

Dr Estimated warranty liability 41.00

Cr Repair parts inventory 41.00

4 0
3 years ago
Read 2 more answers
"New York City is issuing $500,000,000 of general obligation bonds paying interest on January 1st and July 1st of each year unti
poizon [28]

Answer:

  • 8 months for the first interest
  • 6 months for the second

Explanation:

The interest is to be paid semi-annually which means that it accrues for 6 months. However, the bond was issued on May 1, 2020 which is 8 months before the first interest payment on January 1, 2021 so the January payment will have to cover for those months as interest starts to build immediately the bond is purchased.

The second payment on July 1, 2021 will cover the period of 6 months between January 1 and July 1, 2021.

8 0
3 years ago
Identifying and Analyzing Financial Statement Effects of Cash Dividends Freid Corp. has outstanding 6,000 shares of $50 par valu
Neporo4naja [7]

Answer:

Assets              =                Liabilities          +               Equity

cash (18,000)                       NA                          Retained earnigns (18,000)

cash (88,000)                      NA                          Retained earnigns (88,000)

Retained earnings is an equity account and any cash dividends paid either to preferred or common stock will decrease cash and retained earnings, remember that both sides must balance.

6 0
2 years ago
Other questions:
  • Consumers buy from amazon when brand website shipping too expensive long
    15·1 answer
  • In which career would you typically oversee the creation of materials that communicate a favorable public image of your employer
    11·1 answer
  • While asia represents an important source of u.s. imports, few export opportunities exist for u.s. firms to sell goods and servi
    15·2 answers
  • An accountant’s standard report on a compilation should state that the accountant
    11·1 answer
  • Charles Lackey operates a bakery in Idaho Falls, Idaho. Because of its excellent product and excellent location, demand has incr
    13·1 answer
  • How did the shift to steam power lead to the growth of cities?
    10·1 answer
  • A theory of international trade is that nations trade based on demand rather than cost/supply. Discuss this theory, apply it to
    14·1 answer
  • Help me pls thankyou​
    7·1 answer
  • If the owner contributes $19,400 and net income is $15,900, how much did the owner withdraw (owner, withdrawals)
    9·1 answer
  • Question 1<br> What is the most important question you should have after seeing this ad about a check cashing business?<br> Why
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!