Hi,
I like to learn how to use Net Present Value calculation to compare two different projects. If you had worked on this, please help me. The following is an use-case.
Buying house
Cost of house (85,00,000)
1st year income -
second year 3,00,000
third year 3,00,000
second year 3,00,000
third year 3,00,000
second year 3,00,000
third year 3,00,000
second year 3,00,000
third year 3,00,000
second year 3,00,000
Sale 1,53,00,000
Loan Int Rate 9.50%
Return on other investments 7.50%
Regards,
Nirmal
Your little table doesn't make any sense, as you repeated the years a bunch of times, but this will show you how to do it.
http://www.propertymetrics.com/blog/...-npv-in-excel/
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks