finance   Micah is going to buy a rental house to begin building his real estate wealth. He is not sure how much to pay for the property because it needs work. He surveys the area and find that a home in good condition sells for $225,000 and rents are $1250 per month. He will spend the first year spending $35,000 on remodeling and receive no rent. In the second year he will begin collecting rent and will also install a new HVAC system for $18,000. He will sell the home in five years for the current full market value. Micah wants a 15% annual return on his money to take this risk and go to all the trouble. HOW MUCH SHOULD MICAH PAY FOR THE HOME? (Answer in dollars). (Hint: Use the following format in a financial calculator or Excel. Fill in the Cash Flows (CF). Cash Flow 0 (CF0) = 0. Use 0 because we do not know how much he should pay up front for the home. Stating CF0 may not be necessary in Excel. CF1= CF2= CF3= CF4= CF5= i= NPV=___________________

Personal Finance
13th Edition
ISBN:9781337669214
Author:GARMAN
Publisher:GARMAN
Chapter9: Obtaining Affordable Housing
Section: Chapter Questions
Problem 1DTM
icon
Related questions
Question

finance

 

Micah is going to buy a rental house to begin building his real estate wealth. He is not sure how much to pay for the property because it needs work. He surveys the area and find that a home in good condition sells for $225,000 and rents are $1250 per month. He will spend the first year spending $35,000 on remodeling and receive no rent. In the second year he will begin collecting rent and will also install a new HVAC system for $18,000. He will sell the home in five years for the current full market value. Micah wants a 15% annual return on his money to take this risk and go to all the trouble.

HOW MUCH SHOULD MICAH PAY FOR THE HOME? (Answer in dollars). (Hint: Use the following format in a financial calculator or Excel. Fill in the Cash Flows (CF). Cash Flow 0 (CF0) = 0. Use 0 because we do not know how much he should pay up front for the home. Stating CF0 may not be necessary in Excel. CF1= CF2= CF3= CF4= CF5= i= NPV=___________________

Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Emergency Fund
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Personal Finance
Personal Finance
Finance
ISBN:
9781337669214
Author:
GARMAN
Publisher:
Cengage
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
SWFT Corp Partner Estates Trusts
SWFT Corp Partner Estates Trusts
Accounting
ISBN:
9780357161548
Author:
Raabe
Publisher:
Cengage