Final Case Project I. Given the following data on proposed capital budgeting project. Economic life of...

Transcribed Image Text:

Final Case Project I. Given the following data on proposed capital budgeting project. Economic life of project in years. Price of New Equipment Fixed Costs Salvage value of New Equipment Effect on NWC: First Year Revenues Variable Costs Marginal Tax Rate Growth Rate WACC Beta Note Cells C17 and C18 include the initial cash flows today. Column D through G are the operating cash flows. Cells D30, D31, and D32 include terminal cash flows. PLEASE NOTE: You may need to change inputs provided in Column E at left. VACC % Total Equity #DIVIO! Total Debt #DIV/0! Total Value $ Re 2 3 Rd Tax Rate Spreadsheet for determining Cash Flows (in Thousands) Timelin Year 0 II. Net Investment Outlay = Initial CFs Price Increase in NWC III. Cash Flows from Operations Total Revenues Variable Costs Fixed Costs Depreciation Earnings Before Taxes Taxes Net Income Depreciation Net operating CFs IV. Terminal Cash Flows Calcula Salvage Value Tax on Salvage Value Return of NWC Cash Flows Present Value of CFs NPY 1 WACC: Cost of Debt N Periods IY PMT PV FV Cost of Equity Risk Free Rate Market Risk Premium Beta CAPM: Final Case Project I. Given the following data on proposed capital budgeting project. Economic life of project in years. Price of New Equipment Fixed Costs Salvage value of New Equipment Effect on NWC: First Year Revenues Variable Costs Marginal Tax Rate Growth Rate WACC Beta Note Cells C17 and C18 include the initial cash flows today. Column D through G are the operating cash flows. Cells D30, D31, and D32 include terminal cash flows. PLEASE NOTE: You may need to change inputs provided in Column E at left. VACC % Total Equity #DIVIO! Total Debt #DIV/0! Total Value $ Re 2 3 Rd Tax Rate Spreadsheet for determining Cash Flows (in Thousands) Timelin Year 0 II. Net Investment Outlay = Initial CFs Price Increase in NWC III. Cash Flows from Operations Total Revenues Variable Costs Fixed Costs Depreciation Earnings Before Taxes Taxes Net Income Depreciation Net operating CFs IV. Terminal Cash Flows Calcula Salvage Value Tax on Salvage Value Return of NWC Cash Flows Present Value of CFs NPY 1 WACC: Cost of Debt N Periods IY PMT PV FV Cost of Equity Risk Free Rate Market Risk Premium Beta CAPM: