You are scheduled to graduate from the college student in May.You have received two job offers as follows:A position at a large accounting firm with a salary offer of $70,000/year. The firm typically provides annual pay raises in the amount of 4% per year. You will likely be promoted every other year andreceive a $10,000 raise at the time of each promotion.A position at a bank with a salary of $78,000/year. The firm typically provides annual pay raises in the amount of 4% per year. You will not be eligible for promotion until your 5th year and will have tochange employers after that to obtain further promotions.The benefits, hours, working conditions, and other factors relating to the two positions are otherwise indistinguishable.Using a ten-year time horizon and a 5% discount rate, what is the present value of each position?Considering only the monetary factors, which position should you accept, why?In today's money, how much better is the more favorable of the two positions in dollars?

When a person measures the future value of a sum by converting it to its current equivalent…

Answered: You are scheduled to graduate from the…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

In January, you start a job with Acme manufacturing at salary of $66,000 per year paid in equal amounts over 12 months. You have negotiated for a guaranteed 3% raise each year while you work at Acme and you decide to save 10% of your monthly income for retirement. Assume interest equals 1%/month compounded monthly. What is the balance of your retirement account at the end of five years?
You’ve just joined the investment banking firm of Dewey, Cheatum, and Howe. They’ve offered you two different salary arrangements. You can have $79,000 per year for the next two years, or you can have $68,000 per year for the next two years, along with a $24,000 signing bonus today. The bonus is paid immediately, and the salary is paid in equal amounts at the end of each month. If the interest rate is 9 percent compounded monthly, what is the value today of each option? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)
Michael Scott is 30 years old at the beginning of the year and is thinking about getting an MBA. Michael is currently making $40,000 per year and expects the same for the remainder of his working years (until age 65). If he goes to a business school, he gives up his income for two years and, in addition, pays $20,000 per year for tuition. In return, Michael expects an increase in his salary after his MBA is completed. Suppose that the post-graduation salary increases at a 5% per year and that the discount rate is 8%. What is minimum expected starting salary after graduation that makes going to a business school a positive-NPV investment for Michael? For simplicity, assume that all cash flows occur at the end of each year. This is about time value of money, need excel for formula and solution, u can use shortcut in excel if applicable like PMT NPER and etc.
The profit - maximizing manager of Big Farms wants to purchase a large piece of farm equipment. The manager has two financing options from two different banks. Big Bank will allow the manager to make five equal payments of $22,000 at the end of each of the next five years. Best Bank will allow the manager to make a payment of $10,000 at the end of the next four years and then make a balloon payment of $72,000 at the end of the fifth year. If the interest rate is 4 percent, which of the following statements is true? OA. The present value of the two payment plans is exactly the same, so the manager of Big Farms is indifferent between the two payment plans. OB. The manager of Big Farms should select Big Bank's offer as the present value of the payment plan is $97,939.60, which is lower than the payment plan offered by Best Bank. OC. The manager of Big Farms should select Big Bank's offer because the total repayment less than the total repayment at Best Bank. D. The manager of Big Farms…
You have just finished your undergraduate degree and you have two career options: Option 1: Accepting a job offer with the starting salary of $75,000 per year (paid at the end of the year) and an annual raise of 2% pa (guaranteed). You will work in this company for 40 years. Option 2: Choosing a graduate program which will cost you $28,000 per year for the next two years (paid at the beginning of each year). Following the graduate school, you can get a job that offers the initial salary of $85,000 (paid at the end of the Year 3) with an annual raise of 3% pa (guaranteed). You will work in this company for 38 years. a. If you use the discount rate of 10% pa, which option is more lucrative for you? b.At what discount rate will you be indifferent between these two career options? (Hint: You need to use the incremental cash flows to answer this question) c. If option 2 (i.e., work after grad school) comes with a signing bonus (paid at the beginning of Year 3), at what signing bonus will…
Professor Wendy Smith has been offered the following opportunity: A law firm would like to retain her for an upfront payment of $50,000. In return, for the next year the firm would have access to eight hours of her time every month. As an alternative payment arrangement, the firm would pay Professor Smith's hourly rate for the eight hours each month. Smith's rate is $540 per hour and her opportunity cost of capital is 16% per year. What does the IRR rule advise regarding the payment arrangement? (Hint: Find the monthly rate that will yield an effective annual rate of 16%.) What about the NPV rule? The annual IRR is %. (Round to two decimal places.)
Please only anser in Excel format, including lay out, formulas and screenshots. mary finds a job earning $55, 000 per year with a 2% raise every year. What will be her year end cash flo's future value (value at Time 40) at 4.5% interest rate per year compounded monthly, over 40 - year working career?
You are offered a job that pays $37,000 during the first year with an annual increase of 9% per year beginning in the second year. That is, beginning in year 2, your salary will be 1.09 times what it was in the previous year. What can you expect to earn in your fourth year on the job? Round your answer to the nearest dollar.
Professor Wendy Smith has been offered the following opportunity: A law firm would like to retain her for an upfront payment of $49,000. In return, for the next year the firm would have access to eight hours of her time every month. As an alternative payment arrangement, the firm would pay Professor Smith's hourly rate for the eight hours each month. Smith's rate is $550 per hour and her opportunity cost of capital is 16% per year. What does the IRR rule advise regarding the payment arrangement? (Hint: Find the monthly rate that will yield an effective annual rate of 16%.) What about the NPV rule? The annual IRR is 14.96 %. (Round to two decimal places.) The IRR rule advises: (Select the best choice below.) A. Since the IRR is less than the cost of capital, 16%, Smith should turn down this opportunity. OB. With an IRR of 16% and with Smith's cost of capital at 14.96%, according to the IRR rule, she should reject this opportunity. C. Since the IRR is less than the cost of capital, 16%,…
Candace just accepted her first job paying a $48,000 salary and is planning to take a $5,000 vacation cruise throughout Europe for 2 weeks. She is debating whether to take the trip now and finance it with a promotion from the travel company offering no payments for a year at a monthly periodic rate of 1%, or wait the year and save to pay for the trip. If she takes the trip now she will start her career 2 weeks late. Approximately how much would she save by waiting a year and not taking her unpaid time from work to travel? $2,480. $634. $1,557. $600.
Please please solve in excel Only Only excel and show step

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS