📊 EXCEL FOR FINANCE - PRACTICE WORKBOOK
Welcome! This workbook contains practice exercises for each section of the guide.
HOW TO USE THIS WORKBOOK:
1. Each sheet covers a different finance topic
2. BLUE cells are inputs - these are given to you
3. YELLOW cells are where YOU enter your formulas
4. GREEN cells show the correct answers (check your work!)
5. Try to solve each exercise BEFORE looking at the answers
6. Answer sheets are at the end of the workbook
SHEETS IN THIS WORKBOOK:
1. TVM Exercises Future Value, Present Value, PMT, NPER, RATE
2. NPV-IRR Exercises Net Present Value, Internal Rate of Return
3. Bond Exercises Bond pricing and yields
4. Loan Exercises Amortisation, IPMT, PPMT
5. CAPM Exercises Beta, Expected Return, Portfolio Beta
6. WACC Exercises Weighted Average Cost of Capital
7. Data Functions VLOOKUP, INDEX-MATCH, SUMIF
ANSWERS All solutions with formulas shown
,
Welcome! This workbook contains practice exercises for each section of the guide.
HOW TO USE THIS WORKBOOK:
1. Each sheet covers a different finance topic
2. BLUE cells are inputs - these are given to you
3. YELLOW cells are where YOU enter your formulas
4. GREEN cells show the correct answers (check your work!)
5. Try to solve each exercise BEFORE looking at the answers
6. Answer sheets are at the end of the workbook
SHEETS IN THIS WORKBOOK:
1. TVM Exercises Future Value, Present Value, PMT, NPER, RATE
2. NPV-IRR Exercises Net Present Value, Internal Rate of Return
3. Bond Exercises Bond pricing and yields
4. Loan Exercises Amortisation, IPMT, PPMT
5. CAPM Exercises Beta, Expected Return, Portfolio Beta
6. WACC Exercises Weighted Average Cost of Capital
7. Data Functions VLOOKUP, INDEX-MATCH, SUMIF
ANSWERS All solutions with formulas shown
,
