In the worksheet there is data on company's leases in columns A to N. These are all
Question:
In the worksheet there is data on company's leases in columns A to N. These are all leases the company has entered into as a LESSEE. All of these leases are noncancelable.
Using the data on the characteristics of the leases provided, it is required to classify the leases for the company as either operating or finance leases.
The light blue columns (P,Q,R.S,U,W,X,Y,Z, AA,AC ) are suggested columns for you to use to insert formulas to enable you to classify the leases using the five lease criteria.
The goal is to use formulas (or other methods) to automate this lease classification process. This should be an automated and dynamic process. So, if some of the input data in columns B to N is changed, this would result in changes to the necessary calculations, lease classification criteria and the final lease type. It is not permissible to look up the values for columns P and Q in a present value table and type the values into those columns The more this lease classification process is automated, the better.
Intermediate Accounting principles and analysis
ISBN: 978-0471737933
2nd Edition
Authors: Terry d. Warfield, jerry j. weygandt, Donald e. kieso