Business Homework Solutions
Problem
#60847

Business excel

How is this problem done in excel?  

xyz has a capital budget of$60 million, it opitimal capital structure is 40% debt and 60% equity.  Its EBIT was 98 million for a year.  Has 200 million in assets and pays 10%on all of its debt.  Tax rate is 35%.  If the firm uses a residual policy, what will be the amount of the dividends it pays after financing its capital budget?


Solution Summary

This explains the steps to compute the amount of the dividends

Solution
What is this?
By OTA - Overall OTA Rating
Departed OTA
Purchase Cost Now
$2.19 CAD (was ~$7.98)
Included in Download
  • Plain text response
  • Attached file(s):
    • Analysis.xls
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
Browse