Only in excel. No hard coded formulas.

A. Will the shipping line be profitable.

B. Due to Poseidon's good connections on Olympus, he can get a tax reduction. What is the maximum tax rate at which the project will be profitable?

E | F G 1 2 B | POSEIDON SHIPPING LINE 8% 50.00% Interest rate Tax rate Cost per ship (2 ships needed) 6 Earnings per year, per ship 7 Annual increase in earnings 8 Annual costs 1,000 300 5% 60 9 Purchas After-tax e ships revenue After-tax annual costs Year Total 10 11 #NAME? 12 13 14 15 16 17 18 NPV 19 Break-even tax rate (use 20 Goal Seek) 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 16. (Cash-flow analysis) Poseidon is considering opening a shipping line from Athens to Rhodes. In order to open the shipping line, Poseidon will have to purchase two ships that cost 1,000 gold coins each. The life span of each ship is 10 years, and Poseidon estimates that each ship will earn 300 gold coins in the first year and that the earnings will increase by 5% per year. The annual costs of the shipping line are estimated at 60 gold coins annually, Poseidon's interest rate is 8%, and he is charged by Zeus a tax rate of 50%. Depreciation is not an expense for tax purposes. E | F G 1 2 B | POSEIDON SHIPPING LINE 8% 50.00% Interest rate Tax rate Cost per ship (2 ships needed) 6 Earnings per year, per ship 7 Annual increase in earnings 8 Annual costs 1,000 300 5% 60 9 Purchas After-tax e ships revenue After-tax annual costs Year Total 10 11 #NAME? 12 13 14 15 16 17 18 NPV 19 Break-even tax rate (use 20 Goal Seek) 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 16. (Cash-flow analysis) Poseidon is considering opening a shipping line from Athens to Rhodes. In order to open the shipping line, Poseidon will have to purchase two ships that cost 1,000 gold coins each. The life span of each ship is 10 years, and Poseidon estimates that each ship will earn 300 gold coins in the first year and that the earnings will increase by 5% per year. The annual costs of the shipping line are estimated at 60 gold coins annually, Poseidon's interest rate is 8%, and he is charged by Zeus a tax rate of 50%. Depreciation is not an expense for tax purposes