Question

Present value of an annuity On January 1, you win $50,000,000 in the state lottery. The...

Present value of an annuity On January 1, you win $50,000,000 in the state lottery. The $50,000,000 prize will be paid in equal installments of $6,250,000 over eight 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.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 Determine the present value of your winnings. Round your answer to the nearest dollar.

$

Present value of an annuity
DATA
Sum of prize $50,000,000
Annual payment $6,250,000
Number of years 8
Interest rate 5.5%
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

Homework Answers

Answer #1
Issue price of bonds Period Cashflows Present value Calculation
1 $62,50,000 $59,24,171 (6250000/(1+0.055)^1)
2 $62,50,000 $56,15,328 (6250000/(1+0.055)^2)
3 $62,50,000 $53,22,585 (6250000/(1+0.055)^3)
4 $62,50,000 $50,45,105 (6250000/(1+0.055)^4)
5 $62,50,000 $47,82,090 (6250000/(1+0.055)^5)
6 $62,50,000 $45,32,786 (6250000/(1+0.055)^6)
7 $62,50,000 $42,96,480 (6250000/(1+0.055)^7)
8 $62,50,000 $40,72,493 (6250000/(1+0.055)^8)
PV of Bond $3,95,91,037
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
On January 1, you win $4,240,000 in the state lottery. The $4,240,000 prize will be paid...
On January 1, you win $4,240,000 in the state lottery. The $4,240,000 prize will be paid in equal installments of $530,000 over 8 years. The payments will be made on December 31 of each year, beginning on December 31. If the current interest rate is 6%, determine the present value of your winnings. Use the present value tables in Exhibit 7. Round to the nearest whole dollar.
7.) You win a lottery prize that has a total value (after taxes) of $35,850,000. 30...
7.) You win a lottery prize that has a total value (after taxes) of $35,850,000. 30 yearly payments of $1,195,000 would be made if you took the winnings over the 30 year payout with the first payment being made immediately and the remaining equal payments being made yearly at the beginning of each year. The lottery would buy an annuity which has an annual interest rate of 5.2%. You elect the alternative and take the cash value of this annuity...
Partial-year depreciation DATA Cost $100,000 Estimated residual value $6,000 Estimated useful life (in years) 8 Placed...
Partial-year depreciation DATA Cost $100,000 Estimated residual value $6,000 Estimated useful life (in years) 8 Placed into service on May 1 End on the fiscal year December 31 Using formulas and cell references, perform the required analysis, and input your answers into the Amounts column. Transfer the numeric results for the green entry cells (C13:C16) into the appropriate fields in CNOWv2 for grading. Amounts Formulas a. Depreciation (Straight-line method), Year 1 Depreciation (Straight-line method), Year 2 b. Depreciation (DDB method),...
Net present value method The following data are accumulated by Geddes Company in evaluating the purchase...
Net present value method The following data are accumulated by Geddes Company in evaluating the purchase of $160,000 of equipment, having a four-year useful life: Net Income Net Cash Flow Year 1: $42,000 $82,000 Year 2: 22,500 62,500 Year 3: 10,000 50,000 Year 4: 6,000 46,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a) Assuming that the desired rate...
Present/future value computations 1. How much must be deposited on January 1, 2013 to accumulate a...
Present/future value computations 1. How much must be deposited on January 1, 2013 to accumulate a balance of $50,000 on December 31, 2017? At interest rate of 3.5% At interest rate of 6% 2. 50,000 is deposited at interest compounded annually what amount will be on hand in seven years At 4%? At 8% 2A. What if 50,000 is deposited at interest compounded semi-annually what amount will be on hand in seven years At 4%? At 8% 3. How much...
A Kubota tractor acquired on January 8 at a cost of $62,000 has an estimated useful...
A Kubota tractor acquired on January 8 at a cost of $62,000 has an estimated useful life of 10 years. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Assuming that it will have no residual value, determine the depreciation for each of the first two years: by the straight-line method. Round your answers to the nearest dollar. First Year Second...
Present Value of $1 PV of Annuity of $1 Issuance of a Bond at Face Value...
Present Value of $1 PV of Annuity of $1 Issuance of a Bond at Face Value On January 1, 2017, Whitefeather Industries issued 1,100, $1,000 face value bonds. The bonds have a(n) 10-year life and pay interest at the rate of 10%. Interest is paid semiannually on July 1 and January 1. The market rate of interest on January 1 was 10%. Use the present value tables that may be found by clicking on the present value table links above....
Financial Statement Impact of a Lease GEORGE's Warehouse signed a six-year capital lease on January 1,...
Financial Statement Impact of a Lease GEORGE's Warehouse signed a six-year capital lease on January 1, 2016, with payments due every December 31. Interest is calculated annually at 10%, and the present value of the minimum lease payments is $11,455. Use the appropriate present value table: PV of $1 and PV of Annuity of $1 Required: 1. Calculate the amount of the annual payment that GEORGE's must make every December 31. Round your answer to the nearest whole dollar. Lease...
Present Value of an Annuity Find the present value of the following ordinary annuities. Round your...
Present Value of an Annuity Find the present value of the following ordinary annuities. Round your answers to the nearest cent. (Notes: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second...
Net present value—unequal lives Bunker Hill Mining Company has two competing proposals: a processing mill and...
Net present value—unequal lives Bunker Hill Mining Company has two competing proposals: a processing mill and an electric shovel. Both pieces of equipment have an initial investment of $710,000. The net cash flows estimated for the two proposals are as follows: Net Cash Flow Year      Processing Mill      Electric Shovel 1 $311,000 $345,000 2 257,000 315,000 3 257,000 322,000 4 262,000 323,000 5 182,000 6 144,000 7 139,000 8 139,000 The estimated residual value of the processing mill at the end...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT