Balance sheet data

Assignment Help Accounting Basics
Reference no: EM13551080

Balance Sheet Data
Cash 3,000,000 Accounts Payable and Accruals 14,000,000
Accounts Receivable 24,000,000 Notes Payable 41,000,000
Inventories 45,000,000 Long-Term Debt 50,000,000
Preferred Stock 20,000,000
Net Fixed Assets 128,000,000 Common Equity 75,000,000
Total Assets 200,000,000 Total Liabilities &
Owners' Equity 200,000,000

Last year's sales were $210,000,000.
The company has 60,000 bonds with a 30-year life outstanding, with 15 years until maturity. The bonds carry a 9 percent semi-annual coupon, and are currently selling for $870.73.
You also have 100,000 shares of perpetual preferred stock outstanding, which pays a dividend of $7.80 per share. The current market price is $94.00.
The company has 10 million shares of common stock outstanding with a current price of $15.00 per share. The stock exhibits a constant growth rate of 8 percent. The last dividend (D0) was $.90.

Your firm does not use notes payable for long-term financing.
The firm's target capital structure is 25% debt, 5% preferred stock, and 70% common equity. The firm does not plan to issue new common stock.
Your firm's federal + state marginal tax rate is 38%.
The firm has the following investment opportunities currently available in addition to the venture that you are proposing:

Project Cost IRR
A 17,000,000 21%
B 21,000,000 19%
C 16,000,000 15%
D 28,000,000 11%
E 25,000,000 8%

All projects, including Project I, are assumed to be of average risk. Your venture would consist of a new product introduction (You should label your venture as Project I, for "introduction"). You estimate that your product will have a six-year life span, and the equipment used to manufacture the project falls into the MACRS 5-year class. The resulting MACRS depreciation percentages for years 1 through 6, respectively, are 20%, 32%, 19%, 12%, 11%, and 6%. Your venture would require a capital investment of $17,000,000 in equipment, plus $1,000,000 in installation costs. The venture would also result in an increase in accounts receivable and inventories of $3,000,000. At the end of the six-year life span of the venture, you estimate that the equipment could be sold at a $5,000,000 salvage value. Your venture would incur fixed costs of $1,000,000 per year, while the variable costs of the venture would equal 30 percent of revenues. You are projecting that revenues generated by the project would equal $6,000,000 in year 1, $14,000,000 in year 2, $15,000,000 in year 3, $16,000,000 in year 4, $11,000,000 in year 5, and $8,000,000 in year 6.

The following list of steps provides a structure that you should use in analyzing your new venture. Note: Carry all final calculations to two decimal places.
1. Find the costs of the individual capital components (15 points):
a. long-term debt
b. preferred stock
c. retained earnings (use DCF approach)
2. Determine the weighted average cost of capital. (5 points)
3. Compute the Year 0 investment for Project I. (5 points)
4. Compute the annual operating cash flows for years 1-6 of the project. (20 points)
5. Compute the non-operating (terminal) cash flow at the end of year 6. (10 points)
6. Draw a timeline that summarizes all of the cash flows for your venture. (5 points)
7. Compute the IRR, payback, discounted payback, and NPV for Project I. (20 points)
8. Prepare a report for the firm's CEO indicating which projects should be accepted and why. (20 points)
9. Conclude the project with your reflections on what you have learned from this course and how it has affected your view of your own job and career.

Reference no: EM13551080

Questions Cloud

Find the moment of inertia of the lower leg : The center of gravity of a 5 kg lower leg is 18 cm from the knee. When pivoted at the knee and allowed to swing, Find the moment of inertia of the lower leg
Calculate the forces in each of the vertical support columns : a uniform 2000 kg beam 10 m long supports a 500 kg weight 3 m for the right support. calculate the forces in each of the vertical support columns
Compute how long is the string : A 107 ball is tied to a string. It is pulled to an angle of 4.20 and released to swing as a pendulum. How long is the string
What is the height of the launch position : A projectile is launched above the ground with an initial speed of 50 m/s at an angle of 60 degrees above the horizontal.The range is 475 m. What is the height of the launch position?
Balance sheet data : Balance Sheet Data
Write the present situation in the center and the forces : Complete strategic planning and planning a change using the force-field model - Write the present situation in the center and the forces that hinder the change and the forces that can help get the change implemented.
Explain the appropriate number of significant figures : Carry out the following operations, and express the answer with the appropriate number of significant figures. a) 320.5 - (6104.5/2.3) b) [(285.3 x 10^5) - (1200 x 10^3)] x 2.8954
Estimate the thickness of the soap film : A thin soap film (n = 1.35) is suspended in air. The spectrum of light reflected from the film is missing two visible wavelengths of 490.8 nm and 589.0 nm, What is the thickness of the soap film
Discuss this phenomenon in terms of maxwells equations : (from Roger Ordidge, with alterations) The magnetic field can store energy, but it can do no work. Therefore, another agency must be responsible for doing the work that puts the energy into the magnetic field. In order for the energy in the field ..

Reviews

Write a Review

Accounting Basics Questions & Answers

  Review the unadjusted trial balance for smith construction

Review the unadjusted trial balance for Smith Construction and the information needed for the month-end adjustments in the Excel Template.

  Transaction analysis-various accounts

Prepare an answer sheet with the following column headings. For each of the following transactions or adjustments, indicate the effect of the transaction or adjustment on assets, liabilities, and net income by entering for each account affected th..

  Complete the flexible budget performance report showing

airassurance corporation provides on-site air quality testing services. the company has provided the following data

  How much of the payment goes toward principal

Compute the required monthly payment on a $80,000 30-year, fixed-rate mortgage with a nominal interest rate of 5.80%. How much of the payment goes toward principal and interest during the first year?

  Estimate its ending inventory

Accounting essay Please select only ONE of the 3 essays to pick. No minimum wording as long as its correct and can be explained in a essay formate. SELECT ONLY ONE.

  Which product gf10 or gf20 would result in a net decrease

grassy fertilizer manufactures two lines of garden grade fertilizeras part of a joint production process gf10 and gf20.

  How much is lori basis in her remaining stock

Med Inc. had one class of stock outstanding. The one class of stock was owned 50 percent by Lori and 25 percent by each of Lori's parents. In the current taxable year, Med Inc. redeemed 25 percent of Lori's 50 percent, and in exchange for the stoc..

  Amount and direction during same period

If total liabilities decreased by $15,000 and owner's equity increased by $5,000 during a period of time, then total assets must change by what amount and direction during that same period?

  Net cash provided by operations

Cash dividends were $43. The company sold equipment for $61 that was originally purchased for $28 and that had accumulated depreciation of $25. The net cash provided by (used in) operations for the year was:

  Corporations conducting performance measurement

What are the issues and complications that may arise when multinational corporations conduct performance measurement and comparisons among subsidiaries located in different countries?

  Preparing a bank reconciliation problem

Prepare a bank reconciliation using good format. Be sure to include the "cash shortage".

  What journal entries did they book to go from the beginning

DAN had $2000 beginning balance in utilities payable. he had an ending balance of $4000. Over the course of the period ABC received a bill for utilities for $5000. How much cash did they apy for utilities over the course of teh period?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd