Which one makes the biggest impact on irr

Assignment Help Accounting Basics

Reference no: EM132959739

Question: Along with the purchase price and estimated rental rates, please use the following assumptions for the purposes of your analysis:
· Closing costs = 1% of purchase price
· Interest Rate = 4%, 80% LTV, 30yr fully amortized
· Home Price Appreciation = 5%
· Annual Rent Increase = 4%
· Homeowners Insurance = $1,000/yr (increases 4% each year)
· Property Taxes = 1.2% of purchase price (increases 2% each year)
· Water, Sewer, Garbage = $80/mo (increases 5% each year)
· Annual Maintenance = $2,000 (increases 4% each year)
· Depreciation: Tax Life = 27.5 years
· Depreciation: Building = 80% of Total House Price
· Marginal Tax Bracket = 40%
· Capital Gains Tax Rate = 25%

A. Make sure your spreadsheet shows a First Year Operating Projection, 10 Year Operating Projection, Sales Analysis After 10 Years and Rate of Return Analysis After 10 Years

B. Once you have completed your spreadsheet and have found your IRR, play around with the variables for Appreciation, Annual Rent Increase and Interest Rate on the loan. Changing each of these variables up or down by 1%, which one makes the biggest impact on IRR?

Reference no: EM132959739

Questions Cloud

Discuss the role of amortization of mortgages in analysis : Imagine that a friend tells you that you should not rush. Discuss the role of amortization of mortgages in your analysis of the issue.

Describe two aspects of team performance : Describe two aspects of team performance that need to be monitored when reviewing progress towards meeting goals.

What is the growth rate for Dalton Inc : Dalton Inc. has a return on equity of 10.5 percent and retains 52 percent of its earnings for reinvestment purposes. What is the growth rate for Dalton? Inc

How new benefits will impact net pay : An organization, located in Manitoba, will be enhancing the group benefits plan offered to employees in two months by adding accidental death and dismemberment

Which one makes the biggest impact on irr : Variables for Appreciation, Annual Rent Increase and Interest Rate on the loan. Changing each of these variables up or down by 1%, which one makes the biggest

Addressing higher risk issues : What happens when the implementation of risks is affected by the cost or the affect of having "easy wins"? Could this time and money have been better spent addr

Compute mm current earnings and profits for the year : Compute MM's current earnings & profits for the year. MM Corp. is an accrual basis taxpayer. This year the business earned taxable income of $240,000.

What is the firms current weighted average cost of capital : What is the firms current weighted average cost of capital? Assume that management of Terek, which is very conservative, is condidering doing an equity-for-debt

What is marys taxable capital gains for 2020 : What is Marys taxable capital gains for 2020 and In early 2020, she received 10 stock dividends when the FMV was $30 per share. In late 2020, she sold 100

User Account

All Pages