Reference no: EM131010841
Complete the Capital Budgeting Case with your Learming Team. The assignment instructions are available in the University of Phoenix Material: Capital Budgeting Case.
Click the Assignment Files tab to submit your assignment.
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.
|
Prepare a 2014 retained earnings statement
: After this action, what would Woo report as total retained earnings in its December 31, 2014, balance sheet?
|
|
What is the radius of the osculating circle at any time
: What is the radius, ρ, of the osculating circle at any time t > 0, for the curve in part (a)? Given that the curve is defined for all t ≥ 0, why does this question not ask for the radius, at any time t ≥ 0?
|
|
Why do workers try to negotiate wage employment guarantees
: What are the general wage concerns that management and employee representatives bring to the negotiating table? Why do workers try to negotiate wage employment guarantees? Supplemental unemployment benefits
|
|
What type of analysis is appropriate for these data
: As part of a large experiment, researchers planted 2,400 sweetgum, 2,400 sycamore, and 1,200 green ash seedlings. After 18 years, the survival rates were 93% for the sweetgum trees, 88% for the sycamore trees, and 95% for the green ash trees. Wha..
|
|
Describe the relationship between npv and irr
: Complete the Capital Budgeting Case with your Learming Team. The assignment instructions are available in the University of Phoenix Material: Capital Budgeting Case.
|
|
Determine the most efficient alternative energy design
: Determine the most efficient alternative energy design that would reduce the energy output through built-in calculation. Compare the energy usage in the original to the new design of the chosen home
|
|
Explain the mcd spectra in zno in much details
: Magneto Optical properties (studies) of non magnetic ZnO and doped ZnO - explain and concentrate on the result in
|
|
Issue a credit memorandum to maria''s life management
: On a worksheet, the income statement debit column totals $10,200 and the credit column totals $10,000. Which of the following statements is correct?
|
|
What proportion of the variation in cob weights
: The dosage levels were 1.5, 3.0, and 6.0 gm alcohol per kg body weight. The body temperature of each mouse was measured immediately before the alcohol was Interpret the value of se in the context of this setting.
|