# Grand canyon fin 450 assignment chapters 10 and 11 practice problems

Details:

Complete the following problem from chapter 10 in the textbook:

Complete the following problems from chapter 11 in the textbook:

1. Do all work in Excel. Do not submit Word files or *.pdf files.
2. Submit a single spreadsheet file for this assignment. Do not submit multiple files.
3. Place each problem on a separate spreadsheet tab.

P10-25 All techniques with NPV profile: Mutually exclusive projects Projects A and B, of
equal risk, are alternatives for expanding Rosa Company’s capacity. The firm’s cost
of capital is 13%. The cash flows for each project are shown in the following table.

a. Calculate each project’s payback period.
b. Calculate the net present value (NPV) for each project.
c. Calculate the internal rate of return (IRR) for each project.
d. Draw the net present value profiles for both projects on the same set of axes, and
discuss any conflict in ranking that may exist between NPV and IRR.
e. Summarize the preferences dictated by each measure, and indicate which project
you would recommend. Explain why.

P11-4
Sunk costs and opportunity costs. Masters Golf Products, Inc., spent 3 years and
\$1,000,000 to develop its new line of club heads to replace a line that is becoming obsolete.
To begin manufacturing them, the company will have to invest \$1,800,000 in
new equipment. The new clubs are expected to generate an increase in operating cash
inflows of \$750,000 per year for the next 10 years. The company has determined that
the existing line could be sold to a competitor for \$250,000.

a. How should the \$1,000,000 in development costs be classified?
b. How should the \$250,000 sale price for the existing line be classified?
c. Depict all the known relevant cash flows on a time line.

P11-8
Book value and taxes on sale of assets. Troy Industries purchased a new machine
3 years ago for \$80,000. It is being depreciated under MACRS with a 5-year recovery
period using the percentages given in Table 4.2 on page 000. Assume a 40% tax rate.

a. What is the book value of the machine?
b. Calculate the firm’s tax liability if it sold the machine for each of the following
amounts: \$100,000; \$56,000; \$23,200; and \$15,000.

P11-23
Relevant cash flows for a marketing campaign Marcus Tube, a manufacturer of
high-quality aluminum tubing, has maintained stable sales and profits over the past
10 years. Although the market for aluminum tubing has been expanding by 3% per
year, Marcus has been unsuccessful in sharing this growth. To increase its sales, the
firm is considering an aggressive marketing campaign that centers on regularly running
ads in all relevant trade journals and web sites and exhibiting products at all
major regional and national trade shows. The campaign is expected to require an
annual tax-deductible expenditure of \$150,000 over the next 5 years. Sales revenue,
as shown in the accompanying income statement for 2015, totaled \$20,000,000. If
the proposed marketing campaign is not initiated, sales are expected to remain at
this level in each of the next 5 years, 2016 through 2020. With the marketing
campaign, sales are expected to rise to the levels shown in the accompanying table
for each of the next 5 years; cost of goods sold is expected to remain at 80% of
sales; general and administrative expense (exclusive of any marketing campaign outlays)
is expected to remain at 10% of sales; and annual depreciation expense is expected
to remain at \$500,000. Assuming a 40% tax rate, find the relevant cash
flows over the next 5 years associated with the proposed marketing campaign.

Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

### Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors: