Ocean carriers excel sheet solution
Ocean carrier case study discounted cash flow the net present value of the investment for the 15 year period in which ocean carriers would use the ship is negative ($6,814,246) which means the company should not. Ocean carriers case report edmund lo ecl88 2840681 note: 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. Oracle data sheet oracle transportation management the industry’s leading transporation management parcel, air, rail and ocean oracle transportation management supports full “sell” side rating for logistics service providers and other companies who provide transportation services core carrier programs (ie, carrier commitments. Ocean carriers is an international shipping company mary linn, vice president of finance for ocean carriers, is considering investing in a new ship and leasing it to the clients because the existing ships of ocean carriers do not fit the needs of the clients. Ocean carriers group 9 presentation living on bulk carrier m v ganges former how to calculate the payback period and the discounted payback period on excel - duration: 9:50.
Case solution mary linn, v p of ocean carriers (a shipping company), is evaluating a recommended lease from the ship for just about any three year period. Ocean carriers spreadsheet ocean carriers presentation documents similar to ocean carriers excel oceancarriers uploaded by saurabh dhiman ocean carriers - case study solution uploaded by george kolbaia ocean carriers uploaded by classmate ocean carriers uploaded by harita kuppa. Ocean carriers - case study solution mercury athletic footwear ocean carriers reports_final case solution ocean carriers spreadsheet ocean carriers, inc ocean carriers presentation case study ocean carriers documents similar to ocean carriers excel ocean carriers uploadé par woheduoleyetu ocean carriers case study.
Problem: in january 2001, mary linn, vp of finance for ocean carriers, a shipping company with offices in new york and hong kong, must evaluate a proposed lease of a ship for a three-year period, beginning in early 2003. Documents similar to ocean carriers excel ocean carriers - case study solution uploaded by george kolbaia ocean carriers uploaded by classmate oceancarriers uploaded by saurabh dhiman ocean carriers spreadsheet uploaded by arijit nayak cost of capital at ameritrade uploaded by tom ziv. Ocean carriers i need help with the mathematical analysis along with an explanation of the analysis and the conclusion solution summary the posting has solution to the ocean carriers case study $219 add solution to cart remove from cart similar posting changing competitive priorities at fedex please attachment for case study and task.
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. Executive summary given the current and expected market conditions, the financial department of the ocean carriers group is to evaluate the potential revenues and expenses of commissioning a new capsize ship for cargo transportation in order to meet a received demand for lease. Sheetgo is a solution for managing spreadsheet data, our add-on helps to centralize, consolidate or distribute data from any google sheets, excel and csv sheetgo is a solution for managing spreadsheet data, our add-on helps to centralize, consolidate or distribute data from any google sheets, excel and csv. Freight quote worksheet ocean 20 gp ocean 40 gp ocean 40 hc air freight consol drayage to origin port of export: € 450 € 450 € 450 € 1,092. Read online now ocean carriers case excel solutions ebook pdf at our library get ocean carriers case excel solutions pdf file for free from our online library.
Ocean carriers is expected to grow at 2% from 2002 to 2004, then growth is expected to fall to 15% and stay steady forever for this project, i did not calculate a variable cost rate (v), working capital rate (w) or fixed costs. We discounted future cash flows generated from operating the ship as the method to determine the market value of the ship a us buyer with under the same tax rate as ocean carriers will calculate a price threshold of $15,858,028, meaning that a us buyer will yield a zero return if it paid the threshold amount. First, assume that ocean carriers is a us firm subject to 35% taxation second, assume that ocean carriers is located in hong kong, where owners of hong kong ships are not required to pay any tax on profits made overseas and are also exempted from paying any tax on profit made on cargo uplifted from hong kong. Ocean carriers, inc is a shipping company with offices in hong kong and new york 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. Devote to home-study about 2 hours per class group (4 people per team) solution reports of the case-studies: 20% ocean carriers (harvard 9-202-027.
Ocean carriers excel sheet solution
An excel spreadsheet) the cost of the optimal solution is $3000 carrier a is assigned package 7-6 carrier b is the constraints used in the excel solution are shown in figure 3 as many a few of you noted, there are actually several optimal solutions to the problem and they are. Ocean shippers may be paying a bit more this fall, but carriers say they’re delivering on their schedule integrity and despite a restrained capacity increase, most leading container vessel operators are still confronting a formidable oversupply challenge. Times new roman tahoma wingdings arial monotype sorts symbol system blends default design microsoft equation 30 microsoft excel worksheet capital budgeting applications ocean carriers sensitivity, scenario, and breakeven analysis.
Case study: ocean carriers inc 2 executive summary ocean carriers inc is a shipping company, owning and operating dry bulk carriers mainly for iron ore and coal exports, headquartered in both new york and hong kong. Ocean carriers case solution by arijit_nayak_1 in types school work ocean carriers case solution search search ocean carriers excel ocean carriers exercise oceancarriers ken ocean carriers excel documents similar to ocean carriers spreadsheet ocean carriers reports_final case solution uploaded by nadia virk ocean carriers.
Here you can order a plagiarism free case study solution, as well as excel file, harvard case study analysis and solution. Ocean carriers is a us firm subject to 35% taxation working 2 at excel worksheet layout free cash flows regarding purchase of new vessel and operation for fifteen years as per existing policy of the firm to operate ships for 15 years. A modest use of case-studies is employed to solution reports of the case-studies: 20% ocean carriers (harvard 9 (harvard 9-296-003) final exam: 50%.