Excel : finance 331 (real estate) homework speadsheet

i need this homework assignment by december 1st

Fin 331
Homework 3
Due November 29, 2018
This assignment is 10% of your grade.
Review the offering memorandum for the Fox 5 Broadcasting Studio as a real estate investment. Your objective is to evaluate this investment opportunity to determine the offering price based on the assumptions provided in this prompt. You may complete this assignment individually or with one other classmate.
Please do not contact the listing agent.
• Use the spreadsheet provided to create your pro-forma
• Enter your responses in the cells that are shaded in blue for grading.
• An extra worksheet is provided if you wish to use it for intermediate calculations or schedules.
• Be sure to enter you name(s) on the spreadsheet. If you work with a partner, enter both of your names.
• Submit only one spreadsheet for grading. If you work with a partner, submit one spreadsheet for grading. The other partner only needs to submit a note with the name of who submitted the spreadsheet to ensure getting a grade for this assignment. Your name MUST appear on the spreadsheet to receive credit for this assignment.
• Name your spreadsheet “HW3 – Name 1, Name 2”
Assumptions:
• 5 year holding period
• Required IRR to Equity: 13.00%
• Financing:
o 5.00% Interest Rate
o 25 year amortization, monthly payments
o Debt Coverage Ratio of 1.20
o 1 Point Origination Fee
• $15,000 in other acquisition costs that are paid when the property is acquired.
• Income is determined based on the lease and a closing of April 1, 2019
• The Owners will have the following annual costs:
o Reserves for Replacement $6,000 per year, constant
o Unreimbursed Costs of $12,000 per year, constant, for accounting, legal, and other partnership expenses that are not passed through to the tenant.
• Disposition in Year 5
o Sale Price is estimated using the Net Operating Income for year 6 and an exit cap rate of 5.75%.
o Sale commission at the end of year 5 is 4% of the sale price.
o Other disposition costs are estimated at $25,000 for legal and partnership closing costs.
Requirements for analysis

Answers

Related Questions

Physics : physics test...

2. An elevator 2.7 m tall from floor to ceiling and with mass 650 kg begins ascending with constant acceleration. 2.0 s later a bolt comes loose from...

Physics : WATER LEVEL CONTROLLER...

The 1800s (Early History and Great Fervor)1844 - - First public demonstration of Morse's electric telegraph, Baltimore to Washington.1847 - - Alex...

Physics : Scalar And Vector Fields...

Module 1 : A Crash Course in Vectors Lecture 1 : Scalar And Vector FieldsObjectives In this lecture you will learn the followingLearn about the concep...

Physics : physics test...

AP Physics C1984 Free Response QuestionsThe materials included in these files are intended for use by AP teachers for course and exam preparation in t...

Physics : Physics Formulas: Mechanics...

Physics Formulas: MechanicsMechanics is the oldest branch of physics. Mechanics deals with all kinds and complexities of motion. It includes various t...

Physics : physics : measurement...

Physics Lab Book First DraftTABLE OF CONTENTS SBAExpt. NoTITLEEXPERIMENTSKILL PAGENO1Physical Measurements and UnitsFinding volume of a Jamaican $20 c...

Physics : physics test...

1.A student conducts an experiment to investigate the relationship between the mass of a certain liquid that isboiled and the amount of heat used. The...

years_of_major_world...

American Civil War (1861-1865)Soviet War in Afghanistan (1979-1989)Vietnam War (1955-1975)Thirty Years War (1618-1648)Napoleonic Wars (1803-1815)Russi...

Youth empowerment...

Youth EmpowermentFollowing the Guidelines of American Psychological Association Your name Your instructor's nameYouth empowermentYouth empowerment...

zambia_balance_of_payments...

The balance of payments is the method that countries use to monitor all international monetary transactions at a specific period of time. The balance...

Yahoo Company Investment Analysis...

Yahoo Inc.Yahoo Company Investment AnalysisYour nameYour institution's nameYour instructor's nameYAHOO Inc. ProfileWhether you are searching t...

Physics : Units of Measurement...

Units of MeasurementAccelerationMoment of InertiaAcceleration due to GravityMoment of Force of TorqueAngular DisplacementMomentumAngular MomentumPlank...

Physics : physics rubrics...

RUBRICS: LABORATORY PERFORMANCECRITERIAExcellent = 4Good = 3Fair =2Poor =1ScoreDiscipline shows proper/appropriate behavior and follows the rules and...

philosophy_essay.pdf...

Student Number: 20922567A Good Lawyer Cannot be a Good PersonThe question of whether a good lawyer can be a good person is not one which has a defined...

DOCTRINE OF DOUBLE EFFECT...

DOCTRINE OF DOUBLE EFFECT"To do this to the right person, to the right extent, at the right time, with the right motive, and in the right way, that is...

Linnea Pignatello- Philosophy of Education...

Linnea Pignatello- Philosophy of EducationIf I could use one word to describe myself as an educator it would be invested. There are many reasons why I...

What's New, Pussycat? by Dakota Cassidy...

What's So Amazing About Grace?by Philip YanceyIn 1987, an IRA bomb buried Gordon Wilson and his twenty-year-old daughter beneath five feet of rubb...

Uprising (Ava Delaney Vol. 2) by Claire Farrell...

Uprising (Ava Delaney Vol. 2)byClaire FarrellUprising - Volume 2The final three books in the original Ava Delaney series: Taken, Taste, and Traitor.Ta...

Final Essay Assignment...

Winston Hanks Final Essay AssignmentIn this paper I intend to examine the notions of necessity and freedom as presented in Kants Prolegomena to Any Fu...

Throne of Jade (The Temeraire Series, Book 2) by...

Throne of Jade (The Temeraire Series, Book 2)byNaomi NovikHistory takes flight in the second book of Naomi Noviks deliciously addictive series which c...

Thornbear by Michael G. Manning...

ThornbearbyMichael G. ManningGram lives in the long shadow cast by his father, the late-hero, DorianThornbear. Struggling to find his place in a world...

The Wicked: A Novel by Douglas Nicholas...

The Wicked: A NovelbyDouglas NicholasThe mesmerizing and highly anticipated sequel toSomething Redtransports readers to the harsh and enchanting world...

_judge_philosophy.docx...

Zach SchneiderCurrent debater at SIUExperienceCurrently 5th year of national circuit collegiate parli (NPDA/NPTE)2x qualified and broken at NPTEQuick...

The Storm Weaver & the Sand by Sean Williams...

The Storm Weaver & the SandbySean WilliamsSal and his friend Shilly have been joined by a third refugee, Skendar, by the time they make their way to t...

If you didn't find the right answer

Ask Your Questions, We'll notify you once someone answers it