It's @msexcelesports weekend again - so as usual, I'm trying to get in the head of one of this weekend's case authors, in this case, Michael Jarman.
This is Michael's most recent FMWC case, "Tax doesn't have to be taxing", from round 4 of last year, and asks you to model the return to an equity investor of a solar power facility in different jurisdictions, with different weather patterns but also different tax regimes.
If you want to try the problem yourself (always a better way to learn!), you can buy it here:
https://www.fmworldcup.com/product/stage-4-2022-tax-does-not-have-to-be-taxing/
Sections
00:00 Introduction
02:15 Question description
03:35 Model setup (periods, flags, etc)
05:40 Revenue and costs
11:56 Construction, financing, equity returns
17:46 Tax regimes