User Account

All Pages

Mr, Corporate Finance

Assignment Help:
PROBLEM 1

A friend of yours, employed as a Tier 2 field service representative for a telephony corporation, wants your help as a financial specialist to determine the financial consequences associated with investing in education. One alternative is to enroll in an MBA-program and the other alternative is to attain a certification in network design. Your friend has provided you the following information:
General
• The current salary of $40 000 is paid once at the end of each year.
• The salary is expected to grow at a rate of 3% per year and your friend is expected to work for another 35 years (until retirement)
• Your friend’s income tax level is expected to be 25% forever
• Your friend’s current discount rate is 10% and is expected to stay at this level forever unless no further education investment is made.
• Today is the 1st of January 2013
The network design certification education
• The education starts immediately and ends 31st of December 2013
• The course fee is $5 000, to be paid today.
• The certificate implies a promotion and a salary increase of $10 000. The new salary will be paid starting December 31st 2014 and onwards.
• Due to that the education runs on evenings no salary loss is expected during the education
• Upon completion of the education your friend’s new discount rate will become 11%
The mba-program education
• The education starts immediately and ends the 31st of December 2013
• If enrolling your friend will earn no salary during 2013
• The tuition fee is $20 000, to be paid today
• An MBA degree implies a managerial position in the company and a salary increase of $20 000 . The new salary will be paid starting December 31st 2014 and onwards.
• Upon completion of the MBA-program your friend’s new discount rate will be 13% (following higher risk of income decrease)

Your task
Your task is to create a spreadsheet model (using Microsoft Excel) showing your friend which alternative is to prefer from a financial point of view. In particular your friend wants you to show her the following in the spreadsheet model:
a) Show by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose
b) Show by calculation (creating a formula) the discount rate (by replacing the 13% given above) at which your friend ought to be indifferent between not investing in education and investing in the MBA education (assuming she will complete it successfully).
c) Your friend is a bit uncertain about what her discount rate will be if completing an MBA. Therefore she wants you to show in a graph the NPV (with and without income tax) for different discount rates. Use the interval 0% to 100% with 5% subintervals. Set the y-axis as NPV and use the x-axis for the discount rates.
Finally, since your friend wants to be able to use this spreadsheet in the future as well you need to use cell references in the formulas (for tasks a, b and c above).

Related Discussions:- Mr

Trible bottom Line Assignment, I''m studying Accounting course, but English...

I''m studying Accounting course, but English is my second lauguage, it''s vey hard for me to do this, and time is runing out. would you help me with an assignment about the Trible

Establishing the scale and cost of phoenix activity, Q. Establishing the sc...

Q. Establishing the scale and cost of phoenix activity? In 1996, the Australian Securities Commission (ASC, now ASIC) quantified the annual loss to Australian businesses due to

Forecasting demand, The problem considered is that of forecasting demand fo...

The problem considered is that of forecasting demand for single-period products before the period starts. We study this problem for the case of a mail order apparel company that ne

Analysis, Ask question #Minimum 100 words accepted FIN 610 Milestone One Gu...

Ask question #Minimum 100 words accepted FIN 610 Milestone One Guidelines and Rubric Overview: For this first milestone, which is due in Module Three, you will describe each of the

Divident, Critically appraise how companies set their dividend policies, an...

Critically appraise how companies set their dividend policies, and explain the factors that a company will consider in setting its dividend policy and in determining the level of d

Risk aversion and the equity risk premium, Risk Aversion and the Equity Ris...

Risk Aversion and the Equity Risk Premium Case Study On the advice of some of its wealthiest alumni, College has borrowed £15m on a 40-year inflation- linked loan. One year

Speculation and arbitraging in foreign exchange market, Question: a) U...

Question: a) Using illustrative and numerical examples, differentiate between speculation and arbitraging in the context of foreign exchange market. b) One year borrowing

Difference between transaction and translation risk, Question: You have...

Question: You have been appointed as the treasurer of Dockers International, an automobile firm with many subsidiaries abroad. The management of Dockers International is relati

Cost accounting, As What is the major value of the weighted cost of capital...

As What is the major value of the weighted cost of capital calculation for the firm?k question #Minimum 100 words accepted#

Amortizing a loan, Suppose you take out a loan of $10,000, repayable by fiv...

Suppose you take out a loan of $10,000, repayable by five equal annual instalments. The interest rate is 10% per year. (a) How much do you need to repay per year to the nearest ce

Write Your Message!

Captcha
Order Assignment

Featured Services

Order Now

Popular Subjects

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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