Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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: So the working capital needed means that more cash will need to be invested in inventory and other working capital items. When the project concludes in four years the working capital will be released for investment elsewhere within the company, meaning that the cash will be recovered at the end of the 4 years. The overhaul is a cash outflow at the end of 2 years.

Cost of Equipment needed- $130,000

Working capital needed- $60,000

Overhaul of the equipment in two years- $8,000

Salvage value of equipment in four years- $12,000

Annual revenue and cost:

Sales Revenue- $250,000

Variable Expenses- $120,000

Flexed-out-of-pocket operating cost- $70,000

Required: Using Excel answer the following:

(a) Oakmonts cost of capital is 15%, and management does not feel it should have any adjustment for risk, compute the NPV.

(b) Compute the IRR for this project.

(c) At the end of year 1, management wants to spend $10,000 extra each year (so at the end of years 1, 2, and 3) for advertising. They expect the volume of sales to increase by 10% year over year (for years 2, 3 and 4){this means that sales volume will increase by 10% from year 1 to year 2, and then from year 2s volume to year 3's volume by another 10%, etc.).

Big Key: Set up all of your cash inflows and outflows, and then determine the net cash flow for each year. 2nd big Key: I said volume, so think about what changes when your volume of sales increases!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Information Systems Enhancing Performance Of The Enterprise

Authors: Abraham Nyirongo

1st Edition

1490754997, 9781490754994

More Books

Students also viewed these Accounting questions

Question

Can workers be trained in ethics? How? Defend your answer.

Answered: 1 week ago