Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Lou galuppo

09/01/2021 Client: saad24vbs Deadline: 10 Days

REAL 320 – Principles of Real Estate ASSIGNMENT #2 – Buy Your First Investment


1. Please print out and turn in an excel spreadsheet, in which you have prepared a ProForma reflecting the information provided below.


You are considering purchasing a neighborhood location which would be perfect for an Olive Garden location. You’ve spoken with an Olive Garden site selection manager, who is excited about your proposed location, and now you need to determine if the purchase makes economic sense.


You have retained Lou Galuppo of the University of San Diego, who is an expert in providing forecasting assumptions regarding your proposed site. Lou has estimated that there is a very high probability that you would earn an 11% rate of return by investing in the “Corleone Godfather Fund,” which is an independent portfolio of publicly traded securities, known for extremely predictable earnings, especially in turbulent stock market conditions.


After paying Lou’s outrageous fee of $30,000.00 for his data, you sit down to decide whether you should invest in the real estate, buy the securities portfolio, or quit the business and retire by working for your relatives in Palermo.


REPORT FROM LOU GALUPPO


Dear Prospective Olive Garden Property Location Owner:


At your request, I have completed my analysis of the market conditions for this property. At the location you are considering, an appraisal has been completed on the property, and you can purchase the property, built to Olive Garden specifications, for $6,300,000.00 ($2,300,000.00 for the land, and $4,000,000.00 for the building). At the close of escrow, you can expect to pay about 2.7% of the purchase price in closing costs.


Because this is a commercial investment property, Pavarotti Bank Services, LLC can provide you with the best commercial loan at the lowest interest rate – a no- cost, no-points 30 year amortized loan at a fixed 6.75% interest rate. The maximum loan-to-value you can borrow is 70% of the purchase price. Loan costs are estimated at .8% of the value of the loan. You will need to personally guarantee the loan.


Page ! of ! 1 4


Additionally, Pavarotti Bank Services, LLC will require you to create a single asset California-based LLC in order to hold this property. It will cost you $3,000.00 to set up the LLC, and each year your accountant has estimated that you will pay only the $800.00 minimum California Franchise Tax Board Fee for the entity.


This property will appreciate at an annual 5% compounded rate for the term of ownership. Your closing costs at the time of sale will be 8% of the sale price at that time, inclusive of a 5.0% commission and 3.0% for other closing costs.


Olive Garden has agreed to pay annual base rent calculated as 8% of the purchase price of the property, increasing 5% each year. Additionally, Olive Garden will share its profits with you as part of the lease. Olive Garden estimates that your portion of the profits will be $75,000.00 per year, estimated to increase at 5% per year over the course of ownership. Olive Garden will be your only tenant, and they have already signed a 20 year lease, to be effective on the date construction is completed. They have guaranteed payment of both the rental and incentive payment, even if they no longer have an Olive Garden at this location.


The negotiated lease is a triple-net lease, meaning that Olive Garden will pay for taxes, insurance, and maintenance on the property. We have agreed, however, to pay for the Owners Association fee for the common area, which is $2,000.00 per month (estimated to increase at 4% per year), and the water supplied to this location, since Olive Garden’ failure to pay this utility could cause a lien to be put on the property. The estimated water bill is $2,800 per month, and we expect this cost to increase at 13% per year, given San Diego’s huge water infrastructure problems.


Depreciation is calculated over 39 years, your ordinary income tax rate is 35%, and your capital gains rate is 20%. Fortunately, you are fabulously successful, and have plenty of income to offset any loss – so any tax benefit associated with having negative income is of real value to you, since it offsets taxes on other income streams. You initially expect to hold this property 31 years.


You remember than in calculating an IRR, the initial funds are negative, since they represent funds going OUT of your pocket. If you make any additional assumptions, they should be reasonable, and clearly outlined on your paper. Do not add assumptions unless you are stuck.


Page ! of !2 4


2. After completing your initial evaluation based on Lou Galuppo’s forecast, you decide that additional information may help to determine the strength of your model. You should prepare additional Excel printouts detailing the differences in assumptions.


USD Professor Alan Gin is also a trusted advisor, and has suggested that the assumptions provided by Louis Galuppo should be adjusted as described below. Alan doesn’t believe that Lou is wrong, lying or insensitive, but merely has a different view of the future economic outlook. Sensitivity Analysis should be used to test the impact on the return for the following variables:


a. Real Estate Value Appreciation Rate: Real Estate appreciation is more likely to come in at 2% per year compounded over the next 10 years. Also, 2% is a fair amount to use for any relevant holding period.


b. Holding Period: Perhaps the optimal time to hold this particular piece of real estate is 10 years, rather than the 31 years you initially modeled. He thinks you should also test holding periods at 5 years and 15 years.


c. Real Estate Rental Rate Appreciation Rate: Alan Gin suggests that appreciation of the rental rate will go up only 3% over the next 10 years. Then, while he doesn’t have an opinion, the 3% is a fair amount to use for any relevant holding period.


