Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your company made investments in two product lines in the past. You have been asked to evaluate the rate of return on these investments. Assume

image text in transcribed

Your company made investments in two product lines in the past. You have been asked to evaluate the rate of return on these investments. Assume a monthly accounting period for both. investment A: The company made an initial investment of $1.2 million to develop a new product. After two years, they sold the product line to another company for $6.6 million. investment B: The company made an initial investment of $1.5 million. After a one year startup period, the company received a monthly revenue stream of $250,000 from product sales for the next two years. Calculate the company's rate of return on these two investments by doing the following: For investment A, create a cash flow diagram showing the investment amount (negative) and the lump sum payment from its sale to another company (positive). Use a monthly accounting period. Determine the monthly rate of return of the investment by equating the investment amount to the present worth of the sale of the product line. Use the engineering economics formulas to write a mathematical expression for this, using the symbol i for the unknown monthly rate of return (the only unknown in the final equation). Then solve for i and report both the monthly and the annual rate of return (in %). For investment B, create a cash flow diagram showing the investment amount (negative) and the monthly revenue stream to the company (positive). Use a monthly accounting period. Determine the monthly rate of return of the investment by equating the investment amount to the present worth of the revenue stream received. Use the engineering economics formulas to write a mathematical expression for this, using the symbol i for the unknown monthly rate of return. Then use the Excel Goal Seek function to find i, and copy and paste an image of your spreadsheet window into your submission. Report the both the monthly and the annual rate of return (in %) in your

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

More Books

Students also viewed these Finance questions

Question

3. What elements are included in a channel strategy?

Answered: 1 week ago