FW: MBA6010 Assignments (with references and calculation in excel).zip

 

 

Feed: Oronjo
Posted on: Friday, August 2, 2013 9:00 AM
Author: Oronjo feed for homework
Subject: MBA6010 Assignments (with references and calculation in excel).zip

 

Week 1 assignment 4

 

For each of the five years of the provided financial statements, calculate and analyze MNQ Company's thirteen financial ratios:

 

Current ratio

Quick ratio

Cash ratio

Total debt ratio

Times interest earned ratio

Cash coverage ratio

Inventory turnover ratio

Receivables turnover ratio

Profit margin

Return on assets

Return on equity

Price-earnings ratio

Market-to-book ratio

Additionally, critique these numbers. Do any patterns emerge with these ratios? Please explain.

 

Submit your answer in a 5- to 7-page Microsoft Word document and your calculations in a Microsoft Excel sheet.

 

 

 

Week 2 Assignment 3

Based on the financial statements provided in SU_MBA6010_Final_Project_Information.xls in the Doc Sharing area, use the dividend growth model to calculate the intrinsic value of MNQ Company’s common stock in 2008.

Determine whether the stock is undervalued, overvalued, or fully valued. Justify the assumptions that you make.

Submit your answers in a 5- to 7-page Microsoft Word document and your calculations in a Microsoft Excel sheet.

 

Week 3 Assignment 3

 

Assume that MNQ Company is looking to undertake a new project. The cash flows and applicable discount rate are provided in the third tab of SU_MBA6010_Final_Project_Information.xls in the Doc Sharing area.

Calculate the IRR, NPV, MIRR, and payback period of the project.

The company has a three-year payback cutoff period for projects. Determine if it makes financial sense for the company to undertake the project. Justify your decision.

Submit your answers in a 5- to 7-page Microsoft Word document and your calculations in a Microsoft Excel sheet.

 

 

Week-4 Assignment-3

Based on the data on the fourth tab of SU_MBA6010_Final_Project_Information.xls, provided in the Doc Sharing area, create an equally weighted portfolio of all ten stocks (including MNQ Company and the other nine stocks) and estimate the beta of the portfolio.

 Using the CAPM, determine the required rate of return for the portfolio.

Submit your answers in a 3- to 5-page Microsoft Word document and your calculations in a Microsoft Excel sheet.

 

 

 

Week 5 Assignment 2

 

  • Locate ten organizations that currently pay a common stock cash dividend. Go to the Finance Web link provided in the Webliography, enter the ticker symbol of an S&P 500 company in the quote box, and see whether it indicates that the company pays a dividend.
  • Calculate the organizations' cost of equity using the dividend yield plus growth rate approach and the security market line (SML) model approach.
  • For each organization, show how the cost of equity differs based on the two approaches.

Refer to the Web link Finance in the Webliography for information on beta of stocks.

Submit your answers in a 2- to 3-page Microsoft Word document and your calculations in a Microsoft Excel sheet.

 

Week 5 Assignment 3

MNQ Company's pretax cost of debt is 7 percent. Refer to the data on the first and second tabs of the spreadsheet SU_MBA6010_Final_Project_Information.xls provided in the Doc Sharing area. For this part of the assignment only, assume that MNQ Company's book value capital structure weights equal its market value capital structure weights.

Estimate the company's cost of capital for 2008.

Submit your answers in a 3- to 5-page Microsoft Word document and your calculations in a Microsoft Excel sheet.

 

Week 6 Assignment 2

Refer to the data on the first and second tabs of SU_MBA6010_Final_Project_Information.xls provided in the Doc Sharing area. Assume that all of MNQ Company's sales are credit sales.

  • Calculate and critique MNQ Company's cash conversion and operating cycles from 2004 to 2008.
  • Create a 10- to 15-slide Microsoft PowerPoint presentation bringing together your findings from Weeks 1 through 6.

Submit your answers in a 3- to 5-page Microsoft Word document, your calculations in a Microsoft Excel sheet, and your presentation in a Microsoft PowerPoint file.


View article...