Prescribed Loan

This template projects the net tax savings available by using a prescribed rate loan to earn investment income.

Prescribed Loan Worksheet

This worksheet quantifies the net after-tax cash benefits available by using a prescribed loan strategy to split investment income. Using this strategy can provide your clients with significant and recurring savings.

You have full flexibility to consider the existing tax situation for your clients, and the amounts and types of marginal investment income earned. The worksheet then compares the total personal taxes paid by each party with and without the loan for a comprehensive view of the net tax effects.

This template will help you build a powerful tax model for your clients, and show them the real value of your tax planning strategy - regardless of whether they prefer a graphical result, or want to review the numbers. Let the savings begin!

YouTube video

YouTube video

Download PDF

Download PDF


Main interface

Existing personal income

Existing personal credits and deductions

Marginal personal income

Marginal personal credits and deductions

Marginal personal federal tax calculations

Marginal personal provincial tax calculations

Net cash summary

Net tax summary


  • Prescribed Loan Worksheet (Standard)
  • Prescribed Loan Worksheet (Simple)