Conflicted about which piece of equipment to buy? A colleague is considering a major capital expenditure, so I reworked an Excel spreadsheet I developed last year that compared Avid and Final Cut Pro systems to be more generic. I thought I’d post it here as well.

Input the price of each system, the percent you plan on financing, the finance rate, and your internal rate of return. Internal rate of return is your opportunity cost. If the capital to purchase this equipment were to be invested elsewhere, how much would you expect to make? Ten percent is a standard benchmark.

The spreadsheet uses a macro, so Excel will pop up a warning. Click through it and you are good to go.

Download here

 

3 Responses to Equipment purchase calculator

  1. Jason Kalawe says:

    Great stuff! I miss reading your articles in DV!

  2. Errin says:

    Wondering if you might have any advice why I can’t see this in excel (I can see excel opens it, and I’ve adjusted the macro security level… still can’t see it to use though) — LOOKS GREAT.

  3. Frank Capria says:

    It works on current versions of Excel for Mac and Windows. I’ve not tried it on other versions. It’s been out a while, and this is the first I’ve heard this issue.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

You must be logged in to post a
video comment.