Present value of cash flows=cash flows*Present value of discounting factor(rate%,time period)
4963=808/1.056+977/1.056^2+1150/1.056^3+nominal year 4 payment/1.056^4+1485/1.056^5
4963=3748.708766+nominal year 4 payment/1.056^4
nominal year 4 payment=(4963-3748.708766)*1.056^4
=$1510(Approx).
Your boss asks you to re-enter the following table in a new spreadsheet. The problem is...