Finance work 3

Question 1

Day	1	2	3	4
Advances	1023	1245	2460	2509
Declines	2334	2004	1178	980
Volume Advancing(m)	214349	225066	666012	679332
Volume Declining(m)	616678	555010	198058	172311
Yield on Top Rated bond	6.80%	6.70%	6.70%	6.60%
Yield on Intermediate-grade bond	7.40%	7.40%	7.50%	7.60%

What is the trin ratio for day 1?(sample answer: 1.35)

What is the trin ratio for day 4? (sample answer: 1.35)

Does the change in the trin ratio from day 1 to day 4 show a bullish or bearish trend? (sample answer: bullish or bearish)

Question 2

As a financial analyst at Wells Fargo, you are analyzing how the change in yield impacts the bond price. A bond has a duration of 11 years, a yield of 10%, a convexity of 140, and a market price of $1,000. Suppose the market yield increases by 60 basis points. What is the percentage change in the bond’s price by the duration only formula?  (sample answer: 2.25% or -2.25%) What is the bond price after the yield change predicted by the duration only formula?   (sample answer: $1050.65) What is the percentage change in the bond’s price predicted by the duration with convexity formula?   (sample answer: 2.25% or -2.25%) What is the bond price after the yield change predicted by the duration with convexity formula?  (sample answer: $1050.65)

Question 3

You have collected the following cash flow data of Herman Miller Office Furniture for the year ended December 31, 2019

Sale of a used Bus	45450
Cash dividend	90000
Purchase of land	28280
Interest payment on debt	26260
Cash Payment on Salary	90900
Purchase of a New Drilling machine	76760
Purchase of New Wood working machine	60000
Repurchase of stock	75000
Cash payments to Vendor	161600
Cash collections from customers	393900
Cash at the beginning of the year	400000

Please answer the following questions: a .   What is the net cash provided by or used in operating activities?(sample answer: -$135,000 or $135,000) b .   What is the net cash provided by or used in investing activities?  (sample answer: -$135,000 or $135,000) c .   What is the net cash provided by or used in financing activities?  (sample answer: -$135,000 or $135,000) d .   What is the cash at the end of the year?  (sample answer: -$135,000 or $135,000)

Question 4

You are a financial analyst at Bank of America and you have collected following information for Lotus Tech Company. The company has beta of 1.5 and a ROE of 20%. The dividend payout ratio is 50%. Last twelve month earnings were $4 per share. The annual dividend was just paid. The consensus estimate of the coming year’s market return is 11%, and T-bills currently offer a 8% return.

(keep two decimal places please.) a.   What is the required rate of return of the stock? (input format: 15.32%) b.   What is the growth rate of the stock? (input format: 15.32%) c.   What is the intrinsic value of the stock? (input format: $15.32) d.   What is PVGO of the stock? (input format: $15.32) e.   Suppose your research convinces you that company will announce momentarily that it will immediately change its dividend payout ratio to 75%. Find the intrinsic value of the stock. (input format: $15.32)

QUESTION 5

Suppose you are an analyst in pharmaceutical industry for Bank of America. You collect the following data to estimate the expected growth rate of dividends and use it as an input for valuing an oil company’s common stock.

Return on Assets	10%
Profit Margin	8%
Debt/Equity	3
Payout Ratio	50%

a.  The leverage ratio of this company is (sample answer: 3.50) b.  The company’s expected growth rate is (sample answer: 25.60%)

QUESTION 6

The following table lists the Income statement and Balance sheet for First American Furniture Company

I ncome Statement	2020	2021
Revenue	516	630
Depreciation	30	35
Other operating costs	400	480
Income before taxes	86	115
Taxes	30	44
Net income	56	71
Dividends	20	26
Earnings per share	0.56	0.71
Dividend per share	0.2	0.26
Common shares outstanding (millions)	100	100

Balance Sheet	2020	2021
Current assets	350	420
Net property, plant, and equipment	500	520
Total assets	850	940
Current liabilities	130	150
Long-term debt	50	80
Total liabilities	180	230
Shareholders’ equity	670	710
Total liabilities and equity	850	940
Capital expenditures	45	50
Net Working Capital	220	270

You are a financial analyst at RBC. Using the data above, you want to determine the value of First American Bank’s stock using the Free Cash Flow to Equity (FCFE) model. You believe that the company’s FCFE will grow at 40% for three years and 10% thereafter. Capital expenditures, depreciation, working capital, and net debt are all expected to increase proportionately with FCFE. The required rate of return on equity is 16%.

a. Calculate the amount of FCFE per share for the year 2021.(sample answer: $5.15) b. Calculate Projected 2024 terminal value per share based on constant growth of 10% (sample answer: $25.15) c. Calculate the current value of a share of the stock based on the two-stage FCFE model. (sample answer: $25.15)