Question

In: Finance

No excel please! I am trying to learn the math for Exam! Thank yoU! You have...

No excel please! I am trying to learn the math for Exam! Thank yoU!

You have just joined the investment banking firm of Mckenzie & Co. They have offered you two different salary arrangements. You can have $75,000 per year for the next two years, or you can have $55,000 per year for the next two years, along with a $30,000 signing bonus today. If the interest rate is 12% compounded monthly, which is a better offer? NB: first convert the annual percentage rate of 12% to EAR and use the EAR as the discount rate.

Solutions

Expert Solution

- Interest Rate = 12%compounded monthly

calculating the effective Annual rate:-

Where,

r = Interest rate = 12%

m = no of times compounding in a year = 12 (compounded monthly)

EAR = 1.126825 - 1

EAR = 12.6825%

Arrangement 1: You can have $75,000 per year for the next two years

calculating its Present value today:-

Where, C= Periodic Payments = $75,000

r = Periodic Interest rate = 12.6825%

n= no of periods = 2

Present Value = $125,626.16

Arrangement 2: you can have $55,000 per year for the next two years, along with a $30,000 signing bonus today

Calculating the Present Value of 2-year salary and Signing Bonus

Where, C= Periodic Payments = $55,000

r = Periodic Interest rate = 12.6825%

n= no of periods = 2

Present Value = $122,125.85

So, Arrangement 1 is better as its provides higher value today of Future Salaries.

If you need any clarification, you can ask in comments.    

If you like my answer, then please up-vote as it will be motivating       


Related Solutions

No Excel Please! I am trying to learn the math for the exam! Thank you!! You...
No Excel Please! I am trying to learn the math for the exam! Thank you!! You are 35 years old today and are considering your retirement needs. You expect to retire at age 65 (in 30 years) and you plan to live to age 99. You want to buy a house costing $300,000 on your 65th birthday and your living expenses will be $30,000 a year after that (starting at the end of year 65 and continuing through the end...
No execel please! I am trying to learn the math for the exam! Thank you!! Shanna...
No execel please! I am trying to learn the math for the exam! Thank you!! Shanna wants to buy a house costing $325,000 and has obtained a loan from TD Bank. A minimum down payment of 15% would be required and the bank will provide the difference. Her grandparent have told her that they will cover her down payment. a. TD Bank has quoted her mortgage interest rate is 4.5%; this rate would be compounded semiannually, while her payments would...
Please show how you got the answer. I am trying to learn! Drilling Experts, Inc. Drilling...
Please show how you got the answer. I am trying to learn! Drilling Experts, Inc. Drilling Experts, Inc. (DEI) finds and develops oil properties and then sells the successful ones to major oil refining companies. DEI is now considering a new potential field, and its geologists have developed the following data, in thousands of dollars. t = 0. A $400 feasibility study would be conducted at t = 0. The results of this study would determine if the company should...
(trig based physics) Please explain what is happening, I am trying to LEARN how to do...
(trig based physics) Please explain what is happening, I am trying to LEARN how to do these problems as well! Ignore air resistance and gravity in all questions. 1. When Hydrogen is heated on earth, it emits 4 colours of visible light of wavelengths 410 nm, 434 nm, 486 nm and 656 nm. When Hydrogen on a distant galaxy is observed, the 410 nm light appears to have a wavelength of 409 nm. a) Is the galaxy moving towards earth...
*PLEASE PROVIDE ALL SOLUTIONS USING MICROSOFT EXCEL WITH ANY RELEVANT FORMULAS, thank you!* I have provided...
*PLEASE PROVIDE ALL SOLUTIONS USING MICROSOFT EXCEL WITH ANY RELEVANT FORMULAS, thank you!* I have provided the answers to the questions for reference, I just need to know how to get to them. Samantha is going to retire in 20 years. In order to live comfortably, she thinks she will need to withdraw $10,000 every month during retirement. These monthly withdrawals will be made at the end of each month during retirement. Samantha believes she will live for 35 years...
Exam prep question I am struggling with. Could anyone give me a solution with steps? Thank...
Exam prep question I am struggling with. Could anyone give me a solution with steps? Thank you! You are an executive at WX Resorts and you have executive stock options as part of your compensation. You hold 1,000 options that expire six months from today at a strike price of 50 but that can be exercised early. WX is trading at $55 and just announced a $1 dividend per share that will be paid four months from today to stockholders...
I am not understanding how to do this in excel, I have half of it, but...
I am not understanding how to do this in excel, I have half of it, but not sure where to put the 1100, 2900, 2400, 1500. Questions asked are a plus. M4_A1. Edsel Motors produces cars in Los Angeles and Detroit. The company supplies cars to customers in Houston and Tampa. The costs of shipping a car between various points shown in the table below. The dashes in the table indicate a shipment between locations that is not allowed. Los...
I am trying to implement a search function for a binary search tree. I am trying...
I am trying to implement a search function for a binary search tree. I am trying to get the output to print each element preceding the the target of the search. For example, in the code when I search for 19, the output should be "5-8-9-18-20-19" Please only modify the search function and also please walk me through what I did wrong. I am trying to figure this out. Here is my code: #include<iostream> using namespace std; class node {...
PLEASE ANSWER IN EXCEL FORMAT THAT IS EASILY UNDERSTOOD ONLY, THANK YOU!! (no writing please) [EXCEL]...
PLEASE ANSWER IN EXCEL FORMAT THAT IS EASILY UNDERSTOOD ONLY, THANK YOU!! (no writing please) [EXCEL] Percent of sales: Cattail Corporation's financial statements for the fiscal year just ended are shown below: Cattail Corporation Income Statement Net Sales: $1500 Costs: $350 Net Income: $1150 Balance Sheet Assets $700 = $700 Debt $600 Equity 100 = $700 Cattail management expects sales to increase by 14 percent next year. Assume that the financial statement accounts vary directly with changes in sales and...
I am learning Matlab. I have a math formula such as A(x , y)= (x+1) /...
I am learning Matlab. I have a math formula such as A(x , y)= (x+1) / (y+1), and n=6 How can I write down the for loop in Matlab to express 1 <= x and y < = n? Thanks
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT