New technology has a retail cost of $500,000 and $1.5 million 2 and 5 years from now, respectively. The owner of the company is cash strapped but has an offer to buy at wholesale prices which he thinks is too good to pass up. How much could his company afford to spend now if the actual cost of the technology would beonly 50% of the total amounts in each year? use an interest rate of 10% per year. use the appropriate excel function and write your result here.... Please show work, i will rate. Thank you!