This report will analyze your financial position in a bid to provide viable recommendations for future fund management strategies. To this end, your cash flow statement and balance sheet are prepared in order to determine how well you spend your money and how your spending habits have contributed to your overall financial position as a family. Additionally, in order to determine whether your superannuation contributions will be sufficient for your retirement, two schedules are prepared to illustrate how much money you will have accumulated by the time you retire and how this sum will be distributed throughout the retirement period. It is concluded that your expenditure is unsustainable and as such, your family will be forced to adopt alternative fund management strategies in order to maximize your future cash flows. Consequently, the report elaborates five different strategies including the one you suggested (purchasing an investment property) highlighting their potential strengths and weaknesses. Adopting any of these strategies will go a long way in improving your future cash flows.
Q1. Cash flow statements for the 3 financial years ending 30 June 2015 – 2017, including detailed tax calculations (use current tax rates). Financial Planning
- CASH FLOW STATEMENT
|For the year ending 30th June||2015||2016||2017|
|1. CASH RECEIPTS|
|(a) Jerry’s Gross Income||105,000.00||108,150.00||111,394.50|
|Less: Income Tax||(26,797.00)||(27,962.50)||(29,163.00)|
|After Tax Income||78,203.00||80,187.50||82,231.50|
|(b) Jenny’s Salary||50,000.00||15,000.00||30,000.00|
|Less: Income Tax||(7,797.00)||0.00||(2,242.00)|
|After Tax Income||42,203.00||15,000.00||27,758.00|
|Total After Tax Income||120,406.00||95,187.50||109,989.50|
|Medecare Levy (2%)||(3,100.00)||2,163.00||(2,827.89)|
|Net Total Salary||102,581.00||87,076.25||93,729.13|
|(c) Return on Commonwealth Bank Shares||2,120.00||2,120.00||2,120.00|
|(d) Return on Bundoora Term deposit||128.00||269.00||400.54|
|(e) Superannuation Net Earning||17,297.07||18,611.59||20,017.97|
|2. TOTAL CASH RECEIPTS||122,126.07||108,076.84||116,267.64|
|(a) Mortgage and loan payments||29,500.00||29,500.00||29,500.00|
|(b) Work related expenses||2,500.00||1,500.00||2,000.00|
|(d) Household (e.g. food, clothes)||25,800.00||26,574.00||27,371.22|
|(e) Private education expenses||17,000.00||17,510.00||18,035.30|
|(h) Travel and holidays||7,000.00||5,000.00||5,000.00|
|(i) Motor vehicle expenses||8,500.00||8,755.00||9,017.65|
|(j) Jack’s laptop||3,500.00|
|(k) Kitchen Renovation||35,000.00|
|4. TOTAL EXPENDITURE||109,100.00||136,358.00||103,668.74|
Q2. Balance sheets for the 3 financial years ended 30 June 2015-2017.
- BALANCE SHEET
|As at June 30||2015||2016||2017|
|Total Non-Current Assets||737,000||782,500||831,101|
|Total Current Assets||588,054||592,505||650,490|
|LIABILITIES AND EQUITY|
|Personal car loan||16,000||10,889||6,211|
|Jones family equity||1,053,054||1,146,544||1,294,004|
|Total Liability and Equity||1,325,054||1,375,005||1,481,591|
According to the World Bank, the life expectancy in Australia is 82.1 years. As such, you will require a real income of $58,000 per annum for a period of at least 22 years that is from the age of 60 when you both retire to the age of 82. Because your current income grows at the same rate as inflation, the inflation rate will be used as the present value interest factor. The computation for the amount of the “real income” that you will require from your superannuation accounts at the time of retirement is shown below. This represents the approximate lump sum that you will required to have accumulated by the time you retire.
Q3. (i) An excel spreadsheet of accumulated superannuation for both Jerry and Jenny for each year from 1 July 2015 to their retirement in 30 June 2030.
Table 2: Accumulated Superannuation
|Year||Age||Salary||Opening Super Balance||Add: Employer Super Contribution||Less:15% Contributions tax||Add: Net Earnings||Closing Super Balance|
The current combined income for both of you is $1550000 ($105,000 for Jerry and 30,000 for Jenny). It should however be noted that Jenny will not earn any income in 2016 and earn an approximate income of 30,000 thereafter. Your total combined income will be assumed to be growing at the same rate as inflation. While you will be contributing money every year towards your superannuation, the fund will also be generating an average interest of 5.2% for Jerry and 4.9% for Jenny after taxes and fees. This translates to a cumulative average interest rate of 5.05% for both of you. 5.05% will therefore be used as the effective interest rate for calculating your net earnings from the superannuation fund for every year. For instance, during the 2015/2016 financial year, the fund will accumulate $14,725, $2,208.75 of which will be deducted as contributions tax. Whatever is left over will be combined with the opening super balance to generate net earnings of $17,297.07, amounting to a closing super balance of $359,813.32.
(ii) An excel spread sheet of accumulated superannuation for both Jerry and Jenny from the commencement of their retirement on 1 July 2030 detailing how long their superannuation is likely to last.
Table 3: Retirement Plan
|Year||Age||Opening Balance||Less: Pension Withdrawal||Add: Net Earnings||Closing Balance|
As aforementioned, the lump sum should amount to at least $924,341.16. Fortunately, your total combined superannuation contribution will amount to $964,693.55. This amount is more than enough to get you through retirement comfortably, without having to work a day in your life. Better still, the projected income of $58,000, which you will begin to get immediately after you retire has been adjusted for inflation so it will be growing by 3% every year. Provided that the rate of inflation will not have escalated by 2031, you should be able to maintain your lifestyle until the age of 82.
(iii) Determine what you believe the risk profile of the couple to be based on the information provided in this case study (ie. conservative, balanced, growth, highly aggressive etc) and discuss the reasons for your view.
Basing on the information you provided and your asset allocation, it is evident that you are balanced investors. Even though a vast majority of your assets has been allocated to property, all your disposable income have been channeled towards investments. I have also noticed that you are risk averse because most of these investments are associated with fixed interest securities. Only half of the total investment has been allocated to shares.
(ii) Determine the couple’s current asset allocation (across all their investments including super) in both $ and % terms and present this in the form of the following table.
Discuss the extent to which the current asset allocation is consistent with the couple’s risk profile determined in (i) above.
Table 4: Asset Allocation
|Current Asset Allocation|
|Investment||value||Cash||Fixed Interest||Property||Australian Shares||International shares||Total|
|Commonwealth Bank shares||53,000||53,000|
|Bundoora term deposit||165,000||165,000|
|capital stable fund||135,000||27,000||54,000||13,500||27,000||13,500||135,000|
|Total of Asset Class in $||1,067,000||46,500||327,304||779,750||138,500||33,000||1,325,054|
|Total of Asset Class in %||3.51%||24.70%||58.85%||10.45%||2.49%||100%|
5 (i) Critically analyse the financial situation of Jerry and Jenny based on the information provided and provide an overall analysis of the couple’s situation identifying problem areas and weaknesses
Strengths and Weaknesses.
From the financial statements above, it is evident that the family’s expenditure is unsustainable. As such, you should make deliberate efforts to reduce your annual expenditure. Fortunately you have decided to cut down on entertainment, travel and holiday expenditure. If the family kept up this lifestyle, it was highly unlikely that there would be any savings left after retirement. On the other end of the spectrum, you has made commendable attempts to invest in a myriad of financial instruments including shares, term deposits and savings accounts. Nevertheless, there are several other financial instruments that could provide viable investment opportunities for the family. On the bottom line, you are apparently very concerned about securing your future so you have made deliberate efforts to minimize current expenditure while at the same time trying to maximize the returns on the resources at your disposal in order to generate higher cash flows in future.
In order to appreciate the variety of financial instruments at your disposal, you should understand how companies raise capital because when you invest in a company’s financial instruments, you essentially become a source of capital for the company. The capital structure of most companies is usually a mix of long-term and short-term debt, common equity and preferred equity (Mahmud et al., 2009, p.9; Mullen, 2012, p. 5; Angell & Mautz Jr., 2007). These sources of capital are divided into two broad categories, that is, debt financing and equity financing. While equity represents the right to participate in earnings, debt represents the right to be repaid with a predetermined rate of return (or interest) (Walter, 2003, p. 2). When deciding whether to invest in debt or equity, you should consider the risk and reward associated with each financing option and its effect on the level of control you will gain in the company (Sherman, 2005, p. 4). Other than that, the financing option at your disposal will greatly depend on the amount of money you are willing to invest. Notwithstanding, it is more convenient to invest in large companies compared to smaller companies (Great Britain Department for Business, Innovation & Skills, 2010, p. 13). Some of the main variables you should consider before making an investment decision include leverage, liquidity, profitability, and the tangibility of assets in a company (Duca, 2010, p. 525). Moreover, you should not only focus on the current financial position but also the historical performance and future plans of a company.
Equity is mainly composed of common stock and preferred stock (Walter, 2003, p. 2). As you might already be aware, given that you already own shares, common stockholders enjoy voting rights but are paid a varying rate of dividends depending on the profitability of the company. Preference stockholders on the other hand do not enjoy voting rights but are paid a fixed rate of dividends regardless of whether the company makes a profit or a loss. The dividends payable to preference shareholders can either be cumulative or non-cumulative (Sherman, 2005, p. 11). It is also worth noting that if a private company intends to become a public limited company, it will raise additional capital through an Initial Public Offering (IPO). This might present a perfect opportunity for you to increase your wealth in the long run because start-ups are more often than not characterized by a double digit growth in share value in the initial stages of their lifecycles.
Several companies prefer equity as a method of raising capital because it is associated with numerous advantages including the ability to raise large amounts of capital, improved corporate image, easy access to future financing, ability to attract and retain key employees and the use of stock for the acquisition of other companies. Nevertheless, this method of raising capital could translate to several demerits for investors such as the dilution of share value, double taxation and companies focusing on short-term performance at the expense of long term performance.
The most common types of debt finance include loans and overdrafts (Business Link, 2010, p. 4). Individuals can provide both short term and long-term loans to companies and governments by buying certificates of deposit, treasury bills and treasury bonds. They can also advance loans to companies, which pledge assets such as inventory, accounts receivable or purchase orders as collateral. The main advantage of buying debt instead of equity is that it does not come with the risks associated with equity. Treasury bills and treasury bonds are for instance considered to be risk free investments
(iii) Based on the weaknesses identified above, provide any four possible financial strategies that the couple may be able to use to improve their short-term and longterm financial situation.
Fund Management Strategies
Diversify the Investment portfolio
From the foregoing, it is evident that even though the family has invested in shares and company debt, there several other company related financial instruments that have not been explored. It could for instance invest in treasury bills and bonds as opposed to shares and company debt because they are practically risk free. This option would secure the company’s funds for future use and provide a reasonable return on their investment. This return would however be lower than what is currently being offered by the bank. Other than that, because you apparently prefer fixed incomes on your investment, you could invest in cumulative preference shares, which would offer a higher return on your investment through dividends while at the same time offering the possibility of capital growth. Company shares, especially for new companies, have the capacity to grow up to more than double the initial share value in the long run. This would therefore generate more returns compared to company debt, which remains constant.
Invest in a Fund
There are a myriad of other financial instruments at the family’s disposal such as hedge funds, mutual funds, foreign currencies and derivative contracts. While these instruments might be very profitable for some investors, they are virtually useless for individuals who lack adequate knowledge and experience in financial markets. The family could however invest in these instruments vicariously through fund managers. Fund manager’s generally hold a portfolio of diversified assets, which generates a given return every year. In order to maximize the returns on their portfolios, fund managers take several factors into consideration before they ultimately decide to commit investors’ funds to any particular investment opportunity. The major factors they consider include the risk inherent in the opportunity and the expected return. While all investors prefer high to low returns, the former are usually associated with high risk and as such, most managers commit their funds to investments that achieve a suitable trade-off between the two factors. Even though they are not as secure as government securities funds offer higher returns and could go a long way in enhancing the growth of the family’s wealth.
Start a Business
Other than investing in companies and financial instruments, the family can decide to invest in its own business, which could potentially grow into a very successful company. Even though businesses are in most cases very risky investments, the return will also more often than not justify the risks. You could identify a viable business opportunity in the region and attempt to exploit it. Apart from their profitability, businesses can be very fulfilling because you can become your own boss and at the same time work on something you enjoy doing. Nonetheless, business are associated with several challenges. First, the family would require a substantial amount of capital to start and operate the business before it eventually starts to generate a reasonable income. The proprietor would also be force to work for long hours, sacrificing the time they have to spend with the family. This would also imply that at least one spouse would have to quit their job hence putting their future cash flows in jeopardy. If you have a good business idea in mind you could consider pursuing it. You should however be cognizant of the risks and challenges associated with running a business.
Take out insurance policies for the children
One of the main reasons driving most families to invest is so that they maintain its current lifestyle in future, which includes maintaining their children in private schools. One way to guarantee that your children will continue attending private schools even after you retire is by taking out education insurance policies, which will require you to pay premiums now in return for the insurance company paying for your children tuition fees when they get to higher institutions of learning. This is perhaps the surest way of ensuring that your children will continue to attend private schools regardless of your future financial position. This can also be achieved by directly investing in hedge funds and mutual funds, which can be channeled towards the children’s education in future.
- The couple are thinking about borrowing some money to buy an investment property in 2017. Do you believe this is a good strategy for the couple? Discuss the appropriateness of the strategy for the couple including the benefits and disadvantages of negative gearing and investing into property.
Buying an Investment Property
As illustrated in Appendix 1, the family will have only five more years left on the mortgage and one year on Jerry’s car loan so buying in investment property is not a bad idea. The real estate industry in Australia is characterized by increasingly high prices, which are on the verge of becoming unaffordable. This fact was unearthed by the striking revelation that Australia has a median multiple of 5.6, implying that the prices are in fact unaffordable. Some economists have however pointed out that this methodology is misleading citing the law of demand which stipulates that high prices result in a decline in demand, which in turn forces market prices to fall. According to these economists, the fact that market prices are increasing is an indicator that there is a high demand for the latter, hence disqualifying the assertion that market prices are unaffordable. Notwithstanding, before purchasing the investment property, you should carry out extensive research to determine the best location to purchase a house in Australia. Information on historical housing prices can provide valuable insights on the future trends in housing prices in different cities in the country. You should also note that while the investment property will boost future cash flows indefinitely, thereby enhancing the family financial security after retirement, borrowing more money to buy the property will increase your debt ratio. A high debt ratio will have a negative impact on your credit rating and significantly lower your cash flows between now and retirement.
Based on using the funds from the balance of the term deposit and requiring a 20% deposit to be able to purchase an investment property, what price range is the couple reasonably able to afford and accordingly how much will they be required to borrow from a bank? Will the couple be able to afford to pay the loan repayments? Discuss.
From the computation below, it is evident that you can afford to purchase a property worth $990,000.00 using the loan and Term deposit alone, a property worth $ 1,048,432.50 using the loan and term deposit plus your savings and a property worth $ 1,087,679.69 using the loan, term deposit, savings and Commonwealth Bank shares. This implies that you can afford a house ranging between $ 1,048,432.50 and $ 1,087,679.69.Unfortunately you will not be in a position to repay the loan. If you were to take a total loan of 990,000.00 for instance, you will be required to pay at least $ 108,000 per annum as illustrated in appendix 1, which is virtually impossible. You should however consider buying a cheaper investment property
|Other Current Assets:|
|Commonwealth Bank Shares||58,432.50||1,087,679.69|
|Annual loan payments||108,613.44|
|Interest in first calendar year||33,058.48|
|Interest over term of loan||421,974.72|
|Sum of all payments||1,411,974.72|
Angell, R.J. & Mautz Jr., R.D., 2007. Financing Growth in Small Companies. Commercial Lending Review, January-February. pp.27-34. Financial Planning
Basel Committee on Banking Supervision, 2011. The Joint Forum: Report on asset securitization incentives. Basel: Bank for International Settlements Bank for International Settlements. Financial Planning
Business Link, 2010. No-Nonsense Guide to Finance for High Growth and Innovative Businesses. [Online] Available at: http://www.businesslink.gov.uk/Finance_files/NNG_HG_Feb2010.pdf [Accessed 31 July 2013].
Duca, F., 2010. What Determines the Capital Structure of Listed Firms in Romania? CES Working Papers, pp.523-32. Financial Planning
Great Britain Department for Business, Innovation & Skills, 2010. Financing a private sector recovery. 1st ed. London: Stationery Office.
Jiangli, W. & Pritsker, M., 2008. The Impacts of Securitization on US Bank Holding Companies. [Online] Available at: http://web-docs.stern.nyu.edu/salomon/docs/crisis/pritzker.pdf [Accessed 31 July 2013].
Lee, H.J., 2003. Essays on Asset Securitization, Bank Production Costs, and the Credit Card Market. Dissertation. Ann Arbor: ProQuest Information and Learning Company University of California, Berkeley. Financial Planning
Mahmud, M., Herani, G.M., Rajar, A.W. & Farooq, a.W., 2009. Economic Factors Influencing Corporate Capital Structure in Three Asian Countries: Evidence from Japan, Malaysia, and Pakistan. Indusrial Journal of Management & Social Sciences, 3(1), pp.9-17. Financial Planning
Mullen, M., 2012. Best Practice Guideline: SME Finance. [Online] Available at: http://www.icaew.com/~/media/Files/Technical/Corporate-finance/Guidelines/tecpln11488-cff-guideline-58-2-final.pdf [Accessed 31 July 2013].
Sabry, F. & Okongwu, C., 2009. Study of the Impact of Securitization on Consumers, Investors, Financial Institutions and the Capital Markets. [Online] Available at: http://www.americansecuritization.com/uploadedfiles/ASF_NERA_Report.PDF [Accessed 31 July 2013]. Financial Planning
Sherman, A.J., 2005. Raising capital : get the money you need to grow your business. 2nd ed. New York: AMACOM. Financial Planning
Walter, R., 2003. Financing your small business. 1st ed. Hauppauge: Barron’s.
Appendix 1: Amortization
Table 5: Mortgage Amortization
|Payment Date||Beginning Balance||Scheduled Payment||Principal||Interest||Ending Balance|
Table 6: Car Loan Amortization
|Payment Date||Beginning Balance||Scheduled Payment||Principal||Interest||Ending Balance|
Table 7: Property Loan Amortization
|Year||Beginning Balance||Payment||Principal||Interest||Cumulative Principal||Cumulative Interest||Ending Balance|
Thanks for taking a look at our sample papers
Do you need any help with your assignment?
Our aim is to help you get the best grades for your Coursework.
We are very confident in our quality of work that we offer you 100% Money back guaranteeHeader Button Label: Get StartedGet Started