Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave
How to Prepare a Cash Flow Table

Activity

Activity

In this activity, you are a financial planner

Your clients are Craig and Lisa Robertson. Craig, age 36, and Lisa, age 34, come to see you. They have two children, Dylan, age 7 and Stephen, age 6.

Craig

Craig is a self-employed computer programmer. His assessable income was $150,000 in the 2012/13 financial year. He works from an office a couple of blocks away from his and Lisa’s home. He spends on average $600 per week on rent, electricity and other office expenses. He is able to claim $10,000 for work related travel expenses as he usually travels to his clients’ offices and works from there.

In the 2012/13 financial year he contributed $12,000 to his superannuation fund, and paid $500 in premiums for income protection insurance, $400 for death and total and permanent disablement (TPD) cover, and $200 for a separate trauma insurance policy.

Craig’s superannuation account balance is $80,000.

Lisa

Since Dylan’s birth, Lisa has been working two nights per week as a nurse, earning $450 per week. She looks after Dylan, Stephen and also her older sister, Fiona, who has been diagnosed with terminal cancer. Fiona lives in the same suburb.

Lisa owns Australian shares which she purchased for $25,000. They are currently valued at $30,000 and she receives fully franked dividends of $2100, with imputation credits of $900.

Her superannuation account balance is $50,000.

Lisa made a tax deductible donation of $200 to the Cancer Council last year.

Other

Currently their household expenses average $700 per week. Their credit card debt is $8000, outstanding for the past 12 months (at 17% p.a. interest).

They have adequate insurance for their cars as well as home, contents and private health cover.

The premiums for these insurances total $3000 p.a. The rebate offered for private health cover is taken as a reduced premium. They have no other insurance or investments.

Assets

Craig and Lisa’s jointly owned cash management trust (CMT) account balance is $20,000 and earns 4% p.a. in interest. They hold a joint cheque account with a balance of $5000 for emergency funds. Their house is worth $670,000, with a mortgage of $500,000 and repayments of $2500 per month. Their contents are worth around $60,000. They have two cars valued at $30,000 and $5000 respectively. 

Analysing a client’s cash flow is one of the important elements in understanding a client’s financial position. If conducted properly and accurately, a wealth of information can be obtained which will assist a planner in formulating the right strategy for clients.

Assumptions

In an orderly way it can disclose such things as how income is derived and from where, what expenses are incurred, what the tax position of the client is and, importantly, whether a client is spending more than is being received as income. Conversely, it will reflect how much discretionary savings the client has which could be used for either investment or debt reduction.

A cash flow table is an important tool in understanding the client. There are normally two cash flow exercises to be completed when preparing advice for clients. One is for the client’s present situation that reflects where they are currently, and the second reflects the outcome of changes that the planner has recommended — the future situation.

The future cash flow statement/table reflects the client’s cash flow situation following the implementation of the recommended strategies.

Preparing a cash flow table can be straightforward, provided you follow these four steps: Who, When, What and How? 

Assumptions

  • Their cheque account pays no interest.
  • As Craig is self-employed, his $12,000 contribution to superannuation is tax deductible.
  • Income from shares must include any available imputation credits.

To calculate an imputation credit, the following equation can be used:

Imputation credit = Dividend ×

Company tax rate

100 – Company tax rate


Subsequently, the amount of the imputation credit is an offset and subtracted from the total tax.

Step 1: Who?

Who are you preparing the cash flow for?

For example, is it being prepared for one person, two separate non-related people or a couple?

Do those people have company, trust or superannuation structures which they hold assets through?

Each entity (i.e. a person, company, trust or superannuation fund) is taxed separately, so you must initially consider each separately for tax purposes. There may be an opportunity to combine them, at a later stage, for cash flow purposes.

In our case, we are preparing a cash flow table for Craig and Lisa.

Step 2: When?

You will need to identify the period of time for which the cash flow table is being prepared. It might be for a number of weeks, months or years. In the case of Craig and Lisa, it is for a year. It is important to differentiate between a financial year (i.e. 12 months from 1 July to 30 June) and a calendar year

(i.e. 12 months from 1 January to 31 December). A financial year is also the year used for taxation purposes.

