Prepare pro forma consolidated worksheet. Prepare a pro forma consolidation worksheet for Parent, Inc. and its proposed subsidiary as of December…