Transcription
Sale/Leaseback in ABCWarren & Selbert’s Sale/Leaseback model1
What is ABC? Equipment finance modeling software Used for optimizing and pricing Leveraged Leases Sale/Leasebacks Lease Pass-Throughs Partnership flips Sale/Leaseback Sale/Leaseback model built on ABC Commonly used in renewable energyfinance and project finance2
Sale/Leaseback Uses Structure solar andwind sale/leasebacktransactions FAS 13 reports Lease portfolios Evaluate Lessee andLessor cash and taxflows3
Sale/Leaseback WorkflowInputassumptionsRunto evaluate inputsOutputreports to show results4
InputCash and Tax Sections Input project flows Purchases Depreciation Loans Revenues Expenses Fees Paste amounts from Excel5
InputAssumptions Sections Input Solar/Wind Assumptions Project Term Prepayment Limit Input General Lease Assumptions Lease Term Periodicity6
InputEBITDA Section Add and manage project EBITDA Set each EBITDA’s: Amounts Dates Rent Coverage Debt Coverage7
InputLessee Assumptions Model the cash and tax flowsfor the lessee Calculate/Target IRR for thelessee Specify lessee optimizationobjective (e.g., do opt/maxcost)8
Input467 Loan Structure ABC models a 467 LoanStructure Tracks the cumulativedifference between cashrent and allocated rent Proof report of allocatedrent and interest9
RunOptimization Run ABC using linear optimization Choose an Objective such as: Min PV Min Cash Rent Max Yield CALC Expression (Custom Objective – e.g., Min Prepayment) Input Constraints in order to Maintain coverage ratios Limit the prepayment Meet lessee requirements10
OutputReports ABC offers a number of reports including: Yield Proof Cash Detail Tax Detail FAS 13 Accounting Termination Values Create custom reports View reports within ABC Save reports as an Excel or PDF file11
OutputReport SamplesFAS 13 Accounting ReportCash Detail Report12
Technical Details and Support ABC runs on Warren & Selbert’sservers in Santa Barbara Connect using LINK software Secure connection Comprehensive, swift, unmeteredsupport Experienced and knowledgeablestaff13
Thank YouFor any questions or comments, please do not hesitate to contact usPhone: (805) 963-0776Email: support@warren-selbert.comWebsite: http://www.warren-selbert.com/14
Equipment finance modeling software Used for optimizing and pricing Leveraged Leases Sale/Leasebacks Lease Pass-Throughs Partnership flips Sale/Leaseback Sale/Leaseback model built on ABC Commonly used in renewable energy finance and project finance