Investing & Personal Finance
Investing & Portfolio Analysis in Excel
IntermediateCertificate$9.99
Dividend & Income Investing in Excel
Measure yield, payout safety, dividend growth, DRIP compounding, portfolio income and total return, with every formula checked on a live spreadsheet. Educational only, not investment advice.
- One-time payment
- 14-day money-back guarantee
- Secure checkout with Stripe
What you'll build
What you will be able to do
Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.
- Calculate the annual dividend, forward yield, yield on cost and annual income of a five-stock income portfolio.
- Check how well Keystone Industrials' 2026 dividend is covered by earnings and by free cash flow.
- Measure five years of dividend growth and screen six stocks with a Chowder-style yield + growth rule.
- Model ten years of reinvested Westbrook Pharma dividends and compare the income with taking the cash.
- Measure the income and yield of a seven-stock portfolio and the extra capital an income goal needs.
- Screen seven dividend stocks against payout and balance-sheet rules and rate each one SAFE, WATCH or RISK.
- Compare a high-yield stock and a fast dividend grower on price return, total return and the yield + growth shortcut.
- Check which Q4 2026 dividends you are entitled to, what arrives after withholding tax, and whether a dividend-capture trade pays off.
About this course
Turn a list of dividend payers into numbers you can compare and question. You calculate current yield and yield on cost, then check payout ratio and dividend cover against both earnings and free cash flow. A compound growth rate over several years feeds a simple yield-plus-growth screen, and a reinvestment table shows how dividends buy more shares over time. For a small income portfolio you work out the weighted yield and expected annual income, build a pass-or-fail safety screen from several conditions, and compare total return with price-only return. The last lab covers ex-dividend dates and the effect of withholding tax on net income. Aimed at private investors and finance students; it teaches calculations, not stock picks or investment or tax advice.
Curriculum
Course content
8 lessons · 8 labs · 1.8 h · final exam
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Final exam
Certificate
Finish with a certificate you can verify
Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.
- Names the course, your score and the date of issue
- A verification link for your CV or LinkedIn profile
- 12 questions, 75% to pass, unlimited retries.
A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.
Before you buy
Questions about this course
Is this a subscription?
No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.
What exactly do I get?
All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.
Can I get a refund?
Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.
When can I start?
Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.
Do I need Excel or other software?
No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.
Is the certificate an official qualification?
No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.
Full details are in our Terms · hello@tutorvo.com
Real Estate & Property
REIT Analysis: FFO, AFFO, NAV & Dividend Coverage
IntermediateCertificate$9.99