I'm having issues with the vlookup to find the marketing and franchise fee, I need some explation to understanding better.

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question
I'm having issues with the vlookup to find the marketing and franchise fee, I need some explation to understanding better.
Cells
B21
fr
=VLOOKUP(E21, $K$6:N$6,2,TRUE)
A
D
E
F
G.
H
K
M
N
1.
2
3 Real Estate Broker Commission Calculator multi agency split
4
5 Street
1530 Any Street
Hometown
Agency
Split
Franchise fer
Marketing
Transaction fee
6 City
7 Istate
8 Zip Code
АВС
85%
325
400
300
NI
11877.
МЕСА
90%
125
150
150
PROP
85%
125
100
125
10 sales Price
$550 000
11 Commission Rate
Put VLOOKUP in B11 to get commission rate
3.00%
Sales Price
Commission Rate
Note
12 Flat/Adjustment
13 Additional Brakerage Fee
14 Gross Commission
$0.00
5.00%
1
0-499,999 5% commission
$495.00
500000
3.00%
S00,000-749.999 3% commission
750,000-999.999 2 25% commission
1,000.000 and above is 2.05% commission
1699500%
750000
2.25%
15 f Hlat conimasson, cate shouid be zeta
16 Agent 1 Name
17 Award Allacation
1000000
2.05%
Agent 2 Naine
Award Allocation
Mary
30%
John
Agent 3 Name
Daniel
AD
40%
Award Allocation
30%
18 Agency
19 Split
ABC
Agency
Split
MEGA
AgenLy
PROP
85%
90%
Split
85%
20 Franchise Fee
21 Marketing
Franchise Fee
Franchise Fee
#N/Al
Marketing
Marketing
22 Transaction fee
Transaction fee
Transertion fer
085
23
24 Agent 1 Net
$0.03
Agent 2 Net
$0.00
Agent 3 Net
25
26
27
28 Which Agent gets best Income per deal?
29 Explain
30
31
32
33
34
35
36
37
S&P 500
Broker Commission
S&P 500 HISTOGRAM
Population
(+)
Transcribed Image Text:Cells B21 fr =VLOOKUP(E21, $K$6:N$6,2,TRUE) A D E F G. H K M N 1. 2 3 Real Estate Broker Commission Calculator multi agency split 4 5 Street 1530 Any Street Hometown Agency Split Franchise fer Marketing Transaction fee 6 City 7 Istate 8 Zip Code АВС 85% 325 400 300 NI 11877. МЕСА 90% 125 150 150 PROP 85% 125 100 125 10 sales Price $550 000 11 Commission Rate Put VLOOKUP in B11 to get commission rate 3.00% Sales Price Commission Rate Note 12 Flat/Adjustment 13 Additional Brakerage Fee 14 Gross Commission $0.00 5.00% 1 0-499,999 5% commission $495.00 500000 3.00% S00,000-749.999 3% commission 750,000-999.999 2 25% commission 1,000.000 and above is 2.05% commission 1699500% 750000 2.25% 15 f Hlat conimasson, cate shouid be zeta 16 Agent 1 Name 17 Award Allacation 1000000 2.05% Agent 2 Naine Award Allocation Mary 30% John Agent 3 Name Daniel AD 40% Award Allocation 30% 18 Agency 19 Split ABC Agency Split MEGA AgenLy PROP 85% 90% Split 85% 20 Franchise Fee 21 Marketing Franchise Fee Franchise Fee #N/Al Marketing Marketing 22 Transaction fee Transaction fee Transertion fer 085 23 24 Agent 1 Net $0.03 Agent 2 Net $0.00 Agent 3 Net 25 26 27 28 Which Agent gets best Income per deal? 29 Explain 30 31 32 33 34 35 36 37 S&P 500 Broker Commission S&P 500 HISTOGRAM Population (+)
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Industry Specific Activities
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education