Develop a spreadsheet to calculate the broker''s commission

Assignment Help Finance Basics
Reference no: EM131439384

Question: For the stockbroker model you developed in Problem, use data tables to show how the commission is a function of the number of calls made.

Problem: A stockbroker calls on potential clients from referrals. For each call, there is a 10% chance that the client will decide to invest with the firm. Fifty-five percent of those interested are found not to be qualified, based on the brokerage firm's screening criteria. The remaining are qualified. Of these, half will invest an average of $5,000, 25% will invest an average of $20,000, 15% will invest an average of $50,000, and the remainder will invest $100,000. The commission schedule is as follows:

Transaction Amount                    Commission

Up to $25,000                           $50 + 0.5% of the amount

$25,001 to $50,000                   $75 + 0.4% of the amount

$50,001 to $100,000                 $125 + 0.3% of the amount

The broker keeps half the commission. Develop a spreadsheet to calculate the broker's commission based on the number of calls per month made. What is the expected commission based on making 600 calls?

Reference no: EM131439384

Questions Cloud

Which stakeholders in governmental organizations influence : ORG-807: What is the most significant means by which stakeholders in non-governmental organizations influence public policy related to their organizations? Why?
What is most effective way for an npo to manage the diverse : ORG-807: What is the most effective way for an NPO to manage the diverse and potentially conflicting needs of stakeholders to assure that the funding-effectiveness cycle is not disrupted? Why?
Qualitative and quantitative risk management : Describe the differences between Qualitative and Quantitative Risk Management In Information Security. In your opinion, which is better, and why?
Number of orders belonging to the customer : Write a select statement that will display customer number, customer name and the number of orders belonging to the customer. You will need to join two tables, use a COUNT aggregate and a GROUP BY clause in your SELECT statement. Override labels w..
Develop a spreadsheet to calculate the broker''s commission : A stockbroker calls on potential clients from referrals. For each call, there is a 10% chance that the client will decide to invest with the firm. Fifty-five percent of those interested are found not to be qualified, based on the brokerage firm's ..
How much influence should stakeholder interests exert : ORG-807: Current trends indicate that for-profit companies are paying close attention to stakeholder interests. How much influence should stakeholder interests exert over a for-profit company? Why?
Describe the scope and analyze how to control the scope : Documenting the existing IT network and system is an important first step, but you, the CIO, know that capturing the needed changes can be critical to your success as an executive. You know that procuring and documenting quality business requireme..
What is the best way for a for-profit organization : ORG-807: Stakeholder interests in an organization can be quite varied, and there may be many times when these interests do not coincide. What is the best way for a for-profit organization to manage these conflicting needs? Why?
Describe the economic impact of the law : Choose 1 U.S. environmental law. State the name of the law and the date the law was passed.Summarize the major provisions of the law that you chose.Describe the economic impact of the law. Provide specific economic data from credible references.Has t..

Reviews

Write a Review

Finance Basics Questions & Answers

  The good life insurance co wants to sell you an annuity

the good life insurance co. wants to sell you an annuity which will pay you 730 per quarter for 25 years. you want to

  How would each of the following affect a firm''s cost of debt

How would each of the following affect a firm's cost of debt, rd(1 = T); its cost of equity, rs; and its weighted average cost of capital, WACC? Indicate by a plus (+) a minus (_), or a zero (0) if the factor would raise lower, or have an indetermina..

  Calculate the discounted benefit of rehabilitating armory

Calculate the discount factor for each year (use 4% discount rate @ 15 years). Calculate the annual present value cost of maintenance (15 years). Calculate the discounted benefit of rehabilitating the armory.

  Find the amount for dividends payment

Wheeler Company had retained earnings as of 12/31/08 of $12 million. During 2009, Wheeler's net income was $4 million. Retained earnings balance at the end of 2009 was equal to 13 million dollar.

  The real risk-free rate of interest is expected to remain

the real risk-free rate of interest is expected to remain constant at 3 for the foreseeable future. however inflation

  By using data from part a what is the gordon constant

investors require a 17 rate of return on brooks sisters stock rs 17.a.what would the value of brookss stock be if the

  What is the balance in the account if you make no withdrawal

Suppose you are promised $10,000 five years from today. If the appropriate discount rate is 6%, what is this $10,000 worth to you today?

  Is bond selling at premium or discount why ensure to

go to the yahoo finance bonds center.1.under features bond lookup find bonds by name 2.type in the first letter of

  Section on implications and recommendations

In the final section of study reports, there is a section on implications and recommendations. Describe the difference between these terms. Provide examples from one of the studies that you critiqued.

  Highline financial services provides three categories

Highline Financial Services provides three categories of service to its clients. Managing partner Freddie Mack is getting ready to prepare financial and personnel hiring (or layoff) plans for the coming year.

  Primary task response within the discussion board area

primary task response within the discussion board area write 400ndash500 words that respond to the following questions

  What will the exchange rate be if this happens

Explain the structure of a Reverse Annuity Mortgage by creating an example and computing the monthly payment and explaining what happens at the maturity date of this type of mortgage. Lastly, why did these RAM's have losses during the financial c..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd