Spreadsheet Exercise

Spreadsheet icon Ram Electric Company is being considered for acquisition by Cavalier Electric. Cavalier expects the combination to increase its cash flows by $100,000 for each of the next 5 years and by $125,000 for each of the following 5 years. Ram Electric has relatively high financial leverage; Cavalier expects its cost of capital to be 12% for the first 5 years and estimates that it will increase to 16% for the following 5 years if the merger is undertaken. The cash price of Ram Electric is $325,000.

To Do

Create a spreadsheet similar to Table 18.3 to answer the following questions.

  1. Determine the present value of the expected future ...

Get Principles of Managerial Finance, 15th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.