How would you enter this in excel?

1. Present Value Calculations.For each of the following independent scenarios, useFigure 8.9 "Present Value of $1 Received at the End of "in the appendix to calculate the present value of the cash flow described.
2. $10,000 will be received 4 years from today. The rate is 10 percent.
3. $10,000 will be received 4 years from today. The rate is 20 percent.
4. $50,000 will be received 15 years from today. The rate is 12 percent.
5. $50,000 will be received 15 years from today. The rate is 6 percent.

Figure 8.9 Present Value of $1 Received at the End of n Periods Periods Rate per Period 6% 96 10%% 11% 13% 14% 159% 189% 20% 25%% 1.0000 1.0000 1.0000 1.0000 1.0000 1.0050 1/0000 1,0020 1.0000 1,0000 1.0000 1.0000 1/0000 1,0000 1.0000 0.952 0.943 0925 0.917 0.909 0.8929 0.877 0.7692 0.9070 O.B90 0.8734 0.8573 0.8417 0.8754 0.8116 0.7972 0.7831 0.7695 0.7561 07182 0.6914 0.6400 0.5917 0.863 0.8163 07938 0.751 0,7118 0.6750 0.6575 0.5120 0.8227 0.7921 0.762 07350 0.6830 0.655 0.6355 06133 0.592 05718 0.3501 0.783 0.747 0.713 0.G80 0.6209 0.5935 0.5674 05428 0.519 04972 0.2693 0.7107 0.6651 0.6227 05835 0.5470 0.5132 0.4573 04251 0.3906 0.3759 0.2097 0.1504 0.676 0.5820 05403 0.5019 04019 0.3763 0.3506 0.1226 05919 0500 0414 0.132 0.0943 10 0.613 0558 0.5083 04637 6422 039-46 0.269 0.2472 0.0725 0.556 34970 0.4440 03971 0.316 0.2567 07307 0.2076 0.0687 0.0429 0.5303 04150 0 3677 0.2192 0.1821 0.1625 0.0550 0.0330 0.5051 94423 0.3878 0 340 0.761 0.180 0.1597 0.0254 15 04810 0417 0.3624 0315 0.2745 0.1599 0.140 0.1229 0.0835 0.0649 0,0352 0.0195 0 0708 0371 0270 0.1978 0.1456 0. 1078 0.0929 0 0600 0.0451 0.0235 0.01 16 0.415 0.2959 0.0945 0 050H 0.0180 0.0089 0.395 0.2765 0.163 0.0829 0.0703 0.0068 20 0.376 0311 0.258 0214 0.17 0. 148 0.101 0.0868 0.072 0.0365 0.0261 0,0115 6.0053 0.097 0.06 3 0 0309 0,0092 6.0040 0.3418 0.2257 0.183 0.0560 0 0262 0.0181 0.0074 0.0031 0.3256 0.2109 0.0738 0.0491 0.0402 0 0223 0.0059 0.0024 24 0.3101 0 2470 0.1264 0,1015 0.0659 0.0431 0.0349 0.0018 25 0.795 0.2330 0. 184 0.1460 0.116 0.097 0.0588 0.0471 0.037 0.0304 0.0105 0:0038 0.0014 0.052 0.0264 0.0930 27 0.2678 0.2074 0.1609 0.125 0.0976 0.0763 0.0597 0.0291 0.0230 0.0024 0.0008 0.2551 0.1956 0.1504 0.0653 0.0538 0.0419 0.0326 0.0255 0.0200 0.0097 0.0019 0.0006 0,1406 0 1073 0.0827 0.0530 0.0374 0.0289 0.0224 0.0174 0.0082 0.0015 0.0005 30 0.0994 010754 0.0573 0.0334 0:0042 0:0012 0.0004 Note: Factor = (1+r )n