Need Answer for #7 and #8 Please show formula

A B 0 D E F G H #6 (2 pts) A Two Physician Practice faces declining revenues. They decide to stay open 246 days/yr. and see 27 patients/day each at an expected Net Revenue of $126/visit. Show your calculation of their new scenario's Net Revenue. Formula Required 3 #7. (2pts) Given a CCC of 8.6% Calculate the PV for each year using the Excel method and filling down Yr Cash Flow PV 0 ($575,000) Formula Required 1 $220,000 Formula Required 2 $225,000 Formula Required 3 $230,000 Formula Required 4 $240,000 Formula Required 5 $250,000 Formula Required 8 9 0 1 -2 3 #8. (2pts) For problem #7, what are the NPV and IRR? (You may use Excel or Calculator for NPV) NPV IRR Formula Required for NPV and IRR 14 15