Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

Excel ROI Calculator

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Melissa - 22 May 2008 22:51 GMT
I need to get the formula to figure the years and months of return on an
investment
cost of investment  (g16)= 100000
Yearly income (k31) = 33480
Return on Investment =(g16/k31) for years
what is the formula to convert it into months?

thanks, melis
pdberger - 22 May 2008 23:17 GMT
Melissa --
First, a minor clarification.  I think you're computing the "breakeven
point" -- the time delay until your original investment is paid for.  The
"ROI" is an interest-rate calculation -- what interest rate are you
generating on your invested money.  That said, here's one approach:

            A             B
1      Orig. Cost   $100,000
2     Yrly Return   $33,480
3
4     Breakeven    =INT(B1/B2) & " years and " & INT(MOD(B1/B2,1)*12) & "
months"

The result reads "2 years and 11 months".

HTH

> I need to get the formula to figure the years and months of return on an
> investment
[quoted text clipped - 4 lines]
>
> thanks, melis
Fred Smith - 22 May 2008 23:24 GMT
Same as any other conversion from years to months: multiply by 12.

By the way, you are not calculating Return on Investment. You are
calculating the payback period (the time it takes to get your money back).

Regards,
Fred.

>I need to get the formula to figure the years and months of return on an
> investment
[quoted text clipped - 4 lines]
>
> thanks, melis
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.