Reference no: EM131262416
Using the Valuation Software -
To utilize the UPS data file you will need to open excel on your computer. Click on file in the upper left hand corner to open your data file from your drive. Click on OK for each of the next two prompts. You may need to click on the don't save box if a prompt for saving changes to MGnames in a gray box appears when beginning the process. You will then be in eVal, the valuation software. The software may require you to have a low security setting because of macro settings. It depends upon your version of excel. If you open the software before first saving it and get an error message for configuration, click OK if following that it says there is a run time error 91, click end. (You do not need to run the data base)
Begin by clicking on the financial statements tab at the bottom. You should see five years of data. Clicking on ratios will bring up the ratios for your company. This will be used in your financial analysis. After you have completed your industry/strategy analysis, accounting analysis, and financial analysis you can start your forecasting analysis which will be completed when you input your forecast using the forecast tab. Make sure to enter your forecast assumptions beginning moving left to right for each of the five years and the terminal year.You may use the forecast percentages already in the software for the balance sheet since they are relying on a naïve prediction model that believes the most recent percentage is as good a predictor as any. This is not the case for the income statement where you will need all of the knowledge gained to this point about UPS to prepare your forecast. You will also need to include a percentage for the terminal year which can be based upon the competitive equilibrium assumption discussed in class or the forecasting section of the text. This is a simplifying assumption that will keep the company in a steady state going forward.
You will need to enter your cost of equity estimate in the valuation parameters area of eVal. If you use the CAPM to make this calculation please use the betaprovided to you. For UPS it would be the S&P Beta of .97. Use the US Treasury rate for 10 years at 3/23/2016 for the risk free rate. Make sure to use the 3/23/2015 date for the valuation parameters date. Please be sure to include your calculation for the cost of equity in your exam.
After inputting your assumptions and the cost of equity (in the valuation parameter section),the software will calculate the present value of cash flows discussed in your text chapter on valuation. This will result in a share price based upon your assumptions. You can see that share price in the upper left hand corner when using any tab.
Make sure to save your data file before exiting eVal. For the mid-term exam please use the beta of .97 noted above and not one from another source. You will also need to choose a risk premium for utilizing the CAPM. While risk premiums historically are in the 5-7% range, please use a rate in the 6-7% for your exam.
Assignment link -
https://www.dropbox.com/s/pewqshz7oylv26w/Assignment.rar?dl=0.
|
Pmi practice standard for work breakdown structures
: If there are 10 different project managers in a room, there are probably 10 different ideas on what a good WBS should look like. Go to the source, the PMI Practice Standard for Work Breakdown Structures, and review the established quality standard..
|
|
Determine the residual stress distribution
: A beam with the cross section shown in the figure carries a bending moment that causes the elastic region to extend 1.5 in. from the neutral axis. Determine the residual stress distribution after the bending moment has been removed. Use σyp = 40 k..
|
|
Find what is brendas break-even price for a dozen of eggs
: What is Brenda's break-even price for a dozen of eggs? Explain how you found that answer. If the market price of a dozen eggs at the local farmers' market is 72 cents per dozen, will Brenda make an economic profit?
|
|
Explore and record all the things
: Explore and record all the things that you eat or use in one day. Take at least 15 interesting photographs and make at least 10 sketches.
|
|
Calculate cost of equity capital and prepare forecast
: MAcc 652 Using the Valuation Software (Fall 2016). To utilize the UPS data file you will need to open excel on your computer. Click on file in the upper left hand corner to open your data file from your drive
|
|
What is the connection between women and shamanism in silla
: How do Pettid and Kim approach the issue of Confucianism in the Chosen period and why? What are the implications of their understanding of Confucianism to the study of women in the same period?
|
|
Determine the ratio pl/pyp in terms of k
: The restrained beam carries two loads of magnitude P. Denoting the ratio of the limit moment to the yield moment by K, determine the ratio PL/Pyp in terms of K. (Note: If the beam is elastic, the magnitude of the bending moment at each support is 2P..
|
|
Annuity values on any date
: Annuity Values on Any Date An annuity pays $1700 per quarter for 6 years with the first payment on April 1, 2014. Given an annual effective rate of interest of 3.6% a) Find the PV on 4/1/2014 b) Find the AV on 1/1/2020.
|
|
Highlight the high points from the reading material
: What is the summary of chapter 8: training and development: Highlight the high points from the reading material and also let me know how you felt about the assignments vs. tests?
|