Question: EXERCISE 3.8 1. Using the data in Figure 3.8.3, assume that all the annual increases are the same and assume that Ms. Johnson is able

EXERCISE 3.8 1. Using the data in Figure 3.8.3, assume that all the annual increases are the same and assume that Ms. Johnson is able to keep the building for ten years and will be able sell the building at 5.555 times the annual rent roll after ten years What will be the IRR of the investment?Functions CHAPTER 3 53 G Year O Year 1 Year 2 Year 3 Year 4 Year 5 Purchase Price/Price Sold -1000000 1216531.24 3 Loan 800000 800000.00 4 Down Pay/Net Profit 200000 416531.24 5 INCOME Annual Rental Income 180000.00 187200.00 194688.00 202475.52 210574.54 218997.52 7 EXPENSES 8 Wages 12000.00 12360.00 12730.80 13112.72 13506.11 13911.29 9 Real Estate Tax, Water 40000.00 41200.00 42436.00 43709.08 45020.35 46370.96 10 Mortgage ( Interest only) 48000.00 48000.00 48000.00 48000.00 48000.00 11 Electricity 8000.00 8480.00 8988.80 9528.13 10099.82 10705.80 12 Heating, Fuel 30000.00 31800.00 33708.00 35730.48 37874.31 40146.77 13 Repairs 10000.00 10500.00 11025.00 11576.25 12155.06 12762.82 14 Supply 10000.00 10500.00 11025.00 11576.25 12155.06 12762.82 15 Insurance 9000.00 9540.00 10112.40 10719.14 11362.29 12044.03 16 Maintenance 11000.00 11220.00 11444,40 11673.29 11906.75 12144.89 17 Management 12000.00 12000.00 12000.00 12000.00 12000.00 12000.00 18 Total Expenses 142000.00 195600.00 201470.40 207625.34 214079.75 220849.37 19 20 Gross Profit/loss 8400.00 6782.40 -5149 82 -3505.21 -1851.85 21 Cash In/Out Flow 200000 8400 00 6782 40 -5149,82 3505.21 414679.39 22 IRR 13.70% Figure 3.8.3

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!

EXERCISE 3.8 1. Using the data in Figure 3.8.3, assume that all the annual increases are the same and assume that Ms. Johnson is able to keep the building for ten years and will be able sell the...

Using the data in Figure 3.8.3, assume that all the annual increases are the same and assume that Ms. Johnson is able to keep the building for ten years and will be able sell the building at 5.555...

Can you please help me solve these 10 Econ questions? I also attached the chapter just in case. Thanks so much!! :) MARKETS AND HOW THEY WORK 177 9.0 CHAPTER 9 LEARNING GOALS After reading this...

3.8 A REAL ESTATE INVESTMENT MODEL Figure 3.8.1 Ms. Johnson is buying an apariment building in Queens. The seller sent her an annual Income and Expense report of the building as indicated in Figure...

Figure 3.8.1 Ms. Johnson is buying an apartment building in Queens. The seller sent her an annual Income and Expense report of the building as indicated in Figure 3.8.1. The price of the building is...

please show the work in excel sheet, also show the formula, please As indicated in the above example, during the first five years of operation, there will be outgoing cash flows because the rental...

3.8 A REAL ESTATE INVESTMENT MODEL Figure 3.8.1 Ms. Johnson is buying an aptriment building in Queens. The seller sent her an annual Income and Expense report of the building as indicated in Figure...

Focus company - noncurrent liability disclosures . In Exercise 1.1,you were asked to obtain the most recent annual report of a company that you were interested in reviewing throughout this term....

I have attached the corresponding lessons for assignment 8, it usually includes practice problems at the bottom that look similar to the assignment. ASSIGNMENT 7 JOB ORDER COSTING Directions: After...

Use the data in nybight.dat for this problem. Using the 1974 data, estimate the coefficients in a straight line regression model predicting weight of the catch from the number of fish caught. Give...

Draw the shear and moment diagrams for thebeam. 20 kN 40 kN/m 150 kN m m -8 m-

Old Town thdustries has three divisions. Division x has been in existence the longest and has the most statute smes. Ofverion Y has beed five years and is slightly less fisky than the overall firm....

The following are two independent situations. Situation 1 Marigold Cosmetics acquired 10% of the 215,000 shares of common stock of Martinez Fashion at a total cost of $14 per share on March 18, 201...