PLEASE EXPLAIN HOW TO DO THIS IN EXCEL, for the life of me I cant get excel to work with me!
Posted: Fri Jul 01, 2022 8:28 am
2 2 points eBook B Hint Print References An investment offers $5,600 per year for 15 years, with the first payment occurring one year from now. If the required return is 6 percent, what is the value of the investment? (Do not round intermediate calculations and round your final answer to 2 decimal places, e.g., 32.16.) Present value $ What would the value be if the payments occurred for 40 years? (Do not round intermediate calculations and round your final answer to 2 decimal places, e.g., 32.16.) Present value $ What would the value be if the payments occurred for 75 years? (Do not round intermediate calculations and round your final answer to 2 decimal places, e.g., 32.16.) Present value What would the value be if the payments occurred forever? (Do not round intermediate calculations and round your final answer to 2 decimal places, e.g., 32.16.) Present value