Question
Please calculate and include in the portfolio table 1/ the average lease rate factor of the portfolio*, 2/ the average age of the portfolio and
Please calculate and include in the portfolio table 1/ the average lease rate factor of the portfolio*, 2/ the average age of the portfolio and 3/ the average remaining lease term of the portfolio**. Please use the Appraisal Value of the aircraft to weight the calculations. Please show methodology for how appraisal value of the aircraft is weighted. This part is important.
* The Lease Rate Factor is defined as = Monthly Rent of the railcar /aircraft / Appraised Value of the railcar/aircraft, expressed in % with 2 decimals. ** The Remaining Lease Term of a railcar/ aircraft is defined as = Lease Expiry Date Todays date, expressed in years with 2 decimals.
Today's Date Portfolio 8/13/20 Nb 1 2 3 4 Country US Germany Colombia UK France US US Mexico Mexico 5 6 7 8 9 Aicraft Type Airbus A319-100 Airbus A319-100 Boeing B737MAX8 Airbus A319-100 Airbus A320-200 Airbus A320NEO Airbus A321-200 Airbus A320-200 Airbus A320-200 Airbus A320NEO Airbus A320NEO Airbus A320-200 Airbus A320-200 Boeing B737MAX8 Boeing B737-800 Boeing B737-800 Boeing B737MAX8 Boeing B737-800 Boeing B737-900ER Boeing B737-900ER 10 11 12 Japan Date of Manufacture Aircraft Age (years) 10/22/08 11.980556 11/26/08 11.88333 4/7/17 3.400000 5/12/10 10.406 8/25/11 9.100000 9/29/18 1.90000 12/15/11 8.788889 6/27/12 8.2472 7/10/12 8.211111 6/15/17 3.2 11/15/16 3.797222 1/31/14 6.63 1/31/14 6.627778 3/31/19 1.391667 6/8/11 9 4/15/12 8.5 10/17/18 1.850000 2/22/11 9.611 5/30/13 7.31111 2/28/12 8.58 Avge Age: Monthly Rent($ million) 0.315000 0.26000 0.450000 0.250 0.325000 0.38500 0.395000 0.3150 0.315000 0.4 0.365000 0.33 0.350000 0.415000 0 0.3 0.400000 0.275 0.35000 0.38 Avge LRF: Lease Expiry 10/22/22 6/28/22 4/6/20 11/17/25 8/25/22 9/29/23 12/15/23 6/15/23 7/15/24 6/30/21 11/30/21 6/30/22 6/30/22 3/30/22 6/7/23 4/15/22 10/17/21 2/21/21 5/31/23 2/29/24 Remaining Lease Term (years) 2.222222 1.90000 -0.358333 5.339 2.061111 3.17222 3.386111 2.8778 3.977778 0.9 1.316667 1.91 1.905556 1.650000 3 1.7 1.194444 0.533 2.83611 3.60 Avge Rem Lease Term: Appraisal Value($ million) 23.800000 23.80000 50.50000 27.500 35.800000 50.50000 42.900000 38.3000 38.300000 49.5 48.800000 43.50 43.500000 51.200000 39 41.2 51.000000 38.700 43.80000 41.20 13 14 15 16 17 18 19 20 Colombia Hungary Hungary US Germany UK Indonesia Norway Brazil MalaysiaStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started