using information below please fill out the chart and show work... please fill it out the way the chart is set up so i can clearly read it thank you so much

12-1. Business Decision Case New Haven Corporation recently identified an investment opportunity involving the purchase of a patent that will permit the company to modify its line of CD recorders. The patent's purchase price is $720,000 and the legal protection it provides will last for five more years; there is no salvage value. However, after preparing the capital expenditure analysis below, New Haven's treasurer has recommended to the company's capital budgeting committee that the investment be rejected. Brad Decker, chairperson of the capital budgeting committee, finds it diffi- cult to accept the treasurer's analysis because he "feels intuitively" that the investment is attractive. For this reason, he has retained you to review the treasurer's analysis and recommendation. You are provided with the following data and summary of the treasurer's analysis: 1. Required investment: $720,000 cash for the patent to be amortized on a straight-line basis, five-year useful life, with a zero salvage value. 2. Projected cash revenue and operating expenses: Year 1 2 3 4 5 Cash Revenue $ 620,000 560,000 400,000 250,000 200,000 $2,030,000 Cash Expenses $240,000 200,000 170,000 80,000 50,000 $740,000 3. Source of capital: New Haven plans to raise 10% of the needed capital by issuing bonds, 30% by issuing stock, and the balance from retained earnings. For these sources, the capital cost rates are 8%, 9%, and 10%, respectively. New Haven has a policy of seeking a return equal to the weighted average cost of capital plus 2.5 percentage points as a "buffer margin" for the uncertainties involved. C B AUTO Guap2 DUSMESSUSHI 4. Income taxes: New Haven has an overall income tax rate of 30%. 5. Treasurer's analysis: $2,030,000 $740,000 720,000 ---- ---- Average cost of capital (8% + 9% + 10%)/3 = 9% Total cash revenue. Total cash expenses. Total amortization .. Total operating expenses Projected net income over five years. Average annual income ...... Present value of future returns. Required investment... Negative net present value. 1,460,000 $ 570,000 $ 114,000 $ 443,420 720,000 $ (276,580) ---- . Recommendation: Reject investment because of insufficient net present value. Required a. Review the treasurer's analysis, identifying any questionable aspects and briefly com Original After Tax Cash Flows (10% Revenue Reduction) x 1 - Tax Rate) (62,000 x 70%) Revised After Tax Cash Flows (FV) Present Value Show your work here (first one provi $ 237,321 PV = $265,800 x.89286 = $237,322 i/Y 12% ear (N) $ 1 309,200 S 265,800 @ 12% 2 3 12% 12% 4 5 @ 12% Total present value Investment required Net positive present value e conclusion: Sheet2 Sheet e to search