What should the immediate adjustment to his current salary

Assignment Help Financial Management

Reference no: EM131851299

Complete your work in Excel and submit to Canvas by due date/time.
Clearly mark (highlight) your answers

Section I. (Excel TAB1)
Expected inflation is important consideration in financial planning and the valuation process.

1. Based on 10-year Treasury rates, report expected inflation for

a. November 1, 2016 (before election)

b. December 1, 2016 (after election)

2. Generate a graph of expected inflation starting on January 4, 2016 to present There are two ways to get the data from FRED:
a) Directly from Excel - download and install Excel Add-in using this link (you need to provide you e-mail and pick appropriate Excel version):

b) Download data from FRED website:
Enter data codes (provided below) into Search Data codes:

10-Year Treasury Constant Maturity Rate: DGS10

10-Year Treasury Inflation-Indexed Security, Constant Maturity: DFII10

Section II. (Excel TAB2)

Ian received an undergraduate degree in finance four years ago and has been employed all this time at a mid-size wealth management company. His initial salary was $65,000 per year and increased 4.0% every year. Ian decided that his four-year stint at this employer has prepared him well for an MBA degree.

He applied to several schools and was accepted by one of the top-10 programs in the county. Ian notified his manager about his decision yesterday, but today the manager made him the following offer: Ian will be assigned to lead a very important project with immediate salary increase of 10%.

The manager assured him that for the following four years his annual raise will be at least 5%. Ian is planning to make his decision (quit and go to school or stay and lead the project) based on the present value of future earnings in the next 20 years (ignore taxes). He plans to stop working in exactly 20 years regardless of his decision and become a gentleman farmer.

1. Build a spreadsheet with Ian's cash flows for the next 20 years and calculate present value of future earnings for two scenarios: (1) stay
and lead the project and (2) enroll into MBA program; assume the following: Ian estimates that the two-year MBA program will cost $100,000 per year in tuition and other expenses; his starting salary after MBA is expected to be $125,000 and will grow 3.0% per year, the same growth rate that Ian expects his salary will grow at his current employer after the 5% raises are over. Ian thinks that the appropriate discount rate is equal to 10-yr Treasury rate on December 7, 2017 + 4.00% (from Section I). What scenario should Ian pick?

2. What should the immediate adjustment to his current salary be to make Ian indifferent between two scenarios? (Hint: use solver function in Excel)

3. Discuss your findings. What other considerations should Ian take into account in making his decision? Can they be incorporated into the NPV framework?

Reference no: EM131851299

Questions Cloud

What is the maximum initial cost company : What is the maximum initial cost the company would be willing to pay for the project?

Explain the levels of the independent variable : Describe the threats to validity (external or internal) in article. Did authors address these threats?Explain the levels of the independent variable.

Amount of balance sheet accounts receivable : The Arizona Bay Corporation sells on credit terms of net 30. Amount of Balance Sheet Accounts Receivable?

Country would the treasurer want to invest company funds : Ignoring transaction costs, in which country would the treasurer want to invest the company’s funds? Why?

What should the immediate adjustment to his current salary : What should the immediate adjustment to his current salary be to make Ian indifferent between two scenarios?

Utilizing an annual cash-flow analysis : Utilizing an annual cash-flow analysis determine which mutually exclusive water canning option Jaguar Beans should select. Why?

Operating lease agreement : On January 1, 2016, Sweetwater Furniture Company leased office space under a 21-year operating lease agreement.

Collecting cash payments in health care organization : Cash payment should occur at the first encounter with a patient, especially for elective procedures and in cases where insurance coverage cannot be validated.

What will be the before-tax OCF : Suppose your firm uses the NPV rule in making investment decisions and your after-tax OCF is $900000. What will be the before-tax OCF?

User Account

All Pages