| [Company
Name] |
|
|
List
data: |
Purchase |
| Operating Lease
vs. Own Analysis |
|
|
|
Financing |
| [Date] |
|
|
|
Cash |
| |
|
|
|
|
| Model
key |
|
|
|
|
| Bold numbers in
white cells are entered by
user. |
|
|
|
|
| Italicized
numbers in gray cells are calculations that
should not be altered. |
|
|
|
| Black numbers
in gray cells are calculations that can be
overwritten. |
|
|
|
| |
|
|
|
|
| General analysis
information |
|
|
|
|
| Decision date |
1/15/2006 |
|
|
|
|
|
|
|
|
| Tax
information |
|
|
|
|
| Assumed federal tax
rate |
35.00% |
|
|
|
| Assumed state or local
tax rate |
6.00% |
|
|
|
| Combined tax
rate |
38.90% |
|
|
|
| Number of
depreciable years (straight-line
method) |
7 |
|
|
|
|
|
|
|
|
| Purchase
information |
|
|
|
|
| Purchase
price |
$52,500 |
|
|
|
| Purchase with
cash or financing? |
Cash |
|
|
|
| Monthly payment if
financed |
N/A |
|
|
|
| Estimated annual
financing rate |
5.00% |
|
|
|
| Monthly borrowing
rate |
6.50% |
|
|
|
| Number of loan
months |
84 |
|
|
|
| Projected salvage value
percentage |
22.00% |
|
|
|
| Estimated asset
disposition costs |
$1,700 |
|
|
|
| Discount rate
(WACC) |
10.00% |
|
|
|
| . |
|
|
|
|
| Leasing
information |
|
|
|
|
| Monthly lease
payment |
$1,100 |
|
|
|
| Annual lease
payments |
$13,200 |
|
|
|
| |
|
|
|
|
| |
|
|
|
|
