Question: Please use Excel and show formulas Make sure to highlight all final answers and show 2 decimal places. 1) You are considering an investment that
Make sure to highlight all final answers and show 2 decimal places. 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%? 2) 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. If this investment is going to cost you $70,000 today what rate of return would you be earning? 3) You are planning on making the following deposits into an account that will earn 4%. $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 deposits will be made at end of each year? How much will you end up with at the end of the six year
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
