Excel Magic Trick 988: What is Actual Return on my Art Investment from Antiques Roadshow?

2,697 views · Published 22 January 2013 · 3:42 · Indexed 22 September 2026

Channel: excelisfun · 2013 · Education

Watch on YouTube

How Much Did Art Investment Really Return?: Antiques Roadshow Calder Painting

Download Excel Start File:  https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT987-988.xlsx

Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm
From a recent Antiques Roadshow show about a Calder Painting we want to know what the investment return really is:
1. Formula: EndValue/BegValue^(EndYear-BeginYear)-1
2. RATE function

How Much Did Art Investment Really Return?
What is rate of return for antique on Antiques Roadshow?

More from this channel

• 3:51 YouTubersLoveExcel#19: Steady Growth Cash Flow Formula

  excelisfun

  3,557 views · 23 May 2008

• 8:18 YTLE#80: Conditional Format MATCH & INSUMBER functions

  excelisfun

  3,669 views · 4 August 2008

• 4:50 YTL Excel #123: Array Formula To Count E-mails

  excelisfun

  2,540 views · 11 September 2008

• 0:09 Kid Empties Bottle - Funny Waterfall

  excelisfun

  874 views · 6 August 2009

• 10:35 Mr Excel & excelisfun Trick 27: COUNT w More Than 1 Criteria 10 Examples!

  excelisfun

  4,827 views · 15 September 2009

• 5:37 Excel Magic Trick 413: Copied Web Site Data Trouble CLEAN TRIM Text To Columns

  excelisfun

  3,436 views · 14 October 2009

• 39:25 Excel 2010 Business Math 22: Adding & Subtracting Fractions Lest Common Denominator LCM Function

  excelisfun

  4,359 views · 9 October 2011

• 13:56 Excel 2010 Business Math 34: Begin Amount = (Amount of Change)/(Rate of Change)

  excelisfun

  2,623 views · 20 October 2011