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: 

 

 

Follow these instructions for completing and submitting your assignment: 

 

  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.
  4. Label all inputs and outputs and highlight your final answer.
  5. Follow the directions in “Guidelines for Developing Spreadsheets.”

 

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.    

Calculate Your Essay Price
(550 words)

Approximate price: $22

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:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
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.

Read more

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.

Read more

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.

Read more

Privacy policy

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.

Read more

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.

Read more