read the shortcase studyand transcribe the financial data into the providedExcel spreadsheet; all your calculations, i.e. NPV, WACC, FCF, and IRR are completed for you. You need to interpret the data for your boss in a one page memorandum. Your memorandum should follow the guidelines found onOnline Writing Lab(make sure that you read "Parts of a Memo" and "Format" on this website). Your boss is Darth Vader, so choose your words wisely.

case study:

The Empire is planning to create the first ever Death Star. Darth Vader, the Emperor's right hand man and the manager of the project, has asked you to evaluate the project. Here is some of the information that you need to evaluate the project.

• The equipment costs are around IC 100,000 (where IC is the imperial credit) plus IC 60,000 more for installation.
• In order to operate the Death Star, working capital has to increase by IC 40,000 which will be recovered at the end of the project.
• As the Emperor has foreseen it, the project is expected to last 4 years after which the equipment will be destroyed by the Rebellion. However, some parts of the project will be salvaged and sold for IC 20,000 to the Ewoks. Depreciation is based on straight-line method with zero salvaged value.
• Each planet that Darth Vader destroys costs the empire IC 10,000 but at the same time, it brings in IC 25,000 per planet destroyed from other fearing planets. Each year the empire plans to destroy 10 planets.
• The Death Star is a big-machine and therefore incurs a fixed cost of IC 75,000 to operate each year.
• In order to set an example, the Empire Department of Tax charges a 40% tax rate on the Death Star; however they give a tax shield for borrowing money.
• To finance this project, the Empire will borrow 40% of the initial outlay from the Banking Clan at a pre-tax rate of 12.50%. The other 60% will come by selling equity to the Separatist Group. The selling price per share of the Empire is IC 100 and is expected to grow at the constant rate of 11.67% forever. The next dividend will be of IC 5. The lenders of the capital require high rate of return because this is a risky project and has never been done before.

What is your recommendation for the Death Star project to Darth Vader?

Remember, Darth Vader does not like simple answers; you need to provide proper explanation. Please write short persuasive memorandum with your choice, to build or not to build, and rationale as to why you made this determination. You might use some fancy terms with numbers, such as net present value or weighted average cost of capital to assist you. Numbers always impress people! There are many blank templates available on a Word document. Just click on the file tab at the top and left of the page and then click on new. Just a few paragraphs will suffice; however, take caution in the words you choose - they may be your last!

Year 1 Year 2 Year 3 Year 4 Revenue 0 0 0 0 (Fixed Cost) 0 0 0 0 (Variable Cost) 0 0 0 0 Operating Margin 0 0 0 0 Other Revenue 0 (Depreciation Expense) 0 0 0 0 Earnings Before Interest and Taxes (EBIT) 0 0 0 0 (Interest) 0 0 0 0 Earnings Before Taxes 0 0 0 0 (Taxes) 0 0 0 0 Net Income 0 0 0 0 Value 0 Value 1 FCF 0 Cost of Debt 0 Cost of Equity WACC $0.00 NPV $0.00 IRR 0.00% 0 Value 2 Value 3 Value 4 0 0 0 Each Planet Destroyed 0 Number of Planet Destroyed per Year 0 Fixed Cost Per Year 0 Variable Cost Per Planet 0 Salvage Value Promised by the Ewoks 0 Total Depreciation 0 Initial Purchase of Equipment 0 Installation 0 Net Operating Working Capital 0 Interest Rate to Borrow Capital 0.00% Tax Rate 0% Dividend Amount Per Year 0 Stock Price 0 Growth of Stock 0.00% Total % Amount of Capital Borrowed 0% Total % Amount of Capital of Equity 0%