The model calculates the NAL (or NPV) and IRR of the lease for both parties on the basis of relevant input data. The invoice price and lease rental payments must be the same for both parties, but the other input variables may be different for each party. The model also examines the differential profitability to the lessee between conventional and per procedure leases.
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.