Question: Instructions: For this assignment, you will create an Excel spreadsheet one-year cashflow model for the following investment opportunity: You are considering purchasing an existing office

Instructions: For this assignment, you will create an Excel spreadsheet one-year

Instructions: For this assignment, you will create an Excel spreadsheet one-year cashflow model for the following investment opportunity: You are considering purchasing an existing office building for $3,000,000. The property is stabilized with the following metrics: - First-year gross potential income of $452,200 - Vacancy and collection loss of 7% of gross potential income - Operating Expenses of $180,880 for year one - Capital Expenditures of 10% of EGI - Mortgage of $2,225,000 - Interest Rate of 7.7% - Loan Amortization of 25 years - Financing Cost equal to 2% Answer the following questions: 1. What are the monthly loan payments? 2. What is the required equity investment? 3. What is the LTV ratio? 4. What is first-year NOI? 5. What is first-year cash flow? 6. What is the Going-In Cap Rate? 7. What is the Equity Dividend Rate? 8. What is the Effective Gross Income Multiplier? 9. What is the Operating Expense Ratio? 10. What is the DSCR? 11. What is the Debt Yield Ratio

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Instructions: For this assignment, you will create an Excel spreadsheet one-year cashflow model for the following investment opportunity: You are considering purchasing an existing office building...

For this assignment, you will create an Excel spreadsheet one-year cashflow model for the following investment opportunity: You are considering purchasing an existing office building for $3,000,000....

Hi, please provide detailed solution for these two questions. Thank you. RSM 333 Spring 2017 Assignment #2 Due Monday, February 6th @ 4pm in Commerce Office Problem #1: (20 marks) Project Analysis /...

Acquiring the competition is often an option to penetrate untapped markets, increase market share, and realize elevated stock performance. As the CFO of CVS, you have identified a clear opportunity...

SPECIFIC TEST INSTRUCTIONS You have been hired as a new mutual fund manager and have $100 million to invest. In this case, you will use Excel Solver to determine the best mix of securities to buy....

Hi. I need Chapter 11 part 1-4 Let me know. Thanks! (it wont letme add more than $8, but I will give $12+ tip) Personal Finance, Fifth Edition by Jeff Madura BUILDING YOUR OWN FINANCIAL PLAN WORKBOOK...

I need chapters 18, 19, 20, and 21 for the workbook for Personal Finance by Madura!! Please help!!! Personal Finance, Fifth Edition by Jeff Madura BUILDING YOUR OWN FINANCIAL PLAN WORKBOOK INDEX...

I need Chapter 2 & 3 finished. Chapter 4 & 5, Chapter 6 & 7, & Chapter 8. Some of this is completed, but it isn't 100% finished. Let me know if you can get to it. Personal Finance, Fifth Edition by...

Accounting Excel Project , Please see Acct-Excel Project Direction.doc Accounting Excel Group Project Directions - Kayla and Zhejia have always wanted to start their own consulting firm. Kayla and...

Write the following using the prefixes listed in Table 1-1 and the abbreviations listed on the inside cover; for example, 10,000 meters = 10 km. (a) 1,000,000 watts, (b) 0.002 gram, (c) 3 10 6...

A 418 Q resistor, an uncharged 1.5 uF capacitor, and a 10.0 V emf are connected in series. As the capacitor charges, what is the difference between the initial current through the resistor and the...

Which of the following is NOT true of set operations considered as binary operations on the power set of some universe? Relative comkement has the universe as its identity. Intersection has the...

AbnerCorporation's bonds mature in22 years and pay11 percent interest annually. If you purchase the bonds for$1,200, what is your yield tomaturity? Your yield to maturity on the Abner bonds...

What style of conflict resolution would you use as an employee to respond to Jobss statement that Well, it was your job to convince me I was wrong, and you failed!

The three ego states that affect our behavior and the way we transact with others are parent, child, and adult. In the incident described in the case between Kalanick and Apple CEO Tim Cook, who in...

Chapter 3 discusses attitudes, self-concept, values, and ethics. More specifically, a managers attitudes, values, and ethics can affect employees job behavior and performance. How will you relate...