Annual cash inflows that will arise from two competing investment projects are given below: year investment a investment b 1 $ 6,000 $9,000 2 7,000 8,000 3 8,000 7,000 4 9,000 6,000 total $30,000 $30,000 the discount rate is 13%. use excel or a financial calculator to solve the homework. round answers to the nearest dollar. required: compute the present value of the cash inflows for each investment. each investment opportunity will require the same initial investment. b. julie has just retired. her company’s retirement program has two options as to how retirement benefits can be received. under the first option, julie would receive a lump sum of $159,000 immediately as her full retirement benefit. under the second option, she would receive $22,000 each year for seven years plus a lump-sum payment of $67,000 at the end of the seven-year period. use excel or a financial calculator to solve. round answers to the nearest dollar. required: 1a. calculate the present value for the following assuming that the money can be invested at 11%. 1b. if you can invest money at a 11% return, which option would you prefer? first option second option c. fraser company will need a new warehouse in eight years. the warehouse will cost $410,000 to build. use excel or a financial calculator to solve. round answers to the nearest dollar. required: 1. what lump-sum amount should the company invest now to have the $410,000 available at the end of the eight-year period? assume that the company can invest money at twelve percent. 2. what lump-sum amount should the company invest now to have the $410,000 available at the end of the eight-year period? assume that the company can invest money at thirteen percent. d. the atlantic medical clinic can purchase a new computer system that will save $11,000 annually in billing costs. the computer system will last for nine years and have no salvage value. use excel or a financial calculator to solve. round answers to the nearest dollar. required: up to how much should the atlantic medical clinic be willing to pay for the new computer system if the clinic’s required rate of return is: e. the caldwell herald newspaper reported the following story: frank ormsby of caldwell is the state’s newest millionaire. by choosing the six winning numbers on last week’s state lottery, mr. ormsby has won the week’s grand prize totaling $1.32 million. the state lottery commission has indicated that mr. ormsby will receive his prize in 20 annual installments of $66,000 each. use excel or a financial calculator to solve. round answers to the nearest dollar. required: 1. if mr. ormsby can invest money at a 8% rate of return, what is the present value of his winnings?