вторник, 8 апреля 2014 г.

QRB 501 Week 6 Sander's Woodworks - Balance Sheet Analysis & Recommendations

QRB 501 Week 6 Problem Set

QRB 501 Week 6 Capital Budgeting Case Study

>>QRB 501 Week 6 Capital Budgeting Case Study<<

Capital Budgeting Case
Your company is thinking about acquiring another corporation. You have two choices—the cost of each choice is $250,000. You cannot spend more than that, so acquiring both corporations is not an option. The following are your critical data:
Corporation A
Revenues = $100,000 in year one, increasing by 10% each year
Expenses = $20,000 in year one, increasing by 15% each year
Depreciation expense = $5,000 each year
Tax rate = 25%
Discount rate = 10%
Corporation B
Revenues = $150,000 in year one, increasing by 8% each year
Expenses = $60,000 in year one, increasing by 10% each year
Depreciation expense = $10,000 each year
Tax rate = 25%
Discount rate = 11%
Compute and analyze items (a) through (d) using a Microsoft® Excel® spreadsheet. Make sure all calculations can be seen in the background of the applicable spreadsheet cells. In other words, leave an audit trail so others can see how you arrived at your calculations and analysis. Items (a) through (d) should be submitted in Microsoft® Excel®; indicate your recommendation (e) in the Microsoft® Excel® spreadsheet;  the paper stated in item (f) should be submitted consistent with APA guidelines.
a.     A 5-year projected income statement
b.     A 5-year projected cash flow
c.     Net present value (NPV)
d.     Internal rate of return (IRR)
e.     Based on items (a) through (d), which company would you recommend acquiring?
f.      Write a paper of no more 1,050 words that defines, analyzes, and interprets the answers to items (c) and (d). Present the rationale behind each item and why it supports your decision stated in item (e). Also, attempt to describe the relationship between NPV and IRR. (Hint. The key factor is the discount rate used.)  In addition to the paper, a Micosoft® Excel® spreadsheet showing your projections and calculations must be shown and attached.


 

QRB 501 Week 5 Week Five Learning Team Case Studies

QRB 501 Week 5 Quiz

QRB 501 Week 5 Problem Set

QRB 501 Week 4 Quiz

QRB 501 Week 4 Problem Set

QRB 501 Week 4 Learning Team Assignment Standard Deviation Abstract

QRB 501 Week 3 Week Three Learning Team Case Studies

QRB 501 Week 3 Quiz

QRB 501 Week 3 Problem Set

QRB 501 Week 2 Week Two Learning Team Case Studies

>>QRB 501 Week 2 Week Two Learning Team Case Studies<<

1. Ziam wants to know how much his royalty will be for a song he has written. How will it be calculated? Write the steps or the formulas that will be used to calculate his royalty payment.
2. Ziam has written a popular song titled “Going There,” which has been recorded by a well-known performer.  He recently received a royalty check for $7,000. If Ziam gets a 0.5 share of the royalties and the credit value is $3.50, what was the credit total that his song earned? Write out the problem in the form of an equation and solve it.
3. Ziam quickly published another song, “Take Me There,” that is played even more often than “Going There.”  If his first song earns 4,000 credits and his second song earns 6,000 credits, what will the royalty payment be from the two songs if the credit value remains at $3.50?
4. Ziam is considering an offer to perform his own songs on a CD to be titled “Waiting There.” In the past, he has written but not performed his music. If Ziam’s royalty is 0.12 of the suggested retail price of $15.00,  but 0.25 of the retail price is deducted for packaging before Ziam’s royalty is calculated, how much will he receive for sale of the CD? Write your answer in the form of an equation and solve it.
1. What percentage of the total does each of the four customer groups represent? Round to the nearest hundredth of a percent.
2. Minh’s data shows that on average only 4.6% of customers were purchasing complementary services available within Media Systems. By using his company’s services, Minh was projecting that these percentages would triple across all user groups within 1 year. a) How many customers would that equate to in total for each group?  b) What would be the difference compared to current levels?
3. Customer complaint data showed that within the last year, complaints by category were as follows: publication subscribers, 1,174; advertisers, 423; telephone service customers, 4,411; and ISP customers 823. a) What percentage of customers (round to two decimal places)complained within the last year in each category?  b) If the CRM software were able to reduce complaints by 50% each year over the next 2 years, how many complaints would there be by category at the end of that time period? And c) What would the number of complaints at the end of 2 years represent on a percentage basis?

 

QRB 501 Week 2 Quiz

QRB 501 Week 2 Problem Set

QRB 501 Week 1 Quiz

QRB 501 Final Exam