Please hand in an Excel printout for this homework

(Philly Air) PhillyAir Inc. offers low cost air travel between Philadelphia and Atlantic City. Philly Air's invested capital is $5,000,000, corresponding to the investment in the two planes the company owns. Each of the two planes can carry 50 passengers. Each plane does 12 daily trips from Philadelphia to Atlantic City and 12 from Atlantic City to Phila-delphia. The price is $100 for each one-way ticket. The current load factor is 70 percent (ie., 35 seats are sold on the average flight). The annual cost of operating the service and

running the business is $60,000,000 (including all costs, such as labor, fuel, marketing, gate fees, landing fees, maintenance, etc). The company operates 365 days a year. ( a) Draw an ROIC (return on invested capital) tree for the company that incorporates all of the above information (b) What is the current ROIC? ( c )What is the minimum load factor at which the company breaks even? (d) What load factor would the company have to achieve so that it obtained a 10 percentage-