Paste Unde Clipboard Cabri BIY- Fort Wrap Text General Merge & Center - $ % G Conditional Format as Cell Formatting Table Insert Delete Forma Styles Number Styles Cells Best Buy has the opportunity to invest in 2 projects. Project A requires an investment of $2M which will give a return of $500000 each year for 5 years. Project B requires an investment of $750000 which will give a return of $100000, $150000, 5200000, 5250000 and $ 250000 for the next 5 years. Then Calculate the Net Present Value which can be used to decide which opportunity is better and should be invested in Project A Discount Rate 10% Project B Discount Rate 10% Initial investment 5 2,000,000 Initial Investment $750,000 Year Cash Flows Discounting Factor Year Cash Flows Discounting Factor 1 2 3 4 5 Net Present Value Formula Net Present Value 23 Which project should Best Buy Invest in 24 25 Sim 1 Sim 2 Abity Good to ge Net Present Value Formula Net Present Value