A duplex is available for purchase near the university. You estimate that you ca
ID: 2821150 • Letter: A
Question
A duplex is available for purchase near the university. You estimate that you can rent one of the units for $750 and the other for $650 a month. Expenses will be $125 a month. The current sales price is 165,000 and you estimate the property will be worth 360,000 in 10 years. What is your estimated annual IRR for this property?
Answer should be formatted as a percent with 2 decimal places.
What is the estimated annual rate of appreciation in the previous problem?
Answer should be formatted as a percent with 2 decimal places.
Explanation / Answer
The cash flows are such.
Now using excel IRR function we get IRR=1.2137%
Annually IRR shall be = 1.2137*12=14.5638% or 14.56%
Annual rate of appreciation = (360,000/165,000)^(1/10)=8.11%
Month Cash flow Sale Price Total Cash flow 0 $ -1,65,000.00 $ -1,65,000.00 1 $ 1,275.00 $ 1,275.00 2 $ 1,275.00 $ 1,275.00 3 $ 1,275.00 $ 1,275.00 4 $ 1,275.00 $ 1,275.00 5 $ 1,275.00 $ 1,275.00 6 $ 1,275.00 $ 1,275.00 7 $ 1,275.00 $ 1,275.00 8 $ 1,275.00 $ 1,275.00 9 $ 1,275.00 $ 1,275.00 10 $ 1,275.00 $ 1,275.00 11 $ 1,275.00 $ 1,275.00 12 $ 1,275.00 $ 1,275.00 13 $ 1,275.00 $ 1,275.00 14 $ 1,275.00 $ 1,275.00 15 $ 1,275.00 $ 1,275.00 16 $ 1,275.00 $ 1,275.00 17 $ 1,275.00 $ 1,275.00 18 $ 1,275.00 $ 1,275.00 19 $ 1,275.00 $ 1,275.00 20 $ 1,275.00 $ 1,275.00 21 $ 1,275.00 $ 1,275.00 22 $ 1,275.00 $ 1,275.00 23 $ 1,275.00 $ 1,275.00 24 $ 1,275.00 $ 1,275.00 25 $ 1,275.00 $ 1,275.00 26 $ 1,275.00 $ 1,275.00 27 $ 1,275.00 $ 1,275.00 28 $ 1,275.00 $ 1,275.00 29 $ 1,275.00 $ 1,275.00 30 $ 1,275.00 $ 1,275.00 31 $ 1,275.00 $ 1,275.00 32 $ 1,275.00 $ 1,275.00 33 $ 1,275.00 $ 1,275.00 34 $ 1,275.00 $ 1,275.00 35 $ 1,275.00 $ 1,275.00 36 $ 1,275.00 $ 1,275.00 37 $ 1,275.00 $ 1,275.00 38 $ 1,275.00 $ 1,275.00 39 $ 1,275.00 $ 1,275.00 40 $ 1,275.00 $ 1,275.00 41 $ 1,275.00 $ 1,275.00 42 $ 1,275.00 $ 1,275.00 43 $ 1,275.00 $ 1,275.00 44 $ 1,275.00 $ 1,275.00 45 $ 1,275.00 $ 1,275.00 46 $ 1,275.00 $ 1,275.00 47 $ 1,275.00 $ 1,275.00 48 $ 1,275.00 $ 1,275.00 49 $ 1,275.00 $ 1,275.00 50 $ 1,275.00 $ 1,275.00 51 $ 1,275.00 $ 1,275.00 52 $ 1,275.00 $ 1,275.00 53 $ 1,275.00 $ 1,275.00 54 $ 1,275.00 $ 1,275.00 55 $ 1,275.00 $ 1,275.00 56 $ 1,275.00 $ 1,275.00 57 $ 1,275.00 $ 1,275.00 58 $ 1,275.00 $ 1,275.00 59 $ 1,275.00 $ 1,275.00 60 $ 1,275.00 $ 1,275.00 61 $ 1,275.00 $ 1,275.00 62 $ 1,275.00 $ 1,275.00 63 $ 1,275.00 $ 1,275.00 64 $ 1,275.00 $ 1,275.00 65 $ 1,275.00 $ 1,275.00 66 $ 1,275.00 $ 1,275.00 67 $ 1,275.00 $ 1,275.00 68 $ 1,275.00 $ 1,275.00 69 $ 1,275.00 $ 1,275.00 70 $ 1,275.00 $ 1,275.00 71 $ 1,275.00 $ 1,275.00 72 $ 1,275.00 $ 1,275.00 73 $ 1,275.00 $ 1,275.00 74 $ 1,275.00 $ 1,275.00 75 $ 1,275.00 $ 1,275.00 76 $ 1,275.00 $ 1,275.00 77 $ 1,275.00 $ 1,275.00 78 $ 1,275.00 $ 1,275.00 79 $ 1,275.00 $ 1,275.00 80 $ 1,275.00 $ 1,275.00 81 $ 1,275.00 $ 1,275.00 82 $ 1,275.00 $ 1,275.00 83 $ 1,275.00 $ 1,275.00 84 $ 1,275.00 $ 1,275.00 85 $ 1,275.00 $ 1,275.00 86 $ 1,275.00 $ 1,275.00 87 $ 1,275.00 $ 1,275.00 88 $ 1,275.00 $ 1,275.00 89 $ 1,275.00 $ 1,275.00 90 $ 1,275.00 $ 1,275.00 91 $ 1,275.00 $ 1,275.00 92 $ 1,275.00 $ 1,275.00 93 $ 1,275.00 $ 1,275.00 94 $ 1,275.00 $ 1,275.00 95 $ 1,275.00 $ 1,275.00 96 $ 1,275.00 $ 1,275.00 97 $ 1,275.00 $ 1,275.00 98 $ 1,275.00 $ 1,275.00 99 $ 1,275.00 $ 1,275.00 100 $ 1,275.00 $ 1,275.00 101 $ 1,275.00 $ 1,275.00 102 $ 1,275.00 $ 1,275.00 103 $ 1,275.00 $ 1,275.00 104 $ 1,275.00 $ 1,275.00 105 $ 1,275.00 $ 1,275.00 106 $ 1,275.00 $ 1,275.00 107 $ 1,275.00 $ 1,275.00 108 $ 1,275.00 $ 1,275.00 109 $ 1,275.00 $ 1,275.00 110 $ 1,275.00 $ 1,275.00 111 $ 1,275.00 $ 1,275.00 112 $ 1,275.00 $ 1,275.00 113 $ 1,275.00 $ 1,275.00 114 $ 1,275.00 $ 1,275.00 115 $ 1,275.00 $ 1,275.00 116 $ 1,275.00 $ 1,275.00 117 $ 1,275.00 $ 1,275.00 118 $ 1,275.00 $ 1,275.00 119 $ 1,275.00 $ 1,275.00 120 $ 1,275.00 $ 3,60,000.00 $ 3,61,275.00Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.