Lonnie Holtzman is a financial analyst for the Lewellen Group, a management consulting firm headquartered in Providence, Rhode Island. The firm also has offices in Charlotte, North Carolina; Milwaukee, Wisconsin; and Denver, Colorado. Lonnie is using an Excel workbook with multiple worksheets to create a profit and loss statement for the firm. He asks for your help in completing the statement. Go to the Dashboard worksheet. Lonnie first wants to complete the list of links in the range H7:H10. In cell H7, create a hyperlink to the www. lewellen. example. net website.

Suppose that a major city’s main thoroughfare, which is also an interstate highway, will be completely closed to traffic for two years, from january 2014 to december 2015, for reconstruction at a cost of $535 million. if the construction company were to keep the highway open for traffic during construction, the highway reconstruction project would take much longer and be more expensive. suppose that construction would take four years if the highway were kept open, at a total cost of $800 million. the state department of transportation had to make its decision in 2014, one year before the start of construction (so that the first payment was one year away). so the department of transportation had the following choices: (i) close the highway during construction, at an annual cost of $267.5 million per year for two years. (ii) keep the highway open during construction, at an annual cost of $200 million per year for four years. now suppose the interest rate is 80%. calculate the present value of the costs incurred under each plan.