The model consists of a complete base case analysis–no changes need to be made to the existing MODEL-GENERATED DATA section. However, all values in the student version INPUT DATA section have been replaced with zeros. Thus, students must determine the appropriate input values and enter them into the model. These cells are colored red. When this is done, any error cells will be corrected and the base case solution will appear. Note that the model does not contain any risk analyses, so students will have to create their own if required by the case. Furthermore, students must create their own graphics (charts) as needed to present their results.
Both instructor and student versions contains a sheet (Figure 1) that plots lessee’s NAL, lessor’s NPV, and total contract value versus the size of the lease payment.