Question: Please show how you got each answer using Excel or a financial calculator Given the information of a project, answer parts A, B, C, D,
Please show how you got each answer using Excel or a financial calculator
Given the information of a project, answer parts A, B, C, D, E:
Cost of equipment = $500,000
Shipping and installation = $15,000
$20,000 in net working capital required at setup 5-year project life, 10-year class life
Simplified straight line depreciation
Revenues will increase by $200,000 per year
Operating costs will rise by $15,000 per year
Salvage value after year 5 is $300,000
Discount rate = 13%, marginal tax rate = 34%
A) The initial outlay in year 0 is _________.
A. $500,000.
B. $515,000.
C. $590,000.
D. $535,000.
B) The annual cash flow from year 1 through 5 is ___________.
A. $88,110.
B. $157,120.
C. $139,610.
D. $189,658.
C) The terminal cash flow in year 5 is ______ .
A. $305,550
B. $46,690
C. $20,900.
D. $0.
D) The NPV of the project is ___________.
A. $121,881.
B. $24,664.
C. $58,590.
D. -$58,590.
E) Are you going to accept the project?
A. Yes
B. No
C. Depends on IRR
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
