2024 – All Finance Questions Solution In Excel Sheet 100 Correct 3 How many

 All Finance Questions Solution In Excel Sheet (***** 100 % Correct *****)

 

 

3. How many years would it take $50 to triple if you invested it in a bank that pays 8.25% per year?

 

4. You want to buy a new sports car 4 years from now, and you plan to save $4,400 per year,beginning immediately. You will make 4 deposits in an account that pays 5.75% interest. Under these assumptions, how much will you have 3 years from today?

 

 

5. What’s the present value of a 5-year ordinary annuity of $2,250 per year plus an additional $3,500 at the end of Year 5 if the interest rate is 6%?

 

 

6. What’s the future value of $2,500 after 5 years if the appropriate interest rate is 7.5%, compounded semiannually?

 

 

7. An investment promises the following cash flow stream: $1500 at Time 0; $2,750 at the end of Year 1 (or at t = 1); $3,150 at the end of Year 2; and $4,800 at the end of Year 3. At a discount rate of 10.0%, what is the present value of the cash flow stream?

 

 

 

 

8. Suppose you are buying your first house for $250,000, and are making a $50,000 down payment. You have arranged to finance the remaining amount with a 10-year, monthly payment, amortized mortgage at a 3.4% nominal interest rate. What will your equal monthly payments be?

 

 

9. You plan to borrow $30,000 at an 8% annual interest rate. The terms require you to amortize the loan with 10 equal end-of-year payments. How much interest would you be paying in Year 4?

 

 

10. You just deposited $4,000 in a bank account that pays a 6% nominal interest rate, compounded quarterly. If you also add another $9,000 to the account one year (12 months) from now and another $7,500 to the account two years from now, how much will be in the account three years (12 quarters) from now?

 

 11. Your sister turned 35 today, and she is planning to save $6,000 per year for retirement, with the first deposit to be made one year from today. She will invest in a mutual fund that will provide a return of 8.5% per year. She plans to retire 30 years from today, when she turns 65, and she expects to live for 25 years after retirement, to age 90. Under these assumptions, how much can she spend in each year after she retires? Her first withdrawal will be made at the beginning of her first retirement year.

 

 

 

12. You anticipate that you will need $2,000,000 when you retire 40 years from now. You plan to make 40 deposits, beginning today, in a bank account that will pay 7% interest, compounded annually. You expect to receive annual raises of 4%, so you will increase the amount you deposit each year by 4%. (That is, your 2nd deposit will be 4% greater than your first, the 3rd will be 4% greater than the 2nd, etc.) How much must your 1st deposit be if you are to meet your goal?

 

 

 

14. Medium Size Retailers, Inc. (MSR) has EBIT of $225,000, interest expense of $30,000, dividend income of $15,000, short term capital gains of $15,000, and long term capital losses of $18,000. What is MSR’s income tax liability?

 

 

 

15. Frederickson Office Supplies recently reported $12,500 of sales, $7,250 of operating costs other than depreciation, and $1,750 of depreciation. The company had no amortization charges and no non-operating income. It had $8,000 of bonds outstanding that carry a 9.0% interest rate, and its federal-plus-state income tax rate was 40%. How much was the firm’s taxable income, or earnings before taxes (EBT)?

 

 

 

16. Over the years, Janjigian Corporation’s stockholders have provided $19,250 of capital, part when they purchased new issues of stock and part when they allowed management to retain some of the firm’s earnings. The firm now has 1,500 shares of common stock outstanding, and it sells at a price of $48.00 per share. How much value has Janjigian’s management added to stockholder wealth over the years, i.e., what is Janjigian’s MVA?

 

 18. HHH Inc. reported $14,500 of sales and $7,025 of operating costs (including depreciation). The company had $18,750 of investor-supplied operating assets (or capital), the weighted average cost of that capital (the WACC) was 9.5%, and the federal-plus-state income tax rate was 35%. What was HHH’s Economic Value Added (EVA), i.e., how much value did management add to stockholders’ wealth during the year?

 

 

 

19. Wells Water Systems recently reported $8,750 of sales, $4,750 of operating costs other than depreciation, and $1,100 of depreciation. The company had no amortization charges, it had $3,250 of outstanding bonds that carry a 6.75% interest rate, and its federal-plus-state income tax rate was 35%. In order to sustain its operations and thus generate sales and cash flows in the future, the firm was required to spend $750 to buy new fixed assets and to invest $250 in net operating working capital. How much free cash flow did Wells generate?

 

 

 

An investor is considering starting a new business. The company would require $500,000 of assets, and it would be financed entirely with common stock. The investor will go forward only if she thinks the firm can provide a 17.5% return on the invested capital, which means that the firm must have an ROE of 17.5%. How much net income must be expected to warrant starting the business?

 

 

 

23. Helmuth Inc.’s latest net income was $1,250,000, and it had 295,000 shares outstanding. The company wants to pay out 40% of its income as dividends. What dividend per share should it declare?

 

 

 

24. Heaton Corp. sells on terms that allow customers 45 days to pay for merchandise. Its sales last year were $525,000, and its year-end receivables were $70,000. If its DSO is less than the 45-day credit period, then customers are paying on time. Otherwise, they are paying late. By how much are customers paying early or late? Base your answer on this equation: DSO – Credit period = days early or late, and use a 365-day year when calculating the DSO. A positive answer indicates late payments, while a negative answer indicates early payments.

 

 

25. Last year Mason Inc. had a total assets turnover of 1.33 and an equity multiplier of 1.75. Its sales were $195,000 and its net income was $8,549. The CFO believes that the company could have operated more efficiently, lowered its costs, and increased its net income by $4,950 without changing its sales, assets, or capital structure. Had it cut costs and increased its net income in this amount, by how much would the ROE have changed?

 

 

Rick Kish has a $100,000 stock portfolio. $32,000is invested in a stock with a beta of 0.85 and the remainder is invested in a stock with a beta of 1.75. These are the only two investments in his portfolio. What is his portfolio’s beta?

 

 

 

29. ABC Company’s stock has a beta of 1.40, the risk-free rate is3.75%, and the market risk premium is6.50%. What is ABC’s required rate of return using CAPM?

 

 

 

31. Hocking Manufacturing Company has a beta of 0.65, while Levine Industries has a beta of 1.70. The required return on the stock market is 10.00%, and the risk-free rate is 4.25%. What is the difference between Hocking’s and Levine’s required rates of return?

 

 

 

32. Rodriguez Roofing’s stock has a beta of 1.30, its required return is 11.50%, and the risk-free rate is4.00%. What is the required rate of return on the stock market?

 

 

 

35. Garvin Enterprises’ bonds currently sell for $875. They have a 6-year maturity, an annual coupon of $65, and a par value of $1,000. What is their current yield?

 

 

36. Sadik Inc.’s bonds currently sell for $1,250 and have a par value of $1,000. They pay a $135 annual coupon and have a 15-year maturity, but they can be called in 8 years at $1,135. What is their yield to call (YTC)?

 

 

37. Moerdyk Corporation’s bonds have a 20-year maturity, a 6.25% coupon rate with interest paid semiannually, and a par value of $1,000. The nominal required rate of return on these bonds is 8.25%. What is the bond’s intrinsic value?

38. Niendorf Corporation’s 5-year bonds yield 7.75%, and 5-year T-bonds yield 4.80%. The real risk-free rate is r* = 2.75%, the inflation premium for 5-year bonds is IP = 1.65%, the default risk premium for Niendorf’s bonds is DRP = 1.50% versus zero for T-bonds, and the maturity risk premium for all bonds is found with the formula MRP = (t – 1) x 0.1%, where t = number of years to maturity. What is the liquidity premium (LP) on Niendorf’s bonds?

 

 

39. A 20-year, $1,000 par value bond has an 8.5% coupon rate with interest paid semiannually. The bond currently sells for $800. What is the capital gains yield on these bonds?

 

 

40. O’Brien Ltd.’s outstanding bonds have a $1,000 par value, and they mature in 15 years. Their nominal yield to maturity is 9.75%, they pay interest semiannually, and they sell at a price of $900. What is the bond’s nominal (annual) coupon interest rate?