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
Selected comparative financial statements of Korbin Company follow:
Oksanka [162]

Answer:

Korbin Company

Selected Comparative Financial Statements:

1. KORBIN COMPANY  Comparative Income Statements

For Years Ended December 31, 2017, 2016, and 2015

                                      2017         %           2016        %            2015        %

Sales                         $515,770    100%   $395,122  100%   $274,200   100%

Cost of goods sold    310,494      60%    250,507    63%      175,488     64%

Gross profit               205,276      40%      144,615    37%        98,712     36%

Selling expenses        73,239       14%       54,527    14%         36,194     13%

Admin.  expenses       46,419        9%        34,771      9%        22,759      8%

Total expenses         119,658       23%      89,298     23%       58,953     21%

Income before taxes  85,618       17%        55,317      14%       39,759     15%

Income taxes             15,925         3%        11,340        3%          8,071       3%

Net income             $69,693        14%   $43,977        11%      $31,688     12%

2. KORBIN COMPANY

Balance Sheet Data in Trend Percents

for December 31, 2017, 2016, and 2015

                                                  2017            2016             2015

Assets

Current assets                        100.00 %          78%             105%  

Long-term investments          100.00            500%          3,690%

Plant assets, net                     100.00             107%             64%

Total assets                            _124__%       _121_ %       100.00 %

Liabilities and Equity

Current liabilities                    _104_ %       _103__ %     100.00 %

Common Stock                       100.00           100%             75%

Other paid-in capital               100.00           100%            66%

Retained earnings                  100.00             92%            84%

Total liabilities and equity      _124_ %         _121_ %      100.00

Explanation:

a. Data:

KORBIN COMPANY

Comparative Balance Sheets

December 31, 2017, 2016, and 2015

                                                 2017             2016             2015

Assets

Current assets                    $53,867       $42,145        $56,338

Long-term investments            0                   500            3,690

Plant assets, net                 100,040       106,805           63,791

Total assets                      $153,907     $149,450        $123,819

Liabilities and Equity

Current liabilities               $22,470     $22,268         $21,668

Common stock                     71,000        71,000           53,000

Other paid-in capital              8,875          8,875             5,889

Retained earnings               51,562        47,307           43,262

Total liabilities & equity  $153,907    $149,450         $123,819

b) In an income statement vertical analysis, each line item is calculated as a percentage of the sales, which is itself 100%.  This enables the proportional analysis of all the items to be computed about their financial performance in relation to the sales for the period.  It can help management to dictate unusual items, errors, and other outliers.

c) The balance sheet trend analysis shows whether the entity's financial position is improving or not in relation to the base period.  Each item is compared horizontally across periods.  The calculation of trend uses the amount in the non-base year and divides it by the amount of the base year x 100.

4 0
3 years ago
A company makes tools, such as hammer and tape measures. One of their primary raw materials is steel and if they run out of stee
Sedbober [7]

Answer:

D. continuous review system

Explanation:

In the context of manufacturing it seems that the system being described would be a continuous review system. Like mentioned in the question this is a system that automatically adjusts the stock level in real time when a product moves in or out of stock, and automatically triggers an order for more stock as soon as the stock level hits a low quantity point is hit.

3 0
3 years ago
Costco delivers for free using instacart and the only difference is how you sign in to order
viva [34]

Answer:

Go to the Sign in page, which you can access by selecting "Sign In / Register" in the top right corner of our homepage.

Select "Create Account," then enter your e-mail address, a password, and — if you're a member — the number found on your membership card. If you happen to have a Costco Anywhere Visa® Card by Citi, just look for your membership number on the back of the card, directly to the right of your picture.

Once you select the "Create Account" button, your account will be created.

Please keep in mind that being an active Costco member does not automatically register you on Costco.com. Your membership number is not linked to your account until you add it, either when you register or you update your account details under "My Account."

6 0
2 years ago
You and your friends want to buy a condo at the beach to time share. Each of you has single peaked preferences with a most prefe
Gemiola [76]

Answer:

Individual                   Cost                                Shares to be enjoyed

Mabel                      $10,000                            10000 / 150000 =  6.67%

Gertrude                 $20000                            20000 / 150000 = 13.3%

Myron                      $30000                            30000 / 150000 = 20%

Wilber                      $40000                            40000 / 150000 = 26.6%

You                          $50000                            50000 / 150000 = 33.3%

Explanation:

peaked preferences

Most preferred value to spend :

Mabel = $10,000

Gertrude = $20,000

Myron = $30,000

Wilber = $40,000

you = $50,000

cost of Condo = $150,000

<u>Implementing a Uniform rule mechanism to allocate costs and shares </u>

The uniform rule ; ∑ j∈I Uj (p) = Ω.

where Ω = fixed amount of resource

hence the summation of all allotment should = Ω ( $150,000 )

Number of friends = 5

cost of condo  = $150,000

If divide equally each person will have to pay ; $150,000 / 5 = $30,000

Total money to be spent by friends = 10,000 + 20,000 + 30,000 + 40,000 + 50,000  = $150,000

Individual                   Cost                                shares to be enjoyed

Mabel                      $10,000                            10000 / 150000 =  6.67∑%

Gertrude                 $20000                            20000 / 150000 = 13.3%

Myron                      $30000                            30000 / 150000 = 20%

Wilber                      $40000                            40000 / 150000 = 26.6%

You                          $50000                            50000 / 150000 = 33.3%

∑shares ≈ 100% ( 150,000 )

6 0
3 years ago
For each of the following, is it part of demand for yen or supply of yen in the foreign exchange market? a. A Japanese firm sell
Lorico [155]

Answer:

a. A Japanese firm sells its U.S. government securities to obtain funds to buy real estate in Japan.

This contributes to the demand for yen

b. A U.S. import company pays for glassware purchased from a small Japanese producer.

This contributes to the demand for yen

c. A U.S. farm cooperative receives payment from a Japanese importer of U.S. oranges.

This contributes to the supply of yen for foreign exchange

d. A U.S. pension fund uses some incoming contributions to buy equity shares of several Japanese companies through the Tokyo stock exchange.

This contributes to the demand for yen

Explanation:

3 0
3 years ago
Other questions:
  • Robert Bryan, Jr., earns $400 per week plus 3% of sales in excess of $7,000. If Robert sells $21,000, how much are his weekly ea
    14·2 answers
  • "Profit-sharing plans provide a more direct incentive in small firms than in large firms. are practically impossible to use succ
    6·2 answers
  • Can getting in trouble to much in school keep u from getting a job like pizza hut
    12·2 answers
  • Plzzz help (use attached photo)
    13·1 answer
  • Economists sometimes give conflicting advice because
    9·1 answer
  • Barney bought a small retail business a month ago. He plans to advertise it with the help of billboards and flyers to attract cu
    13·1 answer
  • For each of the following items, identify whether they would most likely be reported in the balance sheet (B) or income statemen
    5·1 answer
  • Prescott Bank offers you a five-year loan for $75,000 at an annual interest rate of 6.8 percent. What will your annual loan paym
    6·1 answer
  • Assume that banks keep 10% of deposits as reserves. Households hold money such that the currency-deposit ratio is 80%. The money
    8·1 answer
  • Demonstrate your understanding of the difference between intrapreneurs, entrepreneurs and managers and their role in organizatio
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!