MEWC
FMWC
TAC
EEO
TASK
You must model monthly spending over the next five years based on housing cost assumptions, an estimated car loan payment, a base monthly budget, and adjustments for inflation and seasonality. Then you’ll combine your forecasts with assumptions about salary, a starting savings balance, expected return from savings, and a credit card interest rate to model total savings and debt over five years.
FUNCTIONS USED
absolute references
conditional logic (e.g., “if” statements)
min/max
annuity payment calculations
xlookup
Video is divided in parts so you can easily skip to the part that you are stuck on to find out best solution.
© 2022-2026 Microsoft Excel Collegiate Challenge. All rights reserved.