CAPITAL BUDGETING WORKSHEET
5
Equity Analysis of a Project
INPUT SHEET: USER ENTERS ALL BOLD NUMBERS INITIAL INVESTMENT Initial Investment= Opportunity cost (if any)= Lifetime of the investment Salvage Value at end of project= Deprec. method(1:St.line;2:DDB)= Tax Credit (if any )= Other invest.(non-depreciable)= $200,000 $7,484 10 $10,000 2 10% 0 LOAN DETAILS WORKING CAPITAL Initial Investment in Work. Cap= Working Capital as % of Rev= Salvageable fraction at end= $10,000 25% 100% Borrowing (if any) = Interest rate on loan= Time period for loan = Type(1:Term;2:balloon)= $30,000 8% 5 1 CASHFLOW DETAILS Revenues in year 1