Figure$1$A$-1$contains the summary spreadsheet for the Dr$$nTeq Client Services project. As shown, Carmella$$s initial sales projections are used for the first year$$s revenues. Revenues are projected to grow$10\%$in the second year and$8\%$in the third year. Cost projections are based on Jiang$$s assumptions about the time it will take to develop the system and the resources that will be required. Operating costs have a considerable new labor component because a new business unit is being created, requiring additional staff.$*$Figure$1$A$-1$incorporates several of the financial analysis techniques we have discussed. The rows marked A and C summarize the annual benefits and costs, respectively. The row marked D shows the yearly net benefits$($total benefits$$total costs$).$The ROI calculation shows that this project is expected to return$43\%$on the investment, calculated by dividing the difference between total benefits in row A and total costs in row C by the total costs in row C$.$Row E shows the cumulative cash flow for the project, and this is used to determine the breakeven point. As seen in Figure$1$A$-1,$the project fully recovers its costs in the second year, since the cumulative net cash flow becomes positive in the second year. It takes about$0\mathrm{.}27$of the second year before the costs are recovered. The row marked B computes the present value of each year$$s total benefits, and the row marked F computes the present value of each year$$s total costs. A$9\%$required rate of return was used in these calculations. These values are used in the NPV calculation. The total present value of costs is subtracted from the total present value of benefits, and the result is $$675,818,$indicating the strong financial viability of this investment. This spreadsheet shows that this project can add significant business value even if the underlying assumptions prove to be overly optimistic.$2.$See the figure in the text on page$36.$Your assignment is to recreate the actual spreadsheet using this information to achieve the same results. In your submission, include a printout of the spreadsheet that closely matches the content of page$36.($Are there any errors or omissions that you can find?$)$As well, what would be your recommendation if the required rate of return is specified at$20\%?($for this question you also need to attach your actual spreadsheet$)$Benefits Revenue from new pilot contracts and drone leases Sales from drone flight service and data analysis$($A$)$Total Benefits$($B$)$Present Value Total Benefits Development Costs Labor$-$Analysis and Design Labor$-$Implementation Office space and equipment Software Hardware Total Development Costs Operational Costs Labor$-$Webmaster Labor$-$Network technician Labor$-$Computer operations Labor$-$Business manager Labor$-$Assistant manager Labor$-$IS maintenance developers$(3)$Software upgrades Software licenses Hardware upgrades User training and support Additonal ISP charges Marketing expenses Total Operational Costs$($C$)$Total Costs$($D$)$Total Benefits$-$Total Costs$($E$)$Cumulative New Cash Flow$($F$)$Present Value Total Costs$558,000,455,046,437,379,420,441,1,870,866$Return on Investment$($ROI$)43\%(3,033,180-2,118,1332,118,133)$Break$-$even Point$1\mathrm{.}27$years$($Costs are fully recovered in the second year;$495,100-363,600495,100$NPV$($PV Total Benefits$-$PV Total Costs$)675,818$Intangible Costs and Benefits Intangible Cost: Effective drone flight service option may reduce the demand for actual drone sales Intangible Benefit: Enhanced competitive position through expansion of our drone brand into the drone flight service market FIGURE$1$A$-1$Economic feasibility analysis for Dr$$nTeq$.$