in Excel

Problem 7 You and your friends buy the pub for $65,000. (a) What was the "real world" NPV of the transaction? (b) At $65,000 purchase price, what was your expected return on investment (yield), using the IRR function? Bump your answer out to 2 decimal places, e.g., 5.43\%. Show your calculation in cells to the right of this box. Don't just show the answer, show the entire layout of the problem. Problem 7 You and your friends buy the pub for $65,000. (a) What was the "real world" NPV of the transaction? (b) At $65,000 purchase price, what was your expected return on investment (yield), using the IRR function? Bump your answer out to 2 decimal places, e.g., 5.43\%. Show your calculation in cells to the right of this box. Don't just show the answer, show the entire layout of the