ModeldrillTiming flags for a project
A financial modeling exercise from Modeldrill. Solve it with a live spreadsheet grid in your browser, with Fill right and Fill down, and it is checked the moment you submit.
The task
A project only earns revenue while it operates. Fill the operating flag (row 7: 1 in every year from the first operating year in B2 to the last in B3, both included, otherwise 0) and revenue (row 8: the flag times the full-year revenue in B4).
What this exercise teaches
A flag row of 1s and 0s keeps timing in one place. Every line that depends on the operating period multiplies by the flag, so moving the start date is one input change instead of a rewrite of each row.
A hint if you get stuck
The flag is an IF around AND with two tests against the locked start and end years. Revenue is then just the flag times the locked full-year amount.
Try it now, free, no account needed
The first 15 tasks on Modeldrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every task, timed mode and the certificate.
Open this exerciseMore exercises in Income statement and schedules
- Fixed and variable operating costs
- EBITDA and EBITDA margin
- Straight-line depreciation by asset
- Depreciation from the year of purchase
- Fixed asset roll-forward
- Interest on the opening debt balance
- Tax only when there is a profit
- Tax losses carried forward
- From EBITDA to net income
- Depreciation waterfall with a half-year convention
- Interest on the average balance
- Retained earnings roll-forward
- Declining balance depreciation