I and my husband Jose have total amount of $150,000 in our savings account. We have 3 school going kids. We want to buy a new home, a new car and keep funds for children higher education.

We finalized to buy a home for $760,000. We may use $120,000 of our savings as a down payment on it. For balance financing the mortgage specialist/agent gave us the following options:

1. Option 1: a 25-year mortgage/loan, with semi-monthly payments (at the end of each period). The interest rate on the mortgage is 3.26% APR (annual percentage rate) compounded semi-annually.

Ques 1. What will the semi-monthly payment be on the Option 1 mortgage?

Please use (display + name) the excel function/ formula. Also please attach the screenshots/ photos of the excel sheet solution.

Option 2: a monthly payment of $2,900 to be made at the end of each period. The interest rate with this option would be 3.60% APR (annual percentage rate) compounded semi-annually.

Ques 2. How many years will Option 2 mortgage be amortized over?

Please use (display + name) the excel function/ formula. Also please attach the screenshots/ photos of the excel sheet solution.

Ques 3. To buy a new car of $45,000 (including taxes). In exchange of our old car for $10,000 and $10,000 from our savings as a down payment, the car dealer would provide the $25,000 balance as a 5-year loan paid semi-monthly at 4.8% APR compounded semi-monthly. What will the payment be on the loan for the car as per below information?

Please use (display + name) the excel function/ formula. Also please attach the screenshots/ photos of the excel sheet solution.

Jack is considering adding work jeans and T-shirts to the items he stocks in his general store provided that his payback period is less than 2.5 years. He estimates that the initial cost of inventory will be $6,750. The remodeling expenses required for this addition are $18,200. Jean and T-shirt sales are expected to produce net cash inflows of $10,200, $14,500, and $16,600 over the next three years, respectively. Jack _____ add the jeans and T-shirts to his offerings as the payback period is _____ years.

Multiple Choice

• should; 1.67

• should; 3.67

• should; 2.02

• should not; 3.67

• should not; 2.02

You must evaluate a proposal to buy a new milling machine. The base price is $165,000, and shipping and installation costs would add another $12,000. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $82,500. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The machine would require a $8,000 increase in net operating working capital (increased inventory less increased accounts payable). There would be no effect on revenues, but pretax labor costs would decline by $31,000 per year. The marginal tax rate is 35%, and the WACC is 13%. Also, the firm spent $5,000 last year investigating the feasibility of using the machine.

1. How should the $5,000 spent last year be handled?
   1. The cost of research is an incremental cash flow and should be included in the analysis.
   2. Only the tax effect of the research expenses should be included in the analysis.
   3. Last year's expenditure should be treated as a terminal cash flow and dealt with at the end of the project's life. Hence, it should not be included in the initial investment outlay.
   4. Last year's expenditure is considered as an opportunity cost and does not represent an incremental cash flow. Hence, it should not be included in the analysis.
   5. Last year's expenditure is considered as a sunk cost and does not represent an incremental cash flow. Hence, it should not be included in the analysis

2. What is the initial investment outlay for the machine for capital budgeting purposes, that is, what is the Year 0 project cash flow? Round your answer to the nearest cent.

3. What are the project's annual cash flows during Years 1, 2, and 3? Round your answer to the nearest cent. Do not round your intermediate calculations.

   Year 1 $

   Year 2 $

   Year 3 $

4. Should the machine be purchased?

Highway 65, Inc., is going to elect six board members next month. Betty Brown owns 16.8 percent of the total shares outstanding. a. What percentage of stock is needed to have one of her friends elected under the cumulative voting rule? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b. What percentage of stock is needed to have one of her friends elected under the staggered cumulative voting rule under which shareholders vote on two board member(s) at a time? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

The market price of a stock is $21.98 and it is expected to pay a dividend of $1.59 next year. The required rate of return is 11.86%. What is the expected growth rate of the dividend?

Answer format: Percentage Round to: 2 decimal places (Example: 9.24%, % sign required. Will accept decimal format rounded to 4 decimal places (ex: 0.0924))

A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term government and corporate bond fund, and the third is a T-bill money market fund that yields a rate of 8%.

The probability distribution of the risky funds is as follows: Expected Return Standard Deviation Stock fund (S) 17 % 35 % Bond fund (B) 14 18 The correlation between the fund returns is 0.09. a-1. What are the investment proportions in the minimum-variance portfolio of the two risky funds. (Do not round intermediate calculations. Enter your answers as decimals rounded to 4 places.) a-2. What is the expected value and standard deviation of its rate of return? (Do not round intermediate calculations. Enter your answers as decimals rounded to 4 places.)

How to do this question through excel?

An employee plans to invest $8,000 per year in a retirement fund at the beginning of each of the next 10 years. The employee believes she will earn 14% on her investments in each of the next 7 years and 9% in each of the last 3 years before she retires.

How much money will the employee have in the retirement fund when she retires?

You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $90,000, and it would cost another $13,500 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $27,000. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require an $11,000 increase in net operating working capital (spare parts inventory). The project would have no effect on revenues, but it should save the firm $50,000 per year in before-tax labor costs. The firm's marginal federal-plus-state tax rate is 35%. What is the initial investment outlay for the spectrometer, that is, what is the Year 0 project cash flow? Enter your answer as a positive value. Round your answer to the nearest cent. $ 114500 What are the project's annual cash flows in Years 1, 2, and 3? Do not round intermediate calculations. Round your answers to the nearest cent. Year 1: $ Year 2: $ Year 3: $ If the WACC is 12%, should the spectrometer be purchased?

