Excel 2016 sum function autosum formula how to use auto sum formula to add values in cells 365 duration. This report will assist vp of finance mary lynn to make a. In 2001, ocean carriers didnt possess a ship that might meet up with the needs of the consumer, and. Ocean carriers case analysis background ocean carriers, inc. Ocean carriers case study submitted by fozia abid maryam noor nadia farooq umar farooq hamza tariq muhammad mohsin lahore school of economics ocean carriers report the fragmented shipping industry is one of the most essential industries for continuous globalization and growth. Ocean carriers case solution, ocean carriers case analysis, ocean carriers case study solution, overview ocean carriers is a shipping company with offices in new york and hong kong that operates iron ore capsize carriers with cargo capacities of 80,00. No ship in ocean carriers current fleet met the customers. Questions to consider ocean carriers has a cost of capital of 9% the discount rate for risky firm cash flows, and the riskfree rate is 6%. Currently, no ships in ocean carriers fleet meet the requirements of the customer. From the proposed agreement, ocean carriers would lease 1 ship to a client for the ocean carriers case solution excel 3 yr time frame. Therefore some important factors which drive daily spot hire rates. Ocean carriers case report executive summary ocean carriers is evaluating a proposed lease for a ship over three years starting in 2003. This was a complex case that required me to analyze complex cash flows and to determine the npv of a project.
Ocean carriers case study essay example graduateway. This means that the four underlying scenarios 25 years with and without tax and 15 years with and without tax are linked to separate sheets, which enables the user of the model to calculate the net present value npv for the different. Ocean carriers case study solution excel request analysis. Ocean carrier case solutions essay example graduateway. Glossary of international shipping terms a8a manifest. Ocean carriers case report chapter 11 project analysis. Download solved copy of ocean carriers case study analysis in word doc, ppt, xls or in pdf file with excel solution. Ocean carriers case study analysis by abbas haider, spencer smith, and stephen marqueling fin 361 february 27.
Axle load maximum load permitted to be carried on each axle of a motor vehicle. Currently, ocean carriers does not have any ships that are available to meet this customer demand. He manages to provide an educational and eyeopening account of a ocean carriers case study solution excel countrys political turmoilin this case, afghanistanwhile also developing characters whose heartbreaking struggles and emotional triumphs resonate with. I was then to determine if this project was worth doing for 15 years, 25 years, or not at all. In answering the below questions, assume ocean carriers discount rate is 9%. Ocean carriers case solution, ocean carriers case analysis, ocean carriers case study solution, in january 2001, mary linn, vice president of finance for ocean carriers, a shipping company with offices in new york and hong kong, was to evaluate the pr. In early 2001, the company received a leasing offer from a new potential charterer, for a 3 year period, starting in 2003. It is in an evaluation process for a lease proposal from a client for which marry lin, vice president needs an analysis of profitability and capital budgeting for the purchase of a new cargo ship to meet. Ocean carriers case study overview ocean carriers, inc. Harvard business case studies solutions assignment help. Download ocean carriers case study analysis pdf, excel by.
Ocean carriers case analysis, ocean carriers case study solution, ocean carriers xls file, ocean carriers excel file, subjects covered cash flow forecasting present value valuation by erik stafford, angela chao, kathleen s. In january 2001, mary linn, vice president of finance for ocean carriers, a shipping company with offices in new york and hong kong, was evaluating a proposed lease of a ship for a threeyear period, beginning in early 2003. In january 2001, mary linn, vice president of finance must make a decision on a proposed contract in which ocean carriers would lease one ship to a client for three years and the customer would begin utilizing the ship in 2003. Ocean carriers case analysis by corey ryan on prezi. Ocean carriers case study pdf or one more argumentation is an entirely new experience. Ocean carriers is evaluating a proposed three year lease of a ship. The following project is a harvard business school case entitled ocean carriers. Ocean carriers case report edmund lo ecl88 2840681 note. Ocean carriers case solution, in january 2001, mary linn, vice president of finance of shipping companies, shipping company, with offices in new york and. Ocean carriers case excel calculations investment appraisal of new capsize vessel cash flows in thousands of dollars net cash flows. Ocean carriers case solution excel case solution, analysis. Ocean carriers jacksonville port authority jaxport. The customer was eager to finalize the contract to meet his own commitments.
Ocean carriers case study solution excel cooler master co. Mary lynn, therefore, had to decide whether the ocean carriers should immediately commission a new carrier stall, which will be completed in two years and may be leased to the client. Industry solution the ocean carrier market is an assetheavy industry that requires huge financial investments to cover the cost of operations, from ocean liners to containers and fuel. Ocean carriers free download as powerpoint presentation. Mainly chartered for 1, 3, or 5year periods, occasional spot market charter. Essay on ocean carriers case analysis 781 words cram.
It is also a highly competitive market largely driven by supply and demand in. Alyssa linder wenliang zhang xhangoli, eva daily spot hire rates are determined according to supply and demand of the shipping capacity. He manages to provide an educational and eyeopening account of a ocean carriers case study solution excel countrys political turmoilin this case, afghanistanwhile also developing characters whose heartbreaking struggles and emotional triumphs resonate with readers long after the last page has been turned over. Ocean carriers case study background ocean carriers is known as a shipping company who owns and operates capsize carrier that carries dry bulk around the globe it mainly transports iron ore and coal customers charter the ship by paying the daily hire rate problem in early. Jaxport offers service from dozens of ocean carriers, and over the past few years, jaxport has added new direct port calls and more than 100 transshipment port calls worldwide. Ocean carriers case solution and analysis, hbs case study.
Ocean carriers case study solution case study analysis. The company operates and owns capesize dry bulk carriers, which are used to transport iron ore and coal worldwide. Scribd is the worlds largest social reading and publishing site. Harvard business school designed case on project profitability evaluation using discounted cash flows dcf and internal rate of return irr methods. It is your job to evaluate the commisioning of a new capesize carrier by ocean carriers in response to a lease, as described in the case study write up. Linn expected that australian and indian ore exports would begin in 2003, and that new supplies would significantly increase trading volumes. May 03, 2017 excel 2016 sum function autosum formula how to use auto sum formula to add values in cells 365 duration. Ocean carriers case study net present value inflation. Invision employees share their remote work secrets. The member will function how you will get the harvard business school ocean carriers case solution. Ocean carriers owns and operates capesize vessels that carry iron ore worldwide. To get the cassette to read, as what your associates do, you need to visit the link of the pdf scrap book page in this website. First of all, as given in the above case the ocean carriers incorporation owned and operated capsize bulk carriers, which were used for the purpose of carrying cargoes. Linn took an optimistic view of the longterm market demand for capesizes.
Mary linn, therefore, was whether ocean carriers should immediately order a new capsize carrier to be completed in two years and can be rented to customers. Discoount rate ship life years scrap value initial investment m depr. Ocean carriers is a shipping company with offices in new york and hong kong that operates iron ore capsize carriers with cargo capacities of 80,000 tons to 210,000 tons worldwide. In answering the below questions, assume ocean carrier s discount rate is 9%. Jan 19, 2019 ocean carriers case pdf over 85% of the cargo on these capesizes are iron ore and coal, and demand for these products increases in a strong economy. Ocean carriers case pdf over 85% of the cargo on these capesizes are iron ore and coal, and demand for these products increases in a strong economy. Ocean carriers case study solution, ocean carriers case study analysis, subjects covered cash flow forecasting present value valuation by erik stafford, angela chao, kathleen s. In 2001, ocean carriers didnt possess a ship that might meet up with the needs of the consumer, and thus was contemplating getting a. According to the article, the supply of ships available equals the number of ships currently in the fleet plus any new ships added, minus any scrapings and sinking. Ocean carriers case study pdf can be rather demanding at times, as well as thats exactly the reason why a lot of students typically uncover that its impossible to compose a dissertation completely separately. The customer was eager to finalize the contract to meet his own commitments and offered very attractive terms. Ocean carriers case study net present value scribd. Ocean carriers case study free download as word doc.
Ocean carriers case study solution excel cooler master. Apologies, i was out of state this weekend and had to complete on my own executive summary ocean carriers is evaluating a proposed lease for a ship over three years starting in 2003. Introduction the following case study is based on the attached excel sheet, which has been set up in a dynamic approach. Harvard business school ocean carriers case solution. Ocean carriers case report essay 1447 words bartleby. A complete guide to ocean carriers case study analysis in word doc, xls, ppt or in pdf file with excel solution order now. Summary of facts provided that ocean carriers case.
594 53 1266 1064 422 1108 1067 1086 1359 14 1098 1161 1587 220 712 747 1226 383 1502 516 1137 904 1158 782 162 932 56 1153 1084 1352 315 1038 842 1486 1208 982 300 1100 1030 295 386 1215