This essay has been submitted by a student. This is not an example of the work written by professional essay writers.
Uncategorized

Assignment #1: Review of PMBA Finance Content

Pssst… we can write an original essay just for you.

Any subject. Any type of essay. We’ll even meet a 3-hour deadline.

GET YOUR PRICE

writers online

Assignment #1: Review of PMBA Finance Content
FINC 5050-2: Fall 2019

Due: 10/10/2019

(50 points)

 

The following questions should be answered using Excel.  You should hand in a printed copy of your Excel spreadsheets at the beginning of class and submit your Excel spreadsheets via Email.

 

  1. (12 points) Based on the annual income statements and balance sheets of Costco Wholesale Corporation (ticker symbol: COST) found on http://morningstar.com, calculate the annual rate of growth (% change) in Costco’s revenue, gross profit, operating income, net income, and total assets in 2018 (relative to 2017).  Additionally, calculate the firm’s gross margin (gross profit/revenue), operating margin (operating profit/revenue), profit margin (net income/revenue), operating return on assets (OROA = operating income/assets), and return on assets (ROA = net income/assets) for fiscal year 2017 and 2018.  Based on your calculations, what were the strengths and weaknesses of Costco’s financial performance in fiscal year 2018 compared to their performance in fiscal year 2017?
  2. (5 points) What is the difference between the present value of $200 per year cash payments for the next 40 years and the present value of $200 per year cash payments in perpetuity?  Assume in either case, the first payment occurs one year from today and that the appropriate discount rate is 12%/year.
  3. (6 points) What is the present value of the following series of cash payments: $1,200 per year for four consecutive years starting one year from today, followed by annual cash payments that increase by 3% per year in perpetuity (i.e. cash payment in year 5 is $1,200*1.03, cash payment in year 6 is $1,200*1.032, etc.)?  Assume the appropriate discount rate is 9%/year.
  4. (5 points) Use goal seek in Excel, to solve for the yield to maturity (market rate of return) on a corporate bond with a coupon rate of 5% per year, a maturity of 14 years, and a market value (price) of $1,080.
  5. (10 points) Use the dividend discount model to value a share of Toyota’s stock (ticker symbol: TM) as of December 31, 2019.  In your application of this model, use the data provided on the most recent Toyota Value Line report (history of their annual dividend payments, forecasts of future annual dividend payments, past and forecasted growth rates in dividends, and Value Line’s estimate of Toyota’s equity beta).
  6. (12 points) Estimate Boeing’s (ticker symbol: BA) weighted average cost of capital (WACC).     Provide data sources and dates for each input used in your estimation of Boeing’s WACC.

  Remember! This is just a sample.

Save time and get your custom paper from our expert writers

 Get started in just 3 minutes
 Sit back relax and leave the writing to us
 Sources and citations are provided
 100% Plagiarism free
error: Content is protected !!
×
Hi, my name is Jenn 👋

In case you can’t find a sample example, our professional writers are ready to help you with writing your own paper. All you need to do is fill out a short form and submit an order

Check Out the Form
Need Help?
Dont be shy to ask