Fig5-12 - 4 $65,795 0.0 3 4 $46,443 5 $67,111 1 0.0 3 5...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Leasing Analysis Page 1 Assumptions Annual increase in leasing cost 2.0% Trade-in value after 1 year 30.0% Trade-in value after 2 years 10.0% Model Lease Select From To Cost Year Cost Net Flow Supply/Demand 0.0 1 2 $44,640 1 $62,000 0 -1 0.0 1 3 $58,305 2 $63,240 0 0 0.0 2 3 $45,533 3 $64,505 0 0 0.0 2 4 $59,471
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 4 $65,795 0.0 3 4 $46,443 5 $67,111 1 0.0 3 5 $60,660 0.0 4 5 $47,372 Total Cost $0 6% 60% 15% $64,394 2% 30 10 61401 Compu-Train Minimize: E19 By changing: B11:B17 Subject to: I11:I15=J11:J15 B11:B17>=0...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online