Question

In: Accounting

Determine the present value of the following series of payments: • $ 4,000 at the end...

Determine the present value of the following series of payments:

• $ 4,000 at the end of each month for 8 years at 9% compounded monthly.

Step # 1: Graph the situation

Step # 2: Equation with Factor nomenclature.

Step # 3: Replacement of factors and mathematical solution of the problem.

Expert Solution

1.

2: Equation with factor nomenclature =

here,

pmt = Periodic Payment

r = rate of interest

n = number of periods

3.

=

= $273,033.75

*Here payment period = 12*8 = 96

ekkarill92 answered 2 years ago

Using Excel. What is the present value of the following series of cash payments: $8,000 per...

Using Excel. What is the present value of the following series of cash payments: $8,000 per year for four consecutive years starting one year from today, followed by annual cash payments that increase by 2% per year in perpetuity (i.e. cash payment in year 5 is $8,000*1.02, cash payment in year 6 is $8,000*1.022, etc.)? Assume the appropriate discount rate is 5%/year.

Determine the combined present value as of December 31, 2021, of the following four payments to...

Determine the combined present value as of December 31, 2021, of the following four payments to be received at the end of each of the designated years, assuming an annual interest rate of 8%. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided. Round your final answers to nearest whole dollar amount.) Payment Year Received $ 9,250 2022 9,825 2023 11,400 2025 13,675...

1. Find the present value of a series of quarterly payments of P950 each, the first...

1. Find the present value of a series of quarterly payments of P950 each, the first payment is due at the end of 2 years and 3 months and the last at the end of 5 years and 6 months. If the money is worth 15% compounded quarterly. 2. Find the monthly payment for 36 periods to discharge an obligation of P88000 if the money is worth 12%, m=12 and the first payment is due at the end of 1...

4) Determine the present value of $35,000 to be received at the end of each of...

4) Determine the present value of $35,000 to be received at the end of each of five years, using an interest rate of 5%, compounded annually, as follows: a) By successive computations, using the Present Value of $1 table below. You must show your work. b) By a single computation using the Present Value of an Annuity of $1 table below. You must show your work. Note: The two answers will not come out exactly the same, but should be...

What is the present value of the declining uniform gradient series that has end of first-year...

What is the present value of the declining uniform gradient series that has end of first-year payment of $9,000 declining by 10% per year to year 10 with an interest rate of 10% compounded annually? Note: 10% is based on the end of the first-year payment.

Determine the future value and the present value of the following single amounts: Future and Present...

Determine the future value and the present value of the following single amounts: Future and Present Values item Invested Amount Interest Rate Percentage No. of Periods 1 15,000.00 6 12 2 20,000.00 8 10 3 30,000.00 12 20 4 50,000.00 4 12

Calculate the present value of the following annuity streams: a. $4,000 received each year for 4...

Calculate the present value of the following annuity streams: a. $4,000 received each year for 4 years on the last day of each year if your investments pay 6 percent compounded annually. b. $4,000 received each quarter for 4 years on the last day of each quarter if your investments pay 6 percent compounded quarterly. c. $4,000 received each year for 4 years on the first day of each year if your investments pay 6 percent compounded annually. d. $4,000...

Consider the following scenario to determine the future value of the payments. Annual payments of 100...

Consider the following scenario to determine the future value of the payments. Annual payments of 100 are made for 5 years at an effective rate of r, followed by annual payments of 200 for the next 3 years at the same rate. Set up three different equation of values for this situation.

Develop a spreadsheet to determine the net present value or present worth of the following project:...

Develop a spreadsheet to determine the net present value or present worth of the following project: Bonus Depreciation: 0% Investment: 140,000 Revenue/Savings: 25,000 Incremental Expense/Cost: 5,000 Salvage Value: 25,000 Project Life: 10 years MACRS Schedule: 7 years Tax Rate: 25% MARR: 12% Inflation: 3% Is this a good investment to make? Rework the problem with Bonus Depreciation of 50% and 100% Determine the internal rate of return for the project in the previous problem with all three levels of Bonus...

Assume the appropriate discount rate is 7%. If the present value of this series of payments is $20,000, what must be the amount of each payment?

Today, you begin to receive payments of equal amounts at the beginning of each year for 6 years (including the payment you receive today). Assume the appropriate discount rate is 7%. If the present value of this series of payments is $20,000, what must be the amount of each payment?