Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started