the time value of money ,, Financial Management, Financial Accounting

Assignment Help:
Calculate the present value and determine the npv, Financial Management.

Assume today is 3 December 2009. Helen is 30 years old and has a Bachelor of Business. She is currently employed as a personal banker for ANZ banking group in Sydney and earns $38000 a year that she anticipates will grow at 3% per year. Helen hopes to retire at age 65 and has just begun to think about her future.

Helen has $75000 that she recently inherited form her Uncle John. She invested this money in a five year term deposit with her bank. She is considering whether she should further her education and would use her inheritance to pay for it.

Helen has investigated a couple of options in this regards, and is asking for your help as a financial planner. She has already been accepted to both of these programs and could start either one soon.

The first option that Helen is considering is attaining a certification in IT. The certificate would automatically promote her to a personal manager in ANZ. The base salary for personal manager is $10 000 more than what she currently earns and she anticipates that this salary differential will grow at a rate of 3% a year as long as she keeps working. The certificate in IT program requires the completion of 20 online courses including a score of 80% or better in the exam at the end of each course. She has learned that the average length of time required to finish the program is one year. The total cost of the program is $5000, with payment due when she enrols in the program. Because she will do all the work for the certification in her own time, Helen does not expect to lose any income during the period of study.

The second option is going back to University to study for a Mater of Professional Accountant (MPA). With an MPA degree, Helen expects to be promoted to managerial position. The managerial position pays $20 000 a year more than her current position. She expects that this salary differential will also grow at a rate of 3% a year for as long as she keeps workings.

The evening program will take three years to complete, costs $25 000 per year, with payment due at the beginning of each of the 3 years she is at the university. Because she will attend classes in the evening, Helen does not expect to lose any income while she is studying for her MPA.

Note:
In answering the following questions you should show your workings and or the calculator key strokes used.
Round your answers to two decimal places
You are permitted to make assumptions in arriving at your answer provided that you do not assume away details that have been provided as part of the question

Requires:

1, Determine the interest rate Helen is currently earning on her inheritance by going to the Reserve Bank of Australia and click on the Cash Rate link in the key information section. Choose the market rate at 3 December 2009. Use this interest rate as the discount rate for the remainder of the problem.

2. Create a timeline of expected cash flow for the following 3 scenarios in Excel for Helen''''s current situation, as well as the certificate program and MPA degree option , using the following assumptions:

a) Salaries for the year are paid only once, at the end of the year.

b). The Salary increase becomes effective immediately upon graduating from the MPA or being certified. However although the increases become effective immediately, the salaries are paid at the end of the year, the first salary increase will be paid exactly one year after graduation or certification.

3. Calculate the Present Value of salary differential for completing the certification program. Subtract the cost of the program to get the MPA of undertaking the certification program.

4, Calculate the present value of the salary differential for completing the MPA. Calculate the present value of the cost of the MPA. Based on your calculations, determine the NPV of undertaking the MPA.

5, Base on your answer to question 3 and 4, what advice would you give to Helen? What if the two program are mutually exclusive? If Helen undertakes one of the programs, there is no further benefit to undertaking the other program. Would your advice change?

Related Discussions:- the time value of money ,, Financial Management

Duties of trustees-trusts laws and accounts, DUTIES OF TRUSTEES 1) Not ...

DUTIES OF TRUSTEES 1) Not to profit from the trust : A trustee may not receive remuneration except: By order of the court, if the trust is very onerous or the services of the

Market microstructure and electronic trading, 1. You (Exchange) have just f...

1. You (Exchange) have just filled an order and notified involved traders of their fills. Next you must tell the world about this trade. Suppose you flip a coin. You flip a coin

Content of accounts-trusts accounts, Content of accounts Periodical acc...

Content of accounts Periodical accounts should normally consist of:         1.    Balance sheet of the whole trust;         2.    Capital account;         3.    Income account

Maturity risk premiums , Suppose that the real risk-free rate, r*, is 4% an...

Suppose that the real risk-free rate, r*, is 4% and that inflation is usual to be 8% in Year 1, 5% in Year 2, and 4% thereafter. Suppose also that all Treasury securities are highl

Illustration regarding profit that head office can claim, Illustration rega...

Illustration regarding profit that head office can claim E Ltd sets up a branch in Nyeri on 1 July 2001. Goods are sent to branch at an invoice price which is 10% above cost. S

Experienced auditor, Experienced Auditor - An AUDITOR who has a reasonable ...

Experienced Auditor - An AUDITOR who has a reasonable understanding of audit activities and has studied company's industry as well as accounting and auditing issues relevant to the

Partnership, Definition: A partnership is defined as “the relationship ...

Definition: A partnership is defined as “the relationship that subsists between two or more persons carrying on a business in common with a view to making a profit.” (Partnersh

Adjustment, A company does not need to record the receipt of a bill for uti...

A company does not need to record the receipt of a bill for utilities used during this year if they will not pay for it until next year. True or False

Stock valuation, D1=$0.65, D2=$0.74, D3=$0.79, D4=$0.84.Dividen grow contin...

D1=$0.65, D2=$0.74, D3=$0.79, D4=$0.84.Dividen grow continually at rate of 3% per year stating from year 5 onward.assuming the required rate of return to this stock is 12%.what wil

Entity theory method, Entity theory method: Golden Bells Inc. is a for...

Entity theory method: Golden Bells Inc. is a foreign subsidiary of Northern Bells Ltd., a Canadian company.  Northern Bells had purchased 90% of the outstanding shares of Gold

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd