g $29.$ LO$\mathrm{.}1,2,5$ Harper is considering three alternative investments of $$10,000.$ Assumethat the taxpayer is in the $24\%$ marginal tax bracket for ordinary incomeand $15\%$ for qualifying capital gains in all tax years. The selected investment will beliquidated at the end of five years. The alternatives are:N$/$R$2$Future Value of$$13$Use the future value tables in Appendix H as needed for your calculationsand comparisons. Presernt your answers using spreadsheet software such asMicrosoft Excel$\mathrm{.}4567891011112131415161718$ A taxable corporate bond yielding $5\mathrm{.}333\%$ before tax and the interest can bereinvested at $5\mathrm{.}333\%$ before tax.$$ A Series EE bond that will have a maturity value of $$12,200($a $4\%$ before$-$taxrate of return$)\mathrm{.}20$ Land that will increase in value.The gain on the land is classified and taxed as a long$-$term capital gain. The incomefrom the bonds is taxed as ordinary income. How much must the land increase invalue to yield a greater after$-$tax return than either of the bonds?$1\%1\mathrm{.}01001\mathrm{.}02011\mathrm{.}03031\mathrm{.}04061\mathrm{.}05101\mathrm{.}06151\mathrm{.}07211\mathrm{.}08291\mathrm{.}09371\mathrm{.}10461\mathrm{.}11571\mathrm{.}12681\mathrm{.}13811\mathrm{.}14951\mathrm{.}16101\mathrm{.}18431\mathrm{.}19611\mathrm{.}20812\%1\mathrm{.}22021\mathrm{.}06121\mathrm{.}02001\mathrm{.}03001\mathrm{.}04001\mathrm{.}04041\mathrm{.}06091\mathrm{.}08241\mathrm{.}10411\mathrm{.}12621\mathrm{.}14871\mathrm{.}17171\mathrm{.}19511\mathrm{.}21901\mathrm{.}24341\mathrm{.}29361\mathrm{.}17261\mathrm{.}37281\mathrm{.}31951\mathrm{.}34593\%1\mathrm{.}09271\mathrm{.}48591\mathrm{.}12551\mathrm{.}15931\mathrm{.}19411\mathrm{.}22991\mathrm{.}26681\mathrm{.}30481\mathrm{.}34391\mathrm{.}38421\mathrm{.}46851\mathrm{.}51264\%1\mathrm{.}42581\mathrm{.}55801\mathrm{.}08161\mathrm{.}12491\mathrm{.}16991\mathrm{.}21671\mathrm{.}26531\mathrm{.}3159\mathrm{.}36861\mathrm{.}42331\mathrm{.}48021\mathrm{.}53951\mathrm{.}60101\mathrm{.}66511\mathrm{.}73171\mathrm{.}80091\mathrm{.}80612\mathrm{.}19115\%1\mathrm{.}05001\mathrm{.}10251\mathrm{.}15761\mathrm{.}21551\mathrm{.}27631\mathrm{.}34011\mathrm{.}40711\mathrm{.}47751\mathrm{.}55131\mathrm{.}62891\mathrm{.}71031\mathrm{.}87301\mathrm{.}60471\mathrm{.}94791\mathrm{.}65281\mathrm{.}40021\mathrm{.}79591\mathrm{.}88561\mathrm{.}97992\mathrm{.}07892\mathrm{.}52706\%7\%1\mathrm{.}06001\mathrm{.}07001\mathrm{.}12361\mathrm{.}14491\mathrm{.}19101\mathrm{.}22502\mathrm{.}65331\mathrm{.}33821\mathrm{.}4026141851\mathrm{.}50071\mathrm{.}50361\mathrm{.}60581\mathrm{.}59381\mathrm{.}68951\mathrm{.}79081\mathrm{.}89832\mathrm{.}01222\mathrm{.}13292\mathrm{.}26093\mathrm{.}02561\mathrm{.}71823\mathrm{.}20711\mathrm{.}83852\mathrm{.}39662\mathrm{.}75902\mathrm{.}18292\mathrm{.}54042\mathrm{.}95222\mathrm{.}69283\mathrm{.}15882\mathrm{.}29203\mathrm{.}37992\mathrm{.}85431\mathrm{.}96722\mathrm{.}25222\mathrm{.}40982\mathrm{.}57858\%1\mathrm{.}08003\mathrm{.}86971\mathrm{.}16641\mathrm{.}25971\mathrm{.}36051\mathrm{.}46931\mathrm{.}58691\mathrm{.}71382\mathrm{.}10492\mathrm{.}33161\mathrm{.}85091\mathrm{.}99902\mathrm{.}15893\mathrm{.}42599\%1\mathrm{.}09003\mathrm{.}70001\mathrm{.}18811\mathrm{.}2950141161\mathrm{.}53861\mathrm{.}67711\mathrm{.}82801\mathrm{.}99262\mathrm{.}17192\mathrm{.}367410\%$vaue lduie$4\mathrm{.}32761\mathrm{.}10001\mathrm{.}21001\mathrm{.}33101\mathrm{.}46411\mathrm{.}61052\mathrm{.}143611\%2\mathrm{.}35791\mathrm{.}11002\mathrm{.}59371\mathrm{.}23211\mathrm{.}77161\mathrm{.}87042\mathrm{.}30452\mathrm{.}47602\mathrm{.}55802\mathrm{.}77312\mathrm{.}83943\mathrm{.}10582\mathrm{.}58043\mathrm{.}15182\mathrm{.}85312\mathrm{.}51822\mathrm{.}81273\mathrm{.}13843\mathrm{.}49852\mathrm{.}71963\mathrm{.}06583\mathrm{.}45233\mathrm{.}88332\mathrm{.}93723\mathrm{.}34173\mathrm{.}79754\mathrm{.}31044\mathrm{.}88713\mathrm{.}17223\mathrm{.}64254\mathrm{.}17724\mathrm{.}78465\mathrm{.}47361\mathrm{.}36761\mathrm{.}94872\mathrm{.}07625\mathrm{.}0545151811\mathrm{.}685112\%5\mathrm{.}31091\mathrm{.}12001\mathrm{.}2544140491\mathrm{.}57351\mathrm{.}76231\mathrm{.}97382\mathrm{.}21073\mathrm{.}47856\mathrm{.}86605\mathrm{.}89513\mathrm{.}99604\mathrm{.}71715\mathrm{.}55996\mathrm{.}54367\mathrm{.}69004\mathrm{.}31575\mathrm{.}14176\mathrm{.}11597\mathrm{.}26338\mathrm{.}61284\mathrm{.}66105\mathrm{.}60446\mathrm{.}72758\mathrm{.}06239\mathrm{.}64633\mathrm{.}89604\mathrm{.}36351\mathrm{.}26822\mathrm{.}02581\mathrm{.}70241\mathrm{.}42822\mathrm{.}10681\mathrm{.}75351\mathrm{.}45681\mathrm{.}26251\mathrm{.}31082\mathrm{.}40663\mathrm{.}61653\mathrm{.}97036\mathrm{.}13044\mathrm{.}5950$