Please solve question five below. Please show excel spreadsheet for East Coast Yacht case study. Let's assume that the selling price (P) and the variable cost per unit (VC) remain constant. Then, the new break-even point can be calculated as follows: EFN = (FC + $25 million) / (P - VC) = FC / (P - VC) + $25 million / (P - VC) = EFN + $25 million / (P - VC).

5. Most assets can be increased as a percentage of sales. For example, cash can be increased by any amount. However, fixed assets often must be increased in specific amounts because it is impossible to buy_ part of a new plant or machine. In this case, a company has a "staircase" or "lumpy" fixed cost structure. Assume that East Coast Yachts is currently producing at 100 percent of capacity. As a assumption. What does this imply about capacity utilization for East Coast Yachts next year? Balance Sheet as of December 31, 2022 EAST COAST YACHTS 2022 Income Statement Sales Cost of goods sold Other expenses Depreciation Earnings before interest and taxes (EBIT) Interest Taxable income Taxes (21%) Net income Dividends Additions to retained earnings $185,250,000 136,125,000 22,169,000 6,054,000 $20,902,000 3,336,000 $17,566,000 3,688,860 $13,877,140 $6,340,000 7,537,140 Yacht Industry Ratios