Reference no: EM13973178
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.
What is magnitude of the induced voltage
: The sliding bar has a length of 0.500 m and moves at 2.00 m/s in a magnetic field of 0.250 T. Determine the direction of the current through the resistor. Explain why it is that way.
|
What is the acceleration of the truck
: A 2.70 kg block is in equilibrium on an incline of 34.8? . The acceleration of gravity is 9.81 m/s 2 . What is Fn of the incline on the block?
|
Create a portfolio with an expected return
: You have $15,000 to invest in a stock portfolio. Your choices are Stock X with an expected return of 15 percent and Stock Y with an expected return of 9 percent. Assume your goal is to create a portfolio with an expected return of 12.65 percent.
|
How long should the straight track
: You have a summer job working for a company that designs amusement park rides. Their latest rollercoaster design involves a circular loop-the-loop with a radius of 12 meters. Neglecting friction, what's the minimum energy required for ensuring tha..
|
Describe the relationship between npv and irr.
: 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.
|
Computing the local supplier
: The company's Shipping Division in Missouri has excess capacity and can ship the 30,000 containers at a variable cost of $1.50 per container. What is the total cost to Aerated Water Company if the carbonated water is purchased from the local suppl..
|
Calculate the work done on elevator by its cable, in joules
: Suppose a 1400-kg elevator car is lifted a distance 36 m by its cable at a constant speed, assuming the frictional force on the elevator has a constant value of 95 N. Calculate the work done on the elevator by its cable, in joules.
|
Journalize and post adjusting entries
: Journalize and post adjusting entries. Prepare an adjusted trial balance. Prepare an income statement and a retained earnings
|
A city of tempe muni bond has a yield of 3.4%.
: What is the tax equivalent yield for an investor in the 25% tax bracket compared to an investor in the35% tax bracket?
|