Use this information to analyze weather it is better to own or rent the property with the following financing and rent options. Create an Excel Model to analyze the trade-offs. Property info Purchase price $1,000,000 Buying transaction fees: 15% of purchase price Initial rent: $85000/yr Rental growth rate: 5% Property appreciation rate: 6% Insurance: $4000/yr Maintenance: $4000/yr Expense growth: 3.5% Transaction fees for future sale: 12% of sale price Marginal tax rate: 30% Property tax: 2.0% of current property appraised value LTV: 80% Interest rate: 7% Loan Term: 30 yr Loan type: Annual pay CPM fully amortizing Tax exclusions: First $500,000 of gain on sale
Use this information to analyze weather it is better to own or rent the property with the following financing and rent options. Create an Excel Model to analyze the trade-offs. Property info Purchase price $1,000,000 Buying transaction fees: 15% of purchase price Initial rent: $85000/yr Rental growth rate: 5% Property appreciation rate: 6% Insurance: $4000/yr Maintenance: $4000/yr Expense growth: 3.5% Transaction fees for future sale: 12% of sale price Marginal tax rate: 30% Property tax: 2.0% of current property appraised value LTV: 80% Interest rate: 7% Loan Term: 30 yr Loan type: Annual pay CPM fully amortizing Tax exclusions: First $500,000 of gain on sale
Chapter16: Real Estate And High-risk Investments
Section: Chapter Questions
Problem 1FPC
Related questions
Question
Please give Step by Step Answer
Otherwise i give DISLIKE !!
![Use this information to analyze weather it is better to own or rent the property with the following financing and rent options. Create an Excel Model to analyze the trade-offs. Property info
Purchase price $1,000,000 Buying transaction fees: 15% of purchase price Initial rent: $85000/yr Rental growth rate: 5% Property appreciation rate: 6% Insurance: $4000/yr Maintenance: $4000/yr
Expense growth: 3.5% Transaction fees for future sale: 12% of sale price Marginal tax rate: 30% Property tax: 2.0% of current property appraised value LTV: 80% Interest rate: 7% Loan Term: 30 yr
Loan type: Annual pay CPM fully amortizing Tax exclusions: First $500,000 of gain on sale](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F02ab8ffd-4b8a-4040-9acc-e7b590703dae%2Fe890ff13-d276-452d-a325-49f699d62f82%2Fig8hnv_processed.png&w=3840&q=75)
Transcribed Image Text:Use this information to analyze weather it is better to own or rent the property with the following financing and rent options. Create an Excel Model to analyze the trade-offs. Property info
Purchase price $1,000,000 Buying transaction fees: 15% of purchase price Initial rent: $85000/yr Rental growth rate: 5% Property appreciation rate: 6% Insurance: $4000/yr Maintenance: $4000/yr
Expense growth: 3.5% Transaction fees for future sale: 12% of sale price Marginal tax rate: 30% Property tax: 2.0% of current property appraised value LTV: 80% Interest rate: 7% Loan Term: 30 yr
Loan type: Annual pay CPM fully amortizing Tax exclusions: First $500,000 of gain on sale
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Intermediate Financial Management (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781337395083/9781337395083_smallCoverImage.gif)
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
![Pfin (with Mindtap, 1 Term Printed Access Card) (…](https://www.bartleby.com/isbn_cover_images/9780357033609/9780357033609_smallCoverImage.jpg)
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
![Intermediate Financial Management (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781337395083/9781337395083_smallCoverImage.gif)
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
![Pfin (with Mindtap, 1 Term Printed Access Card) (…](https://www.bartleby.com/isbn_cover_images/9780357033609/9780357033609_smallCoverImage.jpg)
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning