Page 1 of 1
Prepare your Excel spreadsheet showing NPV and IRR of the exercise, and upload. Note NPV must be calculated in Excel. (H
Posted: Sat Feb 26, 2022 9:03 am
by answerhappygod
- Prepare Your Excel Spreadsheet Showing Npv And Irr Of The Exercise And Upload Note Npv Must Be Calculated In Excel H 1 (29.55 KiB) Viewed 50 times
Prepare your Excel spreadsheet showing NPV and IRR of the exercise, and upload. Note NPV must be calculated in Excel. (However, NPV function in Excel does not work! Please feel free to discuss with your friend but do not copy the file. Your file is subject to a detail investigation. . . Initial capital investment: 1,000, 5 years life, straight line depreciation method, no salvage value No working capital Profit Before Tax: Year2 Year1 0 Year4 Year3 300 150 Year 5 700 500 . Tax rate: 30% • Discount rate: 5%