. A property is forecasted to generate annual rental income of $80,000 in year 1. Vacancy...

. A property is forecasted to generate annual rental income of $80,000 in year 1. Vacancy rate is expected to be 5%, there is also a 5% management fee. Other operating expenses will total $17,500 for year 1. Rent is expected to grow at 5% in years 2 and 3, and other operating expenses are expected to grow at 6% in years 2 and 3. You believe that you can sell the property at the end of year 3 for $900,000. Using a required rate of return of 10%, calculate a fair value of the property today (at t=0). (Show all work.)

a. Assuming a purchase price for the property of $800,000, and an 80 LTV, 5.75%, fixed-rate 25-year loan, calculate the debt service coverage ratio based only on the year 1 NOI.

Solutions

Expert Solution

The estimated market value of the property is $817,743.80

The same with Excel Formulas shown:

The debt service coverage ratio is 1.48

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

A property is forecasted to generate annual rental income of $110,000 in year Vacancy rate is...

A property is forecasted to generate annual rental income of $110,000 in year Vacancy rate is expected to be 5%, there is also a 5% management fee. Other operating expenses will total $19,000 for year 1. Rent is expected to grow at 8% in years 2 and 3, and other operating expenses are expected to grow at 5% in years 2 and 3. You believe that you can sell the property at the end of year 3 for $1,220,000. Using...

Suppose that annual income from a rental property is expected to start at $1330 per year...

Suppose that annual income from a rental property is expected to start at $1330 per year and decrease at a uniform amount of $70 each year after the first year for the 16 year expected life of the property. The investment cost is $6900 and i is %10 per year. What is the present equivalent of the rental income? Assume that the investment occurs at time zero (now) and that the annual income is first received at the end of...

Suppose that annual income from a rental property is expected to start at $1800 per year...

Suppose that annual income from a rental property is expected to start at $1800 per year and decrease at a uniform amount of $73 each year after the first year for the 13 year expected life of the property. The investment cost is $8800 and i is %11 per year. What is the present equivalent of the rental income? Assume that the investment occurs at time zero (now) and that the annual income is first received at the end of...

An income property has 8 rental units. Each unit has a year 1 monthly rent of...

An income property has 8 rental units. Each unit has a year 1 monthly rent of $850. The annual operating expenses for the property in year 1 are as follows: Utilities: $3,200 Insurance: $4,500 Repairs and maintenance: $5,500 Trash removal: $2,500 Water: $2,200 Reserves: $5,000 In addition, there is a 6% management fee, and an estimated vacancy rate of 4%. The asking price for this property is $825,000, and you can obtain a 75 LTV loan with a fixed rate...

1. What is Schedule E depreciation (Rental property)? 2. What is Schedule E net income (Rental...

1. What is Schedule E depreciation (Rental property)? 2. What is Schedule E net income (Rental income & Sub-S income)? Paul Turner is single and has two children, Allen and Lee Ann, from his previous marriage. Allen lives with Paul and Paul provides more than half of his support. In the current year, Allen earned $300 of interest income and $5,000 working at a fast-food restaurant. Allen graduated from high-school in December 2017 and was not a registered student during...

1) Rental Income (T776) Dax Jones purchased a new property on May 1st 2019 with the...

1) Rental Income (T776) Dax Jones purchased a new property on May 1st 2019 with the intent to use it as a rental. The purchase price was $650,000. The land portion was valued at $50,000. He began advertising to find his first tenant right away. The following additional information was provided to you by Dax who has asked you to prepare his T776 form for 2019: The first tenant moved in on June 1st and is paying $800 per month...

We are considering investing in a house that will cost $460,000 and generate weekly rental income...

We are considering investing in a house that will cost $460,000 and generate weekly rental income of $440. Calculate the value of our investment ftve years from today, assuming that we fund our investment using a $150,000 cash down payment and a five-year interest-only loan for the balance. This loan incurs interest of 6.1% per annum. We deposit all excess cash in a bank account that earns interest of 2.4% per annum compounded monthly. Make the following additional assumptions, which...

On June 1 of the current year, Chad Wilson established a business to manage rental property....

On June 1 of the current year, Chad Wilson established a business to manage rental property. He completed the following transactions during June: Opened a business bank account with a deposit of $48,000 from personal funds. Purchased office supplies on account, $2,080. Received cash from fees earned for managing rental property, $5,770. Paid rent on office and equipment for the month, $2,550. Paid creditors on account, $950. Billed customers for fees earned for managing rental property, $4,730. Paid automobile expenses...

On June 1 of the current year, Pamela Schatz established a business to manage rental property....

On June 1 of the current year, Pamela Schatz established a business to manage rental property. She completed the following transactions during June: a. Opened a business bank account with a deposit of $55,000 from personal funds. b. Purchased office supplies on account, $3,300. c. Received cash from fees earned for managing rental property, $18,300. d. Paid rent on office and equipment for the month, $8,300. e. Paid creditors on account, $2,290. f. Billed customers for fees earned for managing...

On June 1 of the current year, Chad Wilson established a business to manage rental property....

On June 1 of the current year, Chad Wilson established a business to manage rental property. He completed the following transactions during June: Required: 1. Indicate the effect of each transaction and the balances after each transaction: For those boxes in which no entry is required, leave the box blank. For those boxes in which you must enter subtractive or negative numbers use a minus sign. (Example: -300) Opened a business bank account with a deposit of $28,000 from personal...

Subjects