Calculate the crossover rate

Assignment Help Financial Management

Reference no: EM132065034

Financial Modeling

Question#1

You have just received a $15,000 signing bonus from your new employer and decide to invest it for 2 years. Your banker suggests two alternatives, both of which require a commitment for the full 2 years. The first alternative will earn 8% per year for both years. The second alternative earns 6% for the first year and 10% for the second year. Interest compounds annually. Which alternative should you choose?

Question#2

You are the CFO of Termination, Inc. Your company has 40 employees, each earning a salary of $40,000/year. Employee salaries grow at 4% per year.

Starting from next year, and every second year thereafter, eight employees retire and no new employees are recruited. Your company has in place a pension plan that entitles retired workers to an annual pension which is equal to their annual salary at the moment of retirement. Life expectancy is 20 years after retirement, and the annual pension is paid at year-end. The return on investment is 10% per year. What is the total value of your pension liabilities as of now?

Hint: The total value of your pension liabilities will be the sum of the PV of pension liability of each retirement cohort.

Question#3

Anna just turned 55. She is planning to retire in 10 years, and she currently has $500,00 in her 401k fund. She assumes that she will live 20 years past her retirement age. During each of these 20 years, she desires to withdraw $100,000 from her retirement fund. If the interest rate is 5% annually, how much will Anna have to save per year for the next 10 years (from 55 to 64)? Assume that the first deposit to her retirement fund will be today, followed by nine more annual deposits, and that the annual withdrawals from age 65 will occur at the beginning of each year.

Question#4

Your firm is considering two mutually exclusive projects with cash flows as indicated in the Excel file. A) What is the NPV and IRR for the two projects, respectively? B) Calculate the crossover rate.

Question#5

In purchasing a house that is worth $175,000, you need to obtain a mortgage. Suppose you choose a 30- year fixed rate mortgage with an interest rate/year of 9.74%. What is the annual payment required? How much of each year's payment goes to paying interest and how much to reducing the principal balance?

Question#6

You are trying to decide whether to lease a car for four years or buy a new car now and sell it for four years later. The annual lease payment would be $6,300 with payments made at the beginning of each year. The new car price is $47,000 now. Four years later, you are expected to sell the car for $33,000. The appropriate discount rate for this project is 7.2%.

Should you buy or lease? Use the present value comparison method

Attachment:- Homework- data.rar

Reference no: EM132065034

Questions Cloud

Taking a page from social networking : Now companies are taking a page from social networking sites to make the performance evaluation process more fun and useful. Accenture has developed

Possibility of the landlord leasing : You are the operator of a drug store, Fencegreen's, and negotiating a new lease in a Shopping Center, draft a clause that would address the Tenant

Obtain your 4-letter type formula according to carl jungs : Bearing in mind your own personality profile (from your MBTI results), consider what challenges would you face and how you would overcome these.

What is globecom business strategy : What is GlobeCom's business strategy? What is GlobeCom's corporate strategy in regards to Sports America?

Calculate the crossover rate : AF 426: You are the CFO of Termination, Inc. Your company has 40 employees, each earning a salary of $40,000/year. Employee salaries grow at 4% per year.

Misbehaviour of individuals in position of trust : There is no shortage of discussion in the press regarding corporate scandals and misbehaviour of individuals in position of trust.

Prepare journal entries for listed transactions and events : The following are selected transactions of Graves Company. Prepare journal entries for the listed transactions and events

Identify and explain the type of consumer product : Identify and explain the type of consumer product that you have selected. Identify the selected product’s three layers. You may use a diagram or chart.

Determine pro-forma financials for years : Determine pro-forma financials for years 2018-22. Set your own optimal Capital Raising and Dividend policies.

User Account

All Pages