個案總覽

Spreadsheet for product 9B06N007.

Spreadsheet for product 9B06N008.

Spreadsheet for product 9B06N009.

Spreadsheet for product 9B06N010.

Spreadsheet for product 9B06N012.

Spreadsheet for product 9B07N001.

Spreadsheet for product 9B07N002.

Spreadsheet for product 9B07N003.

Spreadsheet for product 9B07N004.

Spreadsheet for product 9B07N006.

Spreadsheet for product 9B07N007.

Spreadsheet for product 9B07N009.

Spreadsheet for product 9B07N011.

Spreadsheet for product 9B07N012.

Spreadsheet Supplement for KEL487.

Pricing is one of the most difficult decisions marketers make and the one with the most direct and immediate impact on the firm's financial position. This toolkit will introduce the fundamental terminology and calculations associated with pricing and profitability analysis. Users will learn how to produce and interpret demand curves and calculate the price elasticity of demand. The concepts of revenue, costs, and contribution margin, gross margin, and net income will be introduced to inform profitability analyses. Finally, retailer profitability metrics including retailer margin and penny profit are discussed. The note gives students a foundation for analyzing marketing cases, as well as providing an analytical structure and process for completing a marketing plan. The note is accompanied by a free Excel worksheet which contains sample problems, prebuilt Excel models to calculate demand curves, price elasticity, and profitability metrics for firms and their channel partners, and charts and graphs which help visualize the results.

Spreadsheet supplement for NA0068.

Spreadsheet supplement to case 908N23

Student spreadsheet to case 910N10

After booming for more than five years, the global shipping (maritime) industry experienced a dramatic crash in late 2008 as the global financial system froze and the global economy slid into recession. Ship charter rates (revenue) fell by as much as 90% causing prices of used ships to fall by as much as 80%. As ship prices (values?) fell, ship owners began to default on loans and new purchase contracts while banks holding loans secured by ships faced the possibility of increasing defaults (violations of loan-to-value covenants), foreclosures, and write-offs. In the midst of this crisis, VHSS, the German Shipbroker's Association, introduced a proposal to value ships using discounted cash flow analysis (to determine a long-term asset value, LTAV) rather than market prices from comparable transactions. Thomas Rehder, the Chairman of VHSS, argued this approach was necessary because market prices did not reflect fundamental values in the current environment. After announcing the alternative valuation methodology in September 2009, he must convince industry participants--ship owners, appraisers, and bankers--to adopt the new valuation methodology and bank regulators and auditing firms to approve its use.