Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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: NPV

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategic Public Finance

Authors: Stephen Bailey

1st Edition

0333922212, 978-033392221

More Books

Students also viewed these Finance questions

Question

How do we know that we have natural rights?

Answered: 1 week ago

Question

Identify the major phases of the training and HRD process

Answered: 1 week ago