Question: I was trying to use what if analysis to solve it but it return wrong answers Anyone could help me to solve this table step

I was trying to use what if analysis to solve it but it return wrong answers

Anyone could help me to solve this table step by step? or telling me what's wrong with my table? Not just answer only.

Thanks! I was trying to use what if analysis to solve it but

Assumptions SF Rent Operating Expenses General Vacancy Purchase Price Loan to Value Equity Cap rate Growth rate Income Growth rate Expenses Assumptions 10000 20 $/SF 10 $/SF 10% 1,000,000.00 700,000.00 70% 300,000.00 8% 3% 2% Unleveraged Irr Cap Rate Leveraged Irr cap rate Purchase 1,000,000.00 Loan to V 700,000.00 Equity 300,000.00 Purchase Price Data Table 12.20% 1100000 1050000 1000000 9.00% 10.14% 10.14% 10.14% 8.50% 11.13% 11.13% 11.13% 8.00% 12.20% 12.20% 12.20% 7.50% 13.37% 13.37% 13.37% 7.00% 14.64% 14.64% 14.64% LTV 23.09% 60% 65.00% 70.00% 9.00% 8.50% 8.00% 7.50% 7.00% 70% 950000 900000 10.14% 10.14% 11.13% 11.13% 12.20% 12.20% 13.37% 13.37% 14.64% 14.64% 75.00% 80.00% Assumptions SF Rent Operating Expenses General Vacancy Purchase Price Loan to Value Equity Cap rate Growth rate Income Growth rate Expenses Assumptions 10000 20 $/SF 10 $/SF 10% 1,000,000.00 700,000.00 70% 300,000.00 8% 3% 2% Unleveraged Irr Cap Rate Leveraged Irr cap rate Purchase 1,000,000.00 Loan to V 700,000.00 Equity 300,000.00 Purchase Price Data Table 12.20% 1100000 1050000 1000000 9.00% 10.14% 10.14% 10.14% 8.50% 11.13% 11.13% 11.13% 8.00% 12.20% 12.20% 12.20% 7.50% 13.37% 13.37% 13.37% 7.00% 14.64% 14.64% 14.64% LTV 23.09% 60% 65.00% 70.00% 9.00% 8.50% 8.00% 7.50% 7.00% 70% 950000 900000 10.14% 10.14% 11.13% 11.13% 12.20% 12.20% 13.37% 13.37% 14.64% 14.64% 75.00% 80.00%

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!

British Matchbox Cars Case O n 1 July 2 0 X 5 , B M C L t d ( o r i g i n a l l y known a s British Matchbox Cars L t d ) acquired 6 0 % o f the issued voting shares o f Austin L t d for...

You are a portfolio manager, and you are trying to put together a portfolio that is designed to beat the market (represented here by the S&P 500 index). You will first pick ten stocks, and then you...

Assignment 3: Case Study - America Coffee House (20%) It is January 1st, 2023. You are a senior analyst at America Coffee House Inc. (ACH), a leading coffee chain and wholesaler of coffee/bakery...

COMPLETE THE JUNIT SO ALL TESTS PASS: /** * Name: Firstname Lastname * Chapter 6 methods in the Ebook. Submit this file to * the dropbox for grading. * Some methods require you to call a previous...

I used the most recent (2022) table for calculating the federal withholding using the percentage method as instructed. I worked these the same way (see my math written out) but my second answer is...

I am trying to use Excel to solve for the Future Value of an Investment. The information is above the step 1 instructions. I believe I understand the numbers that I should be inputting into the NPER...

Conduct an internet search to find an organization that lists its mission and vision statement on its website. What do the mission and vision statements communicate? How might the organization use...

Strategic Leadership Real Life Case Study Assignment (Individual Basis) Purpose of the learning activity: This project will allow the students to use the concepts of Strategic Leadership learned over...

1. Read the articleSix Impossible Things Before Breakfast. Is the Efficient Market Hypothesis (EMH) the correct theory relative well functioning financial markets? If not why not? 2.Read the...

(QUESTIONS TO ANSWER FOR EACH QUESTION DISCUSS AND ANALYZE THE ISSUE) 1) Based on the discussion between Aliyah, Christine and Brad as well as any external reading you may have done, how best should...

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

Green Vehicle Inc. manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle,...

On 31 December, year 2, Anchor product has a patent shown on its balance sheet for $96,000 that has a remaining legal life of 8 years. It is expected that, the patent will have no economic value...

9. Underemployment means . ( LO4 ) a) the same thing as unemployment b) underutilization of resources c) a recession d) slow economic growth

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

Teamwork.With a partner read alternate sentences from the following paragraph aloud to each other. (Objective 2) ehT qaimtimg also qroved that, sa well sa being a great humter, Cro-Wagmom Nam saw a...

Global.Contact an international center at a university (visit, call, or send e-mail).Ask about a study abroad or work abroad program. Develop and present your findings to your class. (Objectives 4...

Technology. Global. India is a well-known location for offshore sites and outsourcing operations for large corporations. Using an encyclopedia, website URLs in this chapter, or other resources,...