Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate IRR, NPV, and Payback Period using Excel functions. Please show the formula on excel. begin{tabular}{|l|c|c|c|c|c|c|} hline & Initial Expenditures & Year #1 & Year

Calculate IRR, NPV, and Payback Period using Excel functions. Please show the formula on excel.

image text in transcribed

\begin{tabular}{|l|c|c|c|c|c|c|} \hline & Initial Expenditures & Year \#1 & Year \#2 & Year \#3 & Year \#4 & Year \#5 \\ \hline Net Investment Cost & ($800,000) & & & & & \\ \hline Additional Revenue & & $100,000 & $200,000 & $300,000 & $450,000 & $600,000 \\ \hline Additional Operating Expenses & & ($40,000) & ($40,000) & ($40,000) & ($40,000) & ($40,000) \\ \hline Amortization & & ($120,000) & ($176,000) & ($168,000) & ($168,000) & ($168,000) \\ \hline Net Increase in Income & ($800,000) & ($60,000) & ($16,000) & $92,000 & $242,000 & $392,000 \\ \hline Less: Tax @33\% & & - & & ($30,360) & ($79,860) & ($129,360) \\ \hline Increase in Aftertax Income & & ($60,000) & ($16,000) & $61,640 & $162,140 & $262,640 \\ \hline Add back Amortization & & $120,000 & $176,000 & $168,000 & $168,000 & $168,000 \\ \hline Net Change in Cash Flow & ($800,000) & $60,000 & $160,000 & $229,640 & $330,140 & $430,640 \\ \hline \end{tabular}

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

International Financial Management

Authors: Cheol S. Eun

5th Edition

0071181148, 9780071181143

More Books

Students also viewed these Finance questions