28. 29. Hwan also wants to determine the sum-of-years depreciation balance for the first year and the last year of the useful life of the construction equipment. Determine these amounts as follows: a. b. For the yearly allowance for the first year, use a function to calculate the sum-of- years depreciation balance, using a cell reference to Year 1 of the declining balance section as the current period. For the yearly allowance for the last year, use a function to calculate the sum-of- years depreciation balance, using a cell reference to Year 10 of the declining balance as the current period. 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, as shown in the repayment schedule section. Calculate the net present value of the investment and the internal rate of return. a. b. Next to the cell labeled "Present value", use a function to calculate the net present value of the investment in funding the company's expansion. Use a cell reference to the target rate of return value as the rate argument, as well as the payments in Years 1-10 as the returns paid to investors. (Hint: If a Formula Omits Adjacent Cell error warning appears, ignore it.) Next, in the appropriate cell, use a function to calculate the internal rate of return for the investment. Use a cell reference to the payments for Years 1-10 as the returns paid to investors. 30. The Monthly Revenue Projections scatter chart in the range E3:K20 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.