Calculate a portfolio withdrawal scenario
See this course’s project requirements
A fictional retirement-income model with spending gap, withdrawal scenarios, inflation, return-order comparison and dated rule questions.
Keep your working files in your own notebook or software. Save a private description, checklist, and work link in My Proof.
What to include
- An income/spending map with an annual and monthly gap.
- A one-year withdrawal roll-forward and conditional rate explanation.
- An inflation-adjusted spending table with category limits.
- A return-order stress table and sequence-risk explanation.
- A gross/net withdrawal worksheet and dated rule-verification list.
- A retirement scenario packet and spending-review policy.
Review and revise
Use these criteria to check your work and choose what to improve.
- All supplied records reconcile and the decision uses the named case rules.
- Calculations show units, intermediate values and a second check.
- Changed-input practice revises the affected result and identifies uncertainty.
- The final project combines six lesson records, separates fictional assumptions from current rules, and states a supported next step.
Want more background?
The idea in everyday life
This is an original fictional practice case. No account, payment, personal record or outside participation is required. Opening portfolio $200,000; annual withdrawal $8,000 at start of year; subsequent return 5%; no fees or tax.
A withdrawal percentage describes the modeled draw, not a guarantee that savings last.
Calculate a portfolio withdrawal scenario — worked practice
A withdrawal percentage describes the modeled draw, not a guarantee that savings last.
Use paper or a local table; label all amounts as fictional USD unless the case names another unit. Opening portfolio $200,000; annual withdrawal $8,000 at start of year; subsequent return 5%; no fees or tax.
Withdrawal timing and return inputs
Paste at A1.
| AInput or record | BSupplied value |
|---|---|
| Opening portfolio USD | 200000 |
| Withdrawal at year start USD | 8000 |
| Return after withdrawal percent | 5 |
| Fees or tax USD | 0 |
Copy as plain text
1. Step 1: Calculate the opening withdrawal percentage
Calculate the opening withdrawal percentage.
You should see: 8000/200000=4%.
A withdrawal percentage describes the modeled draw, not a guarantee that savings last.
2. Step 2: Subtract the withdrawal before returns
Subtract the withdrawal before returns.
You should see: $192,000 remains invested.
Keep this intermediate result so the final decision can be checked.
3. Step 3: Apply the stated annual return
Apply the stated annual return.
You should see: 192000×1.05=$201,600.
Keep this intermediate result so the final decision can be checked.
4. Step 4: State the conditional result
State the conditional result.
You should see: End balance $201,600 only under this return/timing assumption; 4% is not certified safe.
Keep this intermediate result so the final decision can be checked.
What to finish
A one-year withdrawal roll-forward and conditional rate explanation.
Watch for this
Presenting a modeled percentage as a universally safe withdrawal rule.
How can I tell I understand it?
Model a start-year withdrawal and subsequent return with explicit timing on the supplied changed case while preserving the stated rule and checking the final record.
Quick knowledge check
Answer all 3 questions. Get at least 2 right and the lesson completes automatically.
You’ll get an explanation for each answer. Signed in? Your results save to your account.
Pass the check. We’ll save the progress.
Answer all 3 questions above and get at least 2 right. You can review the explanations and try again.
Go to the knowledge checkTools, templates, and lesson sources
Tools and templates
Tools open in a new tab so you can keep your place here.
Sources and further reading
Explore the references behind this lesson.
Source & access notes · checked 2026-10-01
Official page opened/read during Money expansion authoring; checked the relevant concept and access state. These sources do not establish funding eligibility.
Access: Readable official webpage inspected with the web reader on 2026-10-01. No interactive-tool operation is claimed.
Reuse: Original fictional practice, questions and calculations; paraphrased concepts with a source link. No source exercise copied.
Report a problem with this lesson
Tell us what went wrong. Please leave out personal information and private project contents.