Homework Answers
To calculate Present Value in Excel following formula should be used:-
=PV (rate, nper, pmt, [fv], [type])
Arguments
- rate - The interest rate per period.
- nper - The total number of payment periods.
- pmt - The payment made each period.
- fv - [optional] A cash balance you want to attain after the last payment is made. If omitted, assumed to be zero.
- type - [optional] When payments are due. 0 = end of period, 1 = beginning of period. Default is 0
In Our Case,
If,
A1=15000
A2=10%
A3=10
Then,
=PV(A2,A3,A1,0,0)
And our Answer will be 92168.51
Add Answer to:
5 Use Excel to compute the present value of 10 equal payments of $15,000, with an...
Fill in the tables Use present value tables to compute the present value of $660,000 to...
Fill
in the tables
Use present value tables to compute the present value of $660,000 to be paid in 20 years, with an interest rate of 8 percent. (Future Value of $1, Present Value of $1, Future Value Annuity of $1, Present Value Annuity of $1) (Use appropriate factor(s) from the tables provided and final answer to the nearest whole dollar amount.) Table Function: Future Value: Present Value: Use present value tables to compute the present value of 20 equal...
Present Value of an Annuity 1) On January 1, 2016, you win $2,600,000 in the state lottery. The $2,600,000 prize will be paid in equal installments of $260,000 over 10 years. The payments will be made...
Present Value of an Annuity 1) On January 1, 2016, you win $2,600,000 in the state lottery. The $2,600,000 prize will be paid in equal installments of $260,000 over 10 years. The payments will be made on December 31 of each year, beginning on December 31, 2016. If the current interest rate is 5%, determine the present value of your winnings. Use Table 2. Round to the nearest whole dollar. $ 2) Compute Bond Proceeds, Amortizing Premium by Interest Method,...
Given a 8 percent interest rate, compute the present value of payments made at the end...
Given a 8 percent interest rate, compute the present value of payments made at the end of years 1, 2, 3, and 4 of $2,906, $1,854, $1,050, and $2,317, respectively. (Do not round intermediate calculations and round your final answer to the nearest dollar.)
M9-10 Computing the Present Value of an Annuity LO9-7 What is the present value of 10...
M9-10 Computing the Present Value of an Annuity LO9-7 What is the present value of 10 equal payments of $18,000 to be made at the end of each year for the next 10 years? The annual interest rate is 10%. (FV of $1, PV of $1, FVA of $1, and PVA of $1) (Use the appropriate factor(s) from the tables provided. Round your answer to the nearest whole dollar.)
Inflows Outflows and Net Present Value
The Harding Corporation has $51.2 million of bonds outstanding that were issued at a coupon rate of 12.75 percent seven years ago. Interest rates have fallen to 11.6 percent. Preston Alter, the vice-president of finance, does not expect rates to fall any further. The bonds have 18 years left to maturity, and Preston would like to refund the bonds with a new issue of equal amount also having 18 years to maturity. The Harding Corporation has a tax rate of...
Given a 7 percent interest rate, compute the present value of payments made in years 1,...
Given a 7 percent interest rate, compute the present value of payments made in years 1, 2, 3, and 4 of $1,350, $1,550, $1,550, and $1,850, respectively. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Present value
Compute the present value of the following: (Round time value factors to 6 decimal places and...
Compute the present value of the following: (Round time value factors to 6 decimal places and final answer to the nearest dollar amount. Omit the "$" sign and commas in your response. For example, $123,456 should be entered as 123456.) Years: 15 Interest Rate: 9.2 percent Future Value: $607845
Determine the present value of $310,000 to be received in three years, using an interest rate...
Determine the present value of $310,000 to be received in three years, using an interest rate of 5.5%, compounded annually. Use the present value table in Exhibit 8. Round to the nearest whole dollar. Determine the present value of $220,000 to be received at the end of each of four years, using an interest rate of 6%, compounded annually, as follows: a. By successive computations, using the present value table in Exhibit 4. Round to the nearest whole dollar. First...
eBook Present Value of an Annuity On January 1, you win $5,000,000 in the state lottery. The $5,000,000 prize will be paid in equal installments of $500,000 over 10 years. The payments will be made on December 31 of each year, beginning on December 31. I
eBookPresent Value of an AnnuityOn January 1, you win $5,000,000 in the state lottery. The $5,000,000 prize will be paid in equal installments of $500,000 over 10 years. The payments will be made on December 31 of each year, beginning on December 31. If the current interest rate is 7%, determine the present value of your winnings. Use the present value tables in Exhibit 7. Round to the nearest whole dollar.
You won a lottery that will make equal payments of $1,000 at the end of each...
You won a lottery that will make equal payments of $1,000 at the end of each year for the next five years. If the annual interest rate stays constant at 5%, what is the value of these payments in today's dollars? (Note: Round your answer to the nearest whole dollar.) $3,681 O $4,330 O $5,413 O $4,547 You found out that now you are going to receive payments of $7,500 for the next 15 years. You will receive these payments...
Fill
in the tables
Use present value tables to compute the present value of $660,000 to be paid in 20 years, with an interest rate of 8 percent. (Future Value of $1, Present Value of $1, Future Value Annuity of $1, Present Value Annuity of $1) (Use appropriate factor(s) from the tables provided and final answer to the nearest whole dollar amount.) Table Function: Future Value: Present Value: Use present value tables to compute the present value of 20 equal...
Given a 7 percent interest rate, compute the present value of payments made in years 1, 2, 3, and 4 of $1,350, $1,550, $1,550, and $1,850, respectively. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Present value
You won a lottery that will make equal payments of $1,000 at the end of each year for the next five years. If the annual interest rate stays constant at 5%, what is the value of these payments in today's dollars? (Note: Round your answer to the nearest whole dollar.) $3,681 O $4,330 O $5,413 O $4,547 You found out that now you are going to receive payments of $7,500 for the next 15 years. You will receive these payments...
Most questions answered within 3 hours.
-
A junction box contains two trade size 2 raceways on the left
side, and two trade...
asked 30 minutes ago -
Atmospheric Mass
Venus and Earth have about the same mass and radius, but the
atmospheric pressure...
asked 1 hour ago -
5. Discuss the use of fault tree analysis (FTA) for risk
assessment (maximum one paragraph).
asked 2 hours ago -
Given that a sample of aluminium oxide has a Young's modulus of
393 GPa and a...
asked 3 hours ago -
At a certain temperature, the equilibrium constant, Kc, for this
reaction is 53.3.
H2(g)+I2(g)−⇀↽−2HI(g)Kc=53.3
At this...
asked 5 hours ago -
Question1 ) The STL provides similiar classes called stack and
queue, both of which gave functions...
asked 6 hours ago -
For Questions 1-4, assume you have 5 bits available:
1. For (positive) integers: What is the...
asked 6 hours ago -
convert grams into vloume with the density of water being at
.997514 g/cm^3 at 23.1 Celsuis...
asked 8 hours ago -
Foreman company obtained a $20,000, 6% loan on May 1, 2018.
Principal and interest will be...
asked 8 hours ago -
5. Problem 11.05 (Discounted Payback)
eBook
Project L costs $60,000, its expected cash inflows are $14,000
per...
asked 8 hours ago -
1. Which of the following is true about politics and health
organizations?
A. Health organizations are...
asked 9 hours ago -
A space vehicle is coasting at a constant velocity of 18.1 m/s
in the +y direction...
asked 10 hours ago