Question
In: Finance
A duplex is available for purchase near the university. You estimate that you can rent one...
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.
Solutions
Expert Solution
| 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.00 |
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%
jeff jeffy answered 2 years agoRelated Solutions
Assume you own and occupy a duplex. You live in one unit and rent out the...
Assume you own and occupy a duplex. You live in one unit and
rent out the other unit. You notice your tenant has a clogged drain
on an almost monthly basis. You are responsible for paying for the
plumber or for unclogging the drain yourself. You suspect your
tenant is pouring bacon grease down the drain because you often
experience the smell of frying bacon coming from her apartment.
Despite your questioning, your tenant denies putting bacon grease
down the...
You are considering an option to rent or to purchase a single-family house. You can rent...
You are considering an option to rent or to purchase a
single-family house. You can rent it for
$1,500 per month. If you rent the property, the current owner will
be responsible for
maintenance, property insurance and taxes. Your second option is to
purchase the property for
$125,000. You have enough money for a 20% down payment, and would
need to finance the
other 80% with a fixed-rate mortgage at a four percent interest
rate. Assume that the mortgage
would...
Rent vs Own You are considering an option to purchase or rent a single residential property....
Rent vs Own
You are considering an option to purchase or rent a single
residential property. You can rent it for $4,000 per month and the
owner would be responsible for maintenance, property insurance, and
property taxes.
Alternatively, you can purchase this property for $300,000 and
finance it with an 80% mortgage at 7% interest, 25 year - fixed.
The loan can be prepaid at any time with no penalty.
You have done research in the market and found that...
A university would like to estimate the proportion of fans who purchase concessions at the first...
A university would like to estimate the proportion of fans who
purchase concessions at the first basketball game of the season.
The basketball facility has a capacity of 3500 and is routinely
sold out. It was discovered that a total of 300 fans out of a
random sample of 500 purchased concessions during the game.
Construct a 95% confidence interval to estimate the proportion of
fans who purchased concessions during the game. The 95% confidence
interval to estimate the proportion...
A university would like to estimate the proportion of fans who purchase concessions at the first...
A university would like to estimate the proportion of fans who
purchase concessions at the first basketball game of the season.
The basketball facility has a capacity of 3,500 and is routinely
sold out. It was discovered that a total of 200 fans out of a
random sample of 400 purchased concessions during the game.
Construct a 95% confidence interval to estimate the proportion of
fans who purchased concessions during the game.
The 95% confidence interval to estimate the proportion...
A university would like to estimate the proportion of fans who purchase concessions at the first...
A university would like to estimate the proportion of fans who
purchase concessions at the first basketball game of the season.
The basketball facility has a capacity of 3,500 and is routinely
sold out. It was discovered that a total of 230 fans out of a
random sample of 500 purchased concessions during the game.
Construct a 95% confidence interval to estimate the proportion of
fans who purchased concessions during the game.
The 95% confidence interval to estimate the proportion...
A university would like to estimate the proportion of fans who purchase concessions at the first...
A university would like to estimate the proportion of fans who
purchase concessions at the first basketball game of the season.
The basketball facility has a capacity of 3 comma 600 and is
routinely sold out. It was discovered that a total of 200 fans out
of a random sample of 500 purchased concessions during the game.
Construct a 95% confidence interval to estimate the proportion of
fans who purchased concessions during the game. The 95% confidence
interval to estimate...
After living in a university residence for one year, Kate decides to rent an apartment for...
After living in a university residence for one year, Kate
decides to rent an apartment for the remaining three years of her
degree. She has found a nice location that will cost $860 per
month. Rent for the first and last month must be paid up
front.
How much money would Kate need to have in her bank account right
now to be sure she will always have enough for rent? The bank
account pays 3.0 percent interest, compounded monthly....
Zoysia University must purchase mowers for its landscape department. The university can buy four EVF mowers...
Zoysia University must purchase mowers for its landscape
department. The university can buy four EVF mowers that cost $7,600
each and have annual, year-end maintenance costs of $1,675 per
mower. The EVF mowers will be replaced at the end of Year 4 and
have no value at that time. Alternatively, Zoysia can buy six AEH
mowers to accomplish the same work. The AEH mowers will be replaced
after seven years. They each cost $6,600 and have annual, year-end
maintenance costs...
Zoysia University must purchase mowers for its landscape department. The university can buy six EVF mowers...
Zoysia University must purchase mowers for its landscape
department. The university can buy six EVF mowers that cost $7,900
each and have annual, year-end maintenance costs of $1,775 per
mower. The EVF mowers will be replaced at the end of Year 4 and
have no value at that time. Alternatively, Zoysia can buy seven AEH
mowers to accomplish the same work. The AEH mowers will be replaced
after seven years. They each cost $6,900 and have annual, year-end
maintenance costs...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Enumerations Create an advanced enumeration to represent months (JANUARY – DECEMBER) called enuMonths Add internal properties...
- What is the minimum size of the automorphism group of a simple directed graph having more...
- The birthday paradox says that the probability (chance) that two people in a room will have...
- #include <iostream> #include "lib.hpp" using namespace std; int main() { // declare the bool bool...
- Why do we compare means instead of individual scores? for comparing average SAT test scores across...
- NPV Your division is considering two projects with the following cash flows (in millions): 0...
- The equivalent synchronous impedance of a 25kVA, 400V three-phase Y-connected synchronous generator is 0.05 + j1.6...
ADVERTISEMENT