Algebraic time value of money equations

Assignment Help Finance Basics
Reference no: EM13839744

Please use Excel financial functions or algebraic time value of money equations in your Excel cell formulas to answer these questions in your spreadsheet in order to receive credit for correct answers.

Should he stay or should he go?

Landon Lowman, the redshirt sophomore 20-year-old star quarterback of the university football team, is approached about skipping his last two years of college and entering the professional football draft. Landon expects that his football career will be over by the time he is 32 years old. Talent scouts estimate that Landon could receive a signing bonus of $5 million today, along with a five-year contract for $3 million per year (payable at the end of each year). They further estimate that he could negotiate a contract for $6 million per year for the remaining seven years of his career. The scouts believe, however, that Landon will be a much higher draft pick if he improves by playing two more years of college football. If he stays at the university, he is expected to receive a $10 million signing bonus in two years, along with a five-year contract for $4 million per year. After that, the scouts expect Landon to obtain a five-year contract for $7 million per year to take him into retirement. Assume that Landon can earn a 7% return over this time.

1. What is the present value today (when Landon is 20) of the QB's future expected NFL earnings if he enters the NFL now?

2. What is the present value today (when Landon is 20) of the QB's future expected NFL earnings if he finishes his last 2 years of college enters the NFL 2 years from now? 3. Should Landon stay in college or go to the NFL now?

Reference no: EM13839744

Questions Cloud

What is the anngle of the particles direction of travel? : what is the anngle of the particles direction of travel?
Compare classical conditioning and operant conditioning : Compare and contrast classical conditioning and operant conditioning. According to the research you have undertaken, which theory is more effective in marketing?
Populate the gantt chart using given table : Use the data from the following table to populate the Gantt chart. You can either treat these as individual tasks, or just make these subtasks of a single task. Either way, you'll need to read the instructions in the spreadsheet to add some rows
What is length of runway required for the plane to take off : What is the length of runway required for the plane to take off
Algebraic time value of money equations : Please use Excel financial functions or algebraic time value of money equations in your Excel cell formulas to answer these questions in your spreadsheet in order to receive credit for correct answers.
Explore some option of msgbox style : Problem 1: Write a sub routine to display the following message. The message should at the top of all other window, and it should prevent the user from doing anything in any application until one of the buttons is clicked.
Conduct a scenario analysis - what is its expected npv : Suppose that the project would be allocated $10,000 of existing overhead costs. Should these costs be included in the cash flow analysis? Explain.
How is phenol converted into salicylic acid : How is phenol converted into salicylic acid
Write about the example of it leveraging business advantage : Write a research report on actual example of IT leveraging business advantage at a managerial level. Your report will be judged on the quality of your research and report presentation.

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd