Excel for Corporate Finance 3

What's inside

Excel for Corporate Finance 3: 11 courses, 220 hands-on lessons, with a full solutions appendix.

Learn by doing. Every lesson starts with a clear goal and a short explanation, shows the worksheet cell by cell, and gives you tasks to solve on your own computer in Excel, LibreOffice Calc or Google Sheets. When you are done, check your formulas against the solutions and hints in the appendix and correct your sheet.

• 11 complete courses, 220 lessons, 229 exam questions with answers
• Worksheets with row and column labels – easy to type in
• Tasks with exact solutions and hints in the appendix
• All figures are fictional practice data

Every course is also available as an interactive course on tabellab.com, where each cell is checked instantly.

Courses in this book

• Credit Spreads & CDS Basics: Hazard Rates, Spreads & Default Probabilities
• Insurance Ratemaking: Pure Premium, Loss Trends & Rate Indications
• Revenue-Based Financing & Venture Debt: Caps, Repayment Rates and True Cost
• Bank Loan Pricing: Funding Cost, Expected Loss, Capital & RAROC
• Green Bonds & Sustainable Finance: Use of Proceeds, Greenium & Impact Metrics
• Corporate Treasury: Cash Pooling, Intercompany Netting & Liquidity Forecasting
• Restructuring & Bankruptcy Math: Recovery Waterfalls, Absolute Priority & Plan Value
• Equipment Leasing & Finance: Lessor Yield, Residual Value & Lease-vs-Loan
• Municipal Bonds: Tax-Equivalent Yield, Credit & Call Risk
• Student Loan Repayment Math: Standard, Graduated & Income-Based Plans
• Bank Capital Ratios: Risk-Weighted Assets, CET1, Buffers & Leverage

Details

Format	PDF, US Letter (8.5 × 11 in)
Language	English
Pages	584
Series	The Tabellab Workbook, volume 3
Author	Babala Özdemir
Delivery	Instant download after payment