$29.$ Go to the Investments & Projections worksheet. Besides using a bank loan to fund their upcoming expansion, W&K Engineering is looking for investors. This worksheet should show the returns potential investors could realize if they invested a total of $$400,000$ in the company. Hwan knows that a desirable rate of return would be $9$ percent. He also estimates the investment would pay different amounts each year $($range B$6$:B$14).$ Calculate the present value of the investment and the internal rate of return as follows:

a$.$ In cell B$18,$ enter a formula that uses the NPV function to calculate the present value of the investment in funding the company's expansion.

b$.$ Use the target rate of return value $($cell B$17)$ as the rate argument.

c$.$ Use the payments in Years $110($range B$5$:B$14)$ as the returns paid to investors. $($Hint: If a Formula Omits Adjacent Cell error warning appears, ignore it$.)$

d$.$ In cell B$20,$ enter a formula that uses the IRR function to calculate the internal rate of return for the investment.

e$.$ Use the payments for Years $110($range B$5$:B$14)$ as the returns paid to investors.

$30.$ The Monthly Revenue Projections scatter chart in the range E$3$:K$20$ is based on monthly revenue estimates listed on the hidden Monthly Revenue Projections worksheet. Hwan wants to include a trendline for this chart that shows investors how revenues will most likely increase quickly at first and then level off in later months. Modify the Monthly Revenue Projections scatter chart as follows to include a logarithmic trendline:

a$.$ Add a Trendline to the Monthly Revenue Projections scatter chart.

b$.$ Format the trendline to use the Logarithmic option.