Answered step by step
Verified Expert Solution
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.
\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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started