Question: solve and show using excel formulas 18. Your friend just won the lottery. He has the choice of receiving $50,000 a year for the next

solve and show using excel formulas

18. Your friend just won the lottery. He has the choice of receiving $50,000 a year for the next 20 years or a lump sum today. The lottery uses a 15% discount rate in determining its lump sum payout. What would be the lump sum your friend would recelve, if he chooses that option

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Dr.Ramsey Please assist me with my discussion post. Subject: Annuities Systematic risk evaluates the probability and extent of negative consequences to the larger body. For example, the government...

please show formulas to use in excel for the calculations your workbook named "Investment Analysis". Please include an input area and an answer area for each problem. You will have an answer for each...

show work in excel please Of 6.5 percent? 4. A producer gets a loan to purchase a new piece of equipment for $250,000. What is the annual principal and interest payment for the loan with annual...

show formulas in excel 5. Assume you have won the lottery and have the choice of (1) receiving $1,000,000 now or (2) receiving $120,000 each year for 20 years. Opportunity cost of capital is 10...

Pretend for a moment that you won $1,000,000 in the state lottery and had a choice between receiving $50,000 a year for 20 years or receiving a one-time payment immediately for $560,000. After...

I am wondering if anyone has corrected solutions to fnce 300 assignments 1 2 and 3. I am concered about my answers and would love to compare. Pretty sure on my answers for 1 and 2 mainly interested...

First, complete page one of the worksheet first by closely following the directions of each question. Much of the assignment is subjective based on your own financial goals, but the math is objective...

I am looking for help withthis assignment. Spring 2017 FNCE 370v9: Assignment 2 Assignment 2 is worth 5% of your final mark. Complete and submit Assignment 2 after you complete Lesson 6. Questio n 1...

FNCE 370v9: Assignment 2 Assignment 2 is worth 5% of your final mark. Complete and submit Assignment 2 after you complete Lesson 6. Questio n 1 2 3 4 5 6 7 8 9 10 11 Total Marks available 20 3 20 13...

Complete tabs 6.1, 6.4, 6.7, 6.9, 6.12, 6.16, 6.23, and 6.33 in the attached Chapter 6 Excel spreadsheet. An EXAMPLE tab is provided in the spreadsheet for your guidance. You must use formulas in the...

A box has numbers from 1 to 10. A number is drawn at random. Let X1 be the number drawn. This number is replaced, and the ten numbers mixed. A second number X2 is drawn. Find the distributions of X1...

On December 1, 2017, Prosen Distributing Company had the following account balances. Debit Credit Cash $?7,200 Accumulated DepreciationEquipment Accounts Receivable 4,600 $?2,200 Inventory 12,000...

Prompts Investigators mailed postcards to every household in metro Atlanta to find controls for a case - control study looking at risk factors for dementia. Of the 1 , 0 0 0 , 0 0 0 postcards mailed,...

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

1-9 In this project, you will start out with raw transactional sales data and use Microsoft Access database software to develop queries and reports that help managers make better decisions about...

1-11 In MyMISLab, you will find a Collaboration and Teamwork Project dealing with the concepts in this chapter. You will be able to use Google Drive, Google Docs, Google Sites, Google+, or other...

1-12 What kinds of applications are described in this case? What business functions do they support? Mashaweer is the first personal service company in Egypt. Its purely dedicated to saving its...