Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show the excel formulas used for each column. Consider an investment that has a project life of 12 years and requires an investment of

image text in transcribed

please show the excel formulas used for each column.

Consider an investment that has a project life of 12 years and requires an investment of $1,250,000 at time zero for machinery and equipment to be depreciated over 10 years with the straight-line depreciation method with a half year convention (starting in year 1 and continuing to year 11). Annual revenue is estimated to be $300.000 and annual operating costs of $95.000. $250,000 is needed for working capital at time zero. The salvage value of the machinery and equipment will be zero while an environmental remediation cost of $80,000 will be required to be paid at the end of year 12 as an additional operating cost. The minimum After Tax Cash Flow ROR is 12.5% and the effective income tax rate is 20%. Calculate the After Tax Cash Flow, NPV and ROR of the project

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

Money Banking And Financial Markets

Authors: Stephen Cecchetti

2nd Edition

0073523097, 9780073523095

More Books

Students also viewed these Finance questions

Question

1. Let a, b R, a Answered: 1 week ago

Answered: 1 week ago