Eight tasks on one company, Fenwick Garden Supply, mixing everything from this unit. Your answers stay on the sheet as you go, so the later tasks build on the earlier ones.
Before each formula, find the driver row in the assumptions block and ask:
- Is it a share of something (revenue, COGS, opening PP&E)? Multiply.
- Is it a number of days? Multiply the flow by the days and divide by the day count.
- Is it a roll-forward (PP&E, debt)? Opening balance plus additions less reductions.
- Could it go negative where it shouldn't (taxes in a loss year)? Use MAX.
Interest and depreciation use opening balances throughout. 2028 is a hard year for Fenwick, so watch what each formula does when revenue falls. Answers are checked on hidden data too, so point at the cells.