The following table gives the current balance sheet for Travellers Inn Inc. (TII), a company
that was formed by merging a number of regional motel chains.
Travellers Inn (Millions of Dollars)
Cash $ 10 Accounts payable $ 10
Accounts receivable 20 Accruals 15
Inventories 20 Short-term debt 0
Current assets $ 50 Current liabilities $ 25
Net fixed assets 50 Long-term debt 30
Preferred stock (50,000 shares) 5
Common equity
Common stock (3,800,000 shares $ 10
Retained earnings 30
Total common equity $ 40
Total assets $100 Total liabilities and equity $100
The following facts also apply to TII.
(1) The long-term debt consists of 29,412 bonds, each having a 20-year maturity, semiannual
payments, a coupon rate of 7.6%, and a face value of $1,000. Currently, these
bonds provide investors with a yield to maturity of 11.8%. If new bonds were sold,
they would have an 11.8% yield to maturity.
(2) TII’s perpetual preferred stock has a $100 par value, pays a quarterly dividend per
share of $2, and has a yield to investors of 10%. New perpetual preferred stock would
have to provide the same yield to investors, and the company would incur a 3.85%
flotation cost to sell it.
(3) The company has 3.8 million shares of common stock outstanding, a price per share 5
P0 5 $20, dividend per share 5 D0 5 $1, and earnings per share 5 EPS0 5 $5. The
return on equity (ROE) is expected to be 10%.
(4) The stock has a beta of 1.6%. The T-bond rate is 6%, and RPM is estimated to be 5%.
(5) TII’s financial vice president recently polled some pension fund investment managers
who hold TII’s securities regarding what minimum rate of return on TII’s common
would make them willing to buy the common rather than TII bonds, given that
the bonds yielded 11.8%. The responses suggested a risk premium over TII bonds of
3 percentage points.
(6) TII is in the 25% federal-plus-state tax bracket.
Assume that you were recently hired by TII as a financial analyst and that your boss,
the treasurer, has asked you to estimate the company’s WACC under the assumption
that no new equity will be issued. Your cost of capital should be appropriate for use in

on your analysis, answer the following questions.
a. What are the current market value weights for debt, preferred stock, and common
stock? (Hint: Do your work in dollars, not millions of dollars. When you calculate
the market values of debt and preferred stock, be sure to round the market price per
bond and the market price per share of preferred to the nearest penny.)
b. What is the after-tax cost of debt?
c. What is the cost of preferred stock?
d. What is the required return on common stock using CAPM?
e. Use the retention growth equation to estimate the expected growth rate. Then use
the expected growth rate and the dividend growth model to estimate the required
return on common stock.
f. What is the required return on common stock using the own-bond-yield-plusjudgmental-
risk-premium approach?
g. Use the required return on stock from the CAPM model, and calculate the WACC.

If we hold 44% in the risky market portfolio, M, and 56% in the risk-free
an asset with a risk-free rate of 2%, the expected return on the market of
10% and the standard deviation of the market is 3%. Find the expected
return on the portfolio ( ERp) and the standard deviation of the portfolio (σp)

the answer is ERp=5.52%, σp= 1.32%. Could you please in solution (How to Solve)????

The Bigbee Bottling Company is contemplating the replacement of one of its bottling machines with a newer and more efficient one. The old machine has a book value of $550,000 and a remaining useful life of 5 years. The firm does not expect to realize any return from scrapping the old machine in 5 years, but it can sell it now to another firm in the industry for $295,000. The old machine is being depreciated by $110,000 per year, using the straight-line method.

The new machine has a purchase price of $1,200,000, an estimated useful life and MACRS class life of 5 years, and an estimated salvage value of $145,000. The applicable depreciation rates are 20%, 32%, 19%, 12%, 11%, and 6%. It is expected to economize on electric power usage, labor, and repair costs, as well as to reduce the number of defective bottles. In total, an annual savings of $230,000 will be realized if the new machine is installed. The company's marginal tax rate is 35%, and it has a 12% WACC.

1. What initial cash outlay is required for the new machine? Round your answer to the nearest dollar. Negative amount should be indicated by a minus sign.
   $
   
2. Calculate the annual depreciation allowances for both machines and compute the change in the annual depreciation expense if the replacement is made. Round your answers to the nearest dollar.

   Year	Depreciation Allowance, New	Depreciation Allowance, Old	Change in Depreciation
   1	$	$	$
   2
   3
   4
   5

3. What are the incremental net cash flows in Years 1 through 5? Round your answers to the nearest dollar.

   Year 1	Year 2	Year 3	Year 4	Year 5
   $	$	$	$	$

4. Should the firm purchase the new machine?
   -Select-YesNo

***Please show the math! Thank you!

Assume that security returns are generated by the single-index model,

R_i = α_i + β_iR_M + e_i
where R_i is the excess return for security i and R_M is the market’s excess return. The risk-free rate is 3%. Suppose also that there are three securities A, B, and C, characterized by the following data:

a. If σ_M = 20%, calculate the variance of returns of securities A, B, and C.

b. Now assume that there are an infinite number of assets with return characteristics identical to those of A, B, and C, respectively. What will be the mean and variance of excess returns for securities A, B, and C? (Enter the variance answers as a percent squared and mean as a percentage. Do not round intermediate calculations. Round your answers to the nearest whole number.)