use the following information to develop a spreadsheet model that will calculate the free cash flows and the value of the equity for the company. cost of capital 12% most recent year's sales $1000 nonoperating assets $100 interest-bearing debt $250 operating profit margin 12% working capital/sales 35% fixed assets/sales 20% noninterest-bearing current liabilities/sales 10% rax rate 40% forecasted sales growth years 1-2 12% years 3-5 8% years 6-∞ 4% calculate the value of the firm and the value of the equity in the firm using DCF analysis.
use the following information to develop a spreadsheet model that will calculate the
cost of capital 12%
most recent year's sales $1000
nonoperating assets $100
interest-bearing debt $250
operating profit margin 12%
working capital/sales 35%
fixed assets/sales 20%
noninterest-bearing
current liabilities/sales 10%
rax rate 40%
years 1-2 12%
years 3-5 8%
years 6-∞ 4%
calculate the value of the firm and the value of the equity in the firm using DCF analysis.
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Foundations Of Finance](https://www.bartleby.com/isbn_cover_images/9780134897264/9780134897264_smallCoverImage.gif)
![Fundamentals of Financial Management (MindTap Cou…](https://www.bartleby.com/isbn_cover_images/9781337395250/9781337395250_smallCoverImage.gif)
![Corporate Finance (The Mcgraw-hill/Irwin Series i…](https://www.bartleby.com/isbn_cover_images/9780077861759/9780077861759_smallCoverImage.gif)