“What’s Your (Net) Worth?” – Microsoft Excel Collegiate Challenge 2022


This case was premiered in the Microsoft Excel Collegiate Challenge Semi-Finals 2022.

Case Description:
You are just about to get your first job and you want to project your net worth over the next five years. Rather than focusing on your net worth from a market-value perspective (which would include the present value of all future net cash flows), you choose to focus on the book-value perspective to understand what your assets and liabilities will look like over the next five years. First, you’ll have to project your monthly cash flows, then determine your net worth each month.

The downloadable file consists of the following:
Task: PDF file with Case Materials; PDF file with Questions; Excel file with the initial model
Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold