1) You are considering an investment that will pay you $12,000 the first year, $13,000 the...

1) You are considering an investment that will pay you $12,000 the first year, $13,000 the second year, $17,000 the third year, $19,000 the fourth year, $23,000 the fifth year, and $28,000 the sixth year (all payments are at the end of each year). What is the maximum you would be willing to pay for this investment if your opportunity cost is 11%?

Solve this question assuming that payments will be received at the beginning of each year rather than the end of each year. Please solve using Excel

Solutions

Expert Solution

Solution :

In case the payments are received at the end of each year, the maximum that should be paid for this investment if your opportunity cost is 11% = $ 74,927.37

= $ 74,927 ( when rounded off to the nearest whole number )

In case the payments are received at the beginning of each year, the maximum that should be paid for this investment if your opportunity cost is 11% = $ 83,169.38

= $ 83,169 ( when rounded off to the nearest whole number )

Please find the attached screenshot of the excel sheet containing the detailed calculation for the solution.

jeff jeffy answered 1 day ago

Next > < Previous

Related Solutions

1) You are considering an investment that will pay you $12,000 the first year, $13,000 the...

SHOW WORK ON EXCEL: You are considering an investment that will pay you $12,000 the first...

SHOW WORK ON EXCEL: You are considering an investment that will pay you $12,000 the first year, $13,000 the second year, $17,000 the third year, $19,000 the fourth year, $23,000 the fifth year, and $28,000 the sixth year (all payments are at the end of each year). What is the maximum you would be willing to pay for this investment if your opportunity cost is 11%?

Solve in Excel. Show formulas A) You are considering an investment that will pay you $12,000...

Solve in Excel. Show formulas A) You are considering an investment that will pay you $12,000 the first year, $13,000 the second year, $17,000 the third year, $19,000 the fourth year, $23,000 the fifth year, and $28,000 the sixth year (all payments are at the end of each year). What is the maximum you would pay for this investment if your opportunity cost is 12%? B) You are considering an investment that will pay you $12,000 the first year, $13,000...

1.You are considering an investment that will pay you $1,200 in one year, $1,400 in two...

1.You are considering an investment that will pay you $1,200 in one year, $1,400 in two years, and $1,600 in three years, $1,800 in four years, and $11,000 in five years. All payments will be received at the end of the year. • Your opportunity cost of capital (r ) is 10.5% • Using the present value formula calculate the present value of each of the cash flows by 1. Discounting cash flows using annual compounding 2. Discounting cash flows...

You are considering a project that will pay you $710 in the first year, $2,000 in...

You are considering a project that will pay you $710 in the first year, $2,000 in the second year, and $1,090 in the third year. In the fourth year, the project will pay you a cash flow of 3,000, which starting from the fifth year will grow forever at a rate of 2%. If the interest rate for this project is 12%, and the time-zero cost of starting this project is $10,000, what is the Net Present Value (PV of...

You are valuing an investment that will pay you $23,000 per year for the first 8...

You are valuing an investment that will pay you $23,000 per year for the first 8 years, $27,000 per year for the next 12 years, and $53,000 per year the following 12 years (all payments are at the end of each year). If the appropriate annual discount rate is 10.00%, what is the value of the investment to you today?

You are valuing an investment that will pay you $21,000 per year for the first 9...

You are valuing an investment that will pay you $21,000 per year for the first 9 years, $29,000 per year for the next 12 years, and $68,000 per year the following 16 years (all payments are at the end of each year). Another similar risk investment alternative is an account with a quoted annual interest rate of 13.00% with monthly compounding of interest. What is the value in today's dollars of the set of cash flows you have been offered?

27. You are valuing an investment that will pay you $28,000 per year for the first...

27. You are valuing an investment that will pay you $28,000 per year for the first 4 years, $43,000 per year for the next 12 years, $69,000 per year the next 18 years, and $61,000 per year for the following 10 years (all payments are at the end of each year). If the appropriate annual discount rate is 11.00%, what is the value of the investment to you today?

A- Annuity Present Value -You are looking into an investment that will pay you $12,000 per...

A- Annuity Present Value -You are looking into an investment that will pay you $12,000 per year for the next 10 years. If you require a 15 percent return, what is the most you would pay for this investment? B- Describe how to calculate the future value of a series of cash flows. C- Describe how to calculate the present value of a series of cash flows.

You are considering the purchase of an investment that would pay you $5,000 per year for...

You are considering the purchase of an investment that would pay you $5,000 per year for Years 1‑5, $3,000 per year for Years 6‑8, and $2,000 per year for Years 9 and 10. If you require a 9.5 percent rate of return, and the cash flows occur at the end of each year, then what is the MOST you would be willing to pay for this investment? Answer to 0 decimal places.

Subjects