Please help to solve for problem b below with break-down. If there is a method in excel

Posted Date: