Question

In: Finance

You are interested in buying a house and renting it out. You expect to receive a...

You are interested in buying a house and renting it out. You expect to receive a monthly net income of $1,500 from rent. You then expect to sell the house for $300,000 at the end of 60 months. If your discount rate on this investment is 0.8% per month, what is this property worth to you today? Assume that you receive rent at the beginning of each month and you receive the first rent the same day you purchase the property. Round to the nearest cent. ​[Hint: Notice that the interest rate provided is monthy, so this is i/m. Also, 60 months is nxm.]

Solutions

Expert Solution

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

As nothing was mentioned excel is used. If you need with FINANCIAL formula, let me know, will do that also. Thank you.


Related Solutions

You are interested in buying a house and renting it out. You expect to receive a...
You are interested in buying a house and renting it out. You expect to receive a monthly net income of $1450 from rent. You then expect to sell the house for $329,000 at the end of 54 months. If your discount rate on this investment is 9% per year (compounded monthly), how much is this property worth to you today? Assume that you receive rent at the beginning of each month and you receive the first rent the same day...
You are interested in buying a house and renting it out. You expect to receive a...
You are interested in buying a house and renting it out. You expect to receive a monthly net income of $1,184 from rent. You then expect to sell the house for $320,000 at the end of 54 months. If your discount rate on this investment is 6.5% per year (compounded monthly), how much is this property worth to you today? Assume that you receive rent at the beginning of each month and you receive the first rent the same day...
You are interested in buying a house and renting it out. You expect to receive a...
You are interested in buying a house and renting it out. You expect to receive a monthly net income of $1000 from rent. You then expect to sell the house for $390,000 at the end of 42 months. If your discount rate on this investment is 1.1% per month, what is this property worth to you today? Assume that you receive rent at the beginning of each month and you receive the first rent the same day you purchase the...
Describe the advantages and disadvantages of renting housing vs buying a house.
Describe the advantages and disadvantages of renting housing vs buying a house.
You are making a buying-vs-renting decision. You have the following information: The house you like costs...
You are making a buying-vs-renting decision. You have the following information: The house you like costs $300,000. You expect home values to increase by 3% 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 0.) Maintenance: $1,000 per year. You would take a home mortgage loan with an LTV of 80%. Loan information:...
You are making a buying-vs-renting decision. You have the following information: The house you like costs...
You are making a buying-vs-renting decision. You have the following information: The house you like costs $300,000. You expect home values to increase by 3% 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 0.) Maintenance: $1,000 per year. You would take a home mortgage loan with an LTV of 80%. Loan information:...
You are interested in buying a brand new Jalopy and expect the purchase price to be...
You are interested in buying a brand new Jalopy and expect the purchase price to be $19,000. The car dealership can offer financing at a 6% interest rate over 6 years. If you put $1,000 down towards the purchase and accept the financing terms,what will your monthly payment for the loan be? Please Show the excel formula
"Party Sea" is considering a new business idea: buying and then renting out sailing catamarans to...
"Party Sea" is considering a new business idea: buying and then renting out sailing catamarans to rich customers. The company estimates that it will cost $32,000,000 to buy brand-new sailing catamarans. The estimated operating cash flow will equal $4,000,000 per year. At the end of Year 3 this catamaran project will be over, at which time all used catamarans will be sold at the after-tax salvage value of $10,000,000. The company also plans to immediately set aside $58,000 in cash...
Suppose you are buying a house and have taken out a mortgage for $250,000. The mortgage...
Suppose you are buying a house and have taken out a mortgage for $250,000. The mortgage is a 30 year fixed rate mortgage with an APR of 5.25%. What is your monthly mortgage payment? Construct a loan amortization table in Excel for mortgage loan in the previous problem. You should do the problem in Excel using monthly payments and you must submit the spreadsheet with formulas.
Assume you are preparing to move into a new neighborhood. You are considering renting or buying....
Assume you are preparing to move into a new neighborhood. You are considering renting or buying. Here are the information for the renting and buying option.Renting OptionYou are expected to pay $500 per month for the first year, and rent will increase by $50 per month per year for the next 15 years (e.g., $550 per month for the 2nd year, $600 per month for the 3rd year, etc.). Prepare a schedule showing rent payments for the next 15 years....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT