Using just excel
show the equation in excel please A bank lent a newly graduated engineer $1,000 at i = 10% per year for 4 years. From the bank's perspective (the lender), the investment in this young engineer is expected to produce an equivalent net cash flow of $315.47 for each of 4 years ▪ Compute the amount of the unrecovered investment for each of the 4 years using the rate of return on the unrecovered balance
