80.2K

Verified Solution

Link Copied!

Problem: 1 please show the work with final answer of NPV.

Problem 2 : Please type the Excel formula for NPV only. I have calculated all of them except NPV and they are correct. Thanks !

I did : Sales : =B7 , Cost: =B8, Depreciation: =B6/B10, EBT : =B17-B18-B19, Taxes : =B20*B9, Net Income: =B20-B21, OCF: =B20-B21+B19 and NPV ??

Esfandairi Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.37 million. The fixed asset will be depreciated straightline to zero over its three-year tax life, after which time it will be worthless. The project is estimated to generate $1,765,000 in annual sales, with costs of $675,000. The tax rate is 21 percent and the required return on the project is 12 percent. What is the project's NPV? (Do not round intermediate calculations. Enter your answer in dollars, not millions of dollars, and round your answer to 2 decimal places, e.g., 1,234,567.89.) \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ (Use cells A6 to B10 from the given information to complete this question.) } \\ \hline \multicolumn{3}{|l|}{ Output area: } \\ \hline & & \\ \hline Sales & $1,645,000 & \\ \hline Costs & 610,000 & \\ \hline Depreciation & 726,667 & \\ \hline EBT & $308,333 & \\ \hline Taxes & 64,750 & \\ \hline Net income & $243,583 & \\ \hline OCF & $970,250 & \\ \hline NPV & & \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer