Question

show the student's calculator set-up (using the variables from a financial calculator) and answers for each...

show the student's calculator set-up (using the variables from a financial calculator) and answers for each of the 3 parts in the problem. For part c, give an exact percentage answer and not an approximate answer. Clearly identify your answers to each part.

Assume that you just won the state lottery. your prize can be taken either in the form of 40000 at the end of each of the next 25 years (that is 1,000,000 over 25 years) or as a single amount of 500,000 paid immediately.

a. if you expect to be able to earn 5% annually on your investments over the next 25 years, ignorning taxes and other considerations, which aternative should you take? why?

b. would your decision in part a change if you could eaern 7% rather than 5% on your investments over the next 25 years? why?

c. on a strictly economic basis, at approximately what earning rate would you be indifferent between the two plans?

Homework Answers

Answer #1

a) Let's calculate the present value of 25 cash flows using PV function on calculator

N = 25, I/Y = 5%, PMT = 40,000, FV =0 => Compute = $563,757.78 > a single payment of $500,000

Hence, you should take the annual payment for 25 years.

b) If I/Y = 7% => PV = $466,143.33 < a single payment of $500,000

Hence, you should take the single payment.

c) Indifferent rate can be calculated using I/Y

N = 25, PMT = 40,000, PV = -500,000, FV = 0 => Compute I/Y = 6.24%

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Value of an annuity versus a single amount Assume that you just won the state lottery....
Value of an annuity versus a single amount Assume that you just won the state lottery. Your prize can be taken either in the form of $40,000 at the end of each of the next 25 years (that is, $1,000,000 over 25 years) or as a single amount of $500,000 paid immediately. PLEASE SHOW ALL WORK OR EXCEL FUNCTIONS a. If you expect to be able to earn 5% annually on your investments over the next 25 years, ignoring taxes...
Assume that you just won the Open Golf Championship. Your prize can be taken either in...
Assume that you just won the Open Golf Championship. Your prize can be taken either in the form of RM50,000 at the end of each of the next 25 years (That is RM1,000,000 over 25 years) or as a single amount of RM500,000 paid immediately. If you expect to be able to earn 5% annually on your investments over the next 25 years, ignoring taxes and other considerations, which alternative should you take? Why?                                                                                                            You were offered two...
Assume that you have just won a state award. Your prize can be taken either in...
Assume that you have just won a state award. Your prize can be taken either in the form of RM1 million at the end of each of the next 20 years (that is, RM 20,000,000 over 20 years) or a single amount of RM10 million paid immediately. If you expect to earn 10% annually on your investments over the next 20 years, ignoring taxes and other considerations, which alternative should you take? Why?
1) Your company is planning to borrow $1,000,000 on a 3-year, 8%, fully amortized, term loan....
1) Your company is planning to borrow $1,000,000 on a 3-year, 8%, fully amortized, term loan. Payments for this loan are made at the end of each year, in equal installments. a. What is the amount of each annual payment? b. What will be the amount of the principal paid in the second yearly installment? c. What will be the amount of interest paid in the third yearly installment? 2) A stock is not expected to pay a dividend over...
Each question will be labeled as a calculator or formula question. For calculator problems , you...
Each question will be labeled as a calculator or formula question. For calculator problems , you are to label and input all the variables of interest: N, I/Y, PV, PMT, FV (and Begin mode if you switch). the unknown variable should be indicated by a ? symbol. Once solved, rewrite the variable identifier with the correct answer. For the formula problems, set up the problem and solve. Be sure to show each step for credit. Answer each question in BB...
Congratulations!!!!!! You just won a lottery. It will pay you $1,000,000 ten years from today. You...
Congratulations!!!!!! You just won a lottery. It will pay you $1,000,000 ten years from today. You were watching TV late last night and heard an ad for one of those companies willing to buy your lottery prize in ten years for an immediate single cash payment: a. What is the least you would sell the claim for if you can earn 6% on an investment of comparable risk? b. If 6 percent is the appropriate interest rate and the settlement...
Solve using a financial calculator: please show each step you use on the financial calculator! 1....
Solve using a financial calculator: please show each step you use on the financial calculator! 1. Given the following information, calculate the NPV for this property. Initial cash outflow: $200,000, Discount rate: 15%, CF for year 1: $25,876, CF for year 2: $23,998, CF for year 3: $23,130, CF for year 4: $22,105, CF for year 5: $144,670. Draw your cash flow diagram and show your steps used in financial calculator. 2. Suppose you purchased an income producing property for...
Option​ #1: $15,000,00 five years from now Option​ #2: $2,200,000 at the end of each year...
Option​ #1: $15,000,00 five years from now Option​ #2: $2,200,000 at the end of each year for the next five years Option​ #3: $11,500,000 3 years from now ​Congratulations! You've won a state​ lotto! The state lottery offers you the following​ (after-tax) payout​ options: Requirement Assuming that you can earn 8​% on your​ funds, which option would you​ prefer? ​(Round your answers to the nearest whole​ dollar.) Calculate the present value for each payout.
WEEK 4 FIN CORP (ASSNGMNET) SHOW YOUR CALCULATIONS FOR #7-#20. You have the option of performing...
WEEK 4 FIN CORP (ASSNGMNET) SHOW YOUR CALCULATIONS FOR #7-#20. You have the option of performing calculations manually BUT ARE STRONGLY ENCOURAGEDto use a financial calculator or spreadsheet. Either way, you must specify what is being calculated to earn credit: 1,If you are earning a salary of $42,000 in 2018 and expect to receive 4% raises per annum on January 1, what do you anticipate your salary will be in 2027? 2.What is the future value of $5,000 invested for...
Work problem 1a and 1b with your calculator, using the algebra equations if possible (show work),...
Work problem 1a and 1b with your calculator, using the algebra equations if possible (show work), and using the finance = function available in your spreadsheet Show what Algebraic Formula you use. Submit a screenshot of this sheet filled out with the algebraic calculations, and submit your excel spreadsheet. a          Suppose your Uncle died and provided in his trust that you will receive $5,000 at the end of each year for the next 10 years. Assume you can earn 8.5%...