1. Perform a credit analysis of the company calculating all relent ratios show the data and your calculation using an excel spreadsheet.
2. Estimate future financing requirement based on company currently ordered aircraft once again show calculation. Both airbus and boeing publish arcraft prices on their web.
3. Prepare a single lender loan proposal and amortization schedule using the spreadsheet worked In class
a. bonus - Create a structured financing with sell down structure justifying the size and pricing of each tranche.
Book : airline finance dr morel , peter s.
Attachment:- Assignment.rar