question contained in image

Oakmont Company has an opportunity to manufacture and sell a new product for a four-year period. After careful study, Oakmont estimated the following costs and revenues for the new product: Cost of equipment needed .............................. $130,000 Working mpltal needed ................................. $60,000 Overhaul of the equipment in two years .................... $8.000 Salvage value of the equipment in four years ................ $12,000 Annual revenues and costs: Sales revenues ....................................... $250,000 Variable expenses ..................................... $120,000 Fixed out-of-pocket operating costs ....................... $70,000 When the project concludes in four years the working capital will be released for investment elsewhere within the company. Required: Using Excel (this will save you time and effort) answer the following: (a) Oakmont's cost of capital is 15%, and management does not feel it should have any adjustment for risk, compute the NPV. (b) Same situation as (a), but management does feel this project does possess a greater than average risk, so 19% should be the required rate of return. Compute the NPV. (c) Management is concerned that Sales Revenues and Expenses could be rising due to inflationary factors. 80 the projection for year 1 is as shown, but that sales revenues will grow by 2% per year for years 2-4; and that variable expenses will grow by 4% per year for years 2-4, and that fixed out-of-pocket operating costs will grow by 1% per year. Compute NPV using a 15% cost of capital