Use the data in the attached excel document to answer the following questions. Use a discount rate of 4%. For questions 7 & 8, round your answer to the nearest whole dollar (example: 5048). For question 9 & 10, round your answer to 2 decimal places (example: 0.84).

What is the total present value of costs?

What is the total present value of benefits?

What is the Net Present Value (NPV) of the project?

What is the Benefit-Cost Ratio (BCR) of the project?

Homework 6 Data.xlsx - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEWVIEWACROBAT SAS Li, Rebecca Calibri ' Wrap Text General Paste Sort &Find & Filter Select Editing Share Upload B 1 u .A. ___ tMerge & Center. $. % , '0848 Conditional Format asCel Insert Delete Format Formatting Table" Styles 00 0 Clipboard Font Alignment Number Styles Cells Box The following table shows the costs and benefits of a proposed project over the next five years. Using a 4% discount rate, calculate the Net Present Value (NPV) and Benefit Cost Ration (BCR) for the project Year Costs Benefits 950 147 2 367 497 856 827 697 Total 3515 3741 26 27 29 30 32 CBA Data | READY + 1009% 11:59 AM