finexam_su10 - Financial Analysis with Microsoft Excel

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
FIN 615 Final Exam 1. The following procedure is recommended when creating financial statements in Excel, in order to minimize error and make the statements easier to read when provided to others: a. Use custom number formats b. Make excel do as little work as possible by avoiding the use of formulas c. Use as many fonts and colors as possible in order to separate line items and subheadings d. Hide data you do not want others to see before distributing a worksheet 2. Which of the following is the correct formula for cell B5 to calculate the earnings per share? a. =B2-B3*B2/B4 b. =(B2-B3)/B4 c. =B2*(1-B3)/B4 d. =(B2+B3*B2)/B4 e. =B2*(1+B3)/B4 3. Suppose that you are approached with an offer to purchase an investment that will provide cash flows of $1,200 per year for 15 years. The cost of purchasing this investment is $9,800. If you have an alternative investment opportunity, of equal risk, that will yield 8% per year, how would you determine which one to accept? a. Consider 8% to be your opportunity cost of funds and therefore your discount rate in calculating the present value of the second investment. Compare the present value to the cost of purchasing the investment. b. Compare the yields offered by the investments and accept the investment with the highest yield. c. Either approach could be used. d. There is insufficient information to determine which investment to accept. 4. You are thinking of buying a miniature golf course to operate. It is expected to generate cash flows of $40,000 per year in years one through four and $50,000 per year in years five through eight. If the appropriate discount rate is 10%, what is the present value of these cash flows? a. $285,288 b. $167,943 c. $235,048 d. $828,230 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
5. Your company buys a race horse, which has a winning streak for four years, bringing in $500,000 per year, and then it dies of a heart attack. If you paid $1,518,675 for the horse four years ago, what was your annual return over this four-year period? a. 8% b. 33% c. 18% d. 12% 6. The XYZ Company, whose common stock is currently selling for $40 per share, is expected to pay a $2.00 dividend in the coming year. If investors believe that the expected rate of return on XYZ is 14%, what growth rate in dividends must be expected? a.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 9

finexam_su10 - Financial Analysis with Microsoft Excel

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online