Explain the tables, that is, do the financial analysis of each one. Describe what each means.

OPTION B 1136 Avenue Rd. YEAR 0 1 2 3 4 CASH FLOW PVF at 12% PVCF Cumulative cash Flow $(4,800,000) 1.000 $(4,800,000) $ (4,800,000) $ 489,600 0,893 $ 437,413 $ (4,310,400) $ 960,000 0,797 $ 765,306 $ (3,350,400) $ 384,000 0,712$ 273,324 $ (2,966,400) $ 1,152,000 0,636 $ 732,117 $ (1,814,400) $ 864,000 0,567 $ 490,257 $ (950,400) $ 1,056,000 0,507 $ 535,002 $ 105,600 $ 299,520 0,452 $ 135,488$ 405,120 $ 600,000 0,404 $ 242,330 $ 1,005,120 $ 960,000 0,361 $ 346,186 $ 1,965,120 $ 1,920,000 0,332 $ 618,189 $ 3,885,120 5 6 DN 7 3 9 10 IRRE 10.97% Bv Excel formula =IRR (cashflow year 0: cashflow year 10) NPN= $ (224,659) Sum of PVCF Payback = 5+(950400 10560000) = 5.90 years | OPTION A-5800 Yonge St. NO . 3 4 CASH FLOWPVE at 12% PVCF Cumulative Cash Flow $(3,000,000) 1.000 $(3,000,000) $ (3,000,000) $ 306,000 0,893 $ 273,214 $ (2,694,000) $ 120,000 0,797 $ 95,663 $ (2,574,000) $ 240,000 0,712 $ 170,825 $ (2,334,000) $ 360,000 0,636 $ 228,787 $ (1,974,000) $ 540,000 0,567 $ 306,411 $ (1,434,000) $ 660,000 0,507 | $ 334,377 $ (774,000) $ 187,200 0,452 $ 84,680 $ (586,800) $ 840,000 0,404 $ 339,262 $ 253,200 $ 936,000 0,361 $ 337,531 $ 1,189,200 $ 1,200,000 0,322 $ 386,368 $ 2,389,200 5 6 N000 8 9 10 IRR= 9.16% By excel formula =IRR (cashflow year 0: cashflow year 10) NVP= S (442.851) Sum of PVOF Payback = 7+(586800/840000) 7,70 years