Table 1A has the main values

i need help in part 3 b and c part with excel formulas. I have filled the B-1 to calculate IRR. Please help in rest of the parts

I shared 1c too . I have written answers on white space you can find from there\

- Top 15 Financial Functions in Excel - \#1 - Future Value (FV): Financial Function in Excel - FV Example - \#2 - FVSCHEDULE: Financial Function in Excel - FVSCHEDULE Example: - \#3 - Present Value (PV): Financial Function in Excel - PV Example: - \#4 - Net Present Value (NPV): Financial Function in Excel - NPV Example - \#5 - XNPV: Financial Function in Excel - XNPV Example - \#6 - PMT: Financial Function in Excel - PMT Example investment department of EvTel. Help Oscar and his team to analyze if the investment is logical or not. \begin{tabular}{|l|r|} \hline \multicolumn{2}{|c|}{ Tale A1} \\ \hline Initial Investment & 1,200,000.00 \\ \hline Annual Revenue & 260,000.00 \\ \hline Annual Costs & 175,000.00 \\ \hline Selling Price & 6,000,000.00 \\ \hline Expected Rate of Return & 25% \\ \hline \end{tabular} \begin{tabular}{|c|r|r|r|} \hline \multicolumn{5}{|c|}{ Table B-1 } \\ \hline Year & \multicolumn{1}{|c|}{ Revenue } & Cost & Cash Flow \\ \hline 0 & - & 1,200,000.00 & (1,200,000.00) \\ \hline 1 & 260,000.00 & 155,750.00 & 104,250.00 \\ \hline 2 & 260,000.00 & 155,750.00 & 104,250.00 \\ \hline 3 & 273,000.00 & 155,750.00 & 117,250.00 \\ \hline 4 & 286,650.00 & 155,750.00 & 130,900.00 \\ \hline 5 & 300,982.50 & 155,750.00 & 145,232.50 \\ \hline 6 & 316,031.63 & 155,750.00 & 160,281.63 \\ \hline 7 & 331,833.21 & 155,750.00 & 176,083.21 \\ \hline 8 & 6,348,424.87 & 155,750.00 & 6,192,674.87 \\ \hline & & NPV & (809,697.38) \\ \hline & & IRR & 28% \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ Table B-2 } \\ \hline Year & Revenue & Cost & Cash Flow \\ \hline 0 & & & \\ \hline 1 & & & \\ \hline 2 & & & \\ \hline 3 & & & \\ \hline 4 & & & \\ \hline 5 & & & \\ \hline \multicolumn{1}{l|}{} & & NPV & \\ \hline \multicolumn{1}{l|}{} & & IRR & \\ \hline \multirow{n}{*}{\multicolumn{1}{l|}{}} & & & \\ \hline \end{tabular} - Top 15 Financial Functions in Excel - \#1 - Future Value (FV): Financial Function in Excel - FV Example - \#2 - FVSCHEDULE: Financial Function in Excel - FVSCHEDULE Example: - \#3 - Present Value (PV): Financial Function in Excel - PV Example: - \#4 - Net Present Value (NPV): Financial Function in Excel - NPV Example - \#5 - XNPV: Financial Function in Excel - XNPV Example - \#6 - PMT: Financial Function in Excel - PMT Example investment department of EvTel. Help Oscar and his team to analyze if the investment is logical or not. \begin{tabular}{|l|r|} \hline \multicolumn{2}{|c|}{ Tale A1} \\ \hline Initial Investment & 1,200,000.00 \\ \hline Annual Revenue & 260,000.00 \\ \hline Annual Costs & 175,000.00 \\ \hline Selling Price & 6,000,000.00 \\ \hline Expected Rate of Return & 25% \\ \hline \end{tabular} \begin{tabular}{|c|r|r|r|} \hline \multicolumn{5}{|c|}{ Table B-1 } \\ \hline Year & \multicolumn{1}{|c|}{ Revenue } & Cost & Cash Flow \\ \hline 0 & - & 1,200,000.00 & (1,200,000.00) \\ \hline 1 & 260,000.00 & 155,750.00 & 104,250.00 \\ \hline 2 & 260,000.00 & 155,750.00 & 104,250.00 \\ \hline 3 & 273,000.00 & 155,750.00 & 117,250.00 \\ \hline 4 & 286,650.00 & 155,750.00 & 130,900.00 \\ \hline 5 & 300,982.50 & 155,750.00 & 145,232.50 \\ \hline 6 & 316,031.63 & 155,750.00 & 160,281.63 \\ \hline 7 & 331,833.21 & 155,750.00 & 176,083.21 \\ \hline 8 & 6,348,424.87 & 155,750.00 & 6,192,674.87 \\ \hline & & NPV & (809,697.38) \\ \hline & & IRR & 28% \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ Table B-2 } \\ \hline Year & Revenue & Cost & Cash Flow \\ \hline 0 & & & \\ \hline 1 & & & \\ \hline 2 & & & \\ \hline 3 & & & \\ \hline 4 & & & \\ \hline 5 & & & \\ \hline \multicolumn{1}{l|}{} & & NPV & \\ \hline \multicolumn{1}{l|}{} & & IRR & \\ \hline \multirow{n}{*}{\multicolumn{1}{l|}{}} & & & \\ \hline \end{tabular}