Calculate the irr and npv

Assignment Help Financial Management

Reference no: EM131907124

1) Sigma Tech: You can stay at Sigma and pay $57,500 a year for 4 years. Upon graduation, your starting salary will be $75,000 per year and will increase by 2.5% per year until you retire. You will work for 30 years after graduation and then retire. Assume no inflation.

2) Online4U: You are also thinking of going to a new online university, Online4U, which only costs $15,000 per year. However, you will also have to obtain an additional certificate at the end of the fourth year, which costs $5,000. Then you have to renew your professional certificate every 5 years at the same $5,000 cost. Upon graduation (after 4 years), your starting salary will be $60,000 and will grow by 2% per year. Assume you will also work for 30 years after graduation.

Your discount rate is 7%. PLEASE CALCULATE IRR AND NPV AND SHOW WORK IN EXCEL

Reference no: EM131907124

Questions Cloud

How can social issues create value : How might a package be designed to induce Roberta to stay with the target firm, even if her future at the firm is threatened by a merger?

Formula for the single sample test : What is the 99% margin of error? Show the formula for the single sample test (make sure you specify the test statistics you would use.)

Describe a possible sampling method : Describe a possible sampling method in three to five complete sentences. Make the description detailed.

What is maximum number of characters that will change : What is the maximum number of characters that will he changed in the cipher next if only a single character is changed in the plaintext?

Calculate the irr and npv : You can stay at Sigma and pay $57,500 a year for 4 years. Upon graduation, your starting salary will be $75,000 per year and will increase by 2.5% per year.

What is the maximum number of characters that will be change : In each of the following ciphers. what is the maximum number of character that will be changed in the cipher text if only one character is changed in palm text?

Calculate the margin of error : Calculate the margin of error (round to 3 decimals) for a 95% confidence interval for the proportion of all American adults

How eve decide substitution or transposition cipher was used : How can Eve decide whether a substitution or a transposition cipher was used? How can she decide whether it was an additive, multiplicative, or affine cipher?

What happens if you exercise when the futures price : A put option on gold is struck at $1237. What happens if you exercise when the futures price is $1209 and the futures contract settles at $1211?

User Account

All Pages