Do you think the stock market is rational? Why or why not? Requirement: 150 words or more

our pro forma income statement shows sales of $ 991 comma 000$991,000​, cost of goods sold as $ 510 comma 000$510,000​, depreciation expense of $ 99 comma 000$99,000​, and taxes of $ 152 comma 800$152,800 due to a tax rate of 40 %40%. What are your pro forma​ earnings? What is your pro forma free cash​ flow? Complete the pro forma income statement​ below:  ​(Round to the nearest​ dollar.) Sales $ Cost of Goods Sold $ Gross Profit $ Depreciation $ EBIT $ Taxes (40%) $ Earnings $

Excel work, please

Assume that a lender offers a 30-year, $150,000 adjustable rate mortgage (ARM) with the following terms: Initial interest rate = 7.5 percent Index = one-year Treasuries Payments reset each year Margin = 2 percent Interest rate cap = 1 percent annually; 3 percent lifetime Discount points = 2 percent Fully amortizing; however, negative amortization allowed if interest rate caps reached Based on estimated forward rates, the index to which the ARM is tied is forecasted as follows: Beginning of year (BOY) 2 = 7 percent; (BOY) 3 = 8.5 percent; (BOY) 4 = 9.5 percent; (EOY) 5 = 11 percent. Compute the payments, loan balances, and yield for the ARM for the five-year period.

Dinklage Corp. has 6 million shares of common stock outstanding. The current share price is $85, and the book value per share is $8. The company also has two bond issues outstanding. The first bond issue has a face value of $65 million, a coupon rate of 8 percent, and sells for 95 percent of par. The second issue has a face value of $40 million, a coupon rate of 9 percent, and sells for 108 percent of par. The first issue matures in 23 years, the second in 5 years.

Suppose the most recent dividend was $5.70 and the dividend growth rate is 4 percent. Assume that the overall cost of debt is the weighted average of that implied by the two outstanding debt issues. Both bonds make semiannual payments. The tax rate is 38 percent. What is the company’s WACC? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

What is the price of a money market security with a discount yield of 5.38%, 145 days to maturity, and a $1000 face value? Round to $0.01.

One year​ ago, your company purchased a machine used in manufacturing for $95,000.You have learned that a new machine is available that offers many advantages and you can purchase it for $170,000 today. It will be depreciated on a​ straight-line basis over 10 years and has no salvage value. You expect that the new machine will produce a gross margin​ (revenues minus operating expenses other than​ depreciation) of $50,000 per year for the next 10 years. The current machine is expected to produce a gross margin of $22,000 per year. The current machine is being depreciated on a​ straight-line basis over a useful life of 11​ years, and has no salvage​ value, so depreciation expense for the current machine is $8,636 per year. The market value today of the current machine is $60,000. Your​ company's tax rate is 38 %​, and the opportunity cost of capital for this type of equipment is 12 %.Should your company replace its​ year-old machine?

The NPV of replacing the​ year-old machine is ​? (round to nearest dollar)

$1 is paid at the end of every year for 50 years. Assume an interest rate of 5% unless otherwise noted.

3. Calculate the value of the annuity at t = 25 using the following methods:

1. Sum up the value of each individual payment

2. Use the annuity formulas

3. Use the excel formulas

4. Accumulate the value from part 1.1

5. Present value the value from part 2.1

For 4, part 1.1 gives total present value of $18.2559. And for 5, part 2.1 gives the total accumulated value of 209.3480 at t = 50.

Do this in excels please. And please show the equation that you using with the instructions given.

QUESTION 20

1. If the following quotes are on September 15, 2012, what was the coupon rate for the JD.VR bonds with $1,000 face values and semiannual payments?

   Company (Ticker)	Coupon	Maturity	Last Price	Last Yield	$ Vol. (000s)
   Jim Doe (JD.VR)	?	Sep 15, 2034	117.02	6.6	6,360

   (Do not include the percent sign (%).Enter rounded answer as directed, but do not use the rounded numbers in intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).)

QUESTION 16

1. Three years ago, JKL Co. issued bonds with a 11-year maturity then and at a coupon rate of 7.9 percent. The bonds make semiannual payments. If the YTM on these bonds is 8.6 percent, what is the current bond price? (Do not include the dollar sign ($). Enter rounded answer as directed, but do not use the rounded numbers in intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).)

QUESTION 18

1. Bond RTY.AF has a 5 percent coupon, makes semiannual payments, currently has 18 years remaining to maturity, and is currently priced at par value. If interest rates suddenly rise by 2 percent, what is the percentage change in the price of Bond RTY.AF? Be sure to include the sign, especially if the bond price falls and the percentage change is negative. (Do not include the percent sign (%). Enter rounded answer as directed, but do not use the rounded numbers in intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).)

We are evaluating a project that costs $106,559, has a seven-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 4,308 units per year. Price per unit is $47, variable cost per unit is $29, and fixed costs are $82,563 per year. The tax rate is 40 percent, and we require a 11 percent return on this project. Suppose the projections given for price, quantity, variable costs, and fixed costs are all accurate to within +/-12 percent. What is the NPV of the project in worst-case scenario?

There are three methods of evaluating capital projects that are commonly utilized. What are these methods? Do they all depend on time value methods?

5 (II) Lisa Clark is evaluating her debt safety ratio. Her monthly take-home pay is

$3,240. Each month, she pays $435 for an auto loan, $110 on a personal line of credit, $55 on a department store charge card, and $110 on her bank credit card. Complete Worksheet 6.1 by listing Alyssa's outstanding debts.

a. Calculate her debt safety ratio. Round the answer to 1 decimal place. Enter debt safety ratio as a percentage.

b. Given her current take-home pay, what is the maximum amount of monthly debt payments that Alyssa can have if she wants her debt safety ratio to be 10.0%? Round the answer to the nearest dollar.

c. Given her current monthly debt payment load, what would Alyssa's take-home pay have to be if she wanted a 10.0% debt safety ratio? Round the answer to the nearest dollar.

#13. You own a house worth $250,000 and intend to insure it fully against fire for the next year. Suppose the probability of its burning to the ground during the year is .0001 and that an insurance policy covering the full value costs $500.

Consider the insurance policy as a security.

a. What is the expected holding-period return?

b. What is the standard deviation of it HPR

c. Would you consider this policy to be a very risky asset? Why or why not?

This is not in my notes and I am unsure how to work the solution

Consider a 19-year bond with 13 percent annual coupon payments. The market rate (YTM) is 6.6 percent for this bond. The current yield of the bond is _______ percent. Answer it in percentage without the % sign, and round it to two decimal place, e.g., 5.69.