Excel for Investing & Economics 3

What's inside

Excel for Investing & Economics 3: 10 courses, 200 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.

• 10 complete courses, 200 lessons, 203 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

• House Flipping Math: ARV, the 70% Rule, Rehab Budgets & Holding Costs
• Pension Lump Sum vs Annuity: Present Value, Break-Even Age & Risk Trade-offs
• Portfolio Rebalancing: Drift, Bands, Cash-Flow & Tax-Aware Rebalancing
• College Savings Planning: Future Cost, Monthly Savings & Tax-Advantaged Accounts
• Gold & Precious Metals Investing: Premiums, Storage Costs, Ratios & Portfolio Role
• Investment Fees: Expense Ratios, Advisory Fees, Loads & Their Long-Run Cost
• Employee Equity: RSUs, Stock Options, Vesting, Dilution & Exit Scenarios
• Currency-Hedged Investing: Unhedged vs Hedged Returns, Forward Points, Hedge Costs, Partial Hedge Ratios & Rolling Hedges
• Volatility, Volume & Price Levels: True Range & ATR, Stochastic Oscillator, VWAP, On-Balance Volume, Pivot Points, Retracement Levels & ATR-Based Stops
• Portfolio Optimisation by Hand: Covariance Tables, Two- and Three-Asset Mixes, Minimum-Variance Portfolios, the Efficient Frontier & the Tangency Portfolio

Details

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