Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Could someone help with this example problem please and could possibly include step by step instructions. thank you Iceman Inc. Your boss, Mr. Kuklinski, believes

Could someone help with this example problem please and could possibly include step by step instructions. thank you
image text in transcribed
image text in transcribed
Iceman Inc. Your boss, Mr. Kuklinski, believes that Southern California will soon run short of water. One of the ramifications, other than widespread rioting, is that there will be high demand for fresh, potable water. He is considering starting an iceberg transport company named "Iceman Inc." to address this need and has asked you to help him analyze the project. The timeline for the proposed business is as follows: In Year 0 (i.e., this year), Mr. Kuklinski would acquire the necessary assets and set up operations. In Years 1,2,3, and 4, the business would be in full operation, shuttling icebergs from Alaska to Long Beach. He plans to sell the ships at the end of Year 4. In Year 5 nothing will happen except he will collect all the outstanding working capital. He will then move to Costa Rica, where they have plenty of water for both drinking and surfing. Over the past year, Mr. Kuklinski has paid $200,000 to consultants to write a report with all the relevant figures for this project. This report suggests that he can purchase six ships in Year 0 for $2,250,000 each. Ships don't lose much value if they are well maintained, so it is expected that the ships will have a resale value of $1,825,000 at the end of Year 4 . The ships are quite durable so they will be straight-line depreciated to zero over 20 years. The consulting report predicts that the company will be able to sell water at $0.90 per gallon. The water will be melted from the iceberg at the rate of 8.35 pounds of ice to one gallon of water. However, 2% of the ice will be lost due to evaporation during transit. The plan is to pick up 8 million pounds of icebergs with each ship in Year 1. As water becomes more scarce, the consultants expect the cargo to increase by 10% in Year 2, and then by another 10% in Year 3, and by another 10% in Year 4. The tax rate is 21%, and the required rate of return for this type of businesses is 12% per year. The majority of Iceman Inc's expenses are related to operating and maintaining the ships. Variable costs (including gasoline, maintenance and repairs, insurance, hourly wages for the captain and crew, etc.) are expected to be 40% of same-year sales. Working capital requirements (ineluding accounts receivable and inventory) are expected to be $200,000 in Year 0,10\% of same-year sales in Years 1 to 4, and $0 in Year 5. Iceman Ine. will sign a four-year lease for a slip in the Port of Long Beach at the rate of $800,000 per year in each of Years 1 through 4 , and this is expected to be the only fixed cost for the business. 1) What is the after tax salvage value of the ships? Show your work in the spreadsheet. ( 5 points) 2) Based on the assumptions in the attached case description, calculate the NPV of this project. Should your company accept the project? ( 12 points) 3) The last possibility that the consultants raised in their report is that lceman Ine might face increased competition from desalination technologies in the 3th and 4 th year of the project. There is a 30% chance that Iceman Ine, would need to cut their prices by 10 cents per gallon to sell the number of gallons projected for year 3 and 4 ? What is the resulting "expected" value of the NPV considering the two scenarios? (8 points)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Development Finance Innovations For Sustainable Growth

Authors: Nicholas Biekpe, Danny Cassimon, Andrew William Mullineux

1st Edition

331954165X, 978-3319541655

More Books

Students also viewed these Finance questions

Question

=+beliefs about the brand, product, or service?

Answered: 1 week ago

Question

=+4. Did your message properly reflect the brand's image?

Answered: 1 week ago