Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am thinking about buying a rental property in Southern California. The purchase price of the house is $ 5 0 0 , 0 0

I am thinking about buying a rental property in Southern California. The purchase price of the house is $500,000. I will put a 20% down payment and finance the rest, 80% with a 30-year loan and 6.5% interest rate. The closing cost for the loan will be $12,000. After I purchase the house, I will rent it out for $4,500 a month. However, I need to consider the property tax, insurance, and maintenance, together it is estimated to be $1500 a month. If I believe I can sell the house for $800,000 after 30 years, what are my NPV and IRR for this investment?
Initial outlay = CF0=(-500,000*20%)+(-12,000)=-112,000
Monthly mortgage payment: PV =500,000*.8=400,000, N =30*12=360, I/Y =6.5/12, FV =0=> PMT =-2,523.01
Monthly net cash flow =4,500-15002,523.01=476.99
At the end of the 30 years, sell the house and get $800,000
My total cash flows:
CF0=-112,000
C01=476.99
F01=360
C02=800,000
F02=1
I =6.5/12=> NPV =?
IRR =?(monthly)*12=?%(annually)
What is the IRR? and the NPV?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions

Question

What are the components of an ANOV table?

Answered: 1 week ago

Question

Which of the sources is most cost effective?

Answered: 1 week ago