Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Finish the table for projects C and D and calculate Payback period for all projects. begin{tabular}{|c|c|c|c|c|} hline Year & Project A & Project B &

image text in transcribed

Finish the table for projects C and D and calculate Payback period for all projects.

\begin{tabular}{|c|c|c|c|c|} \hline Year & Project A & Project B & Project C & Project D \\ \hline \begin{tabular}{l} Req. Return (use 2 \\ decimals xx.xx\%) \end{tabular} & 13.33% & 10.93% & 12.13% & 15.13% \\ \hline NPV (to nearest \$1) & \begin{tabular}{l} CF0= \\ 4,000,000 \\ C01= \\ 1,000,000 \\ F01=4 \\ C02=800,000 \\ F02=1 \\ C03=0 \\ F03=1 \\ C4=800,000 \\ FO4=1 \\ C5=300,000 \\ F05=1 \\ NPV= \\ 174,462.38 \end{tabular} & \begin{tabular}{l} CF0= \\ 3,000,000 \\ C01=300,000 \\ F01=1 \\ C02=500,000 \\ F02=2 \\ C03=750,000 \\ F03=7 \\ NPV= \\ 637,951.57 \end{tabular} & \begin{tabular}{l} CF0= \\ 6,000,000 \\ C01=1,500,000 \\ F01=2 \\ C02=2,500,000 \\ F02=2 \\ NPV= \\ 2,885,461.36 \end{tabular} & \begin{tabular}{l} CF0= \\ 7,250,000 \\ CO1=2,500,000 \\ F01=1 \\ C02=3,000,000 \\ F02=1 \\ C03=2,000,000 \\ F03=1 \\ C04=1,500,000 \\ F4=2 \\ NPV= \end{tabular} \\ \hline NPV accept/reject & REJECT & ACCEPT & ACCEPT & \\ \hline IRR (xx.xx\%) & 11.78 & 15.15 & 47.79 & \\ \hline IRR accept/reject & REJECT & ACCEPT & ACCEPT & \\ \hline PI (show 2 decimals, x.xx ) & \begin{tabular}{l} NPV=3,825,5 \\ 37.62 \\ /4,000,000 \\ =0.96 \end{tabular} & \begin{tabular}{l} NPV= \\ 3,637,951.57 \\ /3,000,000 \\ =1.21 \end{tabular} & NPV= & \\ \hline PI accept/reject & REJECT & ACCEPT & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions