How do I solve this discounted cash flow analysis?

Saw? I’m confused. You only mentioned one saw, and that is the one used to make desks for the next 10 years. So, you use the one you have.

What am I missing, Jellies?

You total up the costs for each saw for ten years. Then discount the spending to current dollars to make the costs comparable. Then you see which is cheaper. The Kyrobi has much lower operating costs, but much higher initial cost. That’s why discounting into comparable dollars is necessary to see if the operational savings on the Kyrobi actually make that saw cheaper than the Delta. I assume you know the spreadsheet formula for discounting dollars?

Kyrobi and Delta are two different saws.

No, I don’t have the spreadsheet formula. :\

@Wundayatta, do I include the total acquisition costs for the 10 years?

Yes, the total costs. But you have to discount each year’s cost either forwards or backwards in order to make them even.

ok, thanks. I’ll try..

You have to work out the math on a spreadsheet. I did this for a living. Production accounting and auditing were my two favourite things to do. Some people do crossword puzzles to relax, I did bank account reconciliation.

Can we delete my answer? It was retarded!

@Dutchess_III You must appeal to the fluther Gods (aka Augustlan) for that.

:)