Professional Excel Templates for your Business
MECC 2022 - Final - "What is Your Net Worth"
This is an actual case study that was presented to the participants of Microsoft Excel Collegiate Challenge, Final Round (December 2022).
Case study description:
You are just about to get your first “real” 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.
Using the details given in the model template, you have to project your monthly cash flow. Then determine your net worth each month. To do so, project your asset accounts (cash and the book value of your car) and liabilities accounts (student loan and car loan). The difference is your net worth (book value).
The downloadable file consists of the following:
–Task: PDF file with Case Materials; PDF file with Questions; Excel file with initial data and case assumptions
–Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold
You can also sign-up for the future MECC here.