d. Capital Gains Tax Rate: Alan Gin suggests that capital gains rates will increase to 25%. Additionally, he thinks that Capital Gains could go as high as 35%.


e. Ordinary Income Tax Rate: Alan Gin believes that the ordinary tax rate (both Federal and State combined) will increase to 45% this year.


f. Water Rate: Future water problems are likely to be extremely acute, and will result in a 40% annual increase in water costs.


g. Interest Rate: The interest rates will drop to 4.5% h. Triple Net Lease: Instead of offering a triple net lease, where the tenant


pays for maintenance, taxes and insurance, you should consider the economic impact of a lease where the landlord is responsible for the following costs: • Property Taxes at 1.1% of the total purchase price of the property • Fire and Hazard Insurance at $8,000.00 per year • Maintenance costs estimated at $15,000.00 per year


Page ! of !3 4


3. Please provide a 2-3 page executive summary summarizing your findings describing why or why not the investment described in this assignment should be made.


Your narrative should describe the differences between the Galuppo Assumptions and the Gin Assumptions, and should identify the five input assumptions which are most sensitive to your rate of return.


If it turns out that only the Galuppo Assumptions or the Gin Assumptions suggest you should make the investment, then you should provide an analysis as to whether you should make the investment or not. Remember, the investment can either be made, or not be made – you cannot make the investment only premised on the most favorable set of assumptions.


4. Complete the Comprehensive Peer Evaluation for yourself and your group, pursuant to the instructions in the Syllabus and on the evaluation form.


Page ! of !4 4

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Homework Guru
Best Coursework Help
Writer Writer Name Offer Chat
Homework Guru

ONLINE

Homework Guru

Hi dear, I am ready to do your homework in a reasonable price and in a timely manner.

$102 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$100 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Final Paper - Light bulb languages spanish - Nurses role in system development life cycle - Dilemma at devil's den answers - History article - Seo first year fast track - Project: Risk Management Plan - Nursing Teaching - Develop: Presentation and Reflection Evaluation Title: Your Story - How to reduce communication apprehension - Informative speech topics about nursing - Jill mccorkle her chee to heart - Ordered stem and leaf plot - Mr smith keeps track of his students homework completion - A wall of fire rising by edwidge danticat - Matt biolos net worth - Tricare operations manual 6010.56 m - Vcaa exams 2021 timetable - Diastema function in herbivores - As opposed to other types of monopoly, a natural monopoly typically owes its monopoly position to - St ives high school uniform shop - System of Belief questions - Dead space 3 chapter 15 rosetta puzzle - Glass ladder and co marilyn mini - Ato private health insurance income tier - Haidilao hot pot beijing robot - Levels of social ecological model - M10 12.9 bolt torque - Endothermic and exothermic reactions lab report - Benzoin ir spectrum analysis - Hard anagrams to solve - Lime doodad - The arp entry deletion failed the requested operation requires elevation - The chocolate war setting - How to get answers for homework online - Reply to Biostatistics Discussion- Confounders - Https www ted com talks carol_dweck_the_power_of_believing_that_you_can_improve - Business - Bias ply tires wiki - Penn foster biology research paper example - How to write a cinquain poem - Class observation - I need two discussion questions 400 words min each with references. - Kmart success factors app - The facebook sonnet sherman alexie analysis - Family Health Assessment Part 1 - Civilize them with a stick summary - Go easy into the night - I love myself the world is a ghetto - Warwick trent jasper jones - Defects in metal forming process pdf - 7.17 punchline algebra book a - Ups store stones corner joplin mo - One major avenues for achieving a cost advantage over rivals is by - Creating production possibilities schedules and curves edgenuity answers - Gippsland tafe yallourn campus - Purpose of prologue in romeo and juliet - Lunar eclipse diagram labeled - Mcgraw hill financial statements - International call center management - Dissertation writing services - D8 acc - What is the mass of nabr in the mixture - Me talk pretty one day author purpose - Web Page Design - St austell healthcare doctors - The root douglass carried was thought to have supernatural powers - An author to her book - Ocv non woven technologies - What happens to donalbain in macbeth - What is 5ed4 07a4 - Business management unit 1 - New farm clinic consulting suites - Risk Factors of Behavior Summary due in 24 hours - Complexity is increasing as new technologies are emerging every day. - Xerox tqm case study - ENG 225 Introduction to Film NO PLAGIARISM PLZ Final Film Analysis - Crisis intervention strategies 8th edition ebook - The art of public speaking chapter 5 - The french revolution liberte egalite fraternite answer key - Structure of a flower - Discussion - Raew - Developing savory rosti crisps at dreddo dan's - U.S History - Cash processing solutions cps - Gang of youths fremantle arts centre - Predicting the relative length and energy of chemical bonds - Speech - Theistic existentialism vs atheistic existentialism - Half splayed skirting 140mm - Consider the following linear programming problem 20x 30y - Current transformer calculation examples - ENG 122 Revision Reflection - Is my team ploughing - Sabsa framework and methodology - Solvolysis of 2 bromo 2 methylbutane in acetic acid - Health communication - Molar mass of ethanol c2h6o - Starbucks barista certification test