Purchase Solution

Dime a Dozen Diamonds - Accounting Break-Even Level and NPV Break-Even Level

Not what you're looking for?

Ask Custom Question

(See attached files for full problem description)

Dime a Dozen Diamonds makes synthetic diamonds by treating carbon. Each diamond can be sold for $100.
The materials cost for a standard diamond is $30. The fixed costs incurred each year for factory upkeep
and administrative expenses are $200,000. The machinery costs $1 million a year and is depreciated
straight-line over 10 years to a salvage value of zero.

a. What is the accounting break-even level of sales in terms of number of diamonds sold?

b. What is the NPV break-even sales assuming a tax rate of 35 percent, a 10-year project life and a discount
rate of 12 percent?

In part a, enter the formula to calculate the break-even point. In part b, enter the formulas to calculate
all the unknown items (you will know that your formulas are correct if the NPV is approximately equal to 0.

Fill in the table below for the following zero coupon bonds. The face value of each bond is $1,000.

Yield to
Price Maturity Maturity
$300 30 ?
$300 ? 8%
? 10 10%

Use the RATE, NPER, and PV functions to solve for the unknowns in the table below.

Yield to
Price Maturity Maturity
$300 30 FORMULA
$300 FORMULA 8%
FORMULA 10 10%

Here are the cash flows for two mutually exclusive projects:

Project C0 C1 C2 C3
A ($20,000) $8,000 $8,000 $8,000
B ($20,000) 0 0 $25,000

a. At what interest rates would you prefer project A to B?

b. What is the IRR of each project?

Use the MS Excel NPV function to calculate the NPVs for both projects in the profile below. In part B use
the IRR function.

Purchase this Solution

Solution Summary

The solution has three problems - calculation of accounting and financial break-even level, finding various unknowns in a bond equation and constructing an NPV profile. All these questions are addressed and calculated in three attached Excel files.

Purchase this Solution


Free BrainMass Quizzes
MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.