PROTECTED VIEW Be careful$-$files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.

Enable Editing

A

$B$

C

D

E

F

G

$H$

I

An investment with the following cash flows is considered.

What is the payback period?

How might the magnitude of the final cash flow effect the payback period?

Given:

$\backslash$table$[[$Year$,$Invstmt $($beg yr$),$Inflow $($end yr$)],[1,15000,1000],[2,8000,2000],[3,,2500],[4,,4000],[5,,5000],[6,,6000],[7,,5000],[8,,4000],[9,,3000],[10,,2000]]$

Payback Period:

$($yrs$)$