Archibald Andrews has just learned that he won $1,040,000 in the lottery. Archie has three options for payment: Option A: a lump-sum payment of $1,040,000 right now, in which case 45% will be deducted for taxes. We do not  know the level of Archie’s investment skills and therefore are unsure what rate of return he will earn on the lump sum. Option B: 20 equal annual payments of $72,000, the first to occur immediately. Taxes of 25% of will be deducted from each payment. Assume an inherent interest rate of 8% APR. Option C: 36 equal semi-annual payments of $36,000, the first to occur in exactly one year. Taxes of 15% will be  deducted from each payment. For this option, assume interest of 8% APR, compounded semi-annually. Calculate the present value of each option A, B, and C.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter27: Time Value Of Money (compound)
Section: Chapter Questions
Problem 6E
icon
Related questions
Question

Archibald Andrews has just learned that he won $1,040,000 in the lottery. Archie has three options for payment:
Option A: a lump-sum payment of $1,040,000 right now, in which case 45% will be deducted for taxes. We do not 
know the level of Archie’s investment skills and therefore are unsure what rate of return he will earn on the lump sum.
Option B: 20 equal annual payments of $72,000, the first to occur immediately. Taxes of 25% of will be deducted
from each payment. Assume an inherent interest rate of 8% APR.
Option C: 36 equal semi-annual payments of $36,000, the first to occur in exactly one year. Taxes of 15% will be 
deducted from each payment. For this option, assume interest of 8% APR, compounded semi-annually.
Calculate the present value of each option A, B, and C.

Expert Solution
steps

Step by step

Solved in 4 steps with 7 images

Blurred answer
Knowledge Booster
Types of Property
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
CONCEPTS IN FED.TAX., 2020-W/ACCESS
CONCEPTS IN FED.TAX., 2020-W/ACCESS
Accounting
ISBN:
9780357110362
Author:
Murphy
Publisher:
CENGAGE L
SWFT Comprehensive Vol 2020
SWFT Comprehensive Vol 2020
Accounting
ISBN:
9780357391723
Author:
Maloney
Publisher:
Cengage
SWFT Comprehensive Volume 2019
SWFT Comprehensive Volume 2019
Accounting
ISBN:
9780357233306
Author:
Maloney
Publisher:
Cengage
SWFT Individual Income Taxes
SWFT Individual Income Taxes
Accounting
ISBN:
9780357391365
Author:
YOUNG
Publisher:
Cengage