• When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network.

Archived

This topic is now archived and is closed to further replies.

Walking Dead # 1 CGC 9.9 finally sells!!!

52 posts in this topic

I haven't finished my giant mug o' coffee.

 

What?

He realized a 166% increase in his investment, but when you do this in Excel and change the field to a %, Excel initially will experience an error and show 16,567%, which would mean he had to sell a book for $20K to achieve this.

 

Gotta love Microsoft solutions.

 

He actually received 166.66X his initial investment. I'm no statistician, but, that is not the same as a 166.66% increase.

You round up and 165.67% is 166%. $2,000 - $12/$12 = 165.67%

 

But you are right - you are no statistician (or basic math expert). :baiting:

Close, but no cigar. ROI = Net profit/Cost of asset sold

It is not expressed in terms of a percentage unless you convert it. Therefore, the answer is 165.67 but as a percentage it is 16567%. 165.67% of $12 would $19.88.

Link to comment
Share on other sites

I haven't finished my giant mug o' coffee.

 

What?

He realized a 166% increase in his investment, but when you do this in Excel and change the field to a %, Excel initially will experience an error and show 16,567%, which would mean he had to sell a book for $20K to achieve this.

 

Gotta love Microsoft solutions.

 

He actually received 166.66X his initial investment. I'm no statistician, but, that is not the same as a 166.66% increase.

You round up and 165.67% is 166%. $2,000 - $12/$12 = 165.67%

 

But you are right - you are no statistician (or basic math expert). :baiting:

Close, but no cigar. ROI = Net profit/Cost of asset sold

It is not expressed in terms of a percentage unless you convert it. Therefore, the answer is 165.67 but as a percentage it is 16567%. 165.67% of $12 would $19.88.

 

I am vindicated again. :acclaim:

Link to comment
Share on other sites

Close, but no cigar. ROI = Net profit/Cost of asset sold

It is not expressed in terms of a percentage unless you convert it. Therefore, the answer is 165.67 but as a percentage it is 16567%. 165.67% of $12 would $19.88.

doh!

 

You're right. What the heck was I thinking?

Link to comment
Share on other sites

Pwned_by_whale.jpg

TJ is ALWAYS right. When am I going to get that straight? :frustrated:

 

And the formula for Single-Period Arithmetic Return is Future - Investment/Investment = Yield.

 

So the Yield is 165.67 times investment made. Where I went wrong is then converting that to a %, which is okay, but then reported the Yield as the %.

Link to comment
Share on other sites