Golden Opportunity Case Instructions - FINAL
.pdf
keyboard_arrow_up
School
University of Kentucky *
*We aren’t endorsed by this school
Course
464
Subject
Finance
Date
Apr 3, 2024
Type
Pages
2
Uploaded by MegaHeron3609
1
FIN 464-695 Real Estate Finance and Investments
Golden Opportunity Case Project Instructions
Spring 2024
General Instructions
•
This is a team assignment. Work in the teams you formed earlier in the semester for the Excel assignment.
•
Your team will prepare a case report in the form of an “executive memo” worth 75 points, or 15 percent of your course grade.
•
The “executive memo” will have at most 4 pages of text (1.5 spaced, 12 pt. font, default margins in Word) excluding a cover sheet and at most 5 pages of exhibits, tables, and figures. This means the document should be no longer than 10 pages in total (cover sheet, text, exhibits, tables, and figures). As an example, this document is in the specified format in terms of spacing, font, and margins.
•
The memo should be addressed to “Hank Christofferson, CEO, Orrington Financial Partners” and should be a well-organized and integrated memo that clearly summarizes your analysis of the case questions. It should not be structured as just a series of answers to the suggested case questions.
•
Prepare a brief slide deck summarizing your report. Be prepared to give a 15-minute briefing to Mr. Christofferson on your analysis and recommendations. On the case discussion day, I will select two teams at random to come forward and present their briefing and take some Q&A from Mr. Christofferson (the rest of the class and I will play the role of Mr. Christofferson).
•
Everyone should come to class prepared to discuss the case. All are subject to “cold calls.”
•
Make sure that you state and justify all assumptions. State any qualifications to your conclusions and recommendations and identify any additional data or information that would assist you in making a stronger case.
•
You will need to develop an Excel model to address the questions most efficiently. You are required to turn in your Excel model along with your slide deck at the deadline. The Excel file is not
graded but it may be reviewed to better understand the logic in your memo. It is
2
in your best interest to set up the model in a manner that is clear and well-organized in the event we refer to it when grading your memo. •
You are graded on the quality of your analysis, your logic in drawing conclusions based on your analysis, and the quality of the communication in your report—both narrative text and supporting exhibits or tables.
•
The “executive memo,” slide deck, and Excel file should be submitted via Canvas (one submission of each per team) no later than Sunday, March 24 @ 11:59 pm
.
Case Questions
Your case analysis should focus only on the properties in the San Francisco
market.
1.
Are CBRE’s projections in the pro forma reasonable? If not, how would you change the pro forma? Carefully justify your analysis based on the available data and facts from the case.
2.
What should Aurelia recommend to Orrington Financial Partners? Purchase the entire San Francisco portfolio? Purchase only selected properties in San Francisco? Or pass on the entire opportunity? Justify your position carefully.
3.
If you were Aurelia Dimas, what price would you bid for the properties selected? Which valuation approaches do you rely on and why? Again, carefully justify the assumptions leading to your conclusion.
4.
Do you believe a sale-leaseback is a good or bad strategy for the State of California? Why? How might this issue affect your recommendations?
Some qualitative
issues to consider as appropriate (among others that are possible):
•
Location
: Advantageous relative to competitors?
•
Age
: How should age or the timing of recent renovations affect the pro forma and the value?
•
Tenant
: Given the properties are occupied by the State of California, should that affect the pro forma and the value? If so, how?
•
Deferred maintenance
: Will the buyer need to invest significant capital to position the property to market standards? If so, what is the impact on the value of the project?
•
LEED certification
: Is it already incorporated into the value?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Assume that Whee, Cheatham, and Howe is an auditing firm that has found that its summer interns are subject to a 90 percent learning curve for one of its important tasks, proofreading financial statements. For one of its interns, Kim Down, the firm has started to analyze the relation between time and financial statement proofreading.
Financial StatementsProofread (X)
Time Required to Proofreadthe Xth Financial Statement
1
2.0 hours
2
1.8 hours
4
?
8
?
16
?
Required:
a. Compute the time required to proofread 4, 8, and 16 financial statements.
arrow_forward
TOPIC: ENGINEERING ECONOMICS
SPECIFIC INSTRUCTION: Solve each problem NEATLY and SYSTEMATICALLY. Show your
COMPLETE solutions and BOX your final answers. Express all your answers in 2 decimal places.
PROBLEM:
Find the exact and ordinary interest on Php 5,000 at 19 % for 30 days.
arrow_forward
Complete the problems. Chelk
3. Dabney Washington is paid a weekly comm1ssI
Sales of
the week?
or
Lesson Practice
Use the following commission schedule to find the total graduated
commission in Problems 5–8.
5% on First
8% on Next
10% on sales
Total
Sales Amount
$5,000
$10,000
Over $15,000
Commission
5.
$4,000
b.
С.
d.
а.
6.
8,000
а.
b.
d.
7.
18,000
b.
d.
а.
8.
27,500
b.
a.
d.
$7,500 or on in of Last week
less and 3.0% on in of Nate's
9. Mary Robertson sells tires
Dabney's was of her sales for
4. Nate a of on sales of or
arrow_forward
Required information
Learning Objective 11-04 Calculate the periodic amortization of an
intangible asset.
(The following information applies to the questions displayed below.]
The allocation process for intangible assets is called amortization. For an
intangible asset with a finite useful life, the capitalized cost less any estimated
residual value must be allocated to periods in which the asset is expected to
contribute to the company's revenue-generating activities. An intangible asset
that is determined to have an indefinite useful life is not subject to periodic
amortization. Goodwill is perhaps the most typical intangible asset with an
indefinite useful life.
Software development
arrow_forward
In Organizational Development (OD), each area of OD has its own budget to maintain. Please create a
spreadsheet indicating the following purchases for the different OD areas and the remaining balance for
each department based on the beginning budget and purchases as indicated.
The Center for the Advancement of Teaching
and Learning
Beginning Budget $60,000
Speaker
Books
Speaker Gifts
$2,000
100 @ $22.50 each
$200.00
Leadership Development
Beginning Budget $40,000
Retreat Location Rental
Retreat Lunch
Conference
Awards
$8,000
$11.00 each for 72
attendees
$9,000
$8,800
Creative and Strategic Initiatives
Beginning Budget $25,000
Camera
Software
Digital subscriptions
$7,000
$2,000
$550.00
arrow_forward
None
arrow_forward
hre.7
arrow_forward
Milestone #1 – Research Project Overview (Week Two)
Introduction: Provide a brief overview of the research healthcare. Describe the topic you are focusing on and establish the rationale behind your choice. Use the model for introduction on page 111 in Creswell & Creswell.
Purpose: Describe the main topics that you will examine in the context of the survey. You do not need to discuss the specific survey questions here. Rather, focus on the broader topics and themes that you will address in the questionnaire. Creswell & Creswell (2023) discuss this in Chapter 6.
arrow_forward
EVALUATION (100%)
Make a video of yourself while answering /discussing in detail the following question. Upload this video
clip to a designated folder in Google classroom:
Lesson 6:
On July 1, 2021, Emilia Clarke opened a small paint shop called "Emilia Clarke Paint Shop." The
following were the transactions during the month:
Date
Transactions
1
3
Invested P100,000 cash in the business
Obtained a P30, 000 loan from a bank.
Purchased equipment for P20,000 cash.
5
7
10
Purchased goods for P20,000 cash. (Use perpetual inventory system)
Sold goods for P10,000 cash. The cost of the goods sold was of P7,000.
Withdrew cash P5,000
15
25
Paid utilities expense amounting to P3,000
Paid P5,000 salaries.
31
Requirements:
a.
Record the transactions in the journal.
b.
Post the transaction in the ledger.
c. Prepare the unadjusted trial balance on July 31, 2021
arrow_forward
Perform a categorical analysis on the majors of students enrolled in the MBA. Describe your findings.
arrow_forward
This homework submission should include all calculations for part (a), completed on the designated tab of the Homework Student Workbook, and a document explaining the implications of your findings for the business or business transaction. After reading this week’s resources, respond to the following:You are a financial analyst for the Brittle Company. The director of capital budgeting has asked you to analyze two proposed capital investments: Projects X and Y. Each project has a cost of $10,000, and the cost of capital for each is 12%. The projects' expected net cash flows are shown in the table below.
Expected Net Cash Flows
Year
Project X
Project Y
0
– $10,000
– $10,000
1
6,500
3,500
2
3,000
3,500
3
3,000
3,500
4
1,000
3,500
Use the Workbook to calculate each project's net present value (NPV), internal rate of return (IRR), modified internal rate of return (MIRR), and profitability index (PI).
Which project or projects should…
arrow_forward
You wish to take an Excel course. You may enroll at one within your school or you may take a community class at the local library. You've gathered the following information to aid in your decision-making process:
Costs/Benefits
College Course
Community Course
Cost
$4,300
$1,190
Distance to course
0.20 miles (walking distance)
18 miles (driving distance)
Timing of course
Weekday
Weekend
Number of meetings
16
8
Qualitative considerations
Convenience, quality of instruction
Flexibility, brief duration
Pretend transportation (gas, mileage, and parking) cost $220 per class session at the library. If you consider solely the cost - including transportation - of each alternative, which would you choose?
Multiple Choice
College course
Community course
Both alternatives
Neither alternative
arrow_forward
cements
Unit Study Plan
Coursework
Learning Activities
NUNAVUT PAYROLL TAX
SCENARIO
Patricia Clark, the Human Resources Manager of your Northern Expeditions
company, has advised that the company will be opening an office in Nunavut
this year. The office will offer guided northern trips to hunters and adventurers.
It expects to mainly employ local guides (40 days over the summer period) but
the company will also be periodically bringing in guides from its offices in
Alberta, Saskatchewan and Québec. Some of the guides from outside Nunavut
may work 10 days, others could work 15 days over the summer depending on
the number of bookings; they normally work in their home province for 60 days
every year. The average daily rate paid to these guides is $400.
Patricia is asking for information on the Nunavut Payroll Tax. Who pays the tax
and how is it calculated? Are there any special considerations or challenges for
the calculation of the payroll tax for the guides brought in from Alberta,…
arrow_forward
Please help me answer parts D and F ONLY.
Thank you!
arrow_forward
What is the likely reaction of Jasper's corporate management toward the investment? Why?
arrow_forward
Step by step with explanation.
arrow_forward
Financial Accounting
arrow_forward
Give answer within 45 min I will give you up vote
arrow_forward
Please see below. Need this asap please and thank you.
arrow_forward
KINGDOM OF SAUDI ARABLA
MINISTRY OF HIGHER EDUCATION
4 Imam Muhammad thn Sand hlamie Universio
College of Ecenomies and Adminirative Selenees
Department of inance and Investment
Acedemic year1442-144
Level i four
Caurne Princiuler af finance
and investment-FINI02
Home exercises 1
All results must be numerie and rounded to the nearest hundredth
When you round off to the hundredih digit, you look at only the thousandth digit Le you focus only
on the next digit.
Say x- 8678.4546 When you round it to the nearest hundredth digit, you get - 8678.45
Say z= 8678.4556 When you round it to the nearest hundredth digit. you get z 8678.46
Question1:
You are given the following information about a corporation.
Statement income
2019
2020
Sales
250
300
Operating costs
Depreciations
Net Working Capital
Capital Spending
If we assume the firm faces a 20% tax rate, calculate the free cash flow (FCF) for the year 2020.
180
200
45
20
50
25
45
50
Question2:
You are considering an investment in a new project.…
arrow_forward
ICE TASK 4 – Budgeting Techniques
The University of Africa requires all second-year engineering students to have their own laptop computers to do practical work and tasks. During the last quarter of 2022, a private company, Laptops for Students Proprietary Limited (“LFS”) was established to supply laptops according to the specifications set by the university, at affordable prices. At that time, a loan of R800 000 was granted to LFS and the funds were deposited into the bank account. Prior to the receipt of the loan amount no cash transactions occurred.
The following additional information is available for LFS:
According to estimates, 200 of the 400 second year engineering students will buy their laptops from LFS. There are two types of laptops which will be supplied, namely Exceptional at a selling price of R10 000 and Superior at a selling price of R8 000. Since the Exceptional laptop has a more powerful hard drive, it is expected that 60% of the 200 students will prefer to…
arrow_forward
X
Search the web
↑
EXPERT
SOLUTION
RECOMMENDED
QUESTIONS
Homework help starts here!
← Q&A Library
Step 6 Budgeted Balance Sheet
Minden Company
Budgeted Balance sheet as on May 31
Assets
Cash
Accounts Receivable
Inventory
Building and equipment, net of Depreciation
Total Assets
Liabilities and stakeholders equity
Accounts Payable
Notes Payable
Common Stock
Retained Earnings
Total Liabilities and stakeholders equity
Still Need Help?
FOLLOW UP QUESTION
WAS THIS HELPFUL?
FEEDBACK
The company is in the process of preparing a budget...
во
Amount $
8900
70000
40000
211500
330400
ASK AN EXPERT CHAT | √ MATH SOLVER
72000
20000
180000
58400
330400
where from
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
What is the answer A thru D?
arrow_forward
Give answer within 45min I will give you up boat it's urgent......
arrow_forward
https://elearn.squ.edu.om/mod/quiz/attempt.php?attempt=1863256&cmid%3D886247
(SQU E-LEARNING SYSTEM (ACADI
Managerial Accounting - Spring
34:29 úall á Jl
Company XYZ is currently making sales of $200,000. At this level, the variable expenses were $160,000. Assume that
company XYZ expects sales to increase to $250,000 in the coming period with no change is expected to fixed
?expenses. How much is the expected change in profit
Increase by 40,000 .a
Increase by $160,000 .b O
E Increase by $50,000 .c O
Increase by $10,000 .d O
Cannot be determined
.e O
arrow_forward
Hh2.
Account
arrow_forward
6. I need help with formulas
arrow_forward
Hh.: subject: account
arrow_forward
Creat an initial budget sheet showing the sistribution of $100,000 use the example's format on EXCEL.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- Assume that Whee, Cheatham, and Howe is an auditing firm that has found that its summer interns are subject to a 90 percent learning curve for one of its important tasks, proofreading financial statements. For one of its interns, Kim Down, the firm has started to analyze the relation between time and financial statement proofreading. Financial StatementsProofread (X) Time Required to Proofreadthe Xth Financial Statement 1 2.0 hours 2 1.8 hours 4 ? 8 ? 16 ? Required: a. Compute the time required to proofread 4, 8, and 16 financial statements.arrow_forwardTOPIC: ENGINEERING ECONOMICS SPECIFIC INSTRUCTION: Solve each problem NEATLY and SYSTEMATICALLY. Show your COMPLETE solutions and BOX your final answers. Express all your answers in 2 decimal places. PROBLEM: Find the exact and ordinary interest on Php 5,000 at 19 % for 30 days.arrow_forwardComplete the problems. Chelk 3. Dabney Washington is paid a weekly comm1ssI Sales of the week? or Lesson Practice Use the following commission schedule to find the total graduated commission in Problems 5–8. 5% on First 8% on Next 10% on sales Total Sales Amount $5,000 $10,000 Over $15,000 Commission 5. $4,000 b. С. d. а. 6. 8,000 а. b. d. 7. 18,000 b. d. а. 8. 27,500 b. a. d. $7,500 or on in of Last week less and 3.0% on in of Nate's 9. Mary Robertson sells tires Dabney's was of her sales for 4. Nate a of on sales of orarrow_forward
- Required information Learning Objective 11-04 Calculate the periodic amortization of an intangible asset. (The following information applies to the questions displayed below.] The allocation process for intangible assets is called amortization. For an intangible asset with a finite useful life, the capitalized cost less any estimated residual value must be allocated to periods in which the asset is expected to contribute to the company's revenue-generating activities. An intangible asset that is determined to have an indefinite useful life is not subject to periodic amortization. Goodwill is perhaps the most typical intangible asset with an indefinite useful life. Software developmentarrow_forwardIn Organizational Development (OD), each area of OD has its own budget to maintain. Please create a spreadsheet indicating the following purchases for the different OD areas and the remaining balance for each department based on the beginning budget and purchases as indicated. The Center for the Advancement of Teaching and Learning Beginning Budget $60,000 Speaker Books Speaker Gifts $2,000 100 @ $22.50 each $200.00 Leadership Development Beginning Budget $40,000 Retreat Location Rental Retreat Lunch Conference Awards $8,000 $11.00 each for 72 attendees $9,000 $8,800 Creative and Strategic Initiatives Beginning Budget $25,000 Camera Software Digital subscriptions $7,000 $2,000 $550.00arrow_forwardNonearrow_forward
- hre.7arrow_forwardMilestone #1 – Research Project Overview (Week Two) Introduction: Provide a brief overview of the research healthcare. Describe the topic you are focusing on and establish the rationale behind your choice. Use the model for introduction on page 111 in Creswell & Creswell. Purpose: Describe the main topics that you will examine in the context of the survey. You do not need to discuss the specific survey questions here. Rather, focus on the broader topics and themes that you will address in the questionnaire. Creswell & Creswell (2023) discuss this in Chapter 6.arrow_forwardEVALUATION (100%) Make a video of yourself while answering /discussing in detail the following question. Upload this video clip to a designated folder in Google classroom: Lesson 6: On July 1, 2021, Emilia Clarke opened a small paint shop called "Emilia Clarke Paint Shop." The following were the transactions during the month: Date Transactions 1 3 Invested P100,000 cash in the business Obtained a P30, 000 loan from a bank. Purchased equipment for P20,000 cash. 5 7 10 Purchased goods for P20,000 cash. (Use perpetual inventory system) Sold goods for P10,000 cash. The cost of the goods sold was of P7,000. Withdrew cash P5,000 15 25 Paid utilities expense amounting to P3,000 Paid P5,000 salaries. 31 Requirements: a. Record the transactions in the journal. b. Post the transaction in the ledger. c. Prepare the unadjusted trial balance on July 31, 2021arrow_forward
- Perform a categorical analysis on the majors of students enrolled in the MBA. Describe your findings.arrow_forwardThis homework submission should include all calculations for part (a), completed on the designated tab of the Homework Student Workbook, and a document explaining the implications of your findings for the business or business transaction. After reading this week’s resources, respond to the following:You are a financial analyst for the Brittle Company. The director of capital budgeting has asked you to analyze two proposed capital investments: Projects X and Y. Each project has a cost of $10,000, and the cost of capital for each is 12%. The projects' expected net cash flows are shown in the table below. Expected Net Cash Flows Year Project X Project Y 0 – $10,000 – $10,000 1 6,500 3,500 2 3,000 3,500 3 3,000 3,500 4 1,000 3,500 Use the Workbook to calculate each project's net present value (NPV), internal rate of return (IRR), modified internal rate of return (MIRR), and profitability index (PI). Which project or projects should…arrow_forwardYou wish to take an Excel course. You may enroll at one within your school or you may take a community class at the local library. You've gathered the following information to aid in your decision-making process: Costs/Benefits College Course Community Course Cost $4,300 $1,190 Distance to course 0.20 miles (walking distance) 18 miles (driving distance) Timing of course Weekday Weekend Number of meetings 16 8 Qualitative considerations Convenience, quality of instruction Flexibility, brief duration Pretend transportation (gas, mileage, and parking) cost $220 per class session at the library. If you consider solely the cost - including transportation - of each alternative, which would you choose? Multiple Choice College course Community course Both alternatives Neither alternativearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you