FINAL EXAM Flashcards
(243 cards)
1
Q
_____ is a retrospective (look back) recording of actual business transactions
A
Accounting
2
Q
_____ is a prospective (look forward) evaluation or model of different possible outcomes
A
Finance
3
Q
In ______, you use assumptions and estimates to make the most informed decision possible
A
Finance
4
Q
In _______, you use journal entries, accounts, ledgers & ultimately financial statements to record past activity
A
Accounting
5
Q
Ticket sales, broadcast contracts, concession sales, sponsorship agreements are an example of
A
Revenue
6
Q
Player salaries, equipment, travel, rent, insurance are an example of
A
Expenses
7
Q
An alternate measure of profitability to net income
A
EBITDA
8
Q
Attempts to represent cash profit generated by the company’s operations
A
EBITDA
9
Q
What does EBITDA stand for?
A
Earnings before interest, taxes, depreciation and amortization
10
Q
What is an asset?
A
Provides a future economic benefit to the organization
11
Q
What is a liability?
A
A promise to provide a future good or service
12
Q
What is equity?
A
The initial capital invested in the business // accumulation of profit & loss over time
13
Q
Balance sheet equation
A
(A=L+E) - Assets = liabilities + equity
14
Q
What is a statement that shows movement of cash by account driver?
A
Cash flow statement
15
Q
Three different types of cash flow
A
Operating, investing, financing
16
Q
Total of _____ ______ statement represents total change in cash
from year to year
A
Cash flow
17
Q
Who uses financial statements?
A
Executives, ownership, investors, stockholders, rating agencies, league offices
18
Q
What are the four formatting things a financial statement must have?
A
Company name, name of the financial statement, period in which it occurs, units of measure
19
Q
What is the difference between a balance sheet and an income statement?
A
Balance sheet is a point in time (picture) and an income statement is a period of time (movie)
20
Q
An income statement may also be called
A
Cash flow statement
21
Q
Income equation
A
Revenue - expenses
22
Q
___ provide a future economic benefit
A
Assets
23
Q
____ is money owed to the organization for services already rendered or goods provided
A
Accounts Receivable (AR)
24
Q
Merchandise or raw materials purchased to be produced / packaged and sold at a later date
A
Inventory
25
Prepaid expenses
Upfront payment made by an organization for a future good or service
26
Example of prepaid expense
Rent for future months, insurance premium for future coverage
27
Fixed Assets
Equipment, machinery, furniture or any asset purchased that is expected to be utilized for longer than one year
28
A promise to provide a future good or service
Liability
29
Money owed by the organization for services already received or goods delievered
Accounts Payable (AP)
30
Liability for amounts owed
Accrued liabilities
31
Money borrowed by an org from a creditor or lender
Debt
32
Payments made by a customer in advance of services provided
Deferred revenue
33
Current = _____-term
Short
34
Non-current = _____-term
Long
35
Expected to be received (asset) or paid (liability) within one year
Current or short-term
36
Expected to be received (asset) or paid (liability) beyond one year
Non-current or long-term
37
Assets = __ + ___
Liabilities + Equity
38
Where the ownership interest in the organization is recorded
Equity
39
Interest and required principal debt repayments together are considered ________
Debt service costs
40
How would you calculate the debt service cost of a $30M loan with a 3 year term and 5% annual interest rate?
$30m principal repayment + 3 years of 5% interest ($1.5M per year or $4.5M for 3 years = $34.5M
41
What reduces the liability on the company's balance sheet?
Principal repayments
42
____ is for a period of time (movie)
P&L / income statement
43
__________ flows through to Retained Earnings/Accumulated Loss on the Equity section of the Balance Sheet
Net income
44
____ is a snapshot (picture) at a certain period
Balance sheet
45
_____ is the movements of each balance sheet account, showing all cash activity during the year and reconciling beginning and ending cash
Cash flow
46
__________ method where revenues and expenses are booked when a transaction occurs rather than when a payment is made
Accrual accounting
47
What method of accounting does the U.S. use?
GAAP - Generally Accepted Accounting Principles
48
What method of accounting is used internationally?
IFRS - International Financial Reporting Standards
49
Accrual accounting approach uses the ______________ where revenues and expenses should be recognized at the same time
Matching principle
50
______ method means for any given transaction a minimum of 2 entries must be made for book keeping
Double entry system
51
In the double entry system, for ever transaction _______
The amount of debits must equal the amount of credits
52
Entries on the right side of the t-system
Credits (equity / liabilities)
53
Entries on the left side of the t-system
Debits (assets)
54
Debits indicate an
increase in _____, increase in _______
decrease in _____, decrease in ______,
increase in an asset,
an increase in an expense
a decrease in a liability,
a decrease in shareholders’ equity,
55
Credits indicate an
decrease in _____,
increase in _____,
increase in _____,
increase in _______
decrease in an asset, increase in a liability,
increase in shareholders’ equity,
increase in revenue
56
Three steps in the process from a transaction to financial statements
1. Create journal entries for every transaction
2. At the end of the period reconcile your accounts
3. Apply the ending balance to the corresponding financial statement
57
On January 31st, Sports Clothing Inc, (“SCI”) paid $250,000 in
cash for the monthly salaries of its employees - What are the debits and credits?
Debit - salary expense
Credit - cash
58
On January 1st SCI paid $42,000 cash to rent office space and
furnishings for the year ending December 31st-What are the debits and credits?
Debit - prepaid rent
Credit - cash
59
On March 15th, SCI purchased merchandise for $750 which will
be packaged and sold at a later date- What are the debits and credits?
Debit - inventory
Credit - cash
60
SCI sold merchandise at a selling price of $1,000 on April 1st; the
merchandise sold had cost to SCI $750. The customer paid SCI in
cash with no refunds- What are the debits and credits?
Debit - cash 1k
Credit - sales revenue 1k
Debit - COGS 750
Credit - inventory 750
61
SCI sold merchandise at a selling price of $60,000 on March 10th; the merchandise sold had cost to SCI of $45,000. The customer agreed to pay SCI in the third quarter - What are the debits and credits?
Debit - AR 60K
Credit - Sales rev 60K
Debit - COGS 45K
Credit - Inventory 45K
62
SCI receives $200,000 from a customer for merchandise on March 15th. SCI will deliver 3/4 of the merchandise on June 30th and 1/4 on December 31st - What are the debits and the credits?
Debit - Cash 200k
Credit - Deferred Revenue 200k
63
On 1/1/21, I buy $3,000 worth of t-shirts to sell (Q1 2021) - what are the debits and the credits
Debit - Inventory 3K
Credit - Cash 3K
64
A football manufacturer buys a new machine for $10M on 1/1/21. They estimate that the new equipment will have a useful life of 10 years. Show the entries and FS impact for 2021
1/1/21
DR: Equipment $10M
1/1/21
CR: Cash $10M
12/31/21
DR: Depreciation Expense $1M
12/31/21
CR: Accumulated Depreciation $1M
65
An MLS expansion club plans to borrow $250M from a bank to fund the cost of stadium construction. The bank loans the money to the team on 1/1/21 with an annual interest rate of 3.5%. The loan is due on 12/31/26 and the stadium is expected to last 25 years (assume the stadium is paid for and opens on 7/1/21)
What are the debits and credits?
1/1/21 DR: Cash $250M
1/1/21 CR: Long-Term Debt $250M
7/1/21 DR: Stadium Asset (PP&E) $250M
7/1/21 CR: Cash $250M
66
An MLS expansion club plans to borrow $250M from a bank to fund the cost of stadium construction. The bank loans the money to the team on 1/1/21 with an annual interest rate of 3.5%. The loan is due on 12/31/26 and the stadium is expected to last 25 years (assume the stadium is paid for opens on 7/1/21):
Interest per year - 8.75M
250M/25 years - 5M
12/31/21
DR: Interest Expense $8.75M
12/31/21
CR: Cash $8.75M
12/31/21
DR: Depreciation Expense $5M
12/31/21
CR: Accum Depr – Stadium $5M
67
A basketball team signs a contract with a new jersey patch sponsor. The sponsor pays $5M up front on 1/1/21 for a 2 year contract. Show the journal entries and
financial impact in 2021:
1/1/21
DR: Cash $5M
1/1/21
CR: Deferred Revenue $5M
12/31/21
DR: Deferred Revenue $2.5M
12/31/21
CR: Sponsorship Revenue $2.5M
68
On March 1, a baseball team purchases new travel bags for its players for a cost of $5,000. The team has agreed to pay for the travel bags by September 30. Show the
entries and FS impact for 2021:
3/1/21
DR: Equipment Expense $5,000
3/1/21
CR: Accounts Payable $5,000
9/30/21
DR: Accounts Payable $5,000
9/30/21
CR: Cash $5,000
69
On Jan 1, a football team leases extra office space near the stadium to add offices for staff. The office lease is a 4 year lease for $25,000/year. The team pays for the
entire lease term on Jan 1. Show the entries and FS impact for 2021:
1/1/21
DR: Prepaid Expense (Asset) $100,000
1/1/21
CR: Cash $100,000
12/31/21
DR: Office Lease Expense $25,000
12/31/21
CR: Prepaid Expense (Asset) $25,000
70
Debit or credit - Assets
Debit
71
Debit or credit - Liabilities
Credit
72
Debit or credit - Equity
Credit if net income, debit if net loss
73
Debit or credit - Revenue
Credit
74
Debit or credit - Expenses
Debit
75
Net income formula
Revenue - expenses = net income/loss
76
Examples of stadium investments
Clubs, restuarants, views experience
77
Examples of investing in ticketing technologies
CRM, pricing tools, mobile ticketing
78
Variable pricing
Ticket prices set in advance of on-sale // major variations are by seat and game tier
79
Dynamic pricing
Occurs between on-sale and event date // results from change of demand from variable pricing
80
2 fans could be sitting next to each other in identical seats, and depending on WHEN they purchased, the price could be drastically different. This is an example of?
Dynamic pricing
81
Primary ticket market
Tickets are sold by the artist/team/venue directly to the fans
82
Face value
Price at which tickets are initially sold
83
Secondary ticket market
Tickets are sold by fans (previously obtained on the primary market) to other fans
84
What are some impacts of the secondary ticket market?
Teams are no longer the single source for ticket sales, In theory, every ticket sold on the secondary market cannibalizes a
ticket that otherwise could have been sold on the primary market
85
What does ticketing look like for teams now?
Most leagues/teams have an authorized secondary market partner.
86
In return for _______, secondary market sites agreed to split a share of the fees generated with teams/leagues
Integration
87
Why is integration with teams/leagues and secondary market sites beneficial to each party?
What does StubHub gain?
* Tickets sold on their site are verified by the venue as a legitimate ticket
– What do the teams/leagues gain?
* A portion of the fees, but also customer data (key factor at play)
88
What are sponsorships?
A cash and/or in-kind fee paid to a property (typically in sports, arts, entertainment or causes) in return for access to the exploitable commercial potential associated with that property
89
Examples of sponsorship revenue
* Use of marks
* Activation
* Signage
* Media
* Hospitality
* Tickets
* Suites
90
RSNs - Regional Sports Networks
Cable stations created to primarily show only sports in a local market
91
Advantages of RSNs
High risk, high return
92
Disadvantages of RSNs
No guaranteed money, a lot of work and infrastructure to set up, assume all risk
93
Main revenue drivers for RSNs?
Subscriber fees (could be as much as 85% of revenue), advertising, shoulder programming
94
Revenue sharing
Measures taken to pool and redistribute certain revenues among competing teams in a league, in order to lessen economic inequalities among teams
95
Direct Revenue Sharing
Team-to-team sharing local revenues
96
Indirect/Inherent Revenue Sharing
League revenues shared equally amongst all member teams
* National TV contracts, league-wide licensing deals/sponsorships
97
Why does revenue sharing exist?
Main purpose is to help put all teams on an equal playing field (despite market size)
98
Does the NBA have revenue sharing?
Yes
99
Does the NFL have revenue sharing?
League wide - Yes
Local - Partial
100
Does the MLB have revenue sharing?
Yes
101
Does the NHL have revenue sharing?
Yes
102
What type of salary cap does the NBA have?
Soft
103
What type of salary cap does the NFL have?
Hard
104
What type of salary cap does the MLB have?
Soft
105
What type of salary cap does the NHL have?
Hard
106
Leagues with hard salary caps
NFL, NHL
107
Leagues with soft salary caps
NBA, MLB
108
No show rate
Difference between paid attendance and turnstile attendance
109
Is there sales tax on suite revenue for license?
No
110
Is there sales taxes on tickets?
Yes
111
NBA Revenue Sharing - how is league income and local income split?
League split evenly (including National TV)
Local revenue is split in complicated formula
112
NFL Revenue Sharing - how is league income split?
League rev split evenly
113
NFL Revenue Sharing - how is gate income split?
66% home
34% road
114
MLB Revenue Sharing - how is league income and local income split?
League split evenly
Local rev split in complicated formula
115
NBA has a ____ cap
Soft
116
NFL has a ____ cap
Hard
117
What is the NFL's hard cap set as?
A % of league wide revenues
118
Leagues with guaranteed player contracts
NBA, MLB
119
What is the difference between a soft and hard cap?
Soft cap - go over and pay a tax
Hard cap - cannot go over
120
Leagues with non -guaranteed player contracts
NFL, NHL
121
Internal Audit
Completed by staff members within a business
122
Independent Audit
An external review of finances by people not directly involved with the documents
123
Involved in establishing internal controls and preparing an organization’s financial statements to ensure their accuracy
Internal audit
124
Involved in verifying the truthfulness of the documents being
reviewed, often by public accounting firms
Independent audit
125
A financial plan for a revenue, expense, P&L, cash flow or a balance sheet item
Budget
126
The owner wants what type of salary cap?
Hard
127
The players want what type of salary cap?
Soft
128
What does BRI stand for and what league is it used in?
Basketball related income - NBA
129
Guaranteed contracts happen in leagues that have ___________
Strong player's unions
130
What does TR stand for and what league is it used in?
Total revenue - NFL
131
In what league do you have to be under the salary cap every day of the season?
NFL
132
What does NLR stand for and what league is it used in?
Net local revenue - MLB
133
What does HRR stand for and what league is it used in?
Hockey related revenue - NHL
134
Name a few typical expenses for professional sports orgs
Salaries
Stadium rent (if not owned)
Ops
Arena Ops
Sales/marketing
Front office
135
Name a few expense drivers
Headcount (not just salary - benefits, vacation, office supplies, etc)
Travel costs
Misc operating costs
136
Two types of budgeting?
Zero-based budgeting, historical growth budgeting
137
Zero based budgeting
All budget dollars are requested every year and then budgeted for if approved (i.e. Oscar/Michael - The Office example)
138
Historical growth budgeting
Budgets are set based upon prior years spend and historical trends
139
What does SALY stand for and what does it reference?
Same As Last Year
Historical growth budgeting
140
Updates to the budget that are more frequent than annually
Forecasts
141
SEC requires _____ reporting
Quarterly
142
Direct expenses + example
Directly related to a business operation
EX - producing footballs
143
Examples of indirect expenses
HR / IT / Finance / Legal
Insurance
Back office expenses - computers, supplies, software
144
Examples of direct expenses
Sponsorship (cost of putting up a new sign)
Ticket sales commissions paid to sales team
145
Indirect expenses + example
Overhead/indirect cost in achieving project completion
EX - Salaries
146
What type of expenses are a VARIABLE COST?
DIRECT - they are a function of revenue - i.e. sponsorships, ticket sales, media, etc.
147
What type of expenses are a FIXED COST?
INDIRECT - they stay the same - i.e. back office expenses, insurance, executives, non-revenue generating
148
_____ cap: more favorable to owners (generally)
Hard
149
Salary cap usually comes with a _____
Salary floor (a concession to players/union)
150
____ cap: more favorable to players (generally)
Soft
151
______ cap typically comes with some tax/penalty structure to ensure competitive balance
amongst the teams
Soft
152
__________ are set based on an agreed upon % of total league-wide
revenue (as defined by the CBA)
Salary Caps
153
Name the five (5) different cost arrangements with service providers?
Flat fee
Per hour fee
Per hour fee with min requirement
Per game fee
Fee per usage
154
Will indirect expenses change as revenues increase or decrease?
NO
155
Will direct expenses change as revenues increase or decrease?
YES
156
Types of non sporting events?
Concerts, weddings, tours, corporate meetings
157
Types of deals for non-sporting events?
Facility rental (low risk/minimal upside)
Stadium produces the event (high risk, high reward)
Combination
158
Types of revenue models for non-sporting events?
Rev share agreement
Fixed guarantee to the act
Combination of both
159
How to find Goal Seek
Data tab - what if analysis - goal seek
160
Examples of mixed use developments?
Battery - ATL
SoFi Stadium
161
What is depreciation?
It is the recognition of expense relating to the reduction in value for an asset
162
_____ depreciation – prefer expenses to extend as long as
possible
GAAP
163
____ debt – money loaned by bank
Bank
164
______ offering – investments made by private company
Bond
165
_______ placements – long term investments by companies
Private
166
Goals of capital budgeting
To select investment opportunities that are worth more than
they cost
To invest in those projects that are most profitable for the organization (greatest ROI)
167
Profitability of an investment
or a project
ROI
168
How is ROI profitability measured?
By looking at the cash flow that the project can produce and compare it to the cost of the project
169
Why is ROI important?
ROI provides a method to compare projects and drive the allocation of resources amongst them
170
ROI Formula
(Gain from investment - cost of investment) / cost of investment
SHOWN AS PERCENTAGE
171
Three (3) tools used to calculate Gain from Investment & Cost of
Investment:
- Net Present Value (NPV)
– Internal Rate of Return (IRR)
– Payback Period
172
What is present value?
Time value of money, a dollar today is better than a dollar tomorrow
173
How is time value of money calculated?
PV = CFt / (1+r)^t
PV = present value
CF = cash flow at the end of year t
r = interest rate
t = years
174
Goal of accounting/finance
Help allocate resources
175
Cost of debt =
Discount rate
176
An increase in discount rate ___________ net present value
Lowers
177
If NPV is positive....
Accept the project if there is no better alternative (i.e. another project with a higher NPV)
178
Net Present Value (NPV)
The difference between the present value of the future income and the required investment
179
The difference between the present value of the future income and the required investment
NPV
180
How is NPV calculated?
NPV = PV - RI
PV = present value
RI = required investment
181
Amount of capital needed
Required investment
182
The future income stream is discounted based on _______________
The cost of
capital needed for the project
183
Internal Rate of Return
An organization’s required return for a
project (a hurdle rate)
184
An organization’s required return for a
project (a hurdle rate)
Internal Rate of Return
185
The _____ method shows the rate of return where NPV is equal to _____
IRR, zero
186
If IRR is greater than the required return........
Accept the project if there
is no better alternative
187
The payback period looks at ...
How long it will take a company to get its money back after the investment
(purely measured on the amount of time it
takes to payback the company - time value of money is not factored in)
188
How long it will take a company to get its money back after the investment
Payback period
(purely measured on the amount of time it takes to payback the company - time value of money is not factored in)
189
PRACTICE NPV / IRR / PAYBACK PERIOD EXAMPLES (3.28 4.4)
PRACTICE NPV / IRR / PAYBACK PERIOD EXAMPLES
190
Monthly cash flows need a _____ discount rate
Monthly
191
6% annual discount rate = xxx% monthly rate
0.5%
192
0.25% monthly rate = xxx% annual rate
3%
193
Higher the discount rate = _______ NPV
Lower
194
Lower the discount rate = _____ NPV
Higher
195
How to calculate IRR in excel
Let NPV equal zero, solve for IRR (GOAL SEEK in Excel)
If IRR is greater than the required return, accept the project if there is no better alternative
196
Is time value of money factored into the payback period calculation?
NO
197
Which method of evaluating projects is best?
IT DEPENDS; can calculate all 3 and weigh each data point when comparing Project A vs Project B, C & D
198
_______ are the most commonly used primary investment criteria
NPV & IRR
199
_______ is a commonly used secondary investment criteria
Payback period
200
What does CAGR stand for?
Compound Annual Growth Rate (or Cumulative Annual Growth Rate)
201
How is CAGR used?
To determine the annual growth rate, when applied to value in Period 1, you would arrive at the value in Period T
202
CAGR Formula
((Vfinal/Vbegin)^(1/t))- 1
Vbegin - beginning value
Vfinal - final value
t - time in years
203
CAGR in Excel - counting the number of periods
The Beginning Period does not get counted in the total as you are starting with that period and applying an annual growth rate thereafter
204
Pro of CAGR
Provides a more meaningful growth rate that is annualized
205
Con of CAGR
Does not take into account ANY period values other than the
beginning and the end
206
What is PMT function used for?
Calculates the payment for a loan based on constant payments and a constant interest rate
Calculates a consistent annual value at a constant interest rate to arrive at an ending value (FV) or a desired starting amount (PV)
207
What is PMT useful for?
Useful for personal loans, personal investments or “smoothing” of
contractual escalators
208
Metric to calculate how long it will take to return your initial investment
Payback period
209
_____________ does not go into future cash flow assumptions
Sunk costs
210
Balloon Payment
Assumes the amount borrowed is paid
back at the end of the Term
211
Effective Interest Table
Common, how mortgages are calculated
Even annual principal repayments
212
______ measures the degree to which a change in pricing affects the unit sales of a product
Elasticity
213
If a change in price does not impact demand, then the demand is _________
Examples
Inelastic
Milk, eggs
214
An _______ demand changes significantly when prices change
Examples
Elastic
Entertainment, disposable goods with alternatives
215
How to calculate the right price?
The price where all inventory clears or where supply equals
demand
The place where marginal revenue is greater than marginal cost
216
The __________ is the level of revenue at which total
revenue exactly matches total costs
Break even point
217
Break even point formula
(Price x unit sales) - (COGS x unit sales) - fixed costs = 0
218
Break even sales equation / break even units =
Fixed costs / (price per unit - COGS per unit)
219
______________ is running multiple versions while varying some
of the assumptions
Sensitivity analysis
220
What drives value in franchise valuations?
Brand, cash flow, league economics, location, availbaility
221
Three ways an owner can monetize their franchise
Outright sale, public offering, minority interest
222
Net Income flows through to __________ on the Equity section of the Balance Sheet
Retained Earnings/Accumulated Loss
223
What is taxable / non-taxable?
Tickets / License
Price components: Ticket (taxable) vs License (non-taxable)
224
Two accounting issues with revenue sharing
Consistency with reporting
Accuracy with reporting
225
Two accounting issues with salary cap
Definitions of payments
Loop holes
226
Non sporting events - benefits for teams
More events = more revenue
Higher return on stadium investments
Not subject to revenue sharing
227
Before construction begins decisions must be made on:
Total seating
Premium v.s. non premium spaces
Clubs v.s. restaurants
Logistics - stairs, elevators, bathrooms
228
Before construction begins decisions must be made on:
Total seating
Premium v.s. non premium spaces
Clubs v.s. restaurants
Logistics - stairs, elevators, bathrooms
229
Potential errors using NPV/IRR/other calculations
* Measuring sunk costs
* Measuring opportunity costs
* Failing to analyze the impact of any funding decision
* Failing to appreciate the impact of a capital decision on net
working capital
230
A document that displays the financial condition of a business at a single point in time is called
A balance sheet
231
A legal or financial obligation owed (e.g., debt, taxes owed) is
called a/an
Liability
232
Assets on the balance sheet with the least liquidity (e.g., real
estate, equipment) are known as
Fixed assets
233
The value of an initial lump sum of money after it is invested over
one or more periods of time is called
Future value
234
The “today” value of an amount of money expected to be received
in the future is called:
Present value
235
The concept that monetary amounts to be received in the future
or invested in the present have differing values is called
Time value of money
236
The two major activities in the financial planning process are:
forecasting potential revenues and budgeting for future expenses
237
Bonds and loans are typically examples of:
Long term debt obligations
238
Which of the US pro sports leagues have a hard salary cap
NHL and NFL
239
Examples of revenue sharing in the sports industry:
each team participating equally in national TV contracts
a home team paying a visiting team a % of gate receipts
large-market teams funding a pool to be provided to small-
market team
240
A front office employee notices that inflation has increased
expenses over the past few quarters. Raw materials costs in 2017
were $200,000 and now in 2023 they have increased to
$425,000. What is the CAGR over that period
13.4%
2017 to 2023 = 7 year period, but only 6 years of growth
[(425,000 / 200,000) ^ (1 / 6 years)] – 1 = 13.4%
241
EXCEL:
A Team has to decide between two different sponsorship deals.
Which should they choose and why?
* Deal A – 3 year deal
– Year 1 - $100,000, Year 2 - $125,000, Year 3 - $150,000
– The Team will incur signage costs of $50,000 each year
* Deal B – 3 year deal
– Year 1 - $75,000, Year 2 - $75,000, Year 3 - $75,000
– No out-of-pocket costs incurred
* The Team has an internal borrowing rate of 0.25% per mont
NPV Option 2: $212,145.85
(not option 1, but NPV is $210,752.55)
242
EXCEL:
An NFL team is considering building a standing-room endzone
club for use during games. The team estimates that it will cost
$500,000 to build. The team expects an incremental $60,000 a
year for the next 10 years from this new endzone club. What is
the payback period of this investment? If the team can borrow
money at 3.0% annually, would it make the investment? If the
bank counter-offers a rate of 3.5%, would the team still make the investment?
Payback Period = $500,000 / $60,000 = 8.3 years
* PV = FV / (1+r)t (will be given in exam)
243
EXCEL:
A team plans to sell autographed hockey pucks from its star
player. The team must pay the player $85 for each autograph,
the cost of the pucks is $22/each and the team had to construct a new kiosk in the arena to sell the items (cost of $15,000).
– If they can obtain 500 autographed pucks, what price do they need to charge to break-even?
– If they charge $147 per unit, how many units would they need to sell to break-even
1) $137
2) 375
