Do My Essay!
Do not waste time. Get a complete paper today.
Our leading custom writing service provides custom written papers in 80+ disciplines. Order essays, research papers, term papers, book reviews, assignments, dissertation, thesis or extensive dissertations & our expert ENL writers will easily prepare a paper according to your requirements.
You’ll get your high quality plagiarism-free paper according to your deadline! No Bullshit!!
FIN 380 Take-Home Final Examination- Fall, 2018The following pages contain the take home midterm for Finance 380, sections A, B and C. The exam is due no later than Monday, December 17th at 9:00 AM. Late exams will lose 1 point for every minute late. By electronically submitting the final exam, you are attesting to the following. Please READ carefully.1. I understand that this is an examination and attest that the work presented is my own; that it is done without outside assistance of any kind (except that provided by the instructor). I understand that the penalty for cheating or collusion of any kind is a grade of F for the course.2. Spreadsheet solutions will be appropriately formatted and developed in a logical, readable, coherent fashion. Confusing or unformatted spreadsheets may result in a reduction of points.3. I understand that the file tabs are in their original order and understand that out-of-order problems will not be graded (Note: it is YOUR responsibility to insure that what you pass in ordered correctly)4. I understand that the due date and time for the exam is Monday, December 17th at 9:00 AM. I understand that the exam must be submitted electronically. I understand that exams passed in after that time will be considered late and will incur a minimum penalty of 1 point lost per minute late.5. The file name should contain both your last name, first name, section and the word Final in that order. For example, if youre in the 10AM section (Section A), your file name should be Ketcham.David.A.Final.xlsx6. Make sure you pass in the FINAL exam, not a homework assignment or your midterm. I dont have time to hunt you down.7. If you submit your exam early, Ill try to open the file and make sure I have the right exam and that I can view it. Ill let you know if I have problems. It is unlikely that I will be able to do so for any exam submitted after 5:00 P.M. on the day (Sunday) before the due date.8. The exam is being made available to you on or before December 10th and is due December 17th. That means you have ample time to ask questions in class, during office hours, via email, or through myriad other means. If you dont understand a question, ask BEFORE the exam is due for clarification. Misunderstood questions leading to wrong answers will count against you.9. Good luck! Its almost over.INDEX  This worksheet contains prices and dividends (Hyatt recently began paying dividends in March, 2018) for four companies; each is chosen to represent a different industry sector. Note that Kroger split 1 for 2 in July 2015. Share prices and dividends have been adjusted so that pre-split values are consistent with values after the split. The number of shares for Kroger as shown in the table below should be used for all dates.Construct a Price Index, and Equally Weighted Returns Index, and a Value Weighted Returns Index. Set the initial index level at 25. Graph all three indices on the same graph.=====================================================================================DECIDE  Write a spreadsheet that allows the user to input an initial outlay, up to 10 years of non-constant cash-flows after tax and a discount rate. The spreadsheet should return the Payback Period, the Discounted Payback Period, the Internal Rate of Return , the Modified Internal Rate of Return, and the Net Present Value.=====================================================================================EQUATION  Consider the following system of four equations and four unknowns:3? + ? +2? + 3? =302? – ? +8? – ? =-21-9? +7? +9? + 6? =-70? + 8? +7? – 8? =5Solve for ?, ?, ?, and ?.=====================================================================================IRON  Iron Mountain, Inc. is one of the highest dividend yield stocks on the NYSE, currently yielding 7.65% p.a. I have provided monthly stock price and dividend information as well as index levels of the S&P 500 and monthly risk free rates. Using a characteristic line in risk premium form, calculate beta and determine if Iron Mountain, Inc. stock has outperformed the market on a risk-adjusted basis.=====================================================================================PORT  In Investment class, youve no doubt seen the derivation (at least graphically) of the Capital Market Line, a line which shows the risk-return tradeoffs for efficient portfolios when the risk-free asset is added to the mix. The market portfolio is found by drawing a line from the risk-free rate of interest (rf) on the Y axis tangent to the efficient frontier. The market (or tangent) portfolio is the portfolio ON THE EFFICIENT FRONTIER that maximizes the slope of the Capital Market Line. That is, it is the portfolio (call it portfolio T) that maximizes:Subject to the usual constraints (ie the weights add up to one). The worksheet PORT contains the covariance matrix and mean returns for eight stocks. Using the matrix approach and SOLVER, solve for the weights in the tangent portfolio assuming the risk-free rate of interest is 5% (you may allow for short-selling).=====================================================================================SPORT-T  Sports-T Company makes T-shirts for sports fans. I have provided pro forma balance sheets, income statements the structure for a statement of cash flows. Using the percent of sales method. Forecast financial statements (balance sheets, income statements, and statements of cash flow) for the next five years. Assume excess funds are invested in marketable securities, and any financing shortfall is made up by ISSUING LONG TERM DEBT. Estimate the share price.=====================================================================================CAPITAL  Capital Choppers is a new business making frames for custom-built motorcycles. The company must buy three pieces of equipment; a pipe cutter, a pipe bender, and a robotic welder to accomplish these tasks. The project is expected to produce bike frames for eight years.The pipe cutter is expected to wear out and must be replaced in year 5 (assume the cost of the asset increases at 2% per year). The other two pieces of equipment will last through the entire project life. Sales are expected to increase by 3% per year throughout the project life. COGS/Sales is 73%; fixed costs are $95,000 per year and working capital/sales (starting in year 1) is 6% (assume it can be recovered in year 9). The project is partially financed by $550,000 in interest only debt paying 4% interest. The tax rate is 25% and the discount rate is 12.5%. What minimum level of sales (in year 1) is necessary to justify this project?=====================================================================================OPTION  The stock for Bryant Company is currently trading for $85.77 per share. A put option with an exercise price of $90.00 per share and expiring 37 days from now sells for $6.22. If the annual risk free rate is 2.45%, what is the standard deviation of Bryants stock?=====================================================================================POLLING  Bryant Polling has been hired to do political research for Kurt Blovian, a local candidate for State Representative. The costs of interviewing prospective voters varies by gender and political affiliation; for males, it costs $9 per Democrat, $10 per Republican, and $12.50 per Independent. For females, the costs are $10 per Democrat, $13 per Republican, and $14.50 per Independent. In order to assure quality, the polling company has been given the following criteria.· They must interview at least 4,500 voters· They sample must interview a minimum of 1,000 independent voters.· At least 2,000 males must be interviewed· At least 1,750 females must be interviewed· No more than 30% of those interviewed should be Democrats· No more than 30% of those interviewed should be Republicans· No more than 25% of those interviewed should be Republican males· Each of the six categories of voters (Republican males, Republican females, Democratic males, Democratic females, Independent males or Independent females) must constitute at least 10% of the total interviewsDetermine the least expensive sampling plan. What is the total cost of that plan?=====================================================================================SUNNY  Sunny Solar Energy is considering a highly variable capital budgeting project which will last for four years. (Assume the salvage value can be recovered, along with the working capital in year 5). The project will carry a discount rate of 11% and will be depreciated using 3 year MACRS factors. You have been provided the following information:Sunny figures that growth in sales, COGS/Sales, growth in fixed costs, WC/Sales and tax rate can vary each year. Estimate the projects cash flows and calculate the projects NPV. Run 100 simulations, and graph out the frequency distribution of the projects NPV. Determine the probability that the NPV is positive.