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
Ivanhoe Company purchased a new machine on October 1, 2017, at a cost of $77,980. The company estimated that the machine has a s
Marysya12 [62]

Answer:

Depreciation for

2017 = $2,540

2018 = $10,160

Explanation:

Provided, Total cost of the machine = $77,980

Estimated salvage value = $6,860

Therefore, value to be depreciated = $77,980 - $6,860 = $71,120

Total life of asset = 7 years

Depreciation for the year 2017 = October to December = 3 months

\frac{71,120}{7} \times \frac{3}{12} = $2,540

Depreciation for the year 2018 = \frac{71,120}{7} = $10,160

Under straight line method depreciation is fixed for each year, but in the given case in 2017 the asset is used only for 3 months, thus depreciation will be charged for 3 months only.

Final Answer

Depreciation for

2017 = $2,540

2018 = $10,160

7 0
3 years ago
Suppose that towns collect resources from their surroundings. Then, through trade, they attempt to obtain other desirable items.
Olin [163]

Answer:

-equal to zero

Explanation:

As the price for wood is above the demand is willing to pay there is no trade.

Either some of the participants will increase their demand and accept the price of 60 dollars; look for another supplier or look into producing for themselves

Also, Timber could lower the prce of wood so trade occurs.

5 0
3 years ago
Pleasantville maintains an appropriations ledger for police department supplies. The amount appropriated for supplies was $100,0
satela [25.4K]

Answer:

Appropriation available for spending = 37000

Explanation:

In the appropriations ledger, the amount available for spending at any moment is the total appropriation minus expenditures plus outstanding encumbrances.

100000 - 35000 - 28000 =  37000

3 0
3 years ago
What is an action that will not help you activate your network?
neonofarm [45]

Answer:

Help a friend finish her college application

Explanation:

All these actions will help me activate my network :-

  • Ask for an informational interview at your favorite company
  • Get coffee with an alumnus from your high school
  • Read a detailed book about your dream job

Except :-

  • Help a friend finish her college application
8 0
3 years ago
Alliance Company budgets production of 23,000 units in January and 27,000 units in the February. Each finished unit requires 4 p
iris [78.8K]

Answer:

Total= 96,800 pounds

Explanation:

To calculate the direct material requirement, we need to use the following formula:

Budgeted material= required for production + desired ending inventory - beginning inventory

<u>Budgeted material:</u>

Production for January= (23,000*4)= 92,000

Desired ending inventory= (27,000*4)*0.3= 32,400

Beginning inventory= (27,600)

Total= 96,800 pounds

7 0
3 years ago
Other questions:
  • Aqua Ltd issues a prospectus inviting the public to subscribe for 30 million ordinary shares of $2.00 each. The terms of the iss
    5·1 answer
  • What is the name for utter business ruin or failure
    15·1 answer
  • A person who is skilled at performing calculations, has math skills for advanced analysis, and has organizational skills would b
    10·2 answers
  • Dukelow Corporation has two divisions: the Governmental Products Division and the Export Products Division. The Governmental Pro
    13·1 answer
  • Your boss would like your help on a marketing research project he is conducting on the relationship between the price of juice a
    10·1 answer
  • On August 31, 2018, Harvey and Margaret, who file a joint return and live in Charleston, South Carolina, sell their personal res
    15·2 answers
  • Q 3.53: During the month of August, Jackson Products recognizes $15,000 in revenues. Jackson's accounting staff records these re
    6·1 answer
  • Last year, Rec Room Sports reported earnings per share of $9.10 when its stock price was $282.10. This year, its earnings increa
    14·1 answer
  • Milk is a heterogeneous mixture how? <br>​
    8·1 answer
  • Describe the customer intimacy and operational excellence related information problems that drove PepsiAmericas to adopt a more
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!