Excel for Corporate Finance 5

What's inside

Excel for Corporate Finance 5: 13 courses, 260 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.

• 13 complete courses, 260 lessons, 260 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 Scorecards: Weight of Evidence, Information Value & Points Scaling
• Variance Bridges for FP&A: Price, Volume, Mix, FX & Cost Effects from Budget to Actual
• Finance for Managers Without a Finance Background: P&L Lines, Department Budgets, Headcount Costs, Cash vs Profit & Simple Business Cases
• Mortgage-Backed Securities by Hand: Pool Cash Flows, Prepayment Speeds, Servicing Strips, Weighted Average Life & Price Scenarios
• Private Credit Deals: Floating Margins, Upfront Fees & OID, PIK Interest, Call Protection & Lender Yield
• Reinsurance by Hand: Quota Share, Surplus Treaties, Excess-of-Loss Layers, Reinstatements & the Ceded Result
• Professional Football Club Finance: Wage-to-Revenue, Player Registration Amortisation, Transfer Instalments, Matchday & Broadcast Income
• Aircraft Leasing by the Numbers: Lease Rate Factors, Maintenance Reserves, Return Conditions, Residual Values & Lessor Returns
• Inflation-Linked Bonds by Hand: Index Ratios, Adjusted Principal, Real Yields, Breakeven Inflation & Deflation Floors
• Money Markets by Hand: Discount Yields, Money-Market Yields, Day Counts, Short-Term Deposits, Repos & Cash-Fund Yields
• Litigation Funding by the Numbers: Case Budgets, Stage Probabilities, Expected Recoveries, Funder Return Structures, Proceeds Waterfalls, Duration & IRR and Case Portfolios
• Equity Valuation Models by Hand: Constant-Growth & Two-Stage Dividend Models, H-Model, Growth Value, FCFF vs FCFE, Residual Income, Justified Multiples & a Valuation Range
• Capital Structure by the Numbers: Operating & Financial Leverage, EPS–EBIT Indifference, Interest Tax Shields, Unlevered & Relevered Beta, WACC vs Debt Ratio and the Best Mix

Details

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