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.

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.

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter4: Time Value Of Money

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

What is the NPV of the following cash flows if the required rate of return is 0.09? Year 0 1 2 3 4 CF -6,816 3,577 3,505 2,732 3,757
What is the NPV of the following cash flows if the required rate of return is 0.09? Year 0 1 2 3 4 CF -3,935 687 1,937 3,189 968 Enter the answer with 2 decimals (e.g. 1000.23).
Find the PV of the following Cash Flows: $50; $150; $200 and $100 if the interest rate is 0%
Define the term reinvestment rate and describe how it differs for any cash flow series between (1) a PW value calculated at the MARR, and (2) the IROR value i*.
Which of the following discounts future cash flows to their present value at the expected rate of return, and compares that to the Initial Investment? A. internal rate of return (IRR) method B. net present value (N PV) C. discounted cash flow model D. future value method
Tasks/ calculation these questions are :- by 6 functions are : 1. Accumulative (future) money value 1/ Simple interest FV=PV*(1+* ? *N) 2/ Aggregate interest FV=PV (1+ ? )N 2. Present money value PV = FV * ^note N- total times of getting income^ R= ?????? ??? / N n- frequency of income generation per year 3. Present payment value PV = PMT * 4. Future payment value (PMT) FV = PMT * 5. Amortization payment PMT = PV * 6. Solatium fond factor (SFF) PMT = FV * Q1/ The investor wants to invest in the purchase of an office building. He suggests he can rent it out for 10 years at an annual rent of 1,850,000. At the end of the tenth year it is expected to sell the company for 18 million d.e. Income rate 20% What is the current value of the building?
Which figure of merit provides an interest rate at which the present value of the future cash flows equals the amount invested? a) NPV b) IRR c) Cap Rate d) DCF Please ensure accuracy and explain your choice
Which of the following cash flow streams could be evaluated using the basic Internal Rate of Return (IRR) method? A. CF1 $100 CF2 = -$20 CF3 - $20 B. CF1 =-$100 CF2 $20 CF3 $20 c. CF1 -$100 CF2 = $20 CFJ -$20 D. CF1 $100 CF2 = $20 CFJ $20 All of the above E.
The factor ( 1 + i ) n in the formula is known as the future-value factor (FVF) or _____________ factor of a single amount. Select one: a. compound-interest b. capital-interest c. original-investment d. variable-interest.
Consider two assets with the following cash flow streams: Asset A generates $4 at t=1, $3 at t=2, and $10 at t=3. Asset B generates $2 at t=1, $X at t=2, and $10 at t=3. Suppose X=6 and the interest rate r is constant. Suppose r=0.2. Find the value X such that the present value of asset B is 12. Suppose the (one-period) interest rates are variable and given as follows: r01=0.1,r12=0.2, r23=0.3. Calculate the yield to maturity of asset A. (You can use Excel or ascientific calculator to find the solution numerically.)
Choose the correct option- "This is the rate at which present value of cash inflows are equal to the present value of cash outflows". a. NPV b. IRR c. Payback period
What is the net present value of the following set of cash flows at a discount rate of 5 percent? At 15percent? Multiple Choice $1, 018.47; -$628.30 $1,620.17: $2, 618.99 $1,620.17: $525.13 $722.09; - S1,708.16 $722.09: $418.05