1. Excel sheet assignment:

Excel sheet assignment: : Review Cash flow statement as in attachment.

Instructions: Need NVP, IRR, NVP Vs IRR in excel sheet

1. Use a required rate of return (hurdle rate) of 8% for the discounting of the future cash flows.

2. An Excel spreadsheet that analyzes the proposals from two vendors using the net present value (NPV) discounted cash flow model. Use Excel's =NPV( ) -costs function to determine which proposal is more financially acceptable. The final part of your assignment will include your justification of why your group's analysis using the NPV method suggests selecting one proposal over the other.

3. Use a required rate of return (hurdle rate) of 8% for the discounting of the future cash flows.

\begin{tabular}{lccccc} Breakdown & TTM & 5/31/2022 & 5/31/2021 & 5/31/2020 & 5/31/2019 \\ \hline > Operating Cash Flow & 9,539,000 & 9,539,000 & 15,887,000 & 13,139,000 & 14,551,000 \\ \hline > Investing Cash Flow & 11,220,000 & 11,220,000 & 13,098,000 & 9,843,000 & 26,557,000 \\ \hline > Financing Cash Flow & 29,126,000 & 29,126,000 & 10,378,000 & 6,132,000 & 42,056,000 \\ \hline > End Cash Position & 21,383,000 & 21,383,000 & 30,098,000 & 37,239,000 & 20,514,000 \\ \hline Income Tax Paid Supplemental Data & 2,567,000 & 2,567,000 & 3,189,000 & 3,218,000 & 2,901,000 \\ \hline Interest Paid Supplemental Data & 2,735,000 & 2,735,000 & 2,408,000 & 1,972,000 & 2,059,000 \\ \hline Capital Expenditure & 4,511,000 & 4,511,000 & 2,135,000 & 1,564,000 & 1,660,000 \\ \hline Issuance of Capital Stock & 482,000 & 482,000 & 1,786,000 & 1,588,000 & 2,155,000 \\ \hline Issuance of Debt & 0 & 0 & 14,934,000 & 19,888,000 \\ \hline Repayment of Debt & 8,250,000 & 8,250,000 & 2,631,000 & 4,500,000 \\ \hline Repurchase of Capital Stock & 17,341,000 & 17,341,000 & 21,600,000 & 19,905,000 & 4,500,000 \\ \hline Free Cash Flow & 5,028,000 & 5,028,000 & 13,752,000 & 11,575,000 & 12,891,000 \\ \hline \end{tabular} Net Issuance Payments of ... \begin{tabular}{|c|c|c|c|c|c|} \hline V End Cash Position & 21,383,000 & 21,383,000 & 30,098,000 & 37,239,000 & 20,514,000 \\ \hline Changes in Cash & 8,367,000 & 8,367,000 & 7,589,000 & 16,850,000 & 948,000 \\ \hline Effect of Exchange Rate Changes & 348,000 & 348,000 & 448,000 & 125,000 & 158,000 \\ \hline Beginning Cash Position & 30,098,000 & 30,098,000 & 37,239,000 & 20,514,000 & 21,620,000 \\ \hline Income Tax Paid Supplemental Data & 2,567,000 & 2,567,000 & 3,189,000 & 3,218,000 & 2,901,000 \\ \hline Interest Paid Supplemental Data & 2,735,000 & 2,735,000 & 2,408,000 & 1,972,000 & 2,059,000 \\ \hline Capital Expenditure & 4,511,000 & 4,511,000 & 2,135,000 & 1,564,000 & 1,660,000 \\ \hline Issuance of Capital Stock & 482,000 & 482,000 & 1,786,000 & 1,588,000 \\ \hline Issuance of Debt & 0 & 0 & 14,934,000 & 19,888,000 \\ \hline Repayment of Debt & 8,250,000 & 8,250,000 & 2,631,000 & 4,500,000 \\ \hline Repurchase of Capital Stock & 17,341,000 & 17,341,000 & 21,600,000 & 19,905,000 \\ \hline Free Cash Flow & 5,028,000 & 5,028,000 & 13,752,000 & 11,575,000 \\ \hline \end{tabular} \begin{tabular}{lccccc} Breakdown & TTM & 5/31/2022 & 5/31/2021 & 5/31/2020 & 5/31/2019 \\ \hline > Operating Cash Flow & 9,539,000 & 9,539,000 & 15,887,000 & 13,139,000 & 14,551,000 \\ \hline > Investing Cash Flow & 11,220,000 & 11,220,000 & 13,098,000 & 9,843,000 & 26,557,000 \\ \hline > Financing Cash Flow & 29,126,000 & 29,126,000 & 10,378,000 & 6,132,000 & 42,056,000 \\ \hline > End Cash Position & 21,383,000 & 21,383,000 & 30,098,000 & 37,239,000 & 20,514,000 \\ \hline Income Tax Paid Supplemental Data & 2,567,000 & 2,567,000 & 3,189,000 & 3,218,000 & 2,901,000 \\ \hline Interest Paid Supplemental Data & 2,735,000 & 2,735,000 & 2,408,000 & 1,972,000 & 2,059,000 \\ \hline Capital Expenditure & 4,511,000 & 4,511,000 & 2,135,000 & 1,564,000 & 1,660,000 \\ \hline Issuance of Capital Stock & 482,000 & 482,000 & 1,786,000 & 1,588,000 & 2,155,000 \\ \hline Issuance of Debt & 0 & 0 & 14,934,000 & 19,888,000 \\ \hline Repayment of Debt & 8,250,000 & 8,250,000 & 2,631,000 & 4,500,000 \\ \hline Repurchase of Capital Stock & 17,341,000 & 17,341,000 & 21,600,000 & 19,905,000 & 4,500,000 \\ \hline Free Cash Flow & 5,028,000 & 5,028,000 & 13,752,000 & 11,575,000 & 12,891,000 \\ \hline \end{tabular} Net Issuance Payments of ... \begin{tabular}{|c|c|c|c|c|c|} \hline V End Cash Position & 21,383,000 & 21,383,000 & 30,098,000 & 37,239,000 & 20,514,000 \\ \hline Changes in Cash & 8,367,000 & 8,367,000 & 7,589,000 & 16,850,000 & 948,000 \\ \hline Effect of Exchange Rate Changes & 348,000 & 348,000 & 448,000 & 125,000 & 158,000 \\ \hline Beginning Cash Position & 30,098,000 & 30,098,000 & 37,239,000 & 20,514,000 & 21,620,000 \\ \hline Income Tax Paid Supplemental Data & 2,567,000 & 2,567,000 & 3,189,000 & 3,218,000 & 2,901,000 \\ \hline Interest Paid Supplemental Data & 2,735,000 & 2,735,000 & 2,408,000 & 1,972,000 & 2,059,000 \\ \hline Capital Expenditure & 4,511,000 & 4,511,000 & 2,135,000 & 1,564,000 & 1,660,000 \\ \hline Issuance of Capital Stock & 482,000 & 482,000 & 1,786,000 & 1,588,000 \\ \hline Issuance of Debt & 0 & 0 & 14,934,000 & 19,888,000 \\ \hline Repayment of Debt & 8,250,000 & 8,250,000 & 2,631,000 & 4,500,000 \\ \hline Repurchase of Capital Stock & 17,341,000 & 17,341,000 & 21,600,000 & 19,905,000 \\ \hline Free Cash Flow & 5,028,000 & 5,028,000 & 13,752,000 & 11,575,000 \\ \hline \end{tabular}