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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!