HO15-Case3-DaylightAlchemyCorp

HO15-Case3-DaylightAlchemyCorp - Tax Payment MM $ Cash Flow...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Page 1 Daylight Alchemy Corporation's Value Model Section 1 - Strategy Selection Strategy 1 strategy Strategy Name No Partnership / No Expansion strategy_name Strategy Descriptions 1 No Partnership / No Expansion 2 No Partnership / Expansion 3 Joint Venture 4 Royalty Section 2 - Constants Description Units Value Name Real discount rate % 8% discount_rate Tax Rate % 38% tax_rate Section 3 - Uncertainties Description Units Index In Use Name Low Base High Demand uncertainties DA Corp. markets MM units 2 2.5 dem_DAC 1.0 2.5 5.5 Section 4 - Calculations No Partnership / No Expansion Year 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 Period 0 1 2 3 4 5 6 7 8 9 Sales Demand | DA Corp. Markets MM units Demand | EnzyTech Markets MM units Capacity MM units Sales MM units 0.00 Revenue MM $ Production Cost MM $ Plant Cost MM $ JV Payment MM $ Royalty Payment MM $ Earnings Before Tax MM $ Taxes MM $ Tax Credit Available for Next Year MM $
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Tax Payment MM $ Cash Flow MM$ Present Equivalent MM 2000 $ Here you can select the alternative that you want. Just enter the appropriate number. The cel that contains this number is cal ed "strategy". Place your constants here. If you know how to name cel s this wil make things a lit le easier. Here you enter uncertainties. Look in the In Use cel s. These use the INDEX function which looks in the Low, Base, High range and pul s the correct value depending on how the Index cel is set. Index = 1 = Low. Index = 2 = Base. Index = 3 = High. Your spreadsheet should refer to the In Use cel s for calculations. You should complete this calculation section. We have provide one equation for you. It should give you al the logical statements you might need....
View Full Document

This note was uploaded on 06/16/2010 for the course MS&E 352 taught by Professor Ronhoward during the Winter '09 term at Stanford.

Ask a homework question - tutors are online