So, in Craig and Lisa’s case, we will need information over the 12 months from 1 July 2012 to 30 June 2013.

Step 3: What?

Clients will ask you what they need to provide you with so that you can prepare the cash flow table. You will need the following:

  • Tax returns: A good start is your client’s tax returns. These will provide you with enough information to establish their income after tax. Their income after tax is a key starting point, as this amount tells you what the net cash your client has available to spend, save or invest with. The tax returns also show you where income has been earned.

Step 1: Who?

For example, Lisa owns shares and has been paid dividends on these shares. Craig and Lisa have jobs. Craig is self-employed and therefore has income derived from that self-employment. Lisa is an employee so she has received a salary. In addition, some of their expenses may be tax deductible, which would reduce their taxable income and hence the tax payable on their income. You can review tax returns for such deductible expenses. Further, the latest figures should be used to gain the most recent, up-to-date result.

In our case, we need to ask Craig and Lisa for copies of their 2012/2013 tax returns. The 2012/2013 rates and thresholds will be used.

  • Bank and credit card statements: Preparing a cash flow means identifying flows of cash. A client’s bank statements show exactly that information. The statements will show cash inflows (e.g. salary, dividends received) and cash outflows (e.g. mortgage payments which are direct debited). Many people use their credit cards to pay for expenses. Reviewing their statements will help identify recurring expenses

(e.g. rates and taxes, electricity bills, insurance deductions) and lifestyle expenses (e.g. restaurant meals, holidays).

Ask Craig and Lisa for copies of their cash management trust, chequebook, and credit card statements. In addition, the chequebook and credit card statements would disclose to whom payments have been made.

  • Listing of assets and liabilities: A list of your client’s assets and liabilities and who owns the assets or has the liability can be very useful, not only from a cash flow perspective, but also in understanding your client’s overall financial situation. From this list, you will be able to determine what assets and liabilities have a cash flow impact. Refer to ‘Table A: Assets and liabilities’ 

Step 4: How?

Once the above has been completed, it is quite straightforward to complete a cash flow table. Most people will use a spreadsheet of some sort, or financial planning software. Use whatever is easiest for you and what you are most familiar with, and follow the steps below:

(a) For each person (in our case, Craig and Lisa), calculate his or her income tax liability. Helpful hint: The easiest way to do this is to use the information provided in the tax return. By reviewing the return, you will be able to identify Craig and Lisa’s taxable income (i.e. their assessable income less expenses which can be claimed as a tax deduction). The tax return will also disclose the estimated tax they would have to pay on the taxable income.

(b) Complete the cash flow table. Some of the information from the tax calculation table is also used in the cash flow table, however, the cash flow table only includes income they actually receive and expenses actually paid. It should be noted that some income for tax purposes is not actually received (i.e. franking credits) and some expenses may or may not have actually been incurred (i.e. travel expenses where a specific formula is used). Note: For Craig, it is assumed his travel expenses have been incurred.

(c) Total the income they have received before any tax has been paid.

(d) Total the expenses they have incurred.

(e) Deduct the total expenses from the total of the income received before tax.

(f) Deduct from the total income received before tax, the tax payable from the tax calculation. In this way, taxation is taken into account for cash flow purposes and is treated effectively as an expense.

This will produce a total net cash flow amount ($25,414 combined), which is available for savings or investment.

Further, where there is a significant cash flow and this is not shown in any savings or investments, it may indicate that there may be expenses that have not been identified. This may prompt questions to your client asking what else they do with their money.

HowtoPrepareaCashFlowTable_v2 © Kaplan Education Pty Ltd. All rights reserved.

Asset

Owner

Value

Liabilities

Net value

Notes

Personal assets

Family home

Craig and Lisa

$670,000

$500,000

$170,000

The net value will not result in cash

jointly

flow unless the property is sold.

Home contents

Craig and Lisa

$60,000

$0

$60,000

The value of their contents will not

jointly

result in cash flow. However, if

there is a planned replacement of

contents, such as whitegoods, then

this should be included within the

cash flow. This case study does not

mention the replacement of any

items of contents.

Car (two)

Craig and Lisa

$35,000

$0

$35,000

Unless the cars are sold there

jointly

would be no cash flow.

However, owning cars means

payments for running expenses,

such as registration costs, petrol,

insurance and other maintenance

costs. So you would need to be

alert to these for your cash flow

table.

Credit card

Craig and Lisa

$0

$8,000

–$8,000

Craig and Lisa have a credit card

jointly

with a debt of $8000 outstanding

for the last 12 months. This card

has an interest rate of 17% p.a.

Total

$765,000

$508,000

$257,000

Superannuation

Superannuation

Craig

$80,000

n.a.

$80,000

Craig has made contributions to his

superannuation during the financial

year. This means there has been a

cash outflow from him. He can

claim the full contribution as a tax

deduction.

Superannuation

Lisa

$50,000

n.a.

$50,000

Lisa is not old enough to be drawing

an income from her superannuation

and she has not made any of her

own contributions.

Therefore, there is no cash flow

effect.

Total

$130,000

n.a.

$130,000

 Other assets

Investment property

Cash management

Craig and Lisa

$20,000

$0

$20,000

Even if the balance has remained

trust

jointly

the same during the year, there

may have been a series of cash

inflows and outflows that resulted

in the same cash balance. This is

why you need a copy of the

statements.

This case study tells you that the

account earned interest at 4% p.a.

This means $800 was earned in

interest. For tax purposes, the CMT

is jointly owned. This means that

Craig and Lisa each own half of the

account. Accordingly, for tax

purposes, each has earned half of

the interest, or $400 each.

Cheque account

Craig and Lisa

$5,000

$0

$5,000

Even if the balance has remained

jointly

the same during the year, there

may have been a series of cash

inflows and outflows that resulted

in the same cash balance. This is

why you need a copy of the

statements and chequebook for this

account.

You are told that the account

earned no interest.

Shares

Lisa

$30,000

$0

$30,000

The shares will not result in cash

flow unless the shares are sold.

Total

$55,000

$0

$55,000

Net worth

$950,000

$508,000

$442,000

Liabilities

Loan

Current debt

Percentage tax

Interest only

Repayment

deductible

Home loan

$500,000

nil

No

$2500 per month

Investment property

Investment loan

Personal loan

Other: Credit card

$8,000

nil

No

Interest of 17% p.a. was

charged on the

outstanding balance

= $1360.

Total

$508,000

nil

Now that you have viewed the tutorial, your task is to prepare a cash flow table for Craig and Lisa for the financial year ended 30 June 2013.

Once again, here are the assumptions:

Their cheque account pays no interest.

As Craig is self-employed, his $12,000 contribution to superannuation is fully tax deductible.

Income from shares must include any available imputation credits. To calculate an imputation credit the following equation can be used:

Imputation credit = Dividend ×

Company tax rate

100 – Company tax rate

 
Subsequently, the amount of the imputation credit is then subtracted from the total tax.

Try the task now — we suggest you use Microsoft Excel Workbook format (xls).

Compare your cash flow table to the example on the following pages.

This activity demonstrates the tax and cash flow tables used in Kaplan courses.

Income, tax and cash flow

Tax calculation

Craig

Lisa

Combined

Comments

Income from

employment

Salary

$150,000

$23,400

$173,400

Craig’s income is from self-employment and you are told it

is $150,000. Lisa earned $450 per week (i.e. for the year

52 × $450 = $23,400).

Salary sacrifice

Salary after salary

$150,000

$23,400

$173,400

sacrifice

Rental income

Unfranked dividends

Franked dividends

$2,100

$2,100

The dividend received by Lisa.

Franking (imputation)

$900

$900

The franking credit is attached to the dividends received

credits

by Lisa. For tax purposes, this needs to be added to arrive

at the assessable income.

Interest

$400

$400

$800

$800 in interest earned needs to be split between Craig

and Lisa, as the cash management trust is jointly owned.

Other income

(e.g. taxable benefits,

trust income,

investment income)

Capital gains < 1 yr

Capital gains > 1 yr

Tax-free component of

capital gains

support
Whatsapp
callback
sales
sales chat
Whatsapp
callback
sales chat
close