Question

You are thinking about renting out your condo rather than selling it. You can get $200,000...

You are thinking about renting out your condo rather than selling

it. You can get $200,000 if you sell your condo to an eager buyer

today, but only $100,000 if you wait to sell it. You expect to earn

$5,000 per month (including all expenses). The discount rate of

12%. What is the minimum number of months you need to rent it

out for this to be an acceptable investment?

Please show your work, thank you!

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Minimum no of installments will be required in such manner that PV will be 200,000
Assumed there are N monthly installments
Monthly Interst rate= 1%
PV of annuity for making pthly payment
P = PMT x (((1-(1 + r) ^- n)) / i)
Where:
P = the present value of an annuity stream
PMT = the dollar amount of each annuity payment
r = the effective interest rate (also known as the discount rate)
i=nominal Interest rate
n = the number of periods in which payments will be made
Present value =5000*(((1-(1 + 1%) ^-N)) / 1%)
Present value =5,00,000*(((1-(1.01) ^-N))
Present value =5,00,000-500000*(1.01) ^-N))
PV of sale price =100000/(1+1%)^N
Total should be atleast 200000
200000 =5,00,000-500000*(1.01) ^-N)) + 100000/(1.01)^N
-300000 =-500000*(1.01) ^-N)) + 100000/(1.01)^N
-300000 =-400000/(1.01)^N
300000 =400000/(1.01)^N
(1.01)^N =400000/300000
(1.01)^N 1.333333333
N Log 1.01= Log 1.333
N Log 1.01= Log 1.333
N *0.00432137= 0.12493874
N =0.12493874/0.00432137
N =                           29
So minimum 29 installment should be there to make sure that there is no loss
Add a comment
Know the answer?
Add Answer to:
You are thinking about renting out your condo rather than selling it. You can get $200,000...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Do calculations in excel and show work. You are thinking about buying an investment property in...

    Do calculations in excel and show work. You are thinking about buying an investment property in San Jose for $150,000 today. You expect to earn $10,000 per year of net rental income (after costs, such as property tax, HOA and maintenance, etc.) on the property and you expect to sell it in 5 years for $200,000. If the annual discount rate is 8%, is this investment attractive to you? (a) What is the net present value of this investment? Is...

  • You are thinking about buying a rental property. Because of the difficulty getting a loan, you...

    You are thinking about buying a rental property. Because of the difficulty getting a loan, you are going to pay $350,000 in cash for the house today. You think you can rent out the property for the next 10 years, receiving $1,400 in cash each month after your expenses and taxes, starting a month from today. At the end of ten years, you believe you will be able to sell the property for $425,000. If your discount rate is 7.2%...

  • You and your friends are thinking about starting a motorcycle company named Apple Valley Choppers. Your...

    You and your friends are thinking about starting a motorcycle company named Apple Valley Choppers. Your initial investment would be $500,000 for depreciable equipment, which should last 5 years, and your tax rate would be 40%. You could sell a chopper for $10,000, assuming your average variable cost per chopper is $3000, and assuming fixed costs, such as rent, utilities and salaries, would be $200,000 per year. Financial breakeven: How many choppers would you have to sell to break even,...

  • hework 2 work . Due in 10 hours 0 8/10 answered Question 8 Homework Unanswered You...

    hework 2 work . Due in 10 hours 0 8/10 answered Question 8 Homework Unanswered You are interested in buying a house and renting it out. You expect to receive a monthly net income of $2000 from rent. You then expect to sell the house for $250,000 at the end of 70 months. If your discount rate on this investment is 5% (compounded monthly), how much is this property worth to you today? Assume that you receive rent at the...

  • Step 1 Read the scenario. Assume you are thinking about starting a business and would like to forecast your cash needs f...

    Step 1 Read the scenario. Assume you are thinking about starting a business and would like to forecast your cash needs for the next six months. You expect sales to be approximately $30,000 per month for the first 12 months and your purchases to support sales will be approximately 60% of sales. You anticipate about 20% of your sales will be cash and 80% collected the following month. Your supplier has agreed to extend credit for 70 days at no...

  • You are thinking of renovating a basement apartment beneath your house, which you currently rent out...

    You are thinking of renovating a basement apartment beneath your house, which you currently rent out for $529 per month. If you renovate the apartment, you could get $721 per month instead, starting next month. Assume renovations would cost $10,000, paid immediately, and would take very little time to complete so there’d be no delay in rental income. Assume monthly rental income would last for the foreseeable future (aka forever). If the applicable discount rate is 5% per year, what...

  • please show all steps The house you like costs $200,000. You expect home values to increase...

    please show all steps The house you like costs $200,000. You expect home values to increase by 10% every year. Property taxes: 2% of house value, due at the end of each year. In other words, the property taxes due at the end of year 1 are based on the house value in year o.) Maintenance: $1,000 per year. You would take a home mortgage loan with an LTV of 80%. Loan information: 30-year term, fully amortizing with fixed annual...

  • 1. You have $200 to invest. If you put the money into an account earning 4​%...

    1. You have $200 to invest. If you put the money into an account earning 4​% interest compounded​ annually, how much money will you have in 10 years? How much money will you have in 10 years if the account pays 4​% simple​ interest? 2. You have $1,300 to invest today at 5​% interest compounded annually. a.  Find how much you will have accumulated in the account at the end of​ (1) 6 ​            years, (2) 12 years, and​ (3)...

  • Please show work, thank you "I'm not sure we should lay out $310,000 for that automated...

    Please show work, thank you "I'm not sure we should lay out $310,000 for that automated welding machine," said Jim Alder, president of the Superior Equipment Company. "That's a lot of money, and it would cost us another $50,400 per year just to maintain the thing. In addition, the manufacturer admits it would cost $49,000 more at the end of three years to replace worn-out parts." $86,000 for software and installation, and "I admit it's a lot of money," said...

  • Your friend Sue has asked you to help her out as she is developing her financial plan. Help her come up with a plan for...

    Your friend Sue has asked you to help her out as she is developing her financial plan. Help her come up with a plan for her finances and how she can set herself up for financial success! She has an after tax income of $48,000 and budgets $30,000 for necessary expenses. This leaves $18,000 to spend on debt and savings annually. (Assume all annuity payments are in the form of ordinary annuities.) Part A: Debt Sue has a current balance...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT