Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1) Useful life of the equipment (years) 2) New equipment cost 5) Inventory increase 6) Accounts payable increase 7) Equipment salvage value (end of

1) Useful life of the equipment (years) 2) New equipment cost 5) Inventory increase 6) Accounts payable increase 7) Equipment salvage value (end of life) 8) Projected sales for year 1 9) Projected sales growth per year Low Case Base Case High Case 10) Operating cost (as a % of sales) 11) Depreciation (straight line) per year 12) Corporate marginal tax rate (T) 13) Cost of capital or discount rate (r) 60% 4 $ 240,000 $ 25,000 $ 5,000 $ 15,000 $ 200,000 2% 5% 8% 21% 10% E PART 1A: Use the Excel cells below to calculate all estimated project cash flows for the BASE CASE revenue growth. Depreciation is straight line over the useful life of the equipment. Solve for the NPV, IRR and Payback period. Round off NPV to the nearest dollar, IRR to 1 decimal place and Payback to 2 decimals. CF(0) Cash Flow at Time 0 Year Investments: New equipment cost Net Working Capital needs at start Total Initial Outlay Operations: Revenue Operating Cost Depreciation EBIT Taxes Net Income Profit Margin (%) Add back Depreciation Total Operating Cash Flow Terminal Cash Flows (end of Year 4) Change in net WC Salvage value (after tax) [= Salvage value before tax*(1-T)] Total Project Net Cash Flows D CF(0) 0 $240,000 CF(1) 1 CF(2) 2 LA CF(3) 3 SA H CF(4)

Step by Step Solution

3.40 Rating (159 Votes )

There are 3 Steps involved in it

Step: 1

Useful life of the equipment years 2 New equipment cost 5 Inventory increase 6 Accounts payable i... 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

Intermediate accounting

Authors: J. David Spiceland, James Sepe, Mark Nelson

7th edition

978-0077614041, 9780077446475, 77614046, 007744647X, 77647092, 978-0077647094

More Books

Students also viewed these Accounting questions