Question: Please use excel to solve this ans show the formulas for excel. Thank you Pompeii Pizza Club owns three identical restaurants popular for their specialty

Please use excel to solve this ans show the formulas for excel. Thank you Please use excel to solve this ans show the formulas for excel.

Pompeii Pizza Club owns three identical restaurants popular for their specialty pizzas. Each restaurant has a debt-equity ratio of 35 percent and makes interest payments of $53,000 at the end of each year. The cost of the firm's levered equity is 18 percent. Each store estimates that annual sales will be $1.44 million; annual cost of goods sold will be $800,000; and annual general and administrative costs will be $460,000. These cash flows are expected to remain the same forever. The corporate tax rate is 21 percent. a. Use the flow to equity approach to determine the value of the company's equity. (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89) b. What is the total value of the company? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!