Question

In: Finance

You rent out an apartment for 15 years, with rent starting at $500 per month and...

You rent out an apartment for 15 years, with rent starting at $500 per month and increasing 3% each year. Immediately after receiving rent payments you deposit the rent payment into an account with i(12) = .06. If there are no other deposits or withdrawals into this account then how much is in the account after the 15 year period?

Solutions

Expert Solution

Year 1

The beginning rent of the apartment was $500

The APR rate was given to be 6% yearly or 6/12 = 0.5% montlhy

Usinf FV of annuity payments we have year end balance of

FV annuity = PMT [(1+r)^n -1) /r ] = 500 [(1+0.005)^12 - 1 / 0.005

Year 1 ending balance = $6167.78

Year 2

The rent grows at a rate of 3% pa

so second year rent is 500*(1.03) = 515.0

FV annuity + FV of year 1 balace = 515 [(1+0.005)^12 - 1 / 0.005 + 6167.78(1+0.005)^12

= $12901.01

Year 3

The rent grows at a rate of 3% pa

so second year rent is 515*(1.03) = 530.45

FV annuity + FV of year 1 balace = 530.45 [(1+0.005)^12 - 1 / 0.005 + 12901.01(1+0.005)^12

= $20240.12

Year 4

The rent grows at a rate of 3% pa

so second year rent is 530.45*(1.03) = 546.36

FV annuity + FV of year 1 balace = 546.36 [(1+0.005)^12 - 1 / 0.005 + 20240.12(1+0.005)^12

= $28,228.18

and for upto 15 yeras we get the following table of balance

Rate 6% Year Ending Balance
Year Rent
1 500.00 $6,167.78 $6,167.78
2 515.00 $6,352.81 $12,901.01
3 530.45 $6,543.40 $20,240.12
4 546.36 $6,739.70 $28,228.18
5 562.75 $6,941.89 $36,911.13
6 579.64 $7,150.15 $46,337.87
7 597.03 $7,364.65 $56,560.55
8 614.94 $7,585.59 $67,634.67
9 633.39 $7,813.16 $79,619.39
10 652.39 $8,047.56 $92,577.69
11 671.96 $8,288.98 $1,06,576.67
12 692.12 $8,537.65 $1,21,687.73
13 712.88 $8,793.78 $1,37,986.95
14 734.27 $9,057.59 $1,55,555.28
15 756.29 $9,329.32 $1,74,478.91

Related Solutions

Five years ago, the average apartment rent in southwest Virginia was $895 per month. A recent...
Five years ago, the average apartment rent in southwest Virginia was $895 per month. A recent study of 180 randomly selected apartments found that the average rent was $915, with a standard deviation of $227.50. Do the data enable us to conclude that rents have increased? At the 98% degree of confidence, can it be concluded that the average rent has increased?
Five years ago, the average apartment rent in southwest Virginia was $895 per month. A recent...
Five years ago, the average apartment rent in southwest Virginia was $895 per month. A recent study of 180 randomly selected apartments found that the average rent was $915, with a standard deviation of $227.50. Do the data enable us to conclude that rents have increased? The computed test statistic
You have one apartment to lease, and the quoted rent is $750 per month. The lease...
You have one apartment to lease, and the quoted rent is $750 per month. The lease term is 12 months. A concession of one month’s free rent is being given in the market, and you are concerned about how this will affect property revenues if one month’s free rent is needed to seal the lease deal. What would the effective rent be for the year if no concession is granted? What would the effective rent be for the one-year term...
You are 21 years old today. Starting one month from now, if you deposit $500 per...
You are 21 years old today. Starting one month from now, if you deposit $500 per month for 32 years into your retirement account which earns 0.7 percent per month, are you a millionaire by age of 53? Find out how much money you will have by age of 53. If that number is greater than one million, then you are a millionaire by that age.
Location Square Footage Rent per Month Location Square Footage Rent per Month Queens 500 650 Nassau...
Location Square Footage Rent per Month Location Square Footage Rent per Month Queens 500 650 Nassau County 1100 1875 Queens 588 1215 Nassau County 588 1075 Queens 1000 2000 Nassau County 1250 1775 Queens 688 1655 Nassau County 556 1050 Queens 825 1250 Nassau County 825 1300 Queens 460 1805 Nassau County 743 1475 Queens 1259 2700 Nassau County 660 1315 Queens 650 1200 Nassau County 975 1400 Queens 560 1250 Nassau County 1429 1900 Queens 1073 2350 Nassau County...
I wish to show that the average apartment rent in Atlanta is over $1200 per month....
I wish to show that the average apartment rent in Atlanta is over $1200 per month. I took a simple random sample of 81 and found the sample mean was $1250 with a standard deviation of $36. Let alpha=.01 Critical value = _____ 1) 1.28 2) 12.5 3) 1.65 4) 2.33
Part1) Bob's Apartment Building has 100 units that rent for $1,110 per month each. What is...
Part1) Bob's Apartment Building has 100 units that rent for $1,110 per month each. What is the Gross Potential Income for Bob's Apartment Building? Part2) Bob's Apartment Building has gross potential income of $1,000,000. The expected vacancy rate is 13%. Collection losses are 5% (after allowing for vacancies). Incidental income is $50,000 per year. What is the Effective Gross Income for Bob's Apartment Building? Part3) Bob's Apartment Building has effective gross income of $500,000. Operating expenses are 38% of revenue....
A real estate office handles a 60-unit apartment complex. When the rent is $530 per month,...
A real estate office handles a 60-unit apartment complex. When the rent is $530 per month, all units are occupied. For each $25 increase in rent, however, an average of one unit becomes vacant. Each occupied unit requires an average of $30 per month for service and repairs. What rent should be charged to obtain a maximum profit?
You can pay $91 per month, starting next month, for the next 5 years to have...
You can pay $91 per month, starting next month, for the next 5 years to have a lawn mowing service. Alternatively, you can purchase a riding lawn mower and pay $506 today and mow your own lawn for 5 years, starting next month. If you decide to mow your own lawn, how much do you save in PV terms if your investments earn 3.31% APR, compounded monthly? Note: If you would lose money, make your answer with a negative sign...
A 100 unit apartment building is for sale. It rents for 500/unit per month. Operating expenses...
A 100 unit apartment building is for sale. It rents for 500/unit per month. Operating expenses for the building are 200,000 per year and property taxes are 10,000 a year. Lisa wants to buy it and thus needs to arrange a mortgage loan of 3,000,000 at j4 = 10% amortized over 25 years with monthly payments. The banker assessed the lending value of the property to be 4,000,000. The banker requires a minimum DCR of 1.15, (a) Does Lisa qualify...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT