Accounting / Finance

9.45am – 11.30am Fixed Asset Accounting (i.e. aircraft for this industry)
• Acquisition accounting (fair value, business combination)
• Lease accounting (operating versus finance leases)
• Discussions around depreciation profiles, useful economic lives, residual values
• Discussions on aircraft appraisals (diversity, application, pros and cons)
• Other issues to consider (maintenance accounting policy and how that interfaces with assets values)
• Diversity of treatment (overview and discussion of asset accounting by public and other lessors)

11.30-11.45 Coffee break

11.45 – 1.30pm Impairment
• Brief overview of IFRS impairment provisions
• General approach to impairment by lessors (frequency of testing, initial assessment (Step 1), detailed cash flow testing (Step 2 if necessary))
• Discussion on most significant issues and their implications (e.g. market / aircraft / transaction related issues, use and application of appraisals, estimating cash flows, discount rates, maintenance cash flows)
• Brief discussion on IFRS v US GAAP and the implications
• Overview and discussion of recent impairments in the sector

1.30 – 2.30pm Lunch

2.30 – 4.00pm Maintenance Accounting
• Background to maintenance reserves (what are they, why we need them, touch on dynamics of negotiation, pricing, credit related, economic benefit)
• Genesis of maintenance accounting (e.g. airline guide, different potential accounting treatments, US GAAP v IFRS, application in the current market across the lessor community)
• Issues when considering maintenance accounting policies (pros and cons, revenue recognition, income statement comparison, overall asset / balance sheet values (link with asset accounting and impairment), tracking asset or lease lives, anomalies (e.g. income bump on default), lessor contributions)
• Overview and discussion of treatment within the sector

4.00- 4.15pm Coffee

4.15-5.00pm Proposed Lease Accounting changes
• Summary of why potential changes arose and the current status and timing of the project
• Broad based discussion around the likely lessor accounting implications (income statement and balance sheet implications, transition accounting, impairment implications, financial assets etc)

5.00-5.30pm Q&A / Wrap-up
Other potential topics that may be of interest
• Running a successful aircraft leasing Finance department
• Improving how Finance support the Board / Audit Committee / Business (frequency, consistency, charters, information preparation and timing, improving management packs and other key information, metric reporting and assessment)
• The internal control environment (rolling out, improving, documenting, adhering to a right-sized control environment and the benefits thereof)
• Key metric analysis (consideration of pricing, financial and operational metrics, the understanding, assessment and reporting of same (pros / cons)
• Peer group reviews

Lesson 2:
• Customizing Tables and Charts
• Sort Table Data
• Control Cell Layout
• Perform Calculations in a Table
• Create Charts

Lesson 3:
• Creating Customized Formats with Styles and Themes
• Create or Modify a Text Style
• Create a Custom List or Table Style
• Apply Default and Customized Document Themes

Lesson 4:
• Modifying Pictures
• Resize a Picture
• Adjust the Picture Appearance Settings
• Wrap Text Around a Picture
• Insert and Format Screenshots in a Document

Lesson 5:
• Creating Customized Graphic Elements
• Create Text Boxes and Pull Quotes
• Draw Shapes
• Add WordArt and Other Special Effects to Text
• Create Complex Illustrations with SmartArt

Lesson 6:
• Inserting Content Using Quick Parts
• Insert Building Blocks
• Create Building Blocks
• Modify Building Blocks
• Insert Fields Using Quick Parts

Lesson 7:
• Controlling Text Flow
• Control Paragraph Flow
• Insert Section Breaks
• Insert Columns
• Link Text Boxes to Control Text Flow

Lesson 8:
• Using Templates to Automate Document Creation
• Create a Document Based on a Template
• Create a Template

Lesson 9:
• Automating the Mail Merge
• Use the Mail Merge Feature
• Merge Envelopes and Labels
• Create a Data Source Using Word

Lesson 10:
• Using Macros to Automate Tasks
• Automate Tasks Using Macros , Create a Macro

Lesson 2:
• Organising Worksheet and Table Data
• Create and Modify Tables
• Format Tables
• Sort or Filter Worksheet or Table Data
• Use Functions to Calculate Data in a Table or Worksheet

Lesson 3:
• Presenting Data Using Charts
• Create a Chart
• Modify Charts
• Format Charts

Lesson 4:
• Analysing Data Using PivotTables, Slicers, and PivotCharts
• Create a PivotTable Report
• Filter Data Using Slicers
• Analyse Data Using PivotCharts

Lesson 5:
• Inserting Graphic Objects
• Insert and Modify Pictures and ClipArt
• Draw and Modify Shapes
• Illustrate Workflow Using SmartArt Graphics
• Layer and Group Graphic Objects

Lesson 6:
• Customising and Enhancing Workbooks and the Excel Environment
• Customise the Excel Environment
• Customise Workbooks
• Manage Themes
• Create and Use Templates