Question: please do in excel c) Suppose you have a winning DC lottery ticket which pays the following sums at the end of each of the

please do in excel

c) Suppose you have a winning DC lottery ticket which pays the following sums at the end of each of the next ten years $26.000 a year for the first four years, $28,000 each year for the next four years, and $28,000 in years nine and ten. What is the present value of these payouts? part d is extra credit (up to 10 bonus points). Return to question. What is the future value of these payouts (ie, at the end of year 10)? c) Suppose you have a winning DC lottery ticket which pays the following sums at the end of each of the next ten years $26.000 a year for the first four years, $28,000 each year for the next four years, and $28,000 in years nine and ten. What is the present value of these payouts? part d is extra credit (up to 10 bonus points). Return to question. What is the future value of these payouts (ie, at the end of year 10)

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!

A pipe carrying steam through a section of a factory vibrates violently when the driving pump hits a speed of 300 rpm. (See Figure P5.34.) In an attempt to design an absorber, a trial 9-kg absorber...

11-Mar 13-Mar 16-Mar 16-Mar II. Answer parts a), b) and c) to this question. a) A recent SBPA grad has accepted a job as a DC realtor. She estimates her gross pay for the next 3 years is $40,000 in...

A recent SBPA grad has accepted a job as a DC Realtor. She eatimated her gross pay for the next 3 years is 45,000 in year 1, 56,000 in year 2 , and 61,000 in year 3. What is the present value of...

Can anyone solve the answers from the given document givenbelow? I really need help. MY FINAL LITERALLY IS KNOCKING AT THE DOOR. Name_________________________________ Student...

1. A bank is paying interest at a 5% annual rate on deposits. If you invest 10,000 and the bank compounds interest daily (i.e., 365 times per year), which of the following shows how much you will...

HellonDr.Ramsey Can you assist me with my discussion please, Min 150 words due Friday. Basic Time Value of Money It is a common fact that many lottery winners are ?broke? sooner than later. If you...

SOMEONE PLEASE HELP ME GIVE ALL THE ANSWERS!!!!! MY EXAM IS ON 13th MORNING! SO PLEASEEEEE!!!!! 2. An investment is expected to pay the following: C 1 = $2,300, C 2 = $2,600, C 3 = $2,900, and then...

Financial Planning. Excel, please! 10. Financial Planning. Your sister has just won $300,000 (taxfree) in the state lottery. She's decided to quit her job and devote herself to writing novels for the...

Question 18 Hogan Company has $1,000,000 of bonds outstanding. The unamortized premium is $14,400. If the company redeemed the bonds at 101, what would be the gain or loss on the redemption? $10,000...

PLEASE SOLVE THIS BY EXCEL. THANK YOU FOR YOUR HELP!!! 10. Financial Planning. Your sister has just won $300,000 (taxfree) in the state lottery. She's decided to quit her job and devote herself to...

How does the purchase of supplies on account affect the accounting equation? a. assets increase; liabilities decrease b. assets increase; stockholders equity decreases c. liabilities increase;...

A Petrolplus Ltd (Petrolplus) company has owned a site at 25 Victoria Parade, Bayside VIC 3191 for the past 30 years. A service station with 10 fuel pumps is located on the site. The service station...

Average collection period: Credit sales are 60% of total sales 124800. accounts receivable closing balance is 8000

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...

How can you follow the principles of business communication in your composing efforts and still reflect your own personality in your messages? (Objective 5)

Use short words. Use a print or electronic thesaurus or dictionary to select short words to replace these long words: (a) whimsical, (b) facsimile, (c) consolidate, (d) reproduction, (e) reasonable,...