Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

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

image text in transcribed

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.

Please do in Excel.

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 Malaysia 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 Malaysia

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The ISO 14000 EMS Audit Handbook

Authors: Greg Johnson

1st Edition

1574440691, 978-1574440690

More Books

Students explore these related Accounting questions

Question

What is an asset-backed public offering?

Answered: 3 weeks ago

Question

1. Identify three approaches to culture.

Answered: 3 weeks ago

Question

2. Define communication.

Answered: 3 weeks ago