Assignment help-BUS ADM 446/646: Advanced Corporation Finance


Assignment help-BUS ADM 446/646: Advanced Corporation Finance

Extra-credit problem (30 Points)
Instructions – Solve the following problems using Microsoft Excel, and submit your Excel File in D2L’s Dropbox .

Show your work in Excel. That is, computation has to be done in Excel and Excel functions that are used to complete the necessary output has to stay (saved) in Excel.

1. You are provided with the following cash flows on a project (15 Points).
Year Cash Flow to Firm  0 -6,000,000 1 3,000,000 2 2,500,000 3 3,250,000 4 1,000,000

a. Compute and plot the NPV profile for this project at discount rates ranging from 0% to 50%, at incremental rate of 2.5%.

b. What is the IRR of the project? Show the IRR for the project in the Excel file.

c. What is the modified IRR (MIRR) for the project if the cost of capital is 10%?
2. You are provided with the following cash flows for two projects (15 Points).
Year Project A Project A 0 -4,000,000 -4,000,000 1 2,000,000 1,000,000 2 1,500,000 1,500,000 3 1,250,000 1,700,000 4 1,000,000 2,400,000

a. Compute and plot the NPV profile for each project at discount rates ranging from 0% to 50%, at incremental rate of 2.5%.

b. Find the IRR of each project.

c. At discount rate of 10% which project would you choose?

d. What is a cross-over rate?

e. At a discount rate that is less than cross-over rate, which project would you choose?  f. At a discount rate that is greater than the cross-over rate, which project would you choose?

 

Assignment help-BUS ADM 446/646: Advanced Corporation Finance

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: