REVscene - Vancouver Automotive Forum


Welcome to the REVscene Automotive Forum forums.

Registration is Free!You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! The banners on the left side and below do not show for registered users!

If you have any problems with the registration process or your account login, please contact contact us.


Go Back   REVscene Automotive Forum > Vancouver LifeStyles (VLS) > The Business and Financial Forum

The Business and Financial Forum THIS SPACE OPEN FOR ADVERTISEMENT. YOU SHOULD BE ADVERTISING HERE!
Revscene Wall Street.
Consolidating debt? Good business tips? Buying stock? How's our economy doing? Discuss and share advice and tools on everyday banking, investing, wealth management and insurance.

Reply
 
Thread Tools
Old 09-04-2013, 06:20 PM   #1
MiX iT Up!
 
tiger_handheld's Avatar
 
Join Date: May 2006
Location: vancouver
Posts: 8,133
Thanked 2,066 Times in 865 Posts
Finance help - question about Internal Rate of Return

I'm trying to calculate IRR on a lease and i'm not getting the answer i'm expecting. Am I doing something wrong here?


details:
- lease payments of 5800 paid at beginning of each year
- 8 year lease term
- buy out option at end of lease term = residual value = 5500
- machine cost if purchasing is 33,800 from the dealer

cfo = -33800
cf1 to cf 7 = 5800
cf 8 = -300
IRR = -.08%

The IRR of -.08% does not sound right. see any obvious mistakes?
Advertisement
__________________

Sometimes we tend to be in despair when the person we love leaves us, but the truth is, it's not our loss, but theirs, for they left the only person who couldn't give up on them.


Make the effort and take the risk..

"Do what you feel in your heart to be right- for you'll be criticized anyway. You'll be damned if you do, and damned if you don't." - Eleanor Roosevelt
tiger_handheld is offline   Reply With Quote
Old 09-04-2013, 06:50 PM   #2
I contribute to threads in the offtopic forum
 
Join Date: Jun 2006
Location: not vancouver
Posts: 2,642
Thanked 1,941 Times in 765 Posts
8% - just use excel (=irr)

not sure what you did

make sure first number is negative, all other positive (outflow vs. inflow)

cf8 = 5500+5800, if i'm reading you right
4444 is offline   Reply With Quote
This post thanked by:
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -8. The time now is 03:12 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
SEO by vBSEO ©2011, Crawlability, Inc.
Revscene.net cannot be held accountable for the actions of its members nor does the opinions of the members represent that of Revscene.net