prepare a spreadsheet modeling the initial investment and the incremental annual cash inflows and outflow for each of the next five years. H 2 W 4 5 Total Cash Inflow 91,875 91,875 91,875 91,875 91,875 459,375 438,252.5 Cash Outflow 87,650.50 87,650.50 87,650.50 87,650.50 87,650.50 Profit 4,224.50 4,224.50 4,224.50 4,224.50 4,224.50 21,123 $ $15,228.3 PV $3,771.88 3,367.75 $3,006.92 $2,684.75 $2,397.09 9 1 2 3 4 5 Total Cash Inflow 118,080 118,080 118,080 118,080 118,080 590,400 128,996.5 105,021.5 105,021.5 549,082.5 Cash Outflow 0 105,021.50 105, 021.50 0 0 Profit 10,916.50 13,058.50 13,058.50 13,058.50 15,558.50 43,817.50 ($9,746.8 $ $27,085.2 PV 8) 10,410.16 $9,294.78 $8,298.91 $8,828.31 8 0.73 2 3 5 Total 127,813.2 103,838.2 103,838.2 543,166.2 Cash Outflow 4 103,838.24 103,838.24 4 4 Profit -9,733.24 14,241.76 14,241.76 14,241.76 16,741.76 49,733.80 ($8,690.3 PV $ 9) 11,353.44 $17,881.8 $10,137.00 $2,684.75 $2,397.09 9