Present value of an annuity On January 1, you win $43,500,000 in the state lottery. The $43,500,000 prize will be paid in equal installments of $7,250,000 over six years. The payments will be made on December 31 of each year, beginning on December 31 of this year. The current interest rate is 5%. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet Present value of an annuity DATA Sum of prize $43,500,000 Annual payment $7,250,000 Number of years 6 Interest rate 5.0% Date of win January 1 Date of payments December 31 of each year Using formulas and cell references, perform the required analysis, and input your answer into the Amount column. Transfer the numeric result for the green entry cell (B14) into the appropriate field in CNOWv2 for grading. Amount Formula PV of annual payments
Present value of an annuity On January 1, you win $43,500,000 in the state lottery. The $43,500,000 prize will be paid in equal installments of $7,250,000 over six years. The payments will be made on December 31 of each year, beginning on December 31 of this year. The current interest rate is 5%. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet Present value of an annuity DATA Sum of prize $43,500,000 Annual payment $7,250,000 Number of years 6 Interest rate 5.0% Date of win January 1 Date of payments December 31 of each year Using formulas and cell references, perform the required analysis, and input your answer into the Amount column. Transfer the numeric result for the green entry cell (B14) into the appropriate field in CNOWv2 for grading. Amount Formula PV of annual payments
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 7E
Related questions
Question
On January 1, you win $43,500,000 in the state lottery. The $43,500,000 prize will be paid in equal installments of $7,250,000 over six years. The payments will be made on December 31 of each year, beginning on December 31 of this year. The current interest rate is 5%. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.
Present value of an annuity | ||
DATA | ||
Sum of prize | $43,500,000 | |
Annual payment | $7,250,000 | |
Number of years | 6 | |
Interest rate | 5.0% | |
Date of win | January 1 | |
Date of payments | December 31 of each year | |
Using formulas and cell references, perform the required analysis, and input your answer into the Amount column. Transfer the numeric result for the green entry cell (B14) into the appropriate field in CNOWv2 for grading. | ||
Amount | Formula | |
PV of annual payments |
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
![Intermediate Accounting: Reporting And Analysis](https://www.bartleby.com/isbn_cover_images/9781337788281/9781337788281_smallCoverImage.jpg)
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
![Intermediate Accounting: Reporting And Analysis](https://www.bartleby.com/isbn_cover_images/9781337788281/9781337788281_smallCoverImage.jpg)
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning