Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need an explaination on hot to do PV of CFs Note Cells C17 and Collumn D thro Cells D30, D31 Final Case Project I. Given
Need an explaination on hot to do PV of CFs
Note Cells C17 and Collumn D thro Cells D30, D31 Final Case Project I. Given the following data on proposed capital budgeting project. Economic life of project in years. 4 Price of New Equipment $195,000 Fixed Costs $10,000 Salvage value of New Equipment $25,000 Effect on NWC: $20,000 First Year Revenues $150,000 Variable Costs 55.0% Marginal Tax Rate 30.0% Growth Rate 25.0% WACC 4.8% Spreadsheet for determining Cash Flows (in Thousands) Timeline: Year 0 1 2 3 4 II. Net Investment Outlay = Initial CFs Price (195,000) Increase in NWC (20,000) III. Cash Flows from Operations Total Revenues 150,000 180,000 216,000 259,200 Variable Costs (82,500) (99,000) (118,800) (142,560) Fixed Costs (10,000) (10,000) (10,000) (10,000) Depreciation (42,500 (42,500 (42,500) (42,500) Earnings Before Taxes 15,000 28,500 44,700 64,140 Taxes (5,250) 9,975) (15,645) (22,449) Net Income 9,750 18,525 29,055 41,691 Depreciation 42,500 42,500 42,500 42,500 Net operating CFS 52,250 61,025 71,555 84,191 IV. Terminal Cash Flows Salvage Value 25,000 Tax on Salvage Value (8,750) Return of NWC 20,000 Cash Flows (215,000) 52,250 61,025 71,555 120,441 Present Value of CFS Calculate: NPVStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started