Question: please show me how to solve this with excel and build an excel calcuator! thanks! 2) Given the following information, calculate the before-tax equity reversion

please show me how to solve this with excel and build an excel calcuator! thanks!

2) Given the following information, calculate the before-tax equity reversion (BTER): NOI: $89,100; annual debt service: $58,444; net sale proceeds: $974,700; remaining mortgage balance: $631,026. A) $30,656 B) $343,674 - wrong C) $572,582 D) $885,600

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!

Consider the circuit shown in Figure P6.76 with transistor parameters $\beta=120$ and $V_{A}=\infty$. (a) Determine the small-signal parameters $g_{m}, r_{\pi}$, and $r_{o}$ for both...

This is an assignment for a Real Estate class. Please let me know if you can help out. I have attached 2 files. the PDF file is the assignment instructions. Pages 1, 2 and 3 are examples. The actual...

please explain 25. Given the following information, calculate the funds from operation (FFO). Net income: $1,200,000, Gain/losses from infrequent and unusual events: $0, Amortization of tenant...

I need help with these questions. I will pay $30. This submission limit to $8 only. Can I get by tomorrow noon. 11/16/2017.Please provide excel with calculations Question 2 Assume that you are...

please help me solve this with excel im having a hard time Q2 Given the following information, calculate the going-in capitalization rate for the specific property: First-year NOI: $250,700;...

King Enterprises built Fox Trot at $950,000 for the cabin, $75,000 for the land, and $75,000 for the furnishings. The project will take about 1 year to complete. The investor believes they can sell...

Please show excel functions - Consider the following loan information. - Total acquisition price: $3,000,000. - Property consists of twelve office suites, five on the first floor and seven on the...

only need the answer to 3a. for 90% scenario. The solution for problem 2 will be needed is attached. Using the same information regarding Mr. Arnold Benedict considering buying anapartment complex...

You can ignore question 3. I only need help with the first 2 questions. If you could just provide the right formulas to use, I can fill in the answers. UNIVERSITY OF MEMPHIS FOGELMAN COLLEGE OF...

Please explain in excel as it will easy for me to understand Thank you. Part 1 We are considering an acquisition of an existing medical office building (MOB) to our portfolio. There are 4 tenants....

Need help with milestone one ACC 660, the attached like include guidelines, rubric and a case study on Starbucks from Harvard university. NOTES: 1. Please be sure to attach excel workbooks or...

On an eight-question true-false quiz, a student guesses each answer. What is the probability that he/she gets at least one of the answers correct? Use decimals and round to 3 decimal places.

Questions & Problems 1. (15 points) Calculate the hydrostatic pressures (in psi) at given true vertical depth (TVD) for the following incompressible mud systems (see Conversion Table in the Appendix...

Use the information below to find the cost, including a commission of $10 per bond, of buying 60 Agory bonds. Corporation Bond Data COMPANY(TICKER) COUPON MATURITY LAST PRICE LAST YIELD EST $ VOL